• 欢迎访问搞代码网站,推荐使用最新版火狐浏览器和Chrome浏览器访问本网站!
  • 如果您觉得本站非常有看点,那么赶紧使用Ctrl+D 收藏搞代码吧

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

php 搞代码 3年前 (2022-01-23) 31次浏览 已收录 0个评论
文章目录[隐藏]

<body>

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

"; <br>print_r (json_decode($json2, true));echo "<pre class="prettyprint linenums">";</p><p>print_r (json_ecode($json2, true));echo "<pre class="prettyprint linenums">";</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>echo $pageContents;</p><pre class="prettyprint linenums"><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>

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

回复内容:

<body>

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

"; <br>print_r (json_decode($json2, true));echo "<pre class="prettyprint linenums">";</p><p>print_r (json_ecode($json2, true));echo "<pre class="prettyprint linenums">";</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>echo $pageContents;</p><pre class="prettyprint linenums"><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>

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

这个明显是json了

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

想知道是json还是数组,用var_dump打印下不就知道了
另外这*本文来@源gao@daima#com搞(%代@#码@网2

搞代gaodaima码

个是从前端那边传过来的吧,目测传的时候将json字符串化了,你要在PHP上面转数组的话还需要对字符串进行解码

<code>json.decode("string...")</code>

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

<code> INSERT INTO table (q,w,e) VALUES (1,2,3), (2,3,4), (3,4,5), (3,4,9);</code>

搞代码网(gaodaima.com)提供的所有资源部分来自互联网,如果有侵犯您的版权或其他权益,请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected],我们会在看到邮件的第一时间内为您处理,或直接联系QQ:872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接:mysql – 到底是json还是数组,求PHP批量插入数据库办法

喜欢 (0)
[搞代码]
分享 (0)
发表我的评论
取消评论

表情 贴图 加粗 删除线 居中 斜体 签到

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址