Advertisement
Guest User

Untitled

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