How to put in vertical 3 and horizontal 2 with boostrap, php and connected with mysql

0

Good evening I have a question about PHP with connection with MYSQL , I'm trying that when I call the database MYSQL , I get the data that I have registered but the structure of the frontend is displayed 3x2 and that's why I made this part of the code;

            <?php foreach($resultado as $dato):?>
            <div class="row">
            <div class="col-sm-4">
                <div class="card text-center mb-3" style="width: 18rem;">
                    <div class="card-body">
                        <?php echo $dato['Descripcion'] ?>
                        <a href="#" class="btn btn-primary">Go somewhere</a>                        
                    </div>
                </div>
            </div>


            <div class="col-sm-4">
                <div class="card text-center mb-3" style="width: 18rem;">
                    <div class="card-body">
                        <?php echo $dato['Descripcion'] ?>
                        <a href="#" class="btn btn-primary">Go somewhere</a>                        
                    </div>
                </div>
            </div>

            <div class="col-sm-4">
                <div class="card text-center mb-3" style="width: 18rem;">
                    <div class="card-body">
                        <?php echo $dato['Descripcion'] ?>
                        <a href="#" class="btn btn-primary">Go somewhere</a>                        
                    </div>
                </div>
            </div>
            </div>

            <?php endforeach ?>

and here I show you the complete code of which I did if there is an error in my code

   <?php

    include_once 'conexion.php';

    //Llamar a todos los datos
    $sql='SELECT * FROM ubicacion_habitacion';
    $sentencia = $pdo->prepare($sql);
    $sentencia->execute();

    $resultado = $sentencia->fetchAll();

    // var_dump ($resultado);



    ?>

        <!DOCTYPE html>
        <html lang="en">


        <head>
            <meta charset="utf-8">
            <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
            <meta http-equiv="x-ua-compatible" content="ie=edge">
            <title>Material Design Bootstrap</title>
            <!-- Font Awesome -->
            <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.5.0/css/all.css" integrity="sha384-B4dIYHKNBt8Bc12p+WXckhzcICo0wtJAoU8YZTY5qE0Id1GSseTk6S+L3BlXeVIU" crossorigin="anonymous">
            <!-- Bootstrap core CSS -->
            <link href="css/bootstrap.min.css" rel="stylesheet">
            <!-- Material Design Bootstrap -->
            <link href="css/mdb.min.css" rel="stylesheet">
            <!-- Custom styles for this template -->
            <link href="css/style.css" rel="stylesheet">

            <link href="css/simple-sidebar.css" rel="stylesheet">
        </head>


        <body>
            <!-- As a link -->
            <nav class="navbar verde ">
                <a href="#menu-toggle" data-activates="wrapper" class="btn verde p-3 button-collapse fixed-top" id="menu-toggle"><i class="fa fa-bars"></i>
            <a class="navbar-brand text-white" href="#">
                <img src="img/favicon_sanna.png" height="30" class="d-inline-block align-top">  SANNA\ Clinica el Golf
            </a>
            </nav>
            <div id="wrapper">

                <!-- /#page-content-wrapper -->
                <!-- Sidebar -->
                <div id="sidebar-wrapper">
                    <ul class="sidebar-nav">
                        <li class="sidebar-brand">
                            <a href="#">
                                <img src="img/logo-SANNA.png" height="50" class="rounded mx-auto d-block my-3">
                            </a>
                        </li>
                        <li>
                            <a href="Sidenav.php">Solicitud de Habitación</a>
                            <a href="Habitaciones.php">Gestión de Habitaciones</a>
                        </li>
                    </ul>
                </div>
                <!-- Page Content -->
                <div id="page-content-wrapper " class="fondo view">

                    <div class="container my-5">

                        <?php foreach($resultado as $dato):?>
                        <div class="row">
                        <div class="col-sm-4">
                            <div class="card text-center mb-3" style="width: 18rem;">
                                <div class="card-body">
                                    <?php echo $dato['Descripcion'] ?>
                                    <a href="#" class="btn btn-primary">Go somewhere</a>                        
                                </div>
                            </div>
                        </div>


                        <div class="col-sm-4">
                            <div class="card text-center mb-3" style="width: 18rem;">
                                <div class="card-body">
                                    <?php echo $dato['Descripcion'] ?>
                                    <a href="#" class="btn btn-primary">Go somewhere</a>                        
                                </div>
                            </div>
                        </div>

                        <div class="col-sm-4">
                            <div class="card text-center mb-3" style="width: 18rem;">
                                <div class="card-body">
                                    <?php echo $dato['Descripcion'] ?>
                                    <a href="#" class="btn btn-primary">Go somewhere</a>                        
                                </div>
                            </div>
                        </div>
                        </div>

                        <?php endforeach ?>
                        <hr class="container">

                        <nav class="col-sm-12" aria-label="Page navigation example">
                            <ul class="pagination pg-blue justify-content-center texto">
                                <li class="page-item disabled">
                                    <a class="page-link text-success" tabindex="-1">Previous</a>
                                </li>
                                <li class="page-item"><a class="page-link text-success">1</a></li>
                                <li class="page-item"><a class="page-link text-success">2</a></li>
                                <li class="page-item"><a class="page-link text-success">3</a></li>
                                <li class="page-item">
                                    <a class="page-link text-success">Next</a>
                                </li>
                            </ul>
                        </nav>
                    </div>


                </div>
            </div>
            <!-- /#page-content-wrapper -->

            <!-- /#sidebar-wrapper -->

            </div>
            <!-- /#wrapper -->

            <!-- JQuery -->
            <script type="text/javascript" src="js/jquery-3.3.1.min.js"></script>
            <!-- Bootstrap tooltips -->
            <script type="text/javascript" src="js/popper.min.js"></script>
            <!-- Bootstrap core JavaScript -->
            <script type="text/javascript" src="js/bootstrap.min.js"></script>
            <!-- MDB core JavaScript -->
            <script type="text/javascript" src="js/mdb.min.js"></script>

            <!-- Menu Toggle Script -->
            <script>
                $("#menu-toggle").click(function(e) {
                    e.preventDefault();
                    $("#wrapper").toggleClass("toggled");
                });
            </script>

            <script>
                // Basic example
                $(document).ready(function() {
                    $('#dtBasicExample').DataTable({
                        "paging": true // false to disable pagination (or any other option)
                    });
                    $('.dataTables_length').addClass('bs-select');
                });
            </script>

        </body>

        </html>
    
asked by Christian Guerra Huertas 15.11.2018 в 06:22
source

0 answers