dssqq64884 2018-08-21 08:59
浏览 49
已采纳

PHP上未显示JSON多维数组

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

  • 写回答

1条回答 默认 最新

  • dongxiong1941 2018-08-21 09:05
    关注
        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

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 CST仿真别人的模型结果仿真结果S参数完全不对
  • ¥15 误删注册表文件致win10无法开启
  • ¥15 请问在阿里云服务器中怎么利用数据库制作网站
  • ¥60 ESP32怎么烧录自启动程序
  • ¥50 html2canvas超出滚动条不显示
  • ¥15 java业务性能问题求解(sql,业务设计相关)
  • ¥15 52810 尾椎c三个a 写蓝牙地址
  • ¥15 elmos524.33 eeprom的读写问题
  • ¥15 用ADS设计一款的射频功率放大器
  • ¥15 怎么求交点连线的理论解?