PHP GetPagecjの例

コード例 #1

ファイル: uaj_duihuanlist.php プロジェクト: kwdwkiss/trial

    $SK['limit'] = ($SK['page'] - 1) * $page_size;
    return $SK;
}
$siteweb = GetSiteconfig();
$usname = $_SESSION['usnamese'];
$user_row = Getuname($_SESSION['usnamese'], 1);
$state = isset($_GET["state"]) ? $_GET["state"] : 0;
//当前列表状态
if ($state == 0) {
    $where = '1=1';
} else {
    $where = "status={$state}";
}
$page_size = 5;
$GETSQL = GetCountcj('user_duihuan', "cj_uid=" . $user_row['id'], $where, 1);
$Page = GetPagecj($page_size, 'user_duihuan', "cj_uid=" . $user_row['id'], $where);
$sql = $GETSQL['sql'] . " limit " . $Page['limit'] . "," . $page_size;
$result = mysql_query($sql);
/*
 *****************会员中心请用列表页，返回html******************
 */
//尾页
?>
<!-- 我参与的 积分兑换 活动 -->
<style>
.tablehead { background-color: #eaeaea; height: 40px; line-height: 40px; font-size: 12px; font-weight: bold; }
.tablehead span { float: left; white-space: nowrap; color: #666; }
.tablehead .td1 { width: 80px; margin-left: 20px; }
.tablehead .td2 { width: 383px; margin-right: 10px; }
.tablehead .td3 { width: 140px; }
.tablehead .td4 { width: 115px; margin-right: 10px; float: right; }

コード例 #2

ファイル: uaj_choujianglist.php プロジェクト: kwdwkiss/trial

    $SK['limit'] = ($SK['page'] - 1) * $page_size;
    return $SK;
}
$siteweb = GetSiteconfig();
$usname = $_SESSION['usnamese'];
$user_row = Getuname($_SESSION['usnamese'], 1);
$state = isset($_GET["state"]) ? $_GET["state"] : 0;
//当前列表状态
if ($state == 0) {
    $where = '1=1';
} else {
    $where = "status={$state}";
}
$page_size = 5;
$GETSQL = GetCountcj('choujiang', "cj_uid=" . $user_row['id'], $where, 1);
$Page = GetPagecj($page_size, 'choujiang', "cj_uid=" . $user_row['id'], $where);
$sql = $GETSQL['sql'] . " limit " . $Page['limit'] . "," . $page_size;
$result = mysql_query($sql);
/*
 *****************会员中心请用列表页，返回html******************
 */
//尾页
?>
<!-- 我参与的 积分兑换 活动 -->
<style>
.tablehead { background-color: #eaeaea; height: 40px; line-height: 40px; font-size: 12px; font-weight: bold; }
.tablehead span { float: left; white-space: nowrap; color: #666; }
.tablehead .td1 { width: 80px; margin-left: 20px; }
.tablehead .td2 { width: 383px; margin-right: 10px; }
.tablehead .td3 { width: 140px; }
.tablehead .td4 { width: 115px; margin-right: 10px; float: right; }