1、方法1
$article = $zbp->GetListType('Post', 'select * from ' . $zbp->db->dbpre . 'post where log_ID = 111');
if (empty($article[0])) {
//说明文章不存在
}
[dbpre] => zbp_ 是表前缀
2、方法2
$article = $zbp->GetListType('Post', 'select * from ' . $zbp->table['Post'] . ' where log_ID = 111');
if (empty($article[0])) {
//说明文章不存在
}
表名也可以也可以:$zbp->table['Post'] ## 支持 Post Category Tag Comment Member Config Module Upload
3、方法3
$where = array('=', 'log_ID', 111);
$num = $zbp->db->Query($zbp->db->sql->get()->select($zbp->table['Post'])->column('COUNT(a_id) num')->where($where)->sql)[0]['num'];
if ($num == 0) {
// 说明文章不存在
}
直接sql
$cate_id_rand = $zbp->db->Query("select cate_id as id from " . $zbp->table['Category'] . " order by rand() limit 1")[0]['id']; // 随机分类
#$mem_id_rand = $zbp->db->Query("select mem_id as id from " . $zbp->table['Member'] . " order by rand() limit 1")[0]['id']; // 随机用户
4、方法4 GetArticleList
$articles = $zbp->GetArticleList('*', array(array('=', 'log_Title', '我是标题')));
if (empty($articles)) {
// 如果没有相同标题的文章,则发布
}
5 方法5
$sql = $zbp->db->sql->get()->selectany('count(log_ID) num')->from($zbp->table['Post'])->where(array('=', 'log_Title', $title))->sql;
$num = $zbp->db->Query($sql)[0]['num'];
if ($num == 0) {
// 说明文章不存在
}