使用ajax/jquery绑定Json数据 - Binding Json data with ajax/jquery

Binding Json data with ajax/jquery

本文关键字：Json 数据绑定 jquery ajax 使用 | 更新日期: 2024-05-25

我有sql脚本，必须编码到json（data.php），我想从data.php 绑定json数据

这是data.php中的脚本：

switch ($data){
    case "report-reg-perday":
        $query=("SELECT FROM_UNIXTIME(reqtime, '%Y %D %M') AS 'reqtime', COUNT(DISTINCT user_id) AS 'jumlah' FROM users_demoid GROUP BY FROM_UNIXTIME(reqtime,'%Y %D %M') ORDER BY FROM_UNIXTIME(reqtime) ASC ");
        break;
    case "report-reg-perweek":
        $query=("SELECT FROM_UNIXTIME(reqtime, '%U') AS 'reqtime', COUNT(DISTINCT user_id) AS 'jumlah' FROM users_demoid GROUP BY FROM_UNIXTIME(reqtime,'%U') ORDER BY FROM_UNIXTIME(reqtime) ASC ");
        break;
    case "report-reg-permonth":
        $query=("SELECT FROM_UNIXTIME(reqtime, '%M') AS 'reqtime', COUNT(DISTINCT user_id) AS 'jumlah' FROM users_demoid GROUP BY FROM_UNIXTIME(reqtime,'%M') ORDER BY FROM_UNIXTIME(reqtime) ASC ");
        break;
    default:
        $query=("SELECT FROM_UNIXTIME(reqtime) AS 'reqtime', COUNT(DISTINCT user_id) AS 'jumlah' FROM users_demoid GROUP BY FROM_UNIXTIME(reqtime,'%U') ORDER BY FROM_UNIXTIME(reqtime) ASC ");
        }
$result = mysql_query($query) or die("SQL Error 1: " . mysql_error());
//get data and store in a json array
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    //$date=date("l, F j, Y H:i:s",$row['reqtime']);
            $orders[] = array(
                'reqtime' => $row['reqtime'],
                'jumlah' => $row['jumlah'],
            );
}
echo json_encode($orders);

我想将"reqtime"answers"jumlah"绑定到我的javascript/ajax:

    $(function ()  
                {
   var dataSource = [
    { request_time: 'reqtime', total: 'jumlah'}
];

$("#chartContainer").dxChart({
    dataSource: dataSource,
    equalBarWidth: {
        width: 50
    },
    commonSeriesSettings: {
        argumentField: "request_time",
        type: "bar",
        hoverMode: "allArgumentPoints",
        selectionMode: "allArgumentPoints",
        label: {
            visible: true,
            format: "fixedPoint",
            precision: 0
        }
    },
    series: [
        { valueField: "total", name: "Registrant" }
    ],
    title: "Report",
    legend: {
        verticalAlignment: "bottom",
        horizontalAlignment: "center"
    },
    pointClick: function (point) {
        this.select();
    }
});
}

json、ajax和javascript 中的hhe im nubie

区块报价

谢谢你。

试试这个，

var dataSource;
$.ajax({
   url:'data.php',
   dataType:'json',
   success: function(d){
      if(d.length){
         dataSource = d;
         // code for dxchart;
      }
   }
});