2008 八月一个程序猿孙小一,孙小二,PHP,MYSQL,LINUX,APACHE,原创技术,扯淡

简单分页程序,adodb+smarty

作者 : admin 于 2008年08月31日, 17:56:16

2008
08-31

分页类

<?php
/* Page.Class.php
* Page
* @link http://www.sunboyu.cn
* @package OA
* @version V1.0
*
* 2008 08 28 sunboyu@gmail.com
* Demo
$page = new Page( 1 , 'v_user' , '*' , '' );
$rs = $page->__getlist();
$smarty->assign("page",$page->__getpagelist());
*/
class Page
{
public $count; #结果总数
public $page; #当前页
public $pagesize; #每页结果数
public $pagecount; #翻页数
public $baseurl; #url
public $result; #结果数组集
public $pagelist; #每翻页数
public $db; #数据库连接
public $table; #要查询的表
public $fileds; #要返回的字段
public $where; #where条件
#构造函数，初始化变量
function __construct( $page , $table , $fields = '*' , $where = false , $baseurl = false )
{
global $_CFG;
$this->db = GetDB();
$this->count = $count;
$this->table = $table;
$this->page = isset($page) ? intval($_GET['page']) : 1;
$this->fileds = $fields;
$this->pagesize = $_CFG['pagesize'];
$this->baseurl = ($baseurl!=false) ? $baseurl : $this->__geturl();
$this->pagelist = $_CFG['pagelist'];
$this->where = $where;
}
#获得当前url
function __geturl()
{
$str = ereg_replace(sprintf("(^|&)page=%d",$this->page),"",$_SERVER['QUERY_STRING']);
return $str=="" ? '?' : $str;
}
#获得记录集
function __getlist()
{
#获得count记录
$sql = sprintf("SELECT COUNT(0) AS table_count FROM %s",$this->table);
$rs = $this->db->Execute( $sql );
$this->count = $rs->fields['table_count'];
$offset = ($this->page-1)*$this->pagesize-1;
$sql = sprintf("SELECT %s FROM %s %s",$this->fileds,$this->table,(($this->where!=false) ? " WHERE ".$this->where : ''));
$rs = $this->db->SelectLimit( $sql , $this->pagesize , $offset );
$list = false;
while(!$rs->EOF)
{
$list[] = $rs->fields;
$rs->MoveNext();
}
return $list;
}
#获得分页列表
function __getpagelist()
{
$this->result['count'] = $this->count;
$this->result['page'] = $this->page;
$this->result['pagesize'] = $this->pagesize;
$this->result['pagecount'] = ceil($this->count/$this->pagesize);
if($this->result['pagecount']<=1) //只有一页以下
{
$this->result['pagelist'] = 0;
}
else //一页以上
{
#前一页，第一页的算法
$this->result['first'] = ($this->page == 1) ? 0 : 1;
$this->result['pre'] = ($this->page == 1) ? 0 : 1;
#后一页，最后一页的算法
$this->result['next'] = ($this->page == $this->pagecount ) ? 0 : 1;
$this->result['last'] = ($this->page == $this->pagecount ) ? 0 : 1;
#起始
$pagearray = array();
$start = floor(($this->page-1)/10)*10+1;
for($i=0;$i<10;$i++)
{
if( ($start+$i) <= $this->result['pagecount'])
{
$pagearray[$i]['page'] = $start+$i;
}
if( ($start+$i) != $this->page )
{
$pagearray[$i]['link'] = 1;
}
}
#分页导航列表
$this->result['pagelist'] = $pagearray;
$this->result['baseurl'] = $this->baseurl;
}
return $this->result;
}
}
?>

smarty模版

{{config_load file="Lang.Page.$lang.conf"}}<div id="page">
<table>
<tr>
<td>
{{#gongs#}}{{$page.count}}{{#pagecountend#}} {{#pagepagesizeper#}}{{$page.pagesize}}{{#pagepagelistper#}}{{#tiao#}} {{#gongs#}}{{$page.pagecount}}{{#page#}} {{#pagepage#}}{{$page.page+1}}{{#page#}}
</td>
<td>
{{if $page.pagecount>1}}
{{if $page.first eq 1}}
<a href="{{$page.baseurl}}">{{#pagefirst#}}</a>
{{else}}
{{#pagefirst#}}
{{/if}}
{{if $page.pre eq 1}}
<a href="{{$page.baseurl}}&page={{$page.page-1}}">{{#pagepre#}}</a>
{{else}}
{{#pagepre#}}
{{/if}}
{{foreach from=$page.pagelist item=vols}}
{{if $vols.link eq 1}}
<a href="{{$page.baseurl}}&page={{$vols.page}}">[{{$vols.page}}]</a>
{{else}}
[{{$vols.page}}]
{{/if}}
{{/foreach}}
{{if $page.next eq 1}}
<a href="{{$page.baseurl|default:"?"}}&page={{$page.page+1}}">{{#pagenext#}}</a>
{{else}}
{{#pagenext#}}
{{/if}}
{{if $page.last eq 1}}
<a href="{{$page.baseurl|default:"?"}}&page={{$page.pagecount}}">{{#pageend#}}</a>
{{else}}
{{#pagelast#}}
{{/if}}
{{/if}}
</td>
</tr>
</table>
</div>

语言包内容

pagecountend = "条数据"
pagepagesizeper = "每页"
pagepagesizeend = "条"
page = "页"
tiao = "条"
pagepage = "当前第"
pagefirst = "首页"
pagepre = "上一页"
pagenext = "下一页"
pagelast = "尾页"
gongs = "共"

简单的PHP+SMARTY分页类

作者 : admin 于 2008年08月29日, 23:21:47

2008
08-29

类的代码

<?php
/* Page.Class.php
* Page
* @link http://www.sunboyu.cn
* @package OA
* @version V1.0
*
* 2008 08 28 sunboyu@gmail.com
*/
class Page
{
public $count; #结果总数
public $page; #当前页
public $pagesize; #每页结果数
public $pagecount; #翻页数
public $baseurl; #url
public $result; #结果数组集
public $pagelist; #每翻页数
#构造函数，初始化变量
function __construct( $count , $page , $pagesize , $pagelist , $baseurl = false )
{
$this->count = $count;
$this->page = $page;
$this->pagesize = $pagesize;
$this->baseurl = isset($baseurl) ? $baseurl : $this->__geturl();
$this->pagelist = $pagelist;
}
#获得当前url
function __geturl()
{
return ereg_replace("(^|&)page={$page}","",$_SERVER['QUERY_STRING']);
}
#获得分页列表
function __getpagelist()
{
$this->result['count'] = $this->count;
$this->result['page'] = $this->page;
$this->result['pagesize'] = $this->pagesize;
$this->result['pagecount'] = ceil($this->count/$this->pagesize);
if($this->result['pagecount']<=1) //只有一页以下
{
$this->result['pagelist'] = 0;
}
else //一页以上
{
#前一页，第一页的算法
$this->result['first'] = ($this->page == 1) ? 0 : 1;
$this->result['pre'] = ($this->page == 1) ? 0 : 1;
#后一页，最后一页的算法
$this->result['next'] = ($this->page == $this->pagecount ) ? 0 : 1;
$this->result['last'] = ($this->page == $this->pagecount ) ? 0 : 1;
#起始
$pagearray = array();
$start = floor(($this->page-1)/10)*10+1;
for($i=0;$i<10;$i++)
{
if( ($start+$i) <= $this->result['pagecount'])
{
$pagearray[$i]['page'] = $start+$i;
}
if( ($start+$i) != $this->page )
{
$pagearray[$i]['link'] = 1;
}
}
#分页导航列表
$this->result['pagelist'] = $pagearray;
$this->result['baseurl'] = $this->baseurl;
}
}
}
?>

模版代码

<table>
<tr>
<td>
共{{$page.count}}条数据每页{{$page.pagesize}}条共{{$page.pagecount}}页当前第{{$page.page}}页
</td>
<td>
{{if $page.first eq 1}}
<a href="{{$page.baseurl}}">首页</a>
{{else}}
首页
{{/if}}
{{if $page.pre eq 1}}
<a href="{{$page.baseurl}}&page={{$page.page-1}}">上一页</a>
{{else}}
上一页
{{/if}}
{{foreach from=$page.pagelist item=vols}}
{{if $vols.link eq 1}}
<a href="{{$page.baseurl}}&page={{$vols.page}}">[{{$vols.page}}]</a>
{{else}}
[{{$vols.page}}]
{{/if}}
{{/foreach}}
{{if $page.next eq 1}}
<a href="{{$page.baseurl}}&page={{$page.page-1}}">下一页</a>
{{else}}
下一页
{{/if}}
{{if $page.last eq 1}}
<a href="{{$page.baseurl}}&page={{$page.pagecount}}">尾页</a>
{{else}}
尾页
{{/if}}
</td>
</tr>
</table>

调用范例

<?php
require_once('Include/Init.inc.php');
require_once('Include/Class/Page.Class.php');
$page = new Page( 999 , 12 , 10 , 6 , '?' );
$page->__getpagelist();
$smarty->assign("page",$page->result);
$smarty->display("page.html");
?>

Mysql视图应用

作者 : admin 于 2008年08月28日, 20:55:26

2008
08-28

mysql视图创建方法，以我的OpenOA为例，创建user表left jion user_info表的视图

CREATE VIEW v_user AS SELECT * FROM user LEFT JOIN user_info ON (user.id = user_info.user_id)

然后查看

mysql>use oa

mysql>show tables

结果显示，v_user是库oa中的一个表。因此我们使用的时候，可以直接使用语句 SELECT * FROM v_user

而这句也就等于 SELECT * FROM user LEFT JOIN user_info ON (user.id = user_info.user_id)

而实习在系统中，v_user 只有这么一个文件v_user.frm 也就是只有结构，没有数据和索引.打开后，可以看到详细的存储的内容

TYPE=VIEW
query=select `oa`.`user`.`id` AS `id`,`oa`.`user`.`username` AS `username`,`oa`.`user`.`nickname` AS `nickname`,`oa`.`user`.`password` AS `password`,`oa`.`user`.`lastlogintime` AS `lastlogintime`,`oa`.`user`.`lastloginip` AS `lastloginip`,`oa`.`user`.`loginrand` AS `loginrand`,`oa`.`user_info`.`user_id` AS `user_id`,`oa`.`user_info`.`user_realname` AS `user_realname`,`oa`.`user_info`.`user_sex` AS `user_sex`,`oa`.`user_info`.`user_age` AS `user_age`,`oa`.`user_info`.`user_birthplace` AS `user_birthplace`,`oa`.`user_info`.`user_homeaddress` AS `user_homeaddress`,`oa`.`user_info`.`user_idcard` AS `user_idcard`,`oa`.`user_info`.`user_graduateschool` AS `user_graduateschool`,`oa`.`user_info`.`user_educational` AS `user_educational`,`oa`.`user_info`.`user_graduatetime` AS `user_graduatetime`,`oa`.`user_info`.`user_homephone` AS `user_homephone`,`oa`.`user_info`.`user_cellphone` AS `user_cellphone`,`oa`.`user_info`.`user_workphone` AS `user_workphone`,`oa`.`user_info`.`user_fax` AS `user_fax`,`oa`.`user_info`.`user_email` AS `user_email`,`oa`.`user_info`.`user_oicq` AS `user_oicq`,`oa`.`user_info`.`user_msn` AS `user_msn` from (`oa`.`user` left join `oa`.`user_info` on((`oa`.`user`.`id` = `oa`.`user_info`.`user_id`)))
md5=19f7a28463ad7447c3b4cc5428888fa6
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=1
timestamp=2008-08-28 11:58:17
create-version=1
source=SELECT * FROM user LEFT JOIN user_info ON ( user.id = user_info.user_id )

都是啥意思，没有深究，只是能根据字面猜出来，如果只是用，到此位置即可。

CSS注释兼容性测试

作者 : admin 于 2008年08月28日, 00:21:34

2008
08-28

调试CSS差点调吐了，ff说啥都不认。后来起到html注释有兼容性，进行了一下测试。

风格1:手误的一种注释 <!– *** –>这本是html的注释，一不小心写了出来，结果，firefox不认，差点没调吐。

风格2:标准的注释 /* &&&&& */ ie6，firefox都兼容的。

另外写注释，注释跟两边边界空出一点，会好点，降低错误率。

PHP中FTP模块的一些应用

作者 : admin 于 2008年08月27日, 10:20:06

2008
08-27

<?php
class ftp
{
//connect id
var $ftp;
//remote dir
var $remotedir = '/';
//local dir
var $localdir = './';
//write log
var $writelog = false;
//log file
var $logfile = 'ftp_log.txt';
//print log
var $printlog = false;
//session time
var $timeout = 60;
//construct connetc
function __construct( $host , $user , $pass )
{
$this->ftp = @ftp_connect( $host );
ftp_login( $this->ftp, $user , $pass );
//ftp_set_option( $this->ftp , FTP_TIMEOUT_SEC , $this->timeout );
}
//list sub files
function __list( $dir = false , $subtree = false )
{
$rlist = array();
if(!$dir)
{
$dir = $this->remotedir;
}
$list = ftp_rawlist($this->ftp,$dir,TRUE);
if(is_array($list))
{
foreach( $list as $key => $value )
{
$tmp = explode( ' ' , $value );
$rlist[$key] = end($tmp);
if(@ftp_chdir($this->ftp,$dir.$rlist[$key].'/'))
{
$rlist[$rlist[$key]] = $this->__list( $dir.$rlist[$key].'/' );
unset($rlist[$key]);
}
unset($tmp);
}
}
return $rlist;
}
//change dir $isabs = false,use rela dir default
function __chdir( $dir , $isabs = false )
{
if(!$isabs)
{
$nextdir = $this->remotedir.$dir.'/';
}
else
{
$nextdir = $dir;
}
if(ftp_chdir($this->ftp,$nextdir))
{
$this->remotedir = $nextdir;
return true;
}
else
{
return false;
}
}
//close connect
function __close()
{
@ftp_close($this->ftp);
}
}
$ftp = new ftp( 'www.sunboyu.cn' , '**', '***' );
$ftp->__chdir('website',0);
$list = $ftp->__list('/');
echo $a = time();
print_r($list);
echo time() - $a;
?>

放弃ADODB_lite数据字典功能

作者 : admin 于 2008年08月26日, 23:33:31

2008
08-26

对adodb_lite的数据字典功能进行测试使用后，发现这玩意是一块鸡肋。其优秀之处在于多种数据库的无缝切换，当使用范围扩大的时候，弊端随之暴露：

1：对字段类型的支持不够完全，比如enum类型

2：不支持存储过程触发器之类

而一个项目中，存储过程触发器之类使用很多，没有这些，但出写表的数据字典感觉意义不大，不过简单的表还是会用这种方式，其他的就爹生成sql语句了

今日北京风雨大作,浇老夫于知春路上

作者 : admin 于 2008年08月26日, 09:20:13

2008
08-26

记

PHP调用COM获得服务器硬件信息

作者 : admin 于 2008年08月24日, 10:23:19

2008
08-24

function sys_windows() {
$objLocator = new COM("WbemScripting.SWbemLocator");
$wmi = $objLocator->ConnectServer();
$prop = $wmi->get("Win32_PnPEntity");
//CPU
$cpuinfo = GetWMI($wmi,"Win32_Processor", array("Name","L2CacheSize","NumberOfCores"));
$res['CPU个数'] = $cpuinfo[0]['NumberOfCores'];
if (null == $res['CPU个数']) {
$res['CPU个数'] = 1;
}
for ($i=0;$i<$res['cpu']['num'];$i++){
$res['CPU型号'] .= $cpuinfo[0]['Name']."<br>";
$res['二级缓存'] .= $cpuinfo[0]['L2CacheSize']."<br>";
}
// SYSINFO
$sysinfo = GetWMI($wmi,"Win32_OperatingSystem", array('LastBootUpTime','TotalVisibleMemorySize','FreePhysicalMemory','Caption','CSDVersion','SerialNumber','InstallDate'));
$res['操作系统版本'] = $sysinfo[0]['Caption']." ".$sysinfo[0]['CSDVersion'];
$res['操作系统序列号'] = "{$sysinfo[0]['SerialNumber']} 于".date('Y年m月d日H:i:s',strtotime(substr($sysinfo[0]['InstallDate'],0,14)))."安装";
//UPTIME
$res['最后重启时间'] = $sysinfo[0]['LastBootUpTime'];
$sys_ticks = 3600*8 + time() - strtotime(substr($res['最后重启时间'],0,14));
$min = $sys_ticks / 60;
$hours = $min / 60;
$days = floor($hours / 24);
$hours = floor($hours - ($days * 24));
$min = floor($min - ($days * 60 * 24) - ($hours * 60));
if ($days !== 0) $ress['day'] = $days."天";
if ($hours !== 0) $ress['hours'] .= $hours."小时";
$res['最后重启时间'] = $ress['day'].$ress['hours'].$min."分钟";
//MEMORY
$res['物理内存'] = $sysinfo[0]['TotalVisibleMemorySize'];
$res['剩余内存'] = $sysinfo[0]['FreePhysicalMemory'];
$res['已使用内存'] = $res['物理内存'] - $res['剩余内存'];
$res['使用率'] = round($res['已使用内存'] / $res['物理内存']*100,2);
$swapinfo = GetWMI($wmi,"Win32_PageFileUsage", array('AllocatedBaseSize','CurrentUsage'));
// TODO swp区获取
$res['交换分区'] = $swapinfo[0][AllocatedBaseSize];
$res['已经使用'] = $swapinfo[0][CurrentUsage];
$res['剩余内存'] = $res['swapTotal'] - $res['swapUsed'];
$res['使用率'] = (floatval($res['swapTotal'])!=0)?round($res['swapUsed']/$res['swapTotal']*100,2):0;
// LoadPercentage
$loadinfo = GetWMI($wmi,"Win32_Processor", array("LoadPercentage"));
$res['系统平均负载'] = $loadinfo[0]['LoadPercentage'];
return $res;
}
function GetWMI($wmi,$strClass, $strValue = array()) {
$arrData = array();
$objWEBM = $wmi->Get($strClass);
$arrProp = $objWEBM->Properties_;
$arrWEBMCol = $objWEBM->Instances_();
foreach($arrWEBMCol as $objItem) {
@reset($arrProp);
$arrInstance = array();
foreach($arrProp as $propItem) {
eval("\$value = \$objItem->" . $propItem->Name . ";");
if (empty($strValue)) {
$arrInstance[$propItem->Name] = trim($value);
} else {
if (in_array($propItem->Name, $strValue)) {
$arrInstance[$propItem->Name] = trim($value);
}
}
}
$arrData[] = $arrInstance;
}
return $arrData;
}

小一探针

作者 : admin 于 2008年08月21日, 11:26:28

2008
08-21

闲来没事，突然想写个探针
http://www.sunboyu.cn/info.php
难点很多，逐一突破。写这么个东西对PHP和系统的认识提高很快。

史上最牛的中文验证码，2过腾讯！

作者 : admin 于 2008年08月18日, 23:39:02

2008
08-18

测试地址 http://www.sunboyu.cn/sourse/nbcode.php

下载地址 http://www.sunboyu.cn/sourse/nbcode.rar

一个程序猿

时光不会倒流,脚步总要前进