donglie7778 2012-07-12 15:52
浏览 31
已采纳

是php json_encode和AJAX打破我的阵列?

I'm grabbing some database entries, creating a 2D array and then passing them to js with AJAX. But when I loop through the array in javascript, it's an "undefined" mess. The console log for dbArray works fine, so I know the PHP/AJAX is working. Not sure what I am doing wrong with the loop...

PHP ('load-words.php):

$query = mysql_query("
SELECT * FROM words 
ORDER BY RAND() 
LIMIT 50
") or die(mysql_error()); 

$dbArray = array(); 
while ($row = mysql_fetch_assoc($query)) {
    $word_phrase = stripslashes($row['word_phrase']);
    $description = stripslashes($row['description']);
    // construct a 2D array containing each word and description
    $dbArray[] = array($word_phrase,$description);      
};

echo json_encode($dbArray);

Javascript:

$.ajax({
    url: 'func/load-words.php',
    success: function(dbArray) {
        console.log(dbArray);
        var items = "<ul>";
        for (var i in dbArray) {
            items += "<li><a href='#'><b>" + dbArray[i][0] + ' : ' + dbArray[i][1] + "</a></li>";
        }
        items += "</ul>";
        div = $('#dbArray');
        div.html(items);
    }
});
  • 写回答

1条回答 默认 最新

  • doushi6932 2012-07-12 16:03
    关注

    I guess this is failing because jQuery is interpreting the AJAX response as a string, since your PHP is not outputting a JSON header and your AJAX is not stipulating JSON. This is easily tested:

    $.ajax({
        url: 'func/load-words.php',
        success: function(dbArray) { alert(typeof dbArray); /* "string"? */ }
    });
    

    Try

    $.ajax({
        url: 'func/load-words.php',
        dataType: 'json', //<-- now we explicitly expect JSON
        success: function(dbArray) { alert(typeof dbArray); /* "object"? */ }
    });
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 给自己本科IT专业毕业的妹m找个实习工作
  • ¥15 用友U8:向一个无法连接的网络尝试了一个套接字操作,如何解决?
  • ¥30 我的代码按理说完成了模型的搭建、训练、验证测试等工作(标签-网络|关键词-变化检测)
  • ¥50 mac mini外接显示器 画质字体模糊
  • ¥15 TLS1.2协议通信解密
  • ¥40 图书信息管理系统程序编写
  • ¥20 Qcustomplot缩小曲线形状问题
  • ¥15 企业资源规划ERP沙盘模拟
  • ¥15 树莓派控制机械臂传输命令报错,显示摄像头不存在
  • ¥15 前端echarts坐标轴问题