Retrieve MySQL data using JSON, PHP

Asked May 10 '16 at 10:56

Active May 10 '16 at 12:15

Viewed 57 times

I'm having a trouble getting data from my database; Here's my code

<?php
 require('connectionT.php');

 $result= mysqli_query($con, "SELECT * FROM restaurants");
 while($row=mysqli_fetch_assoc($result))
  {
        $tmp[]=$row;

  }

  echo json_encode ($tmp);

?>

When I execute my code, I just get a blank page. Anyone?

edited May 10 '16 at 11:10

Parth Panchal

asked May 10 '16 at 10:56

Algerian Psycho

4

Does the database contain values? Is the database connection right? Did you enable error reporting? http://stackoverflow.com/a/845025/1864587 – R Pelzer May 10 '16 at 10:59
Use error_reporting(E_ALL); and check paste error here. – RJParikh May 10 '16 at 10:59
Show use the contents of `connectionT.php` – RiggsFolly May 10 '16 at 11:20
I'm using a small database, it has like 23 rows. When I try to use a query like " SELECT subCategory From restaurants". Works perfectly. This is my ConnectionT.php http://paste.ofcode.org/ECXUkazqtGtDy8qaQM6bqy – Algerian Psycho May 10 '16 at 11:24
No error. Just a blank page. – Algerian Psycho May 10 '16 at 11:27

Retrieve MySQL data using JSON, PHP

0 Answers0