Guest User

Untitled

a guest
Oct 27th, 2018
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. PHP CODE:
  2. <?php
  3. $servername = "localhost";
  4. $username = "username";
  5. $password = "password";
  6. $dbname = "dbname";
  7.  
  8. // Create connection
  9. $conn = new mysqli($servername, $username, $password, $dbname);
  10. // Check connection
  11. if ($conn->connect_error) {
  12. die("Connection failed: " . $conn->connect_error);
  13. }
  14. $menu= htmlspecialchars($_GET["menu"]);
  15.  
  16. $sql = "select name,menu,price,picture,description from items where menu='$menu' order by menu asc";
  17.  
  18. $result = $conn->query($sql);
  19. $arr=array();
  20. if ($result->num_rows > 0) {
  21. // output data of each row
  22. while($row = $result->fetch_assoc()) {
  23. array_push($arr, $row);
  24. }
  25. echo json_encode($arr);
  26. } else {
  27. echo "0 results";
  28. }
  29. $conn->close();
  30. ?>
  31.  
  32. Output:
  33. [{"name":"XXXXX","menu":"YYYYY","price":"311.55","picture":"https://www.google.com/test/item/test.jpg","description":"Test Message"}]
  34.  
  35. Expected Output:
  36. {
  37. "data":[
  38. {
  39. "name":"XXXXX",
  40. "menu":"YYYYY",
  41. "price":"311.55",
  42. "picture":"https://www.google.com/test/item/test.jpg",
  43. "description":"Test Message"
  44. }
  45. ]
  46. }
Add Comment
Please, Sign In to add comment