discuz学习记录：重复前面的步骤，分页显示公务员题库内容

    重复前面的步骤，分页显示公务员题库表内容，验证各环节是否正确。所有环节正确后，即可以此为基础开始后面的学习。

涉及文件：

/bgtj.php

/source/module/cat/bgtj_publish.php

/source/class/table/table_bgtj.php

/template/default/cat/bgtj_publish.htm

/bgtj.php

<?php

/**
 *      [Discuz!] (C)2001-2099 Comsenz Inc.
 *      This is NOT a freeware, use is subject to license terms
 *
 *      $Id: bgtj.php  cuibq $
 */


define('APPTYPEID', 101);
define('CURSCRIPT', 'bgtj');

require './source/class/class_core.php';

$discuz = C::app();

$discuz->reject_robot();
$modarray = array('bgtj', 'bgtj_publish');


$mod = getgpc('mod');
$mod = (empty($mod) || !in_array($mod, $modarray)) ? 'error' : $mod;


$discuz->init();

define('CURMODULE', $mod);

//echo 'bbbb';
//exit;
require DISCUZ_ROOT.'./source/module/cat/bgtj_publish.php';

?>

/source/module/cat/bgtj_publish.php

<?php
// mod文件只能被入口文件引用，不能直接访问
if(!defined('IN_DISCUZ')) {
	exit('Access Denied');
}

require_once libfile('function/discuzcode');


// -------------------------------------------
// 分页
require_once libfile('function/home');

$perpage = 10;  
$perpage = mob_perpage($perpage);  
  
$page = empty($_GET['page'])?0:intval($_GET['page']);//页码  
if($page<1) $page = 1;  
$start = ($page-1)*$perpage;//开始记录  

ckstart($start, $perpage);//分页判断  

$count = C::t('bgtj')->count();//所有记录数量
$mpurl = 'bgtj.php';
// ============================================

$querydata = C::t('bgtj')->fetch_all_by_sql($start, $perpage);

$queryarr = array();
foreach ($querydata as $rec) {
	$queryarr[] = $rec;
}

$multipage = multi($count, $perpage, $page, $mpurl);

//显示发布表单
include_once template("cat/bgtj_publish");
?>

/source/class/table/table_bgtj.php

<?php

/**
 *      [Discuz!] (C)2001-2099 Comsenz Inc.
 *      This is NOT a freeware, use is subject to license terms
 *      工业产品表
 *      $Id: table_gycp.php
 */

if(!defined('IN_DISCUZ')) {
	exit('Access Denied');
}

class table_bgtj extends discuz_table
{
	public function __construct() {

		$this->_table = 'bgtj';
		$this->_pk    = 'id';

		parent::__construct();
	}

	public function fetch_all_by_displayorder() {
		return DB::fetch_all('SELECT * FROM %t ORDER BY id ASC', array($this->_table), $this->_pk);
	}

	public function fetch_all_by_sql($start, $limit) {
		return DB::fetch_all('SELECT * FROM %t ORDER BY id ASC'.DB::limit($start, $limit), array($this->_table), $this->_pk);
	}

	//public function fetch_by_id_username($id, $username, $adminid = 1) {
		//return DB::fetch_first('SELECT * FROM %t WHERE id=%d', array($this->_table, $id, $adminid, $username));
	//}

	public function delete_by_id($ids, $adminid = 1) {
		if(($ids = dintval((array)$ids, true))) {
			DB::query('DELETE FROM %t WHERE id IN(%n)', array($this->_table, $ids), false, true);
		}
	}

	//public function update_displayorder_by_id_username($id, $displayorder, $username, $adminid = 1) {
		//if(($id = dintval((array)$id, true))) {
			//DB::query('UPDATE %t SET displayorder=%d WHERE id IN(%n)', array($this->_table, $displayorder, $id, $adminid, $username), false, true);
		//}
	//}

	//public function update_by_id_username($id, $data, $username, $adminid = 1) {
		//if(($id = dintval($id, true)) && $data && is_array($data)) {
			//$adminid = dintval($adminid);
			//DB::update($this->_table, $data, DB::field($this->_pk, $id).')', true);
		//}
	//}


}

?>

/template/default/cat/bgtj_publish.htm

<!--//说明: 显示公共头部模板-->
<!--{template common/header}-->
记录总数量：$count<br/>
<table class="dt mtm">  
        <tr>  
            <th  width="10">ID</td>   
            <th  width="10">序号</td>  
			<th  width="100">问题</td>  
			<th  width="30">答案</td> 
        </tr> 
        <!--{loop $queryarr $rec_data}-->  
        <tr>  
            <td align="left">$rec_data[ID]</td>   
            <td align="left">$rec_data[XH]</td>  
			<td align="left">$rec_data[WT]</td>  
			<td align="left">$rec_data[DA]</td> 
        </tr>  
        <!--{/loop}-->  
        <tr>  
			<td colspan="4"><!--{if $multipage}-->$multipage<!--{/if}--></td>

        </tr>
</table>  

<!--//说明: 显示公共尾部模板-->
<!--{template common/footer}-->

    浏览结果： http://localhost/bgtj.php