thinkphp关联数据库读取

db("cms_archives")->alias('a')->field('a.*,d.*')
->join('cms_addondaimakuai d','a.id = d.id')
->where("a.deletetime",null)
->select();

快捷键：dbjoin

源：HTML,PHP

sublime_text格式

<snippet>
    <content><![CDATA[
db("cms_archives")->alias('a')->field('a.*,d.*')
->join('cms_addondaimakuai d','a.id = d.id')
->where("a.deletetime",null)
->select();
]]></content>
   <tabTrigger>dbjoin(thinkphp关联数据库读取)</tabTrigger>
   <scope></scope>
</snippet>