function getAdminByPage($page, $pageSize = 2)
{
    $sql = "select * from imooc_admin";
    //得到所有记录的记录数,这里把$totalRows变成全局变量，是方便listAdmin在判断总记录数，并判断显示页码时调用
    global $totalRows;
    $totalRows = getResultNum($sql);
    //$pageSize记录每页显示几条，
    $pageSize = 2;
    //得到总页码数,这里把$totalPage设为全局变量，是方便listAdmin.php的总页数调用显示
    global $totalPage;
    $totalPage = ceil($totalRows / $pageSize);
    //设置当前默认页数,这里把$page设为全局变量，是方便page.func.php在获取当前页时调用
    global $page;
    //判断是否小于1，是否为空，或者不是数字，则都为$page都为1
    if ($page < 1 || $page == null || !is_numeric($page)) {
        $page = 1;
    }
    if ($page >= $totalPage) {
        $page = $totalPage;
    }
    $offset = ($page - 1) * $pageSize;
    $sql = "select id,username,email from imooc_admin limit {$offset},{$pageSize}";
    $rows = fetchAll($sql);
    return $rows;
}

function getAdminByPage($page, $pageSize = 2)
{
    $sql = "select * from imooc_admin";
    global $totalRows;
    $totalRows = getResultNum($sql);
    global $totalPage;
    $totalPage = ceil($totalRows / $pageSize);
    if ($page < 1 || $page == null || !is_numeric($page)) {
        $page = 1;
    }
    if ($page >= $totalPage) {
        $page = $totalPage;
    }
    $offset = ($page - 1) * $pageSize;
    $sql = "select id,username,email from imooc_admin limit {$offset},{$pageSize}";
    $rows = fetchAll($sql);
    return $rows;
}

function getAdminByPage($pageSize = 2)
{
    $sql = "select * from myshop_admin";
    $totalRows = getResultNum($sql);
    $pageSize = 2;
    $totalPage = ceil($totalRows / $pageSize);
    $page = $_REQUEST['page'] ? (int) $_REQUEST['page'] : 1;
    if ($page < 1 || $page == null || !is_numeric($page)) {
        $page = 1;
    }
    if ($page >= $totalPage) {
        $page = $totalPage;
    }
    $offset = ($page - 1) * $pageSize;
    $sql = "select id,username,email from myshop_admin limit {$offset},{$pageSize}";
    $rows = fetchAll($sql);
    return $rows;
}

function getPostNumByUid($uid)
{
    $sql = "select pid from zhx_post where uid={$uid}";
    return getResultNum($sql);
}

    $sql = "select head_photo from tuhao_info where user_id={$_SESSION['id']}";
    $src = fetchOne($sql);
    $headPhoto = "uploads/" . $src['head_photo'];
} elseif (autoLogin()) {
    $sql = "select * from tuhao_user where auto_token='{$_COOKIE['autoToken']}'";
    $data = fetchOne($sql);
    $username = $data['username'];
    $loginFlag = $data['id'];
    $id = $data['id'];
} else {
    $username = '';
    $loginFlag = 0;
    $id = 0;
}
$sql2 = "select * from tuhao_pro where username='{$username}' and is_send=1 and status =0";
$sentNum = getResultNum($sql2);
$sql3 = "select * from tuhao_comm where receiver_id={$id} and status = 0";
$mesNum = getResultNum($sql3);
$smarty->assign('username', $username);
//$smarty->assign('headPhoto',$headPhoto);
$smarty->assign('study', $study);
$smarty->assign('clothes', $clothes);
$smarty->assign('digital', $digital);
$smarty->assign('transportation', $transportation);
$smarty->assign('entertainment', $entertainment);
$smarty->assign('others', $others);
$smarty->assign('activity', $activity);
$smarty->assign('loginFlag', $loginFlag);
$smarty->assign('sentNum', $sentNum);
$smarty->assign('mesNum', $mesNum);
$smarty->display("issue.tpl");

function more($pageSize)
{
    $sql = "select * from tuhao_pro where is_send=0 order by hot desc limit 12,100";
    $numRows = getResultNum($sql);
    //总页码数
    $totalPage = ceil($numRows / $pageSize);
    $page = isset($_GET['curPage']) ? (int) $_GET['curPage'] : 1;
    if ($page < 1 || $page == null || !is_numeric($page)) {
        $page = 1;
    } elseif ($page >= $totalPage) {
        $page = $totalPage;
    }
    //偏移量
    $offset = ($page - 1) * $pageSize + 12;
    $sql1 = "select * from tuhao_pro where is_send=0 order by hot desc limit {$offset},{$pageSize}";
    $rows = fetchAll($sql1);
    $goods = array();
    foreach ($rows as $row) {
        $sql2 = "select album_path from tuhao_album where pid={$row['id']}";
        $sql3 = "select id from tuhao_user where username='{$row['username']}'";
        $src = fetchOne($sql2);
        $user_id = fetchOne($sql3);
        $sql4 = "select college from tuhao_info where user_id={$user_id['id']}";
        $college = fetchOne($sql4);
        $row['src'] = "uploads/" . $src['album_path'];
        $row['reg_time'] = $row['reg_time'];
        $row['college'] = $college['college'];
        $goods[] = $row;
    }
    $arr = array('mes' => '获取帖子成功', 'code' => 1, 'curPage' => $page, 'maxPage' => $totalPage, 'data' => $goods);
    return json_encode($arr);
}

}
$pageSize = 8;
$data = sending($id, $pageSize, '');
$goods = 3;
$username1 = fetchOne("select username from tuhao_user where id={$id}");
$sql1 = "select * from tuhao_pro where username='{$username1['username']}' and receiver is null order by reg_time desc ";
$numRows = getResultNum($sql1);
$totalPage = ceil($numRows / $pageSize);
$sql2 = "select * from tuhao_pro where username='{$username}' and is_send=1 and status =0";
$sentNum = getResultNum($sql2);
$sql3 = "select * from tuhao_comm where receiver_id={$id} and status = 0";
$mesNum = getResultNum($sql3);
$sql = "select user_id,college,head_photo,levell,score from tuhao_info where user_id={$id}";
$user = fetchOne($sql);
$sql4 = "select * from tuhao_pro where id={$user['user_id']} and status=1";
$user['sendNum'] = getResultNum($sql4);
$user['src'] = "uploads/" . $user['head_photo'];
$user['username'] = $username1['username'];
$smarty->assign('username', $username);
$smarty->assign('study', $study);
$smarty->assign('clothes', $clothes);
$smarty->assign('digital', $digital);
$smarty->assign('transportation', $transportation);
$smarty->assign('entertainment', $entertainment);
$smarty->assign('others', $others);
$smarty->assign('activity', $activity);
$smarty->assign('loginFlag', $loginFlag);
$smarty->assign('sentNum', $sentNum);
$smarty->assign('mesNum', $mesNum);
$smarty->assign('data', $data);
$smarty->assign('user', $user);

<?php

/**
 * Created by PhpStorm.
 * User: ning-pc
 * Date: 15/8/16
 * Time: 上午11:25
 */
require_once '../include.php';
$sql = "select * from imooc_admin";
$totleRows = getResultNum($sql);
$pageSize = 2;
$totalPage = ceil($totleRows / $pageSize);
$page = $_REQUEST['page'] ? $_REQUEST['page'] : 1;
if ($page < 1 || $page == null || !is_numeric($page)) {
    $page = 1;
}
if ($page >= $totalPage) {
    $page = $totalPage;
}
$offset = ($page - 1) * $pageSize;
$sql = "select * from imooc_admin limit {$offset}, {$pageSize}";
$rows = fetchAll($sql);
foreach ($rows as $key => $row) {
    echo $row['id'] . '-----' . $row['username'];
    echo "<br>";
}
echo showPage($page, $totalPage, "cid=5&pid=6");
function showPage($page, $totalPage, $where = null, $sep = "&nbsp;")
{
    $where = $where == null ? null : "&" . $where;

<?php

/**
 * Created by PhpStorm.
 * User: ning-pc
 * Date: 15/8/16
 * Time: 下午8:43
 */
require_once '../include.php';
$pageSize = 2;
$page = $_REQUEST['page'] ? $_REQUEST['page'] : 1;
if ($page < 1 || !is_numeric($page) || $page == null) {
    $page = 1;
}
$sql = "select * from imooc_admin";
$total = getResultNum($sql);
$offSet = ($page - 1) * $pageSize;
if ($page > $totalPage) {
    $page = $totalPage;
}
$totalPage = ceil($total / $pageSize);
//$sql = "select * from imooc_admin limit {$offSet}, {$pageSize}";
//$rows = fetchAll($sql);
//if($rows<$total){
//    echo showPage($page, $totalPage);
//
//}
echo showPage($page, $totalPage);
die;
//$rows = getAllAdmin();
echo "<table>";

$sql_checkGuestInfo = "SELECT country,locality,administrative_area_level_1,gender,ethnicity,user_type,arrival\n        FROM tg_guest_info as i\n        JOIN tg_guest_request r ON r.guest_id = i.guest_id\n        JOIN tg_user_login lo ON lo.user_id = i.guest_id\n        where lo.user_id={$_SESSION['user_id']}";
$row_checkGuestInfo = fetchOne($sql_checkGuestInfo);
$country = $row_checkGuestInfo['country'];
$city = $row_checkGuestInfo['locality'];
$state = $row_checkGuestInfo['administrative_area_level_1'];
$gender = $row_checkGuestInfo['gender'];
$ethnicity = $row_checkGuestInfo['ethnicity'];
$arrival = $row_checkGuestInfo['arrival'];
$type = $row_checkGuestInfo['user_type'];
//Booking Guest logic
$sql_book = "SELECT * from tg_booking where host_id={$id} and guest_id={$_SESSION['user_id']} and who_book=1";
$book = getResultNum($sql_book);
$status = fetchOne($sql_book);
//Re-Booking  logic
$sql_2 = "SELECT * from tg_booking where host_id={$id} and guest_id={$_SESSION['user_id']} and who_book=2";
$book_2 = getResultNum($sql_2);
$row_2 = fetchOne($sql_2);
?>

<!-- Page Content -->
<div class="container">

    <!-- Page Heading/Breadcrumbs row -->
    <div class="row">
            <div class="col-lg-12">
                <h1 class="page-header text-center" style="margin:0;">
                    <small>
                        <div class="row" id="rp-house-tit">
                            <h2><b><?php 
echo $row_house['house_title'];
?>

require_once 'include.php';
require 'phpmailer/PHPMailerAutoload.php';
$mail = new PHPMailer();
$id = $_REQUEST['house_id'];
$arr = $_POST;
$arrival = $arr['arrival'];
$depart = $arr['depart'];
$time = date("Y-m-d");
$guest_id = $_SESSION['user_id'];
@($sql_guest = "SELECT *\n                FROM tg_guest_info as i\n                JOIN tg_guest_request as r ON r.guest_id = i.guest_id\n                JOIN tg_user_login l ON l.user_id = i.guest_id\n                where i.guest_id={$_SESSION['user_id']}");
$row_guest = fetchOne($sql_guest);
@($sql_host = "SELECT first_name,email\n                FROM tg_host_info as i\n                JOIN tg_user_login l ON l.user_id = i.host_id\n                where i.host_id = {$id}");
$row_host = fetchOne($sql_host);
//Guest booking logic
$sql_book = "SELECT * from tg_booking where host_id={$id} and guest_id={$guest_id}";
$row_num = getResultNum($sql_book);
$row = fetchOne($sql_book);
$status = $row['status'];
if ($row_num == 0) {
    $sql = "INSERT INTO tg_booking (host_id,guest_id,who_book,book_time) VALUES ('{$id}','{$guest_id}','2','{$time}')";
    mysql_query($sql);
} else {
    if ($status == 2) {
        $sql = "UPDATE tg_booking SET status=0, who_book=2 where guest_id={$_SESSION['user_id']} and host_id={$id}";
        mysql_query($sql);
    } else {
        alertMes('You have booked the host family.', 'guest-reservation-list.php');
        return false;
    }
}
//mail content

<?php

require_once 'include.php';
require_once 'header.php';
checkProfileSession();
$id = $_REQUEST['guest_id'];
@($sql = "SELECT *\n            FROM tg_guest_request as r\n            JOIN tg_guest_info i ON i.guest_id = r.guest_id\n            JOIN tg_user_login l ON l.user_id = r.guest_id\n            where r.guest_id={$id}");
$row = fetchOne($sql);
$sql_checkInfo = "SELECT country,locality,administrative_area_level_1,gender,ethnicity,user_type\n                    FROM tg_house_location as l\n                    JOIN tg_host_info i ON i.host_id = l.location_id\n                    JOIN tg_user_login lo ON lo.user_id = l.location_id\n                    JOIN tg_host_house h ON h.house_id = l.location_id\n                    where lo.user_id={$_SESSION['user_id']}";
$row_checkInfo = fetchOne($sql_checkInfo);
//Booking logic
$sql_book = "SELECT * from tg_booking where guest_id={$id} and host_id={$_SESSION['user_id']} and who_book=2";
$book = getResultNum($sql_book);
$status = fetchOne($sql_book);
$sql_1 = "SELECT * from tg_booking where guest_id={$id} and host_id={$_SESSION['user_id']} and who_book=1";
$book_1 = getResultNum($sql_1);
$row_1 = fetchOne($sql_1);
$country = $row_checkInfo['country'];
$city = $row_checkInfo['locality'];
$state = $row_checkInfo['administrative_area_level_1'];
$gender = $row_checkInfo['gender'];
$ethnicity = $row_checkInfo['ethnicity'];
$type = $row_checkInfo['user_type'];
?>

<!-- Page Content -->
<div class="container">

    <!-- Page Heading/Breadcrumbs row -->
    <div class="row">
        <div class="col-lg-12">

function goodsComm($pro_id, $pageSize, $type)
{
    $comm = array();
    $sql = "select * from tuhao_comm where pro_id={$pro_id} and parent_id=0 order by reg_time desc";
    $numRows = getResultNum($sql);
    //总页码数
    $totalPage = ceil($numRows / $pageSize);
    $page = isset($_GET['curPage']) ? (int) $_GET['curPage'] : 1;
    if ($page < 1 || $page == null || !is_numeric($page)) {
        $page = 1;
    } elseif ($page >= $totalPage) {
        $page = $totalPage;
    }
    //偏移量
    $offset = ($page - 1) * $pageSize;
    $sql1 = "select * from tuhao_comm where pro_id={$pro_id} and parent_id=0 order by reg_time desc limit {$offset},{$pageSize}";
    $rows = fetchAll($sql1);
    $res = array();
    foreach ($rows as $row) {
        $sql1 = "select pro_name from tuhao_pro where id={$row['pro_id']}";
        $sql2 = "select head_photo from tuhao_info where user_id={$row['sender_id']}";
        $sql3 = "select username from tuhao_user where id={$row['sender_id']}";
        $sql4 = "select username from tuhao_user where id={$row['receiver_id']}";
        $sql5 = "select * from tuhao_comm where parent_id={$row['id']}";
        $sender = fetchOne($sql3);
        $receiver = fetchOne($sql4);
        $proName = fetchOne($sql1);
        $src = fetchOne($sql2);
        $comments = fetchAll($sql5);
        foreach ($comments as $comment) {
            $sql6 = "select username from tuhao_user where id={$comment['sender_id']}";
            $sql7 = "select username from tuhao_user where id={$comment['receiver_id']}";
            $sql8 = "select head_photo from tuhao_info where user_id={$comment['sender_id']}";
            $sender1 = fetchOne($sql6);
            $receiver1 = fetchOne($sql7);
            $src1 = fetchOne($sql8);
            $comment['sender_author'] = $sender1['username'];
            $comment['receiver_author'] = $receiver1['username'];
            $comment['src'] = "uploads/" . $src1['head_photo'];
            $comm[] = $comment;
        }
        $row['sender_author'] = $sender['username'];
        $row['receiver_author'] = $receiver['username'];
        $row['goods_name'] = $proName['pro_name'];
        $row['src'] = "uploads/" . $src['head_photo'];
        $row['comments'] = $comm;
        $res[] = $row;
        $comm = array();
    }
    if ($type == 'json') {
        $arr = array('mes' => 'success', 'code' => 1, 'curPage' => $page, 'maxPage' => $totalPage, 'data' => $res);
        return json_encode($arr);
    } else {
        $arr = $res;
        return $arr;
    }
}

function tuhaoChart($offset, $num, $type = '')
{
    if ($type == 'week' || $type == '') {
        $sql = "select * from tuhao_info order by week_score desc,id limit {$offset},{$num}";
    } else {
        $sql = "select * from tuhao_info order by score desc,id limit {$offset},{$num}";
    }
    $users = fetchAll($sql);
    foreach ($users as $user) {
        $sql2 = "select username from tuhao_user where id={$user['user_id']}";
        $username = fetchOne($sql2);
        $user['head_photo'] = "uploads/" . $user['head_photo'];
        $user['id'] = $user['user_id'];
        $user['username'] = $username['username'];
        $sql1 = "select * from tuhao_pro where username='{$username['username']}' and status=1";
        $user['sendNum'] = getResultNum($sql1);
        $sql2 = "select * from tuhao_pro where receiver='{$username['username']}' and status=1";
        $user['receiveNum'] = getResultNum($sql2);
        if ($type == 'week' || $type == '') {
            $user['score'] = $user['week_score'];
        }
        $arr[] = $user;
    }
    if ($type == 'month' || $type == 'week') {
        return json_encode($arr);
    } else {
        return $arr;
    }
}

    $goods = 1;
    $sql1 = "select * from tuhao_pro where username='{$username}' and receiver is not null order by reg_time desc ";
    $numRows = getResultNum($sql1);
    $totalPage = ceil($numRows / $pageSize);
} elseif ($type == 'info') {
    $data = receiveComm($id, $pageSize, '');
    $goods = 0;
    $sql1 = "select * from tuhao_comm where receiver_id={$id} order by reg_time desc";
    $numRows = getResultNum($sql1);
    $totalPage = ceil($numRows / $pageSize);
} elseif ($type == 'sending') {
    $data = sending($id, $pageSize, '');
    $goods = 3;
    $username1 = fetchOne("select username from tuhao_user where id={$id}");
    $sql1 = "select * from tuhao_pro where username='{$username}' and receiver is null order by reg_time desc ";
    $numRows = getResultNum($sql1);
    $totalPage = ceil($numRows / $pageSize);
}
$arr = array('status' => 1);
update("tuhao_pro", $arr, "username='{$username}' and is_send=1 and status =0");
$sql = "select user_id,college,head_photo,levell,score from tuhao_info where user_id={$id}";
$user = fetchOne($sql);
$sql1 = "select username from tuhao_user where id={$user['user_id']}";
$username1 = fetchOne($sql1);
$user['src'] = "uploads/" . $user['head_photo'];
$user['username'] = $username1['username'];
$smarty->assign('username', $username);
$smarty->assign('study', $study);
$smarty->assign('clothes', $clothes);
$smarty->assign('digital', $digital);
$smarty->assign('transportation', $transportation);

<?php

require_once '../include.php';
error_reporting(E_ALL & ~E_NOTICE & ~E_WARNING);
// !!! shutdown the reporting of notices and warnings!!!
checkLogined();
$order = $_REQUEST['order'] ? $_REQUEST['order'] : null;
$orderBy = $order ? "order by u." . $order : null;
$keywords = $_REQUEST['keywords'] ? $_REQUEST['keywords'] : null;
$where = $keywords ? "where u.username like '%{$keywords}%'" : null;
//得到数据库中所有用户
$sql = "select u.id,u.username,u.pId,u.cId,u.capacity,u.address,u.phone,u.uDesc,u.pubTime,p.province, c.city from biogas_user as u join biogas_prov p on u.pId=p.id join biogas_city c on u.cId=c.id {$where}";
$totalRows = getResultNum($sql);
$pageSize = 6;
$totalPage = ceil($totalRows / $pageSize);
$page = $_REQUEST['page'] ? (int) $_REQUEST['page'] : 1;
if ($page < 1 || $page == null || !is_numeric($page)) {
    $page = 1;
}
if ($page > $totalPage) {
    $page = $totalPage;
}
$offset = ($page - 1) * $pageSize;
$sql = "select u.id,u.username,u.pId,u.cId,u.capacity,u.address,u.phone,u.uDesc,u.pubTime,p.province, c.city from biogas_user as u join biogas_prov p on u.pId=p.id join biogas_city c on u.cId=c.id {$where} {$orderBy} limit {$offset},{$pageSize}";
$rows = fetchAll($sql);
?>
<!doctype html>
<html>
<head>
    <meta charset="utf-8">
    <title>-.-</title>

function getServicesByPage($pageSize)
{
    $sql = "select * from tg_host_services";
    $totalRows = getResultNum($sql);
    //it has to be set to GLOBAL!!
    global $totalPage;
    $totalPage = ceil($totalRows / $pageSize);
    @($page = $_REQUEST['page'] ? (int) $_REQUEST['page'] : 1);
    if ($page < 1 || $page == null || !is_numeric($page)) {
        $page = 1;
    }
    if ($page >= $totalPage) {
        $page = $totalPage;
    }
    $offset = ($page - 1) * $pageSize;
    $sql = "select * from tg_host_services as c join tg_user_login l on c.services_id = l.user_id order by c.id desc limit {$offset},{$pageSize}";
    $rows = fetchAll($sql);
    return $rows;
}