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='******' 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='******'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='******'username']}' and receiver is null order by reg_time desc ";
$numRows = getResultNum($sql1);
$totalPage = ceil($numRows / $pageSize);
$sql2 = "select * from tuhao_pro where 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 = " ")
{
$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']}' 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='******' 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='******' 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='******' 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;
}
