流程有些复杂,需要按照JSON格式输出一串字符串,格式如下:
{
"list_info": [
{
"order_id": "1",
"order_status": "0",
"order_contact_type": "0",
"order_contact": "0",
"order_contact_name": "王二",
"order_contact_tel": "13386056143",
"cart_list": []
},
{
"order_id": "2",
"order_status": "0",
"order_contact_type": "0",
"order_contact": "5",
"order_contact_name": "李四",
"order_contact_tel": "18605449879",
"cart_list": []
}
],
"timestamp": "1435576540"
}
实现代码如下:
header("Content-type: text/html; charset=utf-8");
$user_id = $_POST['user_id'];
$rows = array();
$sql = "SELECT * FROM order_info WHERE order_info.user_id = '$user_id'";
$result = mysql_query($sql,$conn) or die(mysql_error());
while($r = mysql_fetch_assoc($result)) {
//cart_list 不在数据库搜索的结果中,所以人为预留cart_list
$r['cart_list'] = $tm;
$rows['list_info'][] = $r;
}
$rows['timestamp'] = time();
echo "<br />".JSON($rows);
.php中调用数据库,select出来结果,如何保存到"cart_list"中?
$sqltmp = "SELECT * FROM order_goods_info WHERE order_goods_info.user_id = '$user_id' AND order_goods_info.order_id = '$order_id'";
$resulttmp = mysql_query($sqltmp,$conn) or die(mysql_error());
while($tmpr = mysql_fetch_assoc($resulttmp)){
//此时,如何将$tmpr 存储到第一步中的 cart_list 数组中去?
}
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。