当前位置:Gxlcms > PHP教程 > mysql-到底是json还是数组,求PHP批量插入数据库办法

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

时间:2021-07-01 10:21:17 帮助过:39人阅读

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

  1. "; <br>print_r (json_decode($json2, true));echo "<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li>";<p></p></li><li><p>print_r (json_ecode($json2, true));echo "</p><pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li>";<p></p></li><li><p>都不管用直接用echo</p></li></ol></pre>输出<p></p></li><li><p>$pageContents = $client->getContent();//getError<br>$pageContents =str_replace('trde_fullo_get_rsponse','',$pageContents);<br>$pageContents =str_replace('"jdp_rese":"{"":{"tde":{','',$pageContents);</p></li><li><p>echo $pageContents;</p></li><li><pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><code>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"</code></li></ol></pre></li><li><p>求指点批量插入mysql语句,最好来了例子,多谢大神了,新手上路。</p></li><li> </li><li> <p></p></li><li> </li><li> <h2>回复内容:</h2></li><li> </li><li> </li><li><p><img data-src="https://img.gxlcms.com/https://img.gxlcms.com//img/bVD5H9?w=166&h=885"></p></li><li><p>如图到底是json还是数组<br>print_r (json_decode($json2));echo "</p><pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li>"; <br>print_r (json_decode($json2, true));echo "<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li>";<p></p></li><li><p>print_r (json_ecode($json2, true));echo "</p><pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li>";<p></p></li><li><p>都不管用直接用echo</p></li></ol></pre>输出<p></p></li><li><p>$pageContents = $client->getContent();//getError<br>$pageContents =str_replace('trde_fullo_get_rsponse','',$pageContents);<br>$pageContents =str_replace('"jdp_rese":"{"":{"tde":{','',$pageContents);</p></li><li><p>echo $pageContents;</p></li><li><pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><code>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"</code></li></ol></pre></li><li><p>求指点批量插入mysql语句,最好来了例子,多谢大神了,新手上路。</p></li><li> </li><li> </li><li> <p class="answer fmt" data-id="1020000007139117"></li><li> </li><li></p><p>这个明显是json了</p></li><li><pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><code>// TP3.2批量添加数据</li><li>$dataList[] = array('name'=>'thinkphp','email'=>'thinkphp@gamil.com');</li><li>$dataList[] = array('name'=>'onethink','email'=>'onethink@gamil.com');</li><li>$User->addAll($dataList);</code></li></ol></pre></li><li> </li><li> <p class="answer fmt" data-id="1020000007139417"></li><li> </li><li></p><p>想知道是json还是数组,用var_dump打印下不就知道了<br>另外这个是从前端那边传过来的吧,目测传的时候将json字符串化了,你要在PHP上面转数组的话还需要对字符串进行解码</p></li><li><pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><code>json.decode("string...")</code></li></ol></pre></li><li><p>至于批量插入sql语句,给你一个简单的提示,剩下靠自己把</p></li><li><pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><code> INSERT INTO table (q,w,e) VALUES (1,2,3), (2,3,4), (3,4,5), (3,4,9);</code></li></ol></pre> </li></ol></pre></li></ol></pre></li></ol></pre>

人气教程排行