function getFirstImg($arcId) {
global $dsql;
$sql = "SELECT body FROM #@__addonarticle WHERE aid='$arcId'";
$row = $dsql>GetOne($sql);
preg_match('//i', $row['body'], $matches);
return $matches[1];
}
function formatTime($time) { return date('Ymd H:i:s', $time); }
将时间戳格式化为指定格式
3
获取文章标题
function getArticleTitle($id) { $sql = "SELECT title FROM dede_archives WHERE id = $id"; $title = $this>dsql>GetOne($sql); return $title['title']; }
根据文章ID获取文章标题
4
判断用户是否登录
function isLogin() { if (!isset($_SESSION['username'])) { return false; } return true; }
判断用户是否已登录
5
获取用户角色
function getUserRole() { if (!isLogin()) { return false; } $sql = "SELECT role FROM dede_member WHERE username = '".$_SESSION['username']."'"; $role = $this>dsql>GetOne($sql); return $role['role']; }
获取当前登录用户的角色
6
获取文章分类名称
function getCategoryName($id) { $sql = "SELECT name FROM dede_category WHERE id = $id"; $name = $this>dsql>GetOne($sql); return $name['name']; }
根据分类ID获取分类名称
7
获取文章摘要
function getArticleAbstract($id) { $sql = "SELECT abstract FROM dede_archives WHERE id = $id"; $abstract = $this>dsql>GetOne($sql); return $abstract['abstract']; }
根据文章ID获取文章摘要
8
获取文章作者
function getArticleAuthor($id) { $sql = "SELECT username FROM dede_member WHERE mid = (SELECT mid FROM dede_archives WHERE id = $id)"; $author = $this>dsql>GetOne($sql); return $author['username']; }
function getArticleCommentCount($id) { $sql = "SELECT COUNT(*) AS count FROM dede_comments WHERE aid = $id"; $count = $this>dsql>GetOne($sql); return $count['count']; }