Advertisement
Guest User

Untitled

a guest
May 26th, 2016
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.60 KB | None | 0 0
  1. <?php  
  2.     $username ="x";
  3.     $password ="x";
  4.     $hostname = "x";
  5.     $database_name = "x";
  6.    
  7.     $con = mysql_connect($hostname, $username, $password);
  8.     $selected = mysql_select_db($database_name);
  9.     $mod = isset($_POST['username']) ? $_POST['username'] : '';
  10.     $result = mysql_query("SELECT * FROM mydb WHERE username='{$mod}'");
  11.  
  12.     $json_response = array();
  13.     while ($row = mysql_fetch_array($result, MYSQLI_ASSOC)) {  
  14.         $row_array['username'] = $row['username'];
  15.         $row_array['time'] = $row['time'];
  16.         array_push($json_response, $row_array);  
  17.     }
  18.    
  19.     echo json_encode(array('x' => $json_response));  
  20. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement