几段代码
前端
$.post("index.php?app=my_report&act=get_customer_deal_detail",
{
"buyer_id":buyer_id,"agent_id":agent_id,"begin_time":begin_time,
"end_time":end_time, "direction":direction, "is_orientation":0,page:1,rows:10
}
,function(result){
$("#json_table tbody").empty();
$.each(result.rows,function(i,n){
$("#json_table tbody").append('<tr><td>'+n.order_sn+'</td><td>'+ n.name+'</td><td>'+ n.material+'</td><td>'+ n.spec+'</td><td>'+ n.quantity+'</td><td>'+ n.weight+'</td><td>'+ n.price+'</td><td>'+ n.region+'</td><td>'+ n.warehouse+'</td><td>'+ n.shipping_fee+'</td></tr>')
})
});
服务端 php
$values = $this->_query_sql($sql);
$orderextm = & m('orderextm');
$data['total'] = $total;
$rows = Array();
foreach ($values as $v) {
$row = Array();
$row['order_sn'] = $v['order_sn'];
$row['name'] = $v['goods_name'];
$row['material'] = $v['spec_2'];
$row['spec'] = $v['spec_1'];
$row['quantity'] = $v['quantity'] . $v['unit'];
$t = $v['quantity'] * $v['measure'];
$t = floor($t * 1000000) / 1000000;
$row['weight'] = $t . $v['weight'];
$row['price'] = price_format($v['price']);
$row['region'] = $v['region_name'];
$row['warehouse'] = $v['warehouse_name'];
$order_id = $v['order_id'];
$orderextm_info = $orderextm->get("order_id=" . $order_id);
$row['shipping_fee'] = price_format($orderextm_info['shipping_fee']);
$rows[] = $row;
}
$data['rows'] = $rows;
print_r(json_encode($data));
$.each(result.rows,function(i,n){
其中i为index,即键,n为value,即值。类似php中的foreach
jquery并不需要解析json数据,因为json原生就是支持js的,下面还有一段代码
对于这段json数组
{"sum_money":"6400","sum_weight":"6","compare_sum_weight":"9","compare_sum_money":"9000","new_order":"4","compare_order":"3"}
var dataObj=eval("("+data+")");
$("#sum_money").text(dataObj.sum_money);
$("#sum_weight").text(dataObj.sum_weight);
var result_sum_weight=Math.round((dataObj.sum_weight-dataObj.compare_sum_weight) / dataObj.compare_sum_weight * 1000) / 10.00;
if(isNaN(result_sum_weight)){
result_sum_weight=0;
}
这样解析,注意后面获取百分数的方法,和判断是否为数字的方法。
JSON字符串:
var str1 = '{ "name": "deyuyi", "sex": "man" }';
JSON对象:
var str2 = { "name": "deluyi", "sex": "man" };
可以简单这样理解:
JSON对象是直接可以使用JQuery操作的格式,如C#中可以用对象(类名)点出属性(方法)一样;
JSON字符串仅仅只是一个字符串,一个整体,不截取的话没办法取出其中存储的数据,不能直接使用,需用eval()等方法解析。
这篇文章很详细http://www.cnblogs.com/madyina/p/3448518.html