Guest User

Untitled

a guest
Oct 22nd, 2017
383
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. {"0":"1","ID":"1","1":"2017-10-21 12:39:23","Date":"2017-10-21 12:39:23","2":"Student1","Name":"Student1","3":"student1@stud.com","Email":"student1@stud.com","4":"89123456789","Phone":"89123456789","5":"u042du0423-119","Group":"u042du0423-119","6":"u041fu043eu0436u0435u043bu0430u043du0438u044f","Comment":"u041fu043eu0436u0435u043bu0430u043du0438u044f"}{"0":"2","ID":"2","1":"2017-10-21 20:20:49","Date":"2017-10-21 20:20:49","2":"u0441u0435u0440u0433u0435u0439","Name":"u0441u0435u0440u0433u0435u0439","3":"sad@dsfsd.com","Email":"sad@dsfsd.com","4":"89222222222","Phone":"89222222222","5":"u042du0423-119","Group":"u042du0423-119","6":"rrr","Comment":"rrr"}
  2.  
  3. <?php
  4.  
  5. $host="mysql.hostinger.ru";
  6. $user="u997029462_bo";
  7. $pass="9128925907"; //установленный вами пароль
  8. $db_name="u997029462_bo";
  9.  
  10. $link=mysql_connect($host,$user,$pass);
  11. mysql_select_db($db_name,$link);
  12.  
  13.  
  14. $sql = mysql_query("SELECT * FROM Student", $link);
  15. while ($result = mysql_fetch_array($sql)) {
  16. echo json_encode($result);
  17. }
  18.  
  19. echo "["
  20. while ($result = mysql_fetch_array($sql)) {
  21. echo json_encode($result);
  22. echo ",";
  23. }
  24. echo "]";
Add Comment
Please, Sign In to add comment