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; }