function getInvitesByPage()
{
global $db, $tablepre, $Personal;
$where = array();
$where[] = "status != 9";
$where[] = "fid = {$Personal['uid']}";
$order = " order by postdate DESC";
$sql = "SELECT";
$sql .= " uname,tel,email,postdate";
$sql .= " FROM {$tablepre}openclass_users ";
$sql .= "WHERE " . implode(" AND ", $where);
$sql .= $order;
$query = $db->query($sql);
$total = $db->num_rows($query);
$perpage = 15;
//定义每页显示记录数
$pagecount = ceil($total / $perpage);
//总页数
$query = get_sql_by_page($sql, $total, $perpage, $p);
$query = $db->query($query);
while ($row = $db->fetch_array($query)) {
$row['postdate'] = date('Y-m-d H:i:s', $row['postdate']);
$table[] = $row;
//将获取的数组值写入到新的数组中
}
$table['total'] = $total;
$table['perpage'] = $perpage;
return $table;
}
function getClassPostsByPage($cid, $p)
{
global $db, $tablepre;
$where = array();
$where[] = "status != 9";
$where[] = "ischecked = 1";
$where[] = "cid = {$cid}";
$order = " order by postdate DESC";
$sql = "SELECT";
$sql .= " uid,uname,content,postdate";
$sql .= " FROM {$tablepre}openclass_post ";
$sql .= "WHERE " . implode(" AND ", $where);
$sql .= $order;
$query = $db->query($sql);
$total = $db->num_rows($query);
$perpage = 8;
//定义每页显示记录数
$pagecount = ceil($total / $perpage);
//总页数
$query = get_sql_by_page($sql, $total, $perpage, $p);
$query = $db->query($query);
while ($row = $db->fetch_array($query)) {
$row['uimg'] = $this->getUimgByUid($row['uid']);
$row['postdate'] = date('Y-m-d H:i:s', $row['postdate']);
$table[] = $row;
//将获取的数组值写入到新的数组中
}
$table['total'] = $total;
$table['perpage'] = $perpage;
return $table;
}
