Advertisement
Guest User

Untitled

a guest
Oct 7th, 2016
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. <?php
  2. $servername = "my server name";
  3. $username = "my user nane";
  4. $password = "my password";
  5. $dbname = "my databse name";
  6.  
  7. // Create connection
  8. $connect = @mysql_connect($servername, $username, $password)or die("Cannot connect! ".mysql_error());
  9. $db = @mysql_select_db($dbname,$connect)or die("Cannot connect!2 ".mysql_error());
  10.  
  11. $query = mysql_query("SELECT * FROM login");
  12.  
  13. $ss="";
  14.  
  15. class json {
  16. public $MyEnggShop = array();
  17. }
  18.  
  19. $ob=new json();
  20.  
  21. class MyShop{
  22. public $id = "";
  23. public $email = "";
  24. public $number = "";
  25. public $password = "";
  26. }
  27.  
  28. $i=0;
  29.  
  30. while ($rows = mysql_fetch_array($query)):
  31.  
  32. $e = new MyShop();
  33.  
  34.  
  35. $e->id = $rows['ID'];
  36. $e->email= $rows['Email'];
  37. $e->number= $rows['number'];
  38. $e->password= $rows['Password'];
  39.  
  40. $arr[$i]= $e;
  41. $i=$i+1;
  42.  
  43. endwhile;
  44.  
  45.  
  46. $ob->MyEnggShop = $arr;
  47.  
  48. echo json_encode($ob);
  49.  
  50.  
  51.  
  52. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement