doutuo6689 2019-05-14 20:08
浏览 60
已采纳

json编码数据没有得到Ajax成功检查我的代码

I want to fetch data from database and display into HTML table but ajax URL don't call PHP page and don't get data on success.

Ajax Call: I did not get JSON encoded data on success.

$.ajax({
            url : 'FETCH.PHP',
            dataType:'json',
            contentType: "application/json",
            success: function (data) {
               var data = JSON.stringify(data);

                var html = "";
            for(var a = 0; a < data.length; a++) {
                var firstName = data[a].firstname;
                var email = data[a].email;
                alert(email);

                html += "<tr>";
                    html += "<td>" + firstName + "</td>";
                    html += "<td>" + email + "</td>";
                html += "</tr>";
               document.getElementById("data").innerHTML += html;
              }
            },
            error: function(xhr, textStatus, error){
                alert(xhr.statusText);
                alert(textStatus);
                alert(error);
              }

     });

This is my PHP code page I want to move here using ajax call ==> FETCH.PHP page

<?php
print_r("Hello");
include_once('database/db.php');

$getUsers = $connect->prepare("SELECT * FROM registration ORDER BY id ASC");
$getUsers->execute();
//$users = $getUsers->fetchAll();

$users = $getUsers->fetchAll(PDO::FETCH_ASSOC);

$items = array();
foreach($users as $u) {
    //print_r($u);
 $items[] = $u;
}
var_dump(json_encode($items);
exit(); 
?>
  • 写回答

2条回答 默认 最新

  • dsymx68408 2019-05-15 02:23
    关注

    Remove two things from ajax call and run my code. dataType:'json', contentType: "application/json",

    ==>revised Code

    $.ajax({
            url : 'check.php',
            success: function (data) {
            data = $.parseJSON(data);
               }
            )};
    

    ==> i converted json encoded string into array using $.parseJSON.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 mmocr的训练错误,结果全为0
  • ¥15 python的qt5界面
  • ¥15 无线电能传输系统MATLAB仿真问题
  • ¥50 如何用脚本实现输入法的热键设置
  • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能
  • ¥30 深度学习,前后端连接
  • ¥15 孟德尔随机化结果不一致
  • ¥15 apm2.8飞控罗盘bad health,加速度计校准失败
  • ¥15 求解O-S方程的特征值问题给出边界层布拉休斯平行流的中性曲线
  • ¥15 谁有desed数据集呀