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();
网友评论0