Advertisement
payen83

Swift RETRIEVE Data

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