<?php
require_once('conexion.php');

    $sql = "SELECT * FROM cliente";
    $result = $conn->query($sql);

?>

<div class="modal fade" id="myModal" role="dialog">
                    <div class="modal-dialog modal-lg">
                      <div class="modal-content">
                        <div class="modal-header">
                          <button type="button" class="close" data-dismiss="modal">&times;</button>
                          <h4 class="modal-title">Cliente</h4>
                        </div>
                        <div class="modal-body">

        <div class="form-group">
                <label for="idusuario">Buscar cliente:</label>
                <div class="input-group">
                <input type="text" REQUIRED class="form-control" id="idusuario" placeholder="Ingresar Nombre">
                <div class="input-group-btn">
                        <button type="button" data-toggle="modal" data-target="#myModal" class="btn btn-success"><i class="fa fa-search"></i>&nbsp;Buscar</button>
                      </div>
                     </div>
                </div>
                        <table class="table table-bordered table-hover">
                              <thead>
                                <tr>
                                    <th>#</th>
                                    <th>Nombre</th>
                                    <th>Apellidos</th>
                                    <th>DNI</th>
                                    <th>Direccion</th>
                                    <th>Accion</th>

                                </tr>
                              </thead>
                              <tbody>
<!-- AQUI MUESTRO MIS DATOS -->
                                <?php
                                    if ($result->num_rows > 0) {

                                        while($row = $result->fetch_assoc()) {

                                    echo '<tr><td>'.$row["id_cliente"].'</td><td>'.$row["nombre"].'</td><td>'.$row["apellidos"].'</td><td>'.$row["dni"].'</td><td>'.$row["direccion"].'</td><td><button type="button" class="btn btn-primary" data-dismiss="modal"><i class="fa fa-plus" ></i>&nbsp;Agregar</button></td></tr>';

                                        }
                                    } else {
                                        echo "0 results";
                                    }


                                    $conn->close();

                                ?>

                              </tbody>
                          </table>


                        </div>
                        <div class="modal-footer">

                <div class="row">
                      <div class="col col-xs-3">
                        <ul class="pagination hidden-xs pull-right">
                          <li><a href="#">«</a></li>
                          <li><a href="#">1</a></li>
                          <li><a href="#">2</a></li>
                          <li><a href="#">3</a></li>
                          <li><a href="#">»</a></li>
                        </ul>
                      </div>
                    </div>
                  </div>


                          <!-- <button type="button" class="btn btn-default btn-md" data-dismiss="modal">Cancelar</button> -->
                        </div>
                      </div>
                    </div>
                  </div>

<?php
$servername = "localhost";
$username = "root";
$password = "raphael.18";
$dbname = "dbagricola";


$conn = new mysqli($servername, $username, $password, $dbname);

if (mysqli_connect_error()) {
    die("Conexion a la Base de Dato fallida:  " . mysqli_connect_error());
}

?>