Advertisement
Guest User

Untitled

a guest
Jul 3rd, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.85 KB | None | 0 0
  1. //creazione di un array vuoto
  2. $return_arr = array();
  3.  
  4. //dati di accesso a mysql e al db
  5. $dbhost = 'YOUR_SERVER';
  6. $dbuser = 'YOUR_USERNAME';
  7. $dbpass = 'YOUR_PASSWORD';
  8. $dbname = 'YOUR_DATABASE_NAME';
  9.  
  10. //definisco la variabile di ricerca dell'utente
  11. $term = $_GET("term");
  12.  
  13. //connessione al a mysql
  14. $conn = mysql_connect($dbhost, $dbuser, $dbpass)
  15. or die ('Impossibile connettersi a Mysql');
  16. //selezione ddb
  17. mysql_select_db($dbname);
  18. //se connesso
  19. if ($conn)
  20. {
  21. //query select
  22. $fetch = mysql_query("SELECT * FROM tags WHERE MATCH(tagName) AGAINST('".$term."*')");
  23. //loop dei dati
  24. while ($row = mysql_fetch_array($fetch, MYSQL_ASSOC)) {
  25. $row_array['value'] = $row['tagName '];
  26. array_push($return_arr,$row_array);
  27. }
  28.  
  29. }
  30. //chiudo la connessione a mysql
  31. mysql_close($conn);
  32. //restituisco l'array in formato json
  33. echo json_encode($return_arr);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement