dougong8012
2015-07-28 18:16
浏览 196
已采纳

如何将数据从mysql数据库发送到JS脚本?

My intention is to query an MySQL database using a PHP script and then send the information to JavaScript.

I know how to encode the info into the JSON and send the request to the server script.

How does the PHP script know it has been queried it should answer?

图片转代码服务由CSDN问答提供 功能建议

我的目的是使用PHP脚本查询MySQL数据库,然后将信息发送给JavaScript。

我知道如何将信息编码为JSON并将请求发送到服务器脚本。

PHP脚本如何知道它已被查询它应该回答 ?

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

4条回答 默认 最新

  • douhe1002 2015-07-29 06:19
    已采纳

    Thank you for all the feedback provided!

    Unfortunately, I was not sure, whether I had to use exit or header('Content-Type: application/json') as the answers suggested, I decided to use both.

    In the end, I added both. This is what worked:

    header('Content-Type: application/json');
    echo json_encode($rows, JSON_NUMERIC_CHECK);
    exit;
    
    已采纳该答案
    评论
    解决 无用
    打赏 举报
  • doushi9729 2015-07-28 18:25

    You need to send the header information specifying the content that you are returning. I have no idea how your application is setup but if you run this as a php script and define $data to be an array it would work fine.

    header('Content-Type: application/json');
    echo json_encode($data);
    
    评论
    解决 无用
    打赏 举报
  • dp815292 2015-07-28 18:25

    you should set content type in the http header to json

    评论
    解决 无用
    打赏 举报
  • duanlan3598 2015-07-28 18:28

    You can use json_encode

    Let's say you want to have some JSON like:

    {
      'name': 'bob',
      'weight': 150
    }
    

    In PHP, you could respond to the JS AJAX request with:

    echo json_encode(array('name' => 'bob', 'weight' => 150));
    exit;
    

    Hope that helps!

    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题