Advertisement
Guest User

Untitled

a guest
Jul 9th, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.88 KB | None | 0 0
  1. class Usuarios
  2. {
  3.     public function  __construct() {
  4.         $dbhost = '*******';
  5.         $dbuser = '*******';
  6.         $dbpass = '*******';
  7.         $dbname = '*******';
  8.  
  9.         mysql_connect($dbhost, $dbuser, $dbpass);
  10.  
  11.         mysql_select_db($dbname);
  12.     }
  13.  
  14.     public function buscarUsuario($nombreUsuario){
  15.         $datos = array();
  16.  
  17.         $sql = "SELECT * FROM guestbook WHERE title LIKE '%$nombreUsuario%' ORDER BY title ASC
  18.    
  19.         LIMIT " . ( ( (int)$_GET['page'] - 1 ) * $messaggi ) . "," . $messaggi;
  20.        
  21.         $resultado = mysql_query($sql) or die("Impossibile eseguire la query" .mysql_error());
  22.  
  23.         while ($row = mysql_fetch_array($resultado, MYSQL_ASSOC)){
  24.             $datos[] = array("value" => $row['title']);
  25.         }
  26.  
  27.         return $datos;
  28.     }
  29. }
  30.  
  31. $usuario = new Usuarios();
  32.  
  33. echo json_encode($usuario->buscarUsuario($_GET['term']));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement