mysql - 到底是json还是数组，求PHP批量插入数据库办法-php教程-PHP中文网

mysql - 到底是json还是数组，求PHP批量插入数据库办法

php中文网

发布： 2016-10-12 10:04:09

原创

1272人浏览过

mysql - 到底是json还是数组，求PHP批量插入数据库办法

如图到底是json还是数组
print_r (json_decode($json2));echo "

"; <br>print_r (json_decode($json2, true));echo "<pre class="brush:php;toolbar:false">";</p>
<p>print_r (json_ecode($json2, true));echo "<pre class="brush:php;toolbar:false">";</p>
<p>都不管用直接用echo输出</p>
<p>$pageContents = $client->getContent();//getError<br>$pageContents =str_replace('trde_fullo_get_rsponse','',$pageContents);<br>$pageContents =str_replace('"jdp_rese":"{"":{"tde":{','',$pageContents);</p><p><span>立即学习</span>“<a href="https://pan.quark.cn/s/7fc7563c4182" style="text-decoration: underline !important; color: blue; font-weight: bolder;" rel="nofollow" target="_blank">PHP免费学习笔记（深入）</a>”；</p>
<p>echo $pageContents;</p>
<pre class="brush:php;toolbar:false">tid":2356471828086946,"buyer_nick":"图图爱跳舞","created":"2016-09-16 11:24:05","payment":"657.97","pay_time":"2016-09-16 11:24:22","modified":"2016-10-08 21:03:55","num":1,"price":"1985.00","receiver_name":"小百度","receiver_address":" 十里铺先行大厦（务必联系周冰签收！）","status":"TRADE_FINISHED","total_fee":"2054.97","num":1,"oid":2356471828086946,"outer_iid":"gncfastact240x2","payment":"657.97","status":"TRADE_FINISHED","title":"GN美国原装口香糖","price":"1985.00"

登录后复制

求指点批量插入mysql语句，最好来了例子，多谢大神了，新手上路。

回复内容：

mysql - 到底是json还是数组，求PHP批量插入数据库办法

如图到底是json还是数组
print_r (json_decode($json2));echo "

"; <br>print_r (json_decode($json2, true));echo "<pre class="brush:php;toolbar:false">";</p>
<p>print_r (json_ecode($json2, true));echo "<pre class="brush:php;toolbar:false">";</p>
<p>都不管用直接用echo输出</p>
<p>$pageContents = $client->getContent();//getError<br>$pageContents =str_replace('trde_fullo_get_rsponse','',$pageContents);<br>$pageContents =str_replace('"jdp_rese":"{"":{"tde":{','',$pageContents);</p><p><span>立即学习</span>“<a href="https://pan.quark.cn/s/7fc7563c4182" style="text-decoration: underline !important; color: blue; font-weight: bolder;" rel="nofollow" target="_blank">PHP免费学习笔记（深入）</a>”；</p>
<p>echo $pageContents;</p>
<pre class="brush:php;toolbar:false">tid":2356471828086946,"buyer_nick":"图图爱跳舞","created":"2016-09-16 11:24:05","payment":"657.97","pay_time":"2016-09-16 11:24:22","modified":"2016-10-08 21:03:55","num":1,"price":"1985.00","receiver_name":"小百度","receiver_address":" 十里铺先行大厦（务必联系周冰签收！）","status":"TRADE_FINISHED","total_fee":"2054.97","num":1,"oid":2356471828086946,"outer_iid":"gncfastact240x2","payment":"657.97","status":"TRADE_FINISHED","title":"GN美国原装口香糖","price":"1985.00"

登录后复制

求指点批量插入mysql语句，最好来了例子，多谢大神了，新手上路。

这个明显是json了

// TP3.2批量添加数据
$dataList[] = array('name'=>'thinkphp','email'=>'thinkphp@gamil.com');
$dataList[] = array('name'=>'onethink','email'=>'onethink@gamil.com');
$User->addAll($dataList);

登录后复制

想知道是json还是数组，用var_dump打印下不就知道了
另外这个是从前端那边传过来的吧，目测传的时候将json字符串化了，你要在PHP上面转数组的话还需要对字符串进行解码

json.decode("string...")

登录后复制

至于批量插入sql语句，给你一个简单的提示，剩下靠自己把

 INSERT INTO table (q,w，e) VALUES (1,2,3), (2,3,4), (3,4,5), (3,4,9);

登录后复制