<p>有时候我们需要实现复杂的插入数据，所以就会用到execute方法，</p><p><img src="http://img.80zx.com/ueditor/image/202004/1585797209cec3c5.png" title="image" alt="image"/></p><p><code style="box-sizing: inherit; -webkit-tap-highlight-color: transparent; text-size-adjust: none; -webkit-font-smoothing: antialiased; font-family: Consolas, Monaco, "Andale Mono", "Ubuntu Mono", monospace; font-size: 17px; display: inline-block; border-radius: 4px; padding: 2px 6px; background: rgb(249, 250, 250); word-break: break-all; white-space: pre; line-height: 1.3; margin: 0px 5px; border: 1px solid rgb(222, 217, 217); color: rgb(82, 82, 82);">execute</code><span style="color: rgb(82, 82, 82); font-family: "IBM Plex Mono", "Space Grotesk", "Roboto Slab", "Microsoft YaHei", sans-serif; font-size: 17px; background-color: rgb(255, 255, 255);">用于更新和写入数据的sql操作，如果数据非法或者查询错误则返回</span><code style="box-sizing: inherit; -webkit-tap-highlight-color: transparent; text-size-adjust: none; -webkit-font-smoothing: antialiased; font-family: Consolas, Monaco, "Andale Mono", "Ubuntu Mono", monospace; font-size: 17px; display: inline-block; border-radius: 4px; padding: 2px 6px; background: rgb(249, 250, 250); word-break: break-all; white-space: pre; line-height: 1.3; margin: 0px 5px; border: 1px solid rgb(222, 217, 217); color: rgb(82, 82, 82);">false</code><span style="color: rgb(82, 82, 82); font-family: "IBM Plex Mono", "Space Grotesk", "Roboto Slab", "Microsoft YaHei", sans-serif; font-size: 17px; background-color: rgb(255, 255, 255);">，否则返回影响的记录数。</span></p><p><span style="color:#525252;font-family:IBM Plex Mono, Space Grotesk, Roboto Slab, Microsoft YaHei, sans-serif"><span style="font-size: 17px; background-color: rgb(255, 255, 255);">但我们希望获取插入的id方便后面业务处理，具体实现方法参考如下：</span></span></p><p><span style="color:#525252;font-family:IBM Plex Mono, Space Grotesk, Roboto Slab, Microsoft YaHei, sans-serif"><span style="font-size: 17px; background-color: rgb(255, 255, 255);"></span></span></p><pre style="background-color:#262e37;color:#ffffff;font-family:'Consolas';font-size:11.3pt;">$prefix<span style="color:#f92672;">=</span><span style="color:#e1e1e1;">Config</span><span style="color:#f92672;">::</span><span style="color:#a6e22e;">get</span>(<span style="color:#e6db74;">'database.connections.mysql.prefix'</span>);<br/> <span style="color:#66837f;background-color:#191f26;">//</span><span style="color:#66837f;background-color:#191f26;font-family:'宋体';">复制产品</span><span style="color:#66837f;font-family:'宋体';"><br/></span><span style="color:#66837f;font-family:'宋体';"> </span>$addtime<span style="color:#f92672;">= </span><span style="color:#66d9ef;font-style:italic;">time</span>();<br/> $productSql <span style="color:#f92672;">= </span><span style="color:#e6db74;">"insert into </span><span style="color:#fd971f;font-style:italic;">{</span>$prefix}<span style="color:#e6db74;">store_product (mer_id,image,slider_image,store_name,store_info,keyword,cate_id,price,vip_price,ot_price,postage,unit_name,sort,sales,stock,is_show,is_hot,is_best,is_benefit,is_new,cost,give_integral,description,add_time) <br/></span><span style="color:#e6db74;">select mer_id,image,slider_image,store_name,store_info,keyword,cate_id,price,vip_price,ot_price,postage,unit_name,sort,sales,stock,is_show,is_hot,is_best,is_benefit,is_new,cost,give_integral,description,'</span>$addtime<span style="color:#e6db74;">' as </span><span style="color:#f57dac;">add_time</span><span style="color:#e6db74;"> from </span><span style="color:#fd971f;font-style:italic;">{</span>$prefix}<span style="color:#e6db74;">store_product where id=</span><span style="color:#fd971f;font-style:italic;">$</span>product_id<span style="color:#e6db74;">;<br/></span><span style="color:#e6db74;">"</span>;<br/> $mStoreProduct<span style="color:#f92672;">=</span><span style="color:#e1e1e1;">Db</span><span style="color:#f92672;">::</span><span style="color:#a6e22e;">name</span>(<span style="color:#e6db74;">"store_product"</span>);<br/> $mStoreProduct<span style="color:#f92672;">-></span><span style="color:#a6e22e;">execute</span>($productSql);<br/> <span style="color:#66837f;"><br/></span><span style="color:#66837f;"> </span>$newProductId<span style="color:#f92672;">=</span>$mStoreProduct<span style="color:#f92672;">-></span><span style="color:#a6e22e;">getLastInsID</span>();</pre><p><span style="color:#525252;font-family:IBM Plex Mono, Space Grotesk, Roboto Slab, Microsoft YaHei, sans-serif"><span style="font-size: 17px; background-color: rgb(255, 255, 255);"></span></span><br/></p><p><span style="color:#525252;font-family:IBM Plex Mono, Space Grotesk, Roboto Slab, Microsoft YaHei, sans-serif"><span style="font-size: 17px; background-color: rgb(255, 255, 255);"><br/></span></span></p>
相关文章
