PHP上未显示JSON多维数组

Question

I make a normal API like this

header('Content-Type: application/json');
$return = array();
$conn = mysqli_connect("localhost","root","mysql","dummy");
$fetch = mysqli_query($conn,"SELECT * FROM DATA "); 
while($re=mysqli_fetch_array($fetch)){
    $return[] = $re;
}
echo json_encode($return);

And its not showing anything in my laptop

Edit :

I read some article that PHP can't send more than 1000 request, and my api have more than 1000 data. After i add WHERE id BETWEEN 1 AND 20 it works normally.

Thanks for you guys that answer my question

Answer 1

    header('Content-Type: application/json');
    $return = array();
    $conn = mysqli_connect("localhost","root","mysql","dummy");
    $fetch = mysqli_query($conn,"SELECT * FROM `DATA`") or die(mysqli_error($conn));
    while($re=mysqli_fetch_array($fetch)){
        $return[] = $re;
    }
    echo json_encode($return);

Your code works. Try to escape DATA table name like above. Tested it locally and works fine for me the only issue i can see that may cause an issue is the table name.

Next time avoid to name your table with capital letters or with words that are mysql Keywords, or if you do, make sure to escape them using ` like i did in the above example. You will find additional info into this link