[php]代码库<?php
//分栏类
class ColumnClass {
var $page_size; //每页显示记录数
var $result; //分页记录集
var $page_cols; //栏目数
var $col_names = array () ; //各列显示名称数组
var $col_widths = array () ; //各列显示宽度数组
var $columns; //累计分栏显示标记
var $numbers; //显示当前页内序号
function __construct ( $page_size, $result, $page_cols,
$col_names, $col_widths) { //构造函数
$this->page_size = $page_size;
$this->result = $result;
$this->page_cols = $page_cols;
$this->col_names = $col_names;
$this->col_widths = $col_widths;
$page_res = $page_size / $page_cols; //每栏显示记录数
while ($row = mysql_fetch_array ($this->result)) { //将分页记录集存入二维数组
$records [] = $row;
}
$numbers = 0;
$this ->columns. = "
cellpadding =0 rules =none class ='tab' style ='border -collapse:
collapse'>" ; //建立页面表格
$this->columns. = "
" ;for ($i = 0; $i < $this->page_cols; $i++) { //循环建立栏目表格
$this->columns. = "
" ;$this->columns. = "
'tab' style='border-collapse:collapse'>" ;
$this->columns. = "
" ;$this->columns. = "
序号" ;for ($j = 0; $j < (sizeof ($records [0]) / 2) ; $j++)
//根据各列显示宽度呈现各列显示名称
{
$this->columns. = "
" .$this->col_names [$j] ." " ;}
$this->columns. = "
" ;for ($k = $i * $page_res; $k < ($i + 1) * $page_res; $k++)
//循环显示数据记录
{
$this->columns. = "
" ;if (sizeof ($records [$k]) == 0) { //是否显示序号
$this->columns. = "
 " ;} else {
$numbers++;
$this->columns. = "
$numbers" ;}
for ($j = 0; $j < (sizeof ($records [0]) / 2) ; $j++)
//逐个显示字段值
{
if (sizeof ($records [$k]) == 0) { //是否显示字段值
$this->columns. = "
 " ;} else {
$this->columns. = "
" .$records [$k] [$j] ."" ;}
}
$this->columns. = "
" ;}
$this->columns. = "
" ;$this->columns. = "
" ;}
$this->columns. = "
" ;$this->columns. = "
" ;}
}
?>
//使用方法
//指定参数
$page_size=50; //每页显示记录数
$page_cols=2; //栏目数
$col_names=array (' 编号’,姓名',' 班级',’状态’) ;
//各列显示名称数组
$col_widths=array ('100',’80’,'160',’70’) ;
//各列显示宽度数组
//调用分页类
include (" pageclass.php") ; //包含类文件
$pageObj=new PageClass ($nums,$page_size,$page) ;
//声明分页对象,包含3 个参数:记录总数、每页显示记录数、
//当前页码
$sql=" select num,name,dept,status from ksb limit " .$pageObj->
offset." ," .$pageObj->page_size; //分页SQL
$result=mysql_query ($sql) ; //生成分页记录集
//调用分栏类
include (" columnclass.php") ; //包含类文件
$colObj=new ColumnClass ($page_size,$page_cols,$result,
$col_names,$col_widths) ; //声明分栏对象,包含5 个参数:每
//页显示记录数、分页记录集、栏目数、各列显示名称及显示
//宽度
echo $colObj->columns; //分栏显示
?>
[代码运行效果截图]