<?php
/*********************************************
*
* 程序名： XD留言簿
* 作 者： 晓东
* Email： 502795768@qq.com
* Copyright @ 2009 Xiaodong. All Right Reserved
*
*********************************************/
class mysql{
var $querynum = 0;//查询次数
var $showError = true;
function connect($dbhost, $dbuser, $dbpw, $dbname='',$dbcharset='') {
if(!@mysql_connect($dbhost, $dbuser, $dbpw)) {
$this->show('无法连接到MySQL服务器.');
return false;
}
if($dbname) {
$this->select_db($dbname);
}
if($dbcharset && $this->version() > '4.1') {
$this->query("SET NAMES '".$dbcharset."'");
}
return true;
}
function select_db($dbname) {
return mysql_select_db($dbname);
}
function fetch_array($query, $result_type = MYSQL_ASSOC) {
return @mysql_fetch_array($query, $result_type);
}
function query($sql) {
if(!($query = @mysql_query($sql)))
$this->show('MySQL 执行错误', $sql);
$this->querynum++;
return $query;
}
function affected_rows() {
return mysql_affected_rows();
}
function result($query, $row) {
return mysql_result($query, $row);
}
function num_rows($query) {
return @mysql_num_rows($query);
}
function num_fields($query) {
return mysql_num_fields($query);
}
function free_result($query) {
return mysql_free_result($query);
}
function insert_id() {
return mysql_insert_id();
}
function fetch_row($query) {
return mysql_fetch_row($query);
}
function fetch_assoc($query){
return mysql_fetch_assoc($query);
}
function fetch_object(){
return mysql_fetch_object($query);
}
function version() {
return mysql_get_server_info();
}
function close() {
return mysql_close();
}
function error() {
return mysql_error();
}
function errno() {
return mysql_errno();
}
//出错提示
function show($message = '', $sql = '') {
if($this->showError)
exit($message.'<br>'.($sql?'出错sql语句:'.$sql.'<br>':'').'出错信息:<br>'.$this->errno().': '.$this->error());
}
}
class pagination extends mysql{
//分页类
var $totalrows = 0;//共有信息条数
var $messagenum;//每页信息条数$maxnum
var $pageindex;//当前页面$page
var $pagesnum;//共显示多少页$maxpages
var $pageprenum;//当前页之前显示多少页$pagepre
var $expansion;//扩展
var $totalpages;//可分总页数
var $self;//当前页面
var $psumarr = array();
var $plistarr = array();
function pagination($mnum,$page,$pnum,$ppre,$num=0,$sql='',$exp=''){
//构造函数
$this->messagenum = $mnum;
$this->pageindex = $page;
$this->pagesnum = $pnum;
$this->pageprenum = $ppre;
$this->expansion = $exp;
$this->self = $_SERVER['PHP_SELF'];
//获得记录总数。
if($num)
$this->totalrows = $num;
elseif($sql){
$query = $this->query($sql);
$rows = $this->fetch_array($query,MYSQL_NUM);
$this->totalrows = $rows[0];
}
//如果记录总数不为空，实现分页效果
if($this->totalrows){
$this->pageSum();
$this->pageBefore();
$this->pageList();
$this->pageAfter();
}
}
//功能：获得页面总数
function pageSum(){
$this->totalpages = ceil($this->totalrows/$this->messagenum);
$this->psumarr[] = $this->totalrows;
$this->psumarr[] = $this->pageindex."/".$this->totalpages;
}
//功能：跳到前一页
function pagePre(){
return $this->pageindex - 1;
}
//功能：跳到后一页
function pageNext(){
return $this->pageindex + 1;
}
//功能：置顶
function pageBefore(){
if($this->pageindex != 1){
$this->plistarr['first'] = array($this->self."?page=1".$this->expansion, "|‹");
$this->plistarr['pre'] = array($this->self."?page=".$this->pagePre().$this->expansion, "‹‹");
}
}
function pageList(){
if($this->pagesnum >= $this->totalpages){
$pgstart = 1;
$pgend = $this->totalpages;
}
elseif(($this->pageindex - $this->pageprenum -1 + $this->pagesnum) > $this->totalpages){
$pgstart = $this->totalpages - $this->pagesnum + 1;
$pgend = $this->totalpages;
}
else{
$pgstart = (($this->pageindex <= $this->pageprenum)?1:($this->pageindex-$this->pageprenum));
$pgend = (($pgstart == 1)?$this->pagesnum:($pgstart + $this->pagesnum - 1));
}
for($pg=$pgstart;$pg<=$pgend;$pg++){
$this->plistarr[$pg] = array($this->self."?page=".$pg.$this->expansion, $pg);
}
}
function pageAfter(){
if($this->pageindex != $this->totalpages){
$this->plistarr['next'] = array($this->self.'?page='.$this->pageNext().$this->expansion, "››");
$this->plistarr['last'] = array($this->self.'?page='.$this->totalpages.$this->expansion, "›|");
}
}
//页面格式化
function pageFormat(){
if(!$this->totalrows)
return '';
$pagestr = '';
foreach($this->psumarr as $value){
$pagestr .= $this->htmlTag('li','class="p_num"',$this->htmlTag('b','',$value));
}
foreach($this->plistarr as $key => $val){
if($key == $this->pageindex){
$pagestr .= $this->htmlTag('li','class="p_curpage"',$this->htmlTag('a','href="'.$val[0].'"',$val[1]));
}
else{
$pagestr .= $this->htmlTag('li','class="p_num"',$this->htmlTag('a','href="'.$val[0].'"',$val[1]));
}
}
return $pagestr;
}
function htmlTag($tag,$attr='',$content=''){
if($content == '')
return '<'.$tag.(($attr=='')?'':' '.$attr).' />';
else
return '<'.$tag.(($attr=='')?'':' '.$attr).'>'.$content.'</'.$tag.'>';
}
}
//数据库操作类。
class gbManage extends mysql {
function insertData($tbName,$values){
$sql = "INSERT INTO `{$tbName}` ( ";
$columnArr = $valArr = array();
foreach ($values as $key => $value){
$columnArr[] = "`{$key}`";
$valArr[] = is_null($values) ? 'NULL' : "'{$value}'";
}
$sql .= implode(', ', $columnArr);
$sql .= " ) VALUES ( ";
$sql .= implode(', ', $valArr);
$sql .= " )";
return $this->query($sql);
}
function updateData($tbName,$values,$expansion='',$condition=''){
$sql = "UPDATE `{$tbName}` SET ";
$sqlArr = array();
foreach ($values as $key => $value){
$sqlArr[] = "`{$key}` = '$value'";
}
$sql .= implode(', ',$sqlArr);
$sql .= $expansion;
if($condition)
$sql .= " WHERE " . $condition;
return $this->query($sql);
}
/*删除表内数据
* $tbName:表名 string
* $key:字段名 string
* $value : 字段值 string or array
* */
function deleteData($tbName,$key,$value){
if(is_array($value)){
for($i=0;$i<count($value);$i++){
$sql="Delete from {$tbName} where {$key}='{$value[$i]}'";
$this->query($sql);
}
}
$sql="Delete '{$tbName}'";
}
function return_row($sql){
$query = $this->query($sql);
if($this->num_rows($query))
return $this->fetch_array($query);
}
function return_array($sql) {
$arr = array();
$query = $this->query($sql);
while($row = $this->fetch_array($query)){
$arr[] = $row;
}
return $arr;
}
}
//规范html输出显示类
class Fanso_lite{
var $template_dir = 'templates/';
var $include_header = true;
var $include_footer = true;
var $head = 'header.html';
var $foot = 'footer.html';
//页面显示方法
function display($file_name){
echo $this->parseHeader().$this->fetch($file_name).$this->parseFooter();
}
//将文件内输出内容全部返回
function fetch($file_name){
global $vartem;
$compiledfile_url = $this->template_dir . $file_name;
ob_start();
require($compiledfile_url);
$content = ob_get_contents();
ob_end_clean();
return $content;
}
//解析头部
function parseHeader(){
$headerContent = $this->fetch($this->head);
if(!$this->include_header)
$headerContent = preg_replace('/<center>.+/is','<center>',$headerContent);
return $headerContent;
}
//解析尾部
function parseFooter(){
global $vartem;
$vartem['querytime'] = queryTime();
$footerContent = $this->fetch($this->foot);
if(!$this->include_fo
class.rar （1个子文件） 
class.php 8KB
weixin_43717015
- 粉丝: 0
- 资源: 1
最新资源
- 章节1：Python入门视频
- 无需样板的 Python 类.zip
- ESP32 : 32-bit MCU & 2.4 GHz Wi-Fi & BT/BLE SoCs
- 博物馆文博资源库-JAVA-基于springBoot博物馆文博资源库系统设计与实现
- 旅游网站-JAVA-springboot+vue的桂林旅游网站系统设计与实现
- 小说网站-JAVA-基于springBoot“西贝”小说网站的设计与实现
- 游戏分享网站-JAVA-基于springBoot“腾达”游戏分享网站的设计与实现
- 学习交流-JAVA-基于springBoot“非学勿扰”学习交流平台设计与实现
- EDAfloorplanning
- 所有课程均提供 Python 复习部分.zip
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
评论0