static function select($cid, $page, $pagesize = NULL, $orderkind = null, $deasc = null)
{
$rkind = self::$kind_content;
if (!$pagesize) {
$pagesize = 30;
}
if (!$orderkind) {
$order = sql_use_f::$data_columns[createtime] . " asc";
} else {
$order = sql_use_f::$data_columns[$orderkind] . " " . $deasc;
}
//页码的偏移
if (!$page) {
$page = 0;
}
$limit_begin = $page * $pagesize;
$limit_num = $pagesize;
$limit = $limit_begin . "," . $limit_num;
//页码的偏移完
$where = sql_use_f::$data_columns[upid] . "=" . $cid;
$result = sql_use_f::select(null, $where, $rkind, $order, $limit);
if (!$result) {
return NULL;
exit;
}
//遍历加上作者信息
foreach ($result as $r) {
$author = $r[sql_use_f::$data_columns[author]];
$where = sql_use_f::$data_columns[upid] . "=" . $author;
$rr = sql_use_f::select(null, $where, self::$kind_user);
array_push($rr, $r);
$res[] = $rr;
}
$result = $res;
return $result;
}
