$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']);