Advertisement
Guest User

Untitled

a guest
Jun 27th, 2019
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. if (isset($_REQUEST['query'])) {
  2. $query = $_REQUEST['query'];
  3. $sql = mysqli_query ($db, "SELECT a, b FROM table WHERE a LIKE '%{$query}%' OR b LIKE '%{$query}%'");
  4. $array = array();
  5. while ($row = mysqli_fetch_assoc($sql)) {
  6. $array[] = array (
  7. 'label' => $row['a'].', '.$row['b'],
  8. 'value' => $row['a'],
  9. );
  10. }
  11. //RETURN JSON ARRAY
  12. echo json_encode ($array);
  13. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement