Advertisement
Guest User

Untitled

a guest
May 23rd, 2016
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. <?php
  2. $username="x";
  3. $password="x";
  4. $hostname = "x";
  5. $database_name = "x";
  6.  
  7. $dbhandle = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");
  8. $selected = mysql_select_db($database_name, $dbhandle) or die("Could not select examples");
  9.  
  10. $result = mysql_query("SELECT * FROM isfaaghyth WHERE username='" . htmlspecialchars($_POST["username"]) . "'");
  11.  
  12. $json_response = array();
  13.  
  14. while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
  15. $row_array['username'] = $row['username'];
  16. $row_array['status'] = $row['status'];
  17. array_push($json_response, $row_array);
  18. }
  19.  
  20. echo json_encode(array('test' => $json_response));
  21. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement