Advertisement
Guest User

Untitled

a guest
Dec 1st, 2016
184
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.53 KB | None | 0 0
  1. //jsongetdata.php
  2. <?php
  3. $host="mysql12.000webhost.com";
  4. $database="a8382643_demo";
  5. $username="a8382643_demo";
  6. $password="demo123";
  7.  
  8. $sql= "select * from users;";
  9. $con =mysqli_connect($host,$username,$password,$database);
  10.  
  11. $result= mysqli_query($con,$sql);
  12.  
  13. $response= array();
  14.  
  15. while($row=mysqli_fetch_array($result))
  16. {
  17.    
  18.     array_push($response,array("name"=>$row[0],"email"=>$row[1],"contact"=>$row[2],"password"=>$row[3]));
  19.    
  20. }
  21.  echo json_encode(array("server_response"=>$response));
  22.  mysqli_close($con);
  23.  
  24.  
  25. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement