<h1 class="postTitle">
<span >
<span role="heading" aria-level="2">ThinkPHP的join关联查询不使用默认的表前缀</span></span></h1><h1 class="postTitle"><span ><span role="heading" aria-level="2">ThinkPHP 6 部分表不用数据库前缀<br></span>
</span>
</h1>
<div class="clear"></div>
<div id="cnblogs_post_body" class="blogpost-body blogpost-body-html">
<p> 要关联的(完整)表名以及别名，支持三种写法：</p>
<p> 1、['完整表名或子查询'=>'别名']<br> 2、'完整表名 别名'<br> 3、'不带数据表前缀的表名'</p>
<p> 总：把JOIN参数由<strong><span style="color: rgba(255, 0, 0, 1)">字符串修改为数组</span></strong>，即为完整的表名。</p><p><br></p><p>Db::table只有第一个表不使用前缀。后边 ->join 的表又加上前缀了,正确的写法如下。<br></p><pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:'JetBrains Mono',monospace;font-size:9.8pt;"><span style="color:#9876aa;background-color:#232525;">$wj </span><span style="background-color:#232525;">= Db::</span><span style="color:#ffc66d;background-color:#232525;font-style:italic;">table</span><span style="background-color:#232525;">(</span><span style="color:#6a8759;background-color:#232525;">'cj_mwj'</span><span style="background-color:#232525;">)-></span><span style="color:#ffc66d;background-color:#232525;">alias</span><span style="background-color:#232525;">(</span><span style="color:#6a8759;background-color:#232525;">'a'</span><span style="background-color:#232525;">)<br></span><span style="background-color:#232525;"> -></span><span style="color:#ffc66d;background-color:#232525;">join</span><span style="background-color:#232525;">([</span><span style="color:#6a8759;background-color:#232525;">'cj_mwjcss'</span><span style="background-color:#232525;">=></span><span style="color:#6a8759;background-color:#232525;">'b'</span><span style="background-color:#232525;">]</span><span style="color:#cc7832;background-color:#232525;">, </span><span style="color:#6a8759;background-color:#232525;">'b.wjcss_id = a.wjcss_id'</span><span style="color:#cc7832;background-color:#232525;">, </span><span style="color:#6a8759;background-color:#232525;">'LEFT'</span><span style="background-color:#232525;">)<br></span><span style="background-color:#232525;"> -></span><span style="color:#ffc66d;background-color:#232525;">field</span><span style="background-color:#232525;">(</span><span style="color:#6a8759;background-color:#232525;">'a.*,b.dug '</span><span style="background-color:#232525;">)<br></span><span style="background-color:#232525;"> -></span><span style="color:#ffc66d;background-color:#232525;">where</span><span style="background-color:#232525;">([</span><span style="color:#6a8759;background-color:#232525;">'wj_id'</span><span style="background-color:#232525;">=></span><span style="color:#6a8759;background-color:#232525;">'339046'</span><span style="background-color:#232525;">])<br></span><span style="background-color:#232525;"> -></span><span style="color:#ffc66d;background-color:#232525;">find</span><span style="background-color:#232525;">()</span><span style="color:#cc7832;background-color:#232525;">;</span></pre><p></p>
</div><p></p>
本文地址：
/show-842.html
版权声明：除非特别标注原创，其它均来自互联网，转载时请以链接形式注明文章出处。