请教一下这个json数组如何入库

好啊u 2017-12-07 10:46:42

新手刚学习php，请问下面这个数据如何入库，每个元素分别为1条，键名别是对应数据库的字段名

[{"cid":6,"title":"\u4e1c\u5317\u6709\u673a\u4e94\u8c37\u6742\u7cae\u7ec4\u5408\u81b3\u98df\u7c97\u7cae\u7ca5\u8425\u517b\u996d\u8c46\u6d46\u539f\u6599\u5341\u8c37\u7c734000g\u5305\u90ae","d_title":"\u4e1c\u5317\u6709\u673a\u4e94\u8c37\u6742\u7cae\u7ec4\u5408\u81b3\u98df\u7c97\u7cae\u7ca54000g","goods_id":"558820596536","pic_link":"\/i1\/1125342007\/TB2AqS9afjM8KJjSZFyXXXdzVXa_!!1125342007.jpg","istmall":1,"sales":58,"goods_dsr":4.9,"org_price":148,"price":88,"introduce":"\u5b5d\u4eb2\u793c\u76d2\u6709\u673a\u6742\u7cae4000\u88c5\uff0c\u8db3\u91cf\u81b3\u98df\u7ea4\u7ef4\u4e30\u5bcc\uff0c\u6709\u9971\u8179\u611f\u4e0d\u7528\u62c5\u5fc3\u80fd\u91cf\u8fc7\u5269\uff0c\u5403\u7684\u5b89\u5168\u653e\u5fc3\uff0c\u4eab\u53d7\u5929\u7136\u822c\u7684\u53e3\u611f\u3002","coupon_id":"1573edd2f1304c3b935efb387844c73d","coupon_price":60,"coupon_receive":0,"coupon_surplus":10000,"coupon_condition":"","coupon_stime":1512656551,"coupon_etime":1513267199,"coupon_link":"3280280647&activity_id=1573edd2f1304c3b935efb387844c73d","Commission":20.5,"Commission_jihua":20.5,"Commission_queqiao":0,"jihua_link":"2013.1.0.0.45Gd0g#!\/promo\/self\/campaign?campaignId=71433880&shopkeeperId=123400654&userNumberId=3280280647","jihua_shenhe":null,"dtkid":4736890,"addtime":1512656551,"updatetime":1512656551},{"cid":6,"title":"\u6709\u673a\u4e94\u8c37\u6742\u7cae\u7ec4\u5408\u5341\u8c37\u7c73\u6742\u7cae\u7ca5\u996d\u539f\u6599\u65e0\u5927\u7c73\u5065\u8eab\u9910\u65b0\u7c73400*3\u5305\u90ae","d_title":"\u6709\u673a\u4e94\u8c37\u6742\u7cae\u7ec4\u5408\u5341\u8c37\u7c73\u6742\u7cae\u7ca5\u996d","goods_id":"559934914414","pic_link":"\/i2\/1125342007\/TB2m0dKc3fH8KJjy1zcXXcTzpXa_!!1125342007.jpg","istmall":1,"sales":127,"goods_dsr":4.9,"org_price":38.4,"price":28.4,"introduce":"\u6709\u673a\u6742\u7cae\uff0c\u9897\u7c92\u9971\u6ee1\uff0c\u65b0\u7c73\u751f\u957f\u5468\u671f\u957f\uff0c\u975e\u8f6c\u57fa\u56e0\uff0c\u6bcf\u4e00\u7c92\u90fd\u6709\u8eab\u4efd\uff0c\u5b89\u5168\u6211\u4eec\u4fdd\u969c\u3002","coupon_id":"74035a5217c94599832a1c00ba7b4dcf","coupon_price":10,"coupon_receive":0,"coupon_surplus":10000,"coupon_condition":"","coupon_stime":1512656551,"coupon_etime":1513267199,"coupon_link":"3280280647&activity_id=74035a5217c94599832a1c00ba7b4dcf","Commission":20.5,"Commission_jihua":20.5,"Commission_queqiao":0,"jihua_link":"2013.1.0.0.45Gd0g#!\/promo\/self\/campaign?campaignId=71433880&shopkeeperId=123400654&userNumberId=3280280647","jihua_shenhe":null,"dtkid":4736884,"addtime":1512656551,"updatetime":1512656551},{"cid":8,"title":"\u5357\u6781\u4eba\u8db3\u6d74\u76c6\u6ce1\u811a\u76c6\u6876\u5168\u81ea\u52a8\u6309\u6469\u7535\u52a8\u52a0\u70ed\u8db3\u7597\u673a\u5668\u5bb6\u7528\u6052\u6e29\u6d17\u811a\u76c6","d_title":"\u5357\u6781\u4eba6\u6eda\u8f6e\u9065\u63a7\u6db2\u6676\u5c4f\u7535\u52a8\u8db3\u6d74\u76c6","goods_id":"558295255856","pic_link":"\/i1\/1816897885\/TB2WU4ng2NNTKJjSspeXXaSwpXa_!!1816897885.jpg","istmall":1,"sales":3444,"goods_dsr":4.8,"org_price":199,"price":159,"introduce":"\u5357\u6781\u4eba\u8db3\u7597\u673a\uff0c\u4e00\u952e\u542f\u52a8\uff0c\u9632\u7535\u5899\u8bbe\u8ba1\uff0c\u524d\u7aef\u52a0\u70ed\uff0c\u4fbf\u643a\u6392\u6c34\uff0c\u591a\u79cd\u6a21\u5f0f\uff0c\u54c1\u8d28\u751f\u6d3b\uff0c\u4ece\u5357\u6781\u4eba\u8db3\u6d74\u76c6\u5f00\u59cb\u3010\u8d60\u8fd0\u8d39\u9669\u3011","coupon_id":"749ef3710d11484ab2aad059388efa45","coupon_price":40,"coupon_receive":0,"coupon_surplus":4000,"coupon_condition":"","coupon_stime":1512656551,"coupon_etime":1513267199,"coupon_link":"2454060579&activity_id=749ef3710d11484ab2aad059388efa45","Commission":25.4,"Commission_jihua":0,"Commission_queqiao":25.4,"jihua_link":"0","jihua_shenhe":null,"dtkid":4736857,"addtime":1512656551,"updatetime":1512656551},{"cid":3,"title":"\u7537\u58eb\u7d20\u989c\u971c\u63d0\u4eae\u80a4\u8272BB\u971c\u61d2\u4eba\u971c\u906e\u7455\u75d8\u5370\u7c89\u5e95\u6db2\u818f\u81ea\u7136\u8272\u5316\u5986\u54c1\u5957\u88c5","d_title":"\u4e00\u62b9\u5373\u4eae\u7537\u58eb\u906e\u7455\u7d20\u989c\u971cbb\u971c","goods_id":"544410512702","pic_link":"\/i2\/1015563178\/TB2PLZfcZnI8KJjSsziXXb8QpXa_!!1015563178.jpg","istmall":1,"sales":12129,"goods_dsr":4.8,"org_price":59.9,"price":39.9,"introduce":"\u4e00\u62b9\u5373\u767d\uff0c\u5feb\u901f\u63d0\u4eae\uff0c\u81ea\u7136\u906e\u7455\uff0c\u514d\u5378\u5986\uff01\u8f7b\u677e\u6253\u9020\u81ea\u7136\u6e05\u900f\u88f8\u5986\u611f\uff0c1\u5206\u949f\u5c31\u53ef\u4ee5\u81ea\u4fe1\u51fa\u95e8\uff0c\u7537\u58eb\u5fc5\u5907~","coupon_id":"9e463d6a7302431fb5cd3c8ca9f51c00","coupon_price":20,"coupon_receive":0,"coupon_surplus":10000,"coupon_condition":"","coupon_stime":1512656551,"coupon_etime":1513007999,"coupon_link":"1015563178&activity_id=9e463d6a7302431fb5cd3c8ca9f51c00","Commission":31,"Commission_jihua":31,"Commission_queqiao":0,"jihua_link":"58037899&shopkeeperId=32429801&userNumberId=1015563178","jihua_shenhe":null,"dtkid":4736841,"addtime":1512656551,"updatetime":1512656551}]

...全文

393 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

伟洪winni 2017-12-09

打赏
举报

json_decode — 对 JSON 格式的字符串进行解码

c1s2d3n40 2017-12-09

打赏
举报

把json先转义过来，之后insert就可以了，4楼的方法挺好的

xuzuning 2017-12-08

打赏
举报

spl_autoload_register();
header('Content-type: text/html;charset=utf-8');
$s =<<< TXT
[{"cid":6,"title":"\u4e1c\u5317\u6709\u673a\u4e94\u8c37\u6742\u7cae\u7ec4\u5408\u81b3\u98df\u7c97\u7cae\u7ca5\u8425\u517b\u996d\u8c46\u6d46\u539f\u6599\u5341\u8c37\u7c734000g\u5305\u90ae","d_title":"\u4e1c\u5317\u6709\u673a\u4e94\u8c37\u6742\u7cae\u7ec4\u5408\u81b3\u98df\u7c97\u7cae\u7ca54000g","goods_id":"558820596536","pic_link":"\/i1\/1125342007\/TB2AqS9afjM8KJjSZFyXXXdzVXa_!!1125342007.jpg","istmall":1,"sales":58,"goods_dsr":4.9,"org_price":148,"price":88,"introduce":"\u5b5d\u4eb2\u793c\u76d2\u6709\u673a\u6742\u7cae4000\u88c5\uff0c\u8db3\u91cf\u81b3\u98df\u7ea4\u7ef4\u4e30\u5bcc\uff0c\u6709\u9971\u8179\u611f\u4e0d\u7528\u62c5\u5fc3\u80fd\u91cf\u8fc7\u5269\uff0c\u5403\u7684\u5b89\u5168\u653e\u5fc3\uff0c\u4eab\u53d7\u5929\u7136\u822c\u7684\u53e3\u611f\u3002","coupon_id":"1573edd2f1304c3b935efb387844c73d","coupon_price":60,"coupon_receive":0,"coupon_surplus":10000,"coupon_condition":"","coupon_stime":1512656551,"coupon_etime":1513267199,"coupon_link":"3280280647&activity_id=1573edd2f1304c3b935efb387844c73d","Commission":20.5,"Commission_jihua":20.5,"Commission_queqiao":0,"jihua_link":"2013.1.0.0.45Gd0g#!\/promo\/self\/campaign?campaignId=71433880&shopkeeperId=123400654&userNumberId=3280280647","jihua_shenhe":null,"dtkid":4736890,"addtime":1512656551,"updatetime":1512656551},{"cid":6,"title":"\u6709\u673a\u4e94\u8c37\u6742\u7cae\u7ec4\u5408\u5341\u8c37\u7c73\u6742\u7cae\u7ca5\u996d\u539f\u6599\u65e0\u5927\u7c73\u5065\u8eab\u9910\u65b0\u7c73400*3\u5305\u90ae","d_title":"\u6709\u673a\u4e94\u8c37\u6742\u7cae\u7ec4\u5408\u5341\u8c37\u7c73\u6742\u7cae\u7ca5\u996d","goods_id":"559934914414","pic_link":"\/i2\/1125342007\/TB2m0dKc3fH8KJjy1zcXXcTzpXa_!!1125342007.jpg","istmall":1,"sales":127,"goods_dsr":4.9,"org_price":38.4,"price":28.4,"introduce":"\u6709\u673a\u6742\u7cae\uff0c\u9897\u7c92\u9971\u6ee1\uff0c\u65b0\u7c73\u751f\u957f\u5468\u671f\u957f\uff0c\u975e\u8f6c\u57fa\u56e0\uff0c\u6bcf\u4e00\u7c92\u90fd\u6709\u8eab\u4efd\uff0c\u5b89\u5168\u6211\u4eec\u4fdd\u969c\u3002","coupon_id":"74035a5217c94599832a1c00ba7b4dcf","coupon_price":10,"coupon_receive":0,"coupon_surplus":10000,"coupon_condition":"","coupon_stime":1512656551,"coupon_etime":1513267199,"coupon_link":"3280280647&activity_id=74035a5217c94599832a1c00ba7b4dcf","Commission":20.5,"Commission_jihua":20.5,"Commission_queqiao":0,"jihua_link":"2013.1.0.0.45Gd0g#!\/promo\/self\/campaign?campaignId=71433880&shopkeeperId=123400654&userNumberId=3280280647","jihua_shenhe":null,"dtkid":4736884,"addtime":1512656551,"updatetime":1512656551},{"cid":8,"title":"\u5357\u6781\u4eba\u8db3\u6d74\u76c6\u6ce1\u811a\u76c6\u6876\u5168\u81ea\u52a8\u6309\u6469\u7535\u52a8\u52a0\u70ed\u8db3\u7597\u673a\u5668\u5bb6\u7528\u6052\u6e29\u6d17\u811a\u76c6","d_title":"\u5357\u6781\u4eba6\u6eda\u8f6e\u9065\u63a7\u6db2\u6676\u5c4f\u7535\u52a8\u8db3\u6d74\u76c6","goods_id":"558295255856","pic_link":"\/i1\/1816897885\/TB2WU4ng2NNTKJjSspeXXaSwpXa_!!1816897885.jpg","istmall":1,"sales":3444,"goods_dsr":4.8,"org_price":199,"price":159,"introduce":"\u5357\u6781\u4eba\u8db3\u7597\u673a\uff0c\u4e00\u952e\u542f\u52a8\uff0c\u9632\u7535\u5899\u8bbe\u8ba1\uff0c\u524d\u7aef\u52a0\u70ed\uff0c\u4fbf\u643a\u6392\u6c34\uff0c\u591a\u79cd\u6a21\u5f0f\uff0c\u54c1\u8d28\u751f\u6d3b\uff0c\u4ece\u5357\u6781\u4eba\u8db3\u6d74\u76c6\u5f00\u59cb\u3010\u8d60\u8fd0\u8d39\u9669\u3011","coupon_id":"749ef3710d11484ab2aad059388efa45","coupon_price":40,"coupon_receive":0,"coupon_surplus":4000,"coupon_condition":"","coupon_stime":1512656551,"coupon_etime":1513267199,"coupon_link":"2454060579&activity_id=749ef3710d11484ab2aad059388efa45","Commission":25.4,"Commission_jihua":0,"Commission_queqiao":25.4,"jihua_link":"0","jihua_shenhe":null,"dtkid":4736857,"addtime":1512656551,"updatetime":1512656551},{"cid":3,"title":"\u7537\u58eb\u7d20\u989c\u971c\u63d0\u4eae\u80a4\u8272BB\u971c\u61d2\u4eba\u971c\u906e\u7455\u75d8\u5370\u7c89\u5e95\u6db2\u818f\u81ea\u7136\u8272\u5316\u5986\u54c1\u5957\u88c5","d_title":"\u4e00\u62b9\u5373\u4eae\u7537\u58eb\u906e\u7455\u7d20\u989c\u971cbb\u971c","goods_id":"544410512702","pic_link":"\/i2\/1015563178\/TB2PLZfcZnI8KJjSsziXXb8QpXa_!!1015563178.jpg","istmall":1,"sales":12129,"goods_dsr":4.8,"org_price":59.9,"price":39.9,"introduce":"\u4e00\u62b9\u5373\u767d\uff0c\u5feb\u901f\u63d0\u4eae\uff0c\u81ea\u7136\u906e\u7455\uff0c\u514d\u5378\u5986\uff01\u8f7b\u677e\u6253\u9020\u81ea\u7136\u6e05\u900f\u88f8\u5986\u611f\uff0c1\u5206\u949f\u5c31\u53ef\u4ee5\u81ea\u4fe1\u51fa\u95e8\uff0c\u7537\u58eb\u5fc5\u5907~","coupon_id":"9e463d6a7302431fb5cd3c8ca9f51c00","coupon_price":20,"coupon_receive":0,"coupon_surplus":10000,"coupon_condition":"","coupon_stime":1512656551,"coupon_etime":1513007999,"coupon_link":"1015563178&activity_id=9e463d6a7302431fb5cd3c8ca9f51c00","Commission":31,"Commission_jihua":31,"Commission_queqiao":0,"jihua_link":"58037899&shopkeeperId=32429801&userNumberId=1015563178","jihua_shenhe":null,"dtkid":4736841,"addtime":1512656551,"updatetime":1512656551}]
TXT;
$ar = json_decode($s, true);
foreach($ar as $r) {
  $field = join(',', array_keys($r));
  $value = join("','", $r);
  $sql = "insert into tbl_name ($field) values ('$value')";
  echo $sql,PHP_EOL;
}


insert into tbl_name (cid,title,d_title,goods_id,pic_link,istmall,sales,goods_dsr,org_price,price,introduce,coupon_id,coupon_price,coupon_receive,coupon_surplus,coupon_condition,coupon_stime,coupon_etime,coupon_link,Commission,Commission_jihua,Commission_queqiao,jihua_link,jihua_shenhe,dtkid,addtime,updatetime) values ('6','东北有机五谷杂粮组合膳食粗粮粥营养饭豆浆原料十谷米4000g包邮','东北有机五谷杂粮组合膳食粗粮粥4000g','558820596536','/i1/1125342007/TB2AqS9afjM8KJjSZFyXXXdzVXa_!!1125342007.jpg','1','58','4.9','148','88','孝亲礼盒有机杂粮4000装，足量膳食纤维丰富，有饱腹感不用担心能量过剩，吃的安全放心，享受天然般的口感。','1573edd2f1304c3b935efb387844c73d','60','0','10000','','1512656551','1513267199','3280280647&activity_id=1573edd2f1304c3b935efb387844c73d','20.5','20.5','0','2013.1.0.0.45Gd0g#!/promo/self/campaign?campaignId=71433880&shopkeeperId=123400654&userNumberId=3280280647','','4736890','1512656551','1512656551')
insert into tbl_name (cid,title,d_title,goods_id,pic_link,istmall,sales,goods_dsr,org_price,price,introduce,coupon_id,coupon_price,coupon_receive,coupon_surplus,coupon_condition,coupon_stime,coupon_etime,coupon_link,Commission,Commission_jihua,Commission_queqiao,jihua_link,jihua_shenhe,dtkid,addtime,updatetime) values ('6','有机五谷杂粮组合十谷米杂粮粥饭原料无大米健身餐新米400*3包邮','有机五谷杂粮组合十谷米杂粮粥饭','559934914414','/i2/1125342007/TB2m0dKc3fH8KJjy1zcXXcTzpXa_!!1125342007.jpg','1','127','4.9','38.4','28.4','有机杂粮，颗粒饱满，新米生长周期长，非转基因，每一粒都有身份，安全我们保障。','74035a5217c94599832a1c00ba7b4dcf','10','0','10000','','1512656551','1513267199','3280280647&activity_id=74035a5217c94599832a1c00ba7b4dcf','20.5','20.5','0','2013.1.0.0.45Gd0g#!/promo/self/campaign?campaignId=71433880&shopkeeperId=123400654&userNumberId=3280280647','','4736884','1512656551','1512656551')
insert into tbl_name (cid,title,d_title,goods_id,pic_link,istmall,sales,goods_dsr,org_price,price,introduce,coupon_id,coupon_price,coupon_receive,coupon_surplus,coupon_condition,coupon_stime,coupon_etime,coupon_link,Commission,Commission_jihua,Commission_queqiao,jihua_link,jihua_shenhe,dtkid,addtime,updatetime) values ('8','南极人足浴盆泡脚盆桶全自动按摩电动加热足疗机器家用恒温洗脚盆','南极人6滚轮遥控液晶屏电动足浴盆','558295255856','/i1/1816897885/TB2WU4ng2NNTKJjSspeXXaSwpXa_!!1816897885.jpg','1','3444','4.8','199','159','南极人足疗机，一键启动，防电墙设计，前端加热，便携排水，多种模式，品质生活，从南极人足浴盆开始【赠运费险】','749ef3710d11484ab2aad059388efa45','40','0','4000','','1512656551','1513267199','2454060579&activity_id=749ef3710d11484ab2aad059388efa45','25.4','0','25.4','0','','4736857','1512656551','1512656551')
insert into tbl_name (cid,title,d_title,goods_id,pic_link,istmall,sales,goods_dsr,org_price,price,introduce,coupon_id,coupon_price,coupon_receive,coupon_surplus,coupon_condition,coupon_stime,coupon_etime,coupon_link,Commission,Commission_jihua,Commission_queqiao,jihua_link,jihua_shenhe,dtkid,addtime,updatetime) values ('3','男士素颜霜提亮肤色BB霜懒人霜遮瑕痘印粉底液膏自然色化妆品套装','一抹即亮男士遮瑕素颜霜bb霜','544410512702','/i2/1015563178/TB2PLZfcZnI8KJjSsziXXb8QpXa_!!1015563178.jpg','1','12129','4.8','59.9','39.9','一抹即白，快速提亮，自然遮瑕，免卸妆！轻松打造自然清透裸妆感，1分钟就可以自信出门，男士必备~','9e463d6a7302431fb5cd3c8ca9f51c00','20','0','10000','','1512656551','1513007999','1015563178&activity_id=9e463d6a7302431fb5cd3c8ca9f51c00','31','31','0','58037899&shopkeeperId=32429801&userNumberId=1015563178','','4736841','1512656551','1512656551')

好好学习,天天向上 2017-12-08