Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- PHP CODE:
- <?php
- $servername = "localhost";
- $username = "username";
- $password = "password";
- $dbname = "dbname";
- // Create connection
- $conn = new mysqli($servername, $username, $password, $dbname);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $menu= htmlspecialchars($_GET["menu"]);
- $sql = "select name,menu,price,picture,description from items where menu='$menu' order by menu asc";
- $result = $conn->query($sql);
- $arr=array();
- if ($result->num_rows > 0) {
- // output data of each row
- while($row = $result->fetch_assoc()) {
- array_push($arr, $row);
- }
- echo json_encode($arr);
- } else {
- echo "0 results";
- }
- $conn->close();
- ?>
- Output:
- [{"name":"XXXXX","menu":"YYYYY","price":"311.55","picture":"https://www.google.com/test/item/test.jpg","description":"Test Message"}]
- Expected Output:
- {
- "data":[
- {
- "name":"XXXXX",
- "menu":"YYYYY",
- "price":"311.55",
- "picture":"https://www.google.com/test/item/test.jpg",
- "description":"Test Message"
- }
- ]
- }
Add Comment
Please, Sign In to add comment