Advertisement
Guest User

autocomplete

a guest
Feb 20th, 2017
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.56 KB | None | 0 0
  1. <?php
  2.     $dbHost = 'localhost';
  3.     $dbUsername = 'root';
  4.     $dbPassword = '';
  5.     $dbName = 'biblio';
  6.     //connect with the database
  7.     $db = mysqli_connect($dbHost,$dbUsername,$dbPassword,$dbName);
  8.     //$db = new mysqli($dbHost,$dbUsername,$dbPassword,$dbName);
  9.     //get search term
  10.     $searchTerm = $_GET['term'];
  11.     //get matched data from skills table
  12.     $query = $db->query("SELECT term FROM dictionnaire WHERE term LIKE '%".$searchTerm."%' ORDER BY term ASC");
  13.     while ($row = $query->fetch_assoc()) {
  14.         $data[] = $row['term'];
  15.     }
  16.     //return json data
  17.     echo json_encode($data);
  18. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement