Advertisement
Jenderal92

Untitled

Sep 28th, 2022 (edited)
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. <?php
  2.  
  3. $mysqli = new mysqli("host", "username", "password", "database");
  4. $sql = "SELECT name FROM countries
  5. WHERE name LIKE '%".$_GET['query']."%'
  6. LIMIT 10";
  7. $result = $mysqli->query($sql);
  8. $data = [];
  9. while($row = $result->fetch_assoc()){
  10. $data[] = $row['name'];
  11. }
  12. echo json_encode($data);
  13. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement