Advertisement
Guest User

Untitled

a guest
May 26th, 2016
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.62 KB | None | 0 0
  1. <?php  
  2.     $username ="x";
  3.     $password ="x";
  4.     $hostname = "x";
  5.     $database_name = "x";
  6.    
  7.     $con = mysqli_connect($hostname, $username, $password);
  8.     $selected = mysqli_select_db($con, $database_name);
  9.     $mod = isset($_POST['username']) ? $_POST['username'] : '';
  10.     $result = mysqli_query($con, "SELECT * FROM mydb WHERE username='".$mod."'");
  11.    
  12.     $json_response = array();
  13.     while ($row = mysqli_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('webloker' => $json_response));  
  20. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement