Model层的常用操作写法
1、增加
Model_Albart::getInstance()->Insert([
'articleid' => 1,
'uid' =>2,
"albumid" => 3
]);2、修改
Model_Albart::getInstance()->Update([
'id' =>1,
'uid' => 2,
"albumid" => 3
]);3、删除
Model_Albart::getInstance()->Delete("id");4、获取
Model_Article::getInstance()
->PageNum(0)
->PageSize(10)
->Select();5、join
Model_Arttag::getInstance()->
->Where("a.articleid=?", [
$_id
])
->Alias("a")
->Join("Tag", "a.tagid=b.id", "b")
->Field("b.tagname,b.tagshort,a.tagid")
->Select(false);6、union
Model_Activity::getInstance()->
Union("select * from [Article]",true)
->Select();
{{collectdata}}
网友评论0