Advertisement
payen83

Sample Output JSON

Mar 15th, 2016
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. <?php
  2.  
  3. $dbhost = 'localhost';
  4. $dbuser = 'sampleuser';
  5. $dbpass = 'samplepassword';
  6. $dbname = 'sampleuser_dbname';
  7.  
  8. mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());
  9. mysql_select_db($dbname);
  10.  
  11.  
  12. //view users in db
  13.  
  14. $result = mysql_query("SELECT * FROM sampleuser_dbname.xdkdemo") or die(mysql_error());
  15. $emparray = array();
  16. while ($row = mysql_fetch_assoc($result)){
  17. $emparray['employees'][] = $row;
  18. }
  19. //echoing JSON response
  20. echo json_encode($emparray);
  21.  
  22. //closedb
  23. mysql_close();
  24. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement