$sql = "select `pic` from `mypic` limit $nextpagestart,$pagesize";
$query =mysql_query($sql);
while($row = mysql_fetch_array($query)){
//内容
?>
<img src="<?php
echo $row["pic"];
?>
" alt="" width="200" height="200">
<?
}
//分页
if($page ==$maxnum){
include('page.class.php');
$sqlsum = "select `id` from `mypic`";
$querysum = mysql_query($sqlsum);
//数据总数
$total = mysql_num_rows($querysum);
//参数对应位置：总记录，每页显示的条数，当前页，连接的地址
$my_page=new PageClass($total,$pagesize,$page,'?page={page}');
//输出页码
echo $my_page->myde_write();
exit;
}
?>
default:
//list
$pageListNum = 12;
//每页显示
$totalPage = 0;
//总页数
$page = isset($page) ? (int) $page : 1;
$start = ($page - 1) * $pageListNum;
$List = $users_log->GetList(array('id', 'userid', 'action', 'addtime'), $start, $pageListNum, '', 'id desc');
include WEB_INC . "page.class.php";
$sqlNum = "select id from {tablepre}users_log";
$db->Execute($sqlNum);
$pageNum = $db->GetRsNum();
$totalPage = ceil($pageNum / $pageListNum);
//总页数
$pages = new PageClass($page, $totalPage);
$showpage = $pages->showPage();
$templatefile = 'users_log_list.tpl.php';
break;
case 'edit':
//
break;
case 'search':
//
break;
case 'show':
//
break;
case 'del':
//
break;
<!DOCTYPE html>
<html>
<?php
require_once '../Database/dbConn.php';
require_once '../Database/DataAccessMySQLi.php';
require_once '../Business/PageClass.php';
require_once '../Business/ArticleClass.php';
require_once '../Business/ContentAreaClass.php';
require_once '../Business/CssClass.php';
$pageArray = PageClass::retrievePages();
$currentTemplate = CssClass::getSingleTemplate(1);
$singlePage = PageClass::getSinglePage(1);
if (isset($_GET['page'])) {
$singlePage = PageClass::getSinglePage($_GET['page']);
$currentTemplate = CssClass::getSingleTemplate($_GET['page']);
}
// WARNING: PSEUDO_CODE ONLY
// this may be a presentation page in 3-tier or a view in MVC
// I am doing a bit too much echoing HTML (li tags, etc.) but wanted to simplify
// FIND OUT WHAT PAGE WE ARE ON
// obtain/receive the current page ($currentPage)
// using GET from the nav or if none then default page
// FIND OUT WHAT STYLE TEMPLATE WE ARE USING
// obtain/receive the active style/template ($currentTemplate)
?>
<title><?php
echo $singlePage->getPageTitle();
?>
</title>
<style type="text/css">
<?php
<thead>
<tr>
<td>Page Id</td>
<td>Page Name</td>
<td colspan="2">
<form action="editorPortal.php" method="post">
<input type="Submit" id="addPage" name="addPage" value="Add Page" />
</form>
</td>
</tr>
</thead>
<tbody>
<?php
require "../Business/PageClass.php";
$arrayOfPages = PageClass::retrievePages();
foreach ($arrayOfPages as $page) {
?>
<tr>
<td><?php
echo $page->getID();
?>
</td>
<td><?php
echo $page->getPageTitle();
?>
</td>
<td>
<form action="editorPortal.php" method="post">
<input type="text" id="editPageId" name="editPageId" value="<?php
echo $page->getID();
echo "<table>";
$sql = "select * from test limit " . ($page - 1) * $pagesize . "," . $pagesize . "";
$query = $db->query($sql);
while ($rs = $query->fetch_array()) {
?>
<tr>
<td>
标题：<?php
echo $rs['id'];
?>
</td>
<td>
作者：<?php
echo $rs['name'];
?>
</td>
<td>
时间：<?php
echo $rs['sex'];
?>
</td>
</tr>
<?php
}
echo "</table>";
//显示分页符
/*($i =1;$i<=$pagenum;$i++){
echo "<a href='index.php?page=".$i."''>".$i."</a> ";
}*/
$page = new PageClass($count, $pagesize, $page, '?page={page}');
$page->page_print(1);
<body>
<?php
require_once '../Database/dbConn.php';
require_once '../Database/DataAccessMySQLi.php';
require_once '../Business/PageClass.php';
require_once '../Business/ArticleClass.php';
require_once '../Business/ContentAreaClass.php';
require_once '../Business/CssClass.php';
echo "test";
?>
<DIV>
<h2>Database connection test!</h2>
<?php
// $arrayOfPages = ArticleClass::retrieveArticles();
$arrayOfPages = PageClass::retrievePages();
foreach ($arrayOfPages as $page) {
echo "<p>";
echo $page->getDesc();
echo "</p>";
}
$singlePage = PageClass::getSinglePage(1);
echo "<br/><p>";
echo $singlePage->getId();
echo $singlePage->getPageTitle();
echo $singlePage->getCSS();
echo $singlePage->getDesc();
echo "</p>";
?>
</DIV>
</body>
</html>
} elseif (isset($_POST['addPage'])) {
//load the divs management table\
include_once 'tables/page/page.php';
} elseif (isset($_POST['delPage'])) {
//load delete confirmation page
include_once 'tables/page/deletePage.php';
} elseif (isset($_POST['addedPage'])) {
//load insert routine + success/fail message
include_once 'tables/page/addPage.php';
} elseif (isset($_POST['editedPage'])) {
//load update routine + success/fail message
include_once 'tables/page/editPage.php';
} elseif (isset($_POST['deletedPage'])) {
//delete selected article
require_once '../Business/PageClass.php';
$currentPage = PageClass::getSinglePage($_POST['delPageId']);
$result = $currentPage->deletePage();
echo $result;
}
//////////////////////////////////////////
// Article MGMT Block //
////////////////////////////////////////
if (isset($_POST['articleMgmtBtn'])) {
//load the articles management table
include_once 'tables/articleMgmt.php';
} elseif (isset($_POST['addArticle'])) {
//load empty form + pointer to insert routine
include_once 'tables/article/article.php';
} elseif (isset($_POST['editArticle'])) {
//load pre-populated form + pointer to update routine
include_once 'tables/article/article.php';
<?php require '../Business/PageClass.php'; //build new article business object $newPage = new PageClass($_POST['pName'], $_POST['pWebName']); $newPage->setId($_POST['editPageId']); $newPage->setDesc($_POST['pDesc']); $newPage->setCSS($_POST['pCss']); $result = $newPage->updatePage(); //report success/failure echo $result; ?>
include template('hejin_toupiao:admin/zuopindsh');
}
}
//作品投票记录
elseif($model == 'tpjles'){
$zid = intval($_GET['zid']);
$zpinfo = C::t('#hejin_toupiao#hjtp_zuopins')->fetch_by_id($zid);
if($zid){
include_once ("page.class.php");
$page=$_GET['page'];
$tplist = C::t('#hejin_toupiao#hjtp_tpjles')->fetch_zid_all($zid);
$totail = count($tplist);
$number = 40;
$url = $SELF.'?action=plugins&operation=config&do=' . $_GET['do'] . '&identifier=hejin_toupiao&pmod=toupiao&model=tpjles&zid='.$zid.'&page={page}';
$my_page=new PageClass($totail,$number,$page,$url);//参数设定：总记录，每页显示的条数，当前页，连接的地址
$startnum = $my_page->page_limit;
$count = $my_page->myde_size;
$stlists = C::t('#hejin_toupiao#hjtp_tpjles')->fetch_zid_limit($zid,$startnum,$count);
$page_string = $my_page->myde_write();
include template('hejin_toupiao:admin/tpjles');
}
}
//删除作品投票记录
elseif($model == 'deltpjl'){
if($_GET['formhash']==formhash()){
} else {
if (trim($_GET['action']) == 'exit') {
$_SESSION = array();
session_destroy();
setcookie('PHPSESSID', '', time() - 3600, '/', '', 0, 0);
header('Location: login.php');
ob_end_flush();
} else {
$page = $_GET['page'] ? intval($_GET['page']) : "1";
$sql = "SELECT `id` FROM {$table2}";
mysql_query("set names 'utf-8'");
$DB_site->query($sql);
$query = mysql_db_query($dbname, $sql);
$totail = $DB_site->num_rows();
$number = $pagenumber;
$my_page = new PageClass($totail, $number, $_GET['page'], '?page={page}');
$sql = "SELECT * FROM {$table2} order by `id` DESC LIMIT " . $my_page->page_limit . "," . $my_page->myde_size;
$DB_site->query($sql);
while ($row = $DB_site->fetch_array()) {
if ($row['level'] == 1) {
$newlevel = "低";
} elseif ($row['level'] == 2) {
$newlevel = "中";
} elseif ($row['level'] == 3) {
$newlevel = "高";
} else {
$newlevel = "NULL";
}
if ($row['remove'] == 0) {
$newremove = "未隔离";
} elseif ($row['remove'] == 1) {
<?php require '../Business/PageClass.php'; //build new article business object $newPage = new PageClass($_POST['pName'], $_POST['pWebName']); $newPage->setDesc($_POST['pDesc']); $newPage->setCSS($_POST['pCss']); $result = $newPage->savePage(); //report success/failure echo $result; ?>
exit;
}
}
if($vid){
$vote = C::t('#hejin_toupiao#hjtp_votes')->fetch_by_id($vid);
$zid = intval($_GET['zid'])?intval($_GET['zid']):0;
$picarray = explode(',',$vote['pic']);
if(count($picarray)>1){
$ispicarr = 1;
}else{
$ispicarr = 0;
}
$ishave = count($vote);
if($page){
include_once ("page.class.php");
$my_page=new PageClass(0,10,1,'');
$page_string = $my_page->is_page($vid,$zid);
}
if($hejintoupiao['hjtp_jssdk'] && $hejinbox['hjbox_appid'] && $hejinbox['hjbox_appsecret']){
require_once DISCUZ_ROOT.'./source/plugin/hejin_toupiao/jssdk.php';
$jssdk = new JSSDK($hejinbox['hjbox_appid'], $hejinbox['hjbox_appsecret']);
$signPackage = $jssdk->GetSignPackage();
}
if($ishave){
if($vote['start_time']>time()){
$bmzt = 1;//报名还没有开始
}elseif($vote['over_time']<time()){
$bmzt = 2;//报名已经结束
}else{
if($_COOKIE['hjbox_openid']){
$openid = addslashes($_COOKIE['hjbox_openid']);
