dtwk6019 2019-03-18 19:47
浏览 1707


I have data coming from MySql, answered from this: How to SQL query parent-child for specific JSON format?. Basically I query it using JSON_OBJECT() which produces the result:

results <-- The column name

{"projects": "project_name": "project 1", [2nd layer stuff]}  <-- the row

Awesome. MySql did the json thing for me. I make an ajax call to a PHP function to get this onto the web server.:

myPhpFunction () {
    //some usual PDO code
    echo json_encode($query_result);

On JS, I make a jQuery ajax call:

var ajaxRequest =
        type: 'post',
        url: '../includes/ajax.php',
        data: 'action' : 'myPhpFunction',
        dataType: 'json'

      ajaxRequest.done(function(data) { 
        //$.each(data[0].results.projects, function(key, val){ 
            //I want to access each stuff in the object here
        $('#ph-projects').append(JSON.stringify(data)); //testing it out

The problem I'm having is by this time, my object data outputs like this:

{ "results": "{...}" }

results value is a string because of those double quotes!

This is driving me crazy. Am I missing a step to prevent this from happening?

  • 写回答

1条回答 默认 最新

  • du0531 2019-03-18 20:15

    The json_encode() is working fine as it is providing the result as a JSON object as suggested by your question({ "results": "{...}" }). And JSON_OBJECT() in PDO returning a string is fine as the name JSON suggests, its JavaScript Object Notation in a humanly readable format.

    You can do on the server side:

    json_encode(['results'=> json_decode($query_result['results'])]);

    or on client side,

        data.results = JSON.parse(data.results);
        // Your json data here
    本回答被题主选为最佳回答 , 对您是否有帮助呢?



  • ¥15 关于#linux#的问题(输入输出错误):出现这个界面接着我重新装系统,又让修电脑的师傅帮我扫描硬盘(没有问题)用着用着又卡死(相关搜索:固态硬盘)
  • ¥15 cv::resize不同线程时间不同
  • ¥15 web课程,怎么做啊😭没好好听课 根本不知道怎么下手
  • ¥15 做一个关于单片机的比较难的代码,然后搞一个PPT进行解释
  • ¥15 python提取.csv文件中的链接会经常出现爬取失败
  • ¥15 数据结构中的数组地址问题
  • ¥15 maya的mel里,怎样先选择模型A,然后利用mel脚本自动选择有相同名字的模型B呢。
  • ¥15 Python题,根本不会啊
  • ¥15 会会信号与系统和python的来
  • ¥15 关于#python#的问题