Guest User

Untitled

a guest
Feb 16th, 2018
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. <?php
  2. $host = "localhost"; /* Host name */
  3. $user = "root"; /* User */
  4. $password = ""; /* Password */
  5. $dbname = "ubigeo"; /* Database name */
  6.  
  7. $conexion = mysqli_connect($host, $user, $password,$dbname);
  8. // Check connection
  9. if (!$conexion) {
  10. die("Connection failed: " . mysqli_connect_error());
  11. }
  12.  
  13.  
  14. $search = $_POST['service'];
  15.  
  16. $qss = mysqli_query("SELECT * FROM provincias WHERE provincia like '" . $search . "%' AND status=1 ORDER BY title DESC", $conexion);
  17. while ($row = mysqli_fetch_array($qss)) {
  18. echo '<div class="suggest-element"><a data="'.$row['provincia'].'" id="service'.$row['idProvincia'].'">'.utf8_encode($row['idDepartamento']).'</a></div>';
  19. }
  20. ?>
Add Comment
Please, Sign In to add comment