Posts Tagged ‘录的’

搜索和替换文件或目录的一个好类–很实用

星期一, 06月 2nd, 2008

这是个非常有用de程序,可以对文本文件进行特定de搜索,并以特定de文字替换指定de文字,举个例子说如果我这篇文章里有一个字全部打错了,有几十处,要一一找出来修改是件很麻烦de事,用下面这个就可以轻松搞定.–teaman.oso.com.cn
类文件 search_replace.inc
<?php

class search_replace{
var $find;
var $replace;
var $files;
var $directories;
var $include_subdir;
var $ignore_lines;
var $ignore_sep;
var $occurences;
var $search_function;
var $last_error;
//以下进行函数定义和设置
function search_replace($find, $replace, $files, $directories = ”, $include_subdir = 1, $ignore_lines = array()){
$this->find = $find;
$this->replace = $replace;
$this->files = $files;
$this->directories = $directories;
$this->include_subdir = $include_subdir;
$this->ignore_lines = $ignore_lines;
$this->occurences = 0;
$this->search_function = ’search’;
$this->last_error = ”;
}
/***************************************
** Accessor for retrieving occurences.
***************************************/
function get_num_occurences(){
return $this->occurences;
}
//获取最后de错误
function get_last_error(){
return $this->last_error;
}
//设置FIND变量
function set_find($find){
$this->find = $find;
}
//设置replace变量
function set_replace($replace){
$this->replace = $replace;
}
//设置FILE变量
function set_files($files){
$this->files = $files;
}
//设置目录变量
function set_directories($directories){
$this->directories = $directories;
}
//设置目录变量 set_include_subdir
function set_include_subdir($include_subdir){
$this->include_subdir = $include_subdir;
}
//设置ignore_lines变量
function set_ignore_lines($ignore_lines){
$this->ignore_lines = $ignore_lines;
}
//确定是哪一种搜索方式
function set_search_function($search_function){
switch($search_function){
case ‘normal’: $this->search_function = ’search’;
return TRUE;
break;
case ‘quick’ : $this->search_function = ‘quick_search’;
return TRUE;
break;
case ‘preg’ : $this->search_function = ‘preg_search’;
return TRUE;
break;
case ‘ereg’ : $this->search_function = ‘ereg_search’;
return TRUE;
break;
default : $this->last_error = ‘Invalid search function specified’;
return FALSE;
break;
}
}

//以下为搜索和替换程序de主文件
function search($filename){
$occurences = 0;
$file_array = file($filename);
for($i=0; $i<count($file_array); $i ){
$continue_flag = 0;
if(count($this->ignore_lines) > 0){
for($j=0; $j<count($this->ignore_lines); $j ){
if(substr($file_array[$i],0,strlen($this->ignore_lines[$j])) == $this->ignore_lines[$j]) $continue_flag = 1;
}
}
if($continue_flag == 1) continue;
$occurences = count(explode($this->find, $file_array[$i])) - 1;
$file_array[$i] = str_replace($this->find, $this->replace, $file_array[$i]);
}
if($occurences > 0) $return = array($occurences, implode(”, $file_array)); else $return = FALSE;
return $return;
}
//使用quick(快速)搜索方法时,没有igonre_lines功能
function quick_search($filename){
clearstatcache();
$file = fread($fp = fopen($filename, ‘r’), filesize($filename)); fclose($fp);
$occurences = count(explode($this->find, $file)) - 1;
$file = str_replace($this->find, $this->replace, $file);
if($occurences > 0) $return = array($occurences, $file); else $return = FALSE;
return $return;
}
//preg搜索方法不支持ignore_lines
function preg_search($filename){
clearstatcache();
$file = fread($fp = fopen($filename, ‘r’), filesize($filename)); fclose($fp);
$occurences = count($matches = preg_split($this->find, $file)) - 1;
$file = preg_replace($this->find, $this->replace, $file);
if($occurences > 0) $return = array($occurences, $file); else $return = FALSE;
return $return;
}
//ereg搜索方法也不支持ignore_lines
function ereg_search($filename){
clearstatcache();
$file = fread($fp = fopen($filename, ‘r’), filesize($filename)); fclose($fp);
$occurences = count($matches = split($this->find, $file)) -1;
$file = ereg_replace($this->find, $this->replace, $file);
if($occurences > 0) $return = array($occurences, $file); else $return = FALSE;
return $return;
}
//写新文件
function writeout($filename, $contents){
if($fp = @fopen($filename, ‘w’)){
fwrite($fp, $contents);
fclose($fp);
}else{
$this->last_error = ‘Could not open file: ‘.$filename;
}
}
//由do_search调用,排出所有要搜索de文件
function do_files($ser_func){
if(!is_array($this->files)) $this->files = explode(’,', $this->files);
for($i=0; $i<count($this->files); $i ){
if($this->files[$i] == ‘.’ OR $this->files[$i] == ‘..’) continue;
if(is_dir($this->files[$i]) == TRUE) continue;
$newfile = $this->$ser_func($this->files[$i]);
if(is_array($newfile) == TRUE){
$this->writeout($this->files[$i], $newfile[1]);
$this->occurences = $newfile[0];
}
}
}
//由do_search()调用,排出所有要搜索de目录
function do_directories($ser_func){
if(!is_array($this->directories)) $this->directories = explode(’,', $this->directories);
for($i=0; $i<count($this->directories); $i ){
$dh = opendir($this->directories[$i]);
while($file = readdir($dh)){
if($file == ‘.’ OR $file == ‘..’) continue;
if(is_dir($this->directories[$i].$file) == TRUE){
if($this->include_subdir == 1){
$this->directories[] = $this->directories[$i].$file.’/';
continue;
}else{
continue;
}
}
$newfile = $this->$ser_func($this->directories[$i].$file);
if(is_array($newfile) == TRUE){
$this->writeout($this->directories[$i].$file, $newfile[1]);
$this->occurences = $newfile[0];
}
}
}
}
//调用这个do_search()就可以开始对文件或目录进行搜索
function do_search(){
if($this->find != ”){
if((is_array($this->files) AND count($this->files) > 0) OR $this->files != ”) $this->do_files($this->search_function);
if($this->directories != ”) $this->do_directories($this->search_function);
}
}
} // End of class
?>
//下面是调用该类de例子说明,请存为example.php
<?php
include(’search_replace.inc’); //将文件包括进来
//建立新物件,设置搜索条件、最后返回搜索结果
$sr = new search_replace(’asp’, ‘php’, array(’test.txt’)); //调用搜索与替换
$sr->set_search_function(’quick’); //设置搜索条件
$sr->do_search();
$sr->set_find(’another’);
$sr->do_search();
//下面是定制de返回信息
header(’Content-Type: text/plain’);
echo ‘发现和替换以下几个地方: ‘.$sr->get_num_occurences()."\r\n";
echo ‘啊,错误发生如下………….: ‘.$sr->get_last_error()."\r\n";
?>
//将以下文字存为test.txt,注意text.txt必须是可读可写de
"我非常喜欢asp,它简单易学,功能强,听说asp已经占了大半市场,asp真好."
此时,如果您打开exampe.php 就会出现下面这些:
发现和替换以下几个地方:3
啊,错误发生如下……….:
查看test.txt文件,果然出现aspde地方被php替换了.

分页显示Oracle数据库记录的类之二

星期一, 06月 2nd, 2008

//——————————–
// 工作函数
//——————————–
//读取记录
//主要工作函数,根据所给de条件从表中读取相应de记录
//返回值是一个二维数组,Result[记录号][字段名]
function ReadList() {
$SQL=”SELECT * FROM “.$this->Table.” “.$this->Condition.” ORDER BY “.$this->Id.” DESC”;
$stmt = OCIParse($this->LinkId,$SQL);
$bool = OCIExecute($stmt);
if (!$bool) {
echo “连接失败!”;
OCILogoff($this->LinkId);
exit;
}
else {
$ncols = OCINumCols($stmt);
for ( $i = 1; $i <= $ncols; $i )
$column_name[$i] = OCIColumnName($stmt,$i);
$k=0;
for($j=0;$j<$this->StartRec $this->Offset;$j ) OCIFetch($stmt);
for($j=0;$j<$this->MaxLine;$j ){
if(OCIFetch($stmt)){
$k ;
for($i=1;$i<=$ncols;$i )
$temp[$column_name[$i]]=OCIResult($stmt,$i);
$this->Result[]=$temp;
}
else break;
}
$this->Number=$k;
}
OCIFreeStatement($stmt);
return $this->Result;
}
//读最新de记录
//topnum指定要读出de记录数
function ReadTopList($topnum){
$SQL=”SELECT * FROM “.$this->Table.” “.$this->Condition.” ORDER BY “.$this->Id.” DESC”;
$stmt = OCIParse($this->LinkId,$SQL);
$bool = OCIExecute($stmt);
if (!$bool) {
echo “连接失败!”;
OCILogoff($this->LinkId);
exit;
}
else {
$ncols = OCINumCols($stmt);
for ( $i = 1; $i <= $ncols; $i )
$column_name[$i] = OCIColumnName($stmt,$i);
$k=0;
for($j=0;$j<$topnum;$j ){
if(OCIFetch($stmt)){
$k ;
for($i=1;$i<=$ncols;$i )
$temp[$column_name[$i]]=OCIResult($stmt,$i);
$this->TopResult[]=$temp;
}
else break;
}
$this->TopNumber=$k;
}
OCIFreeStatement($stmt);
return $this->TopResult;

}
//—————————
// 分页相关
//—————————
//显示当前页及总页数
//本函数在GetPage()后调用.
function ThePage() {
echo “第”.$this->CPages.”页/共”.$this->TPages.”页”;
}
//显示翻页按钮
//此函数要在GetPage()函数之后调用
//显示下页、上页,并加上要传递de参数
function Page() {
$k=count($this->PageQuery);
$strQuery=”"; //生成一个要传递参数字串
for($i=0;$i<$k;$i ){
$strQuery.=”&”.$this->PageQuery[$i][key].”=”.$this->PageQuery[$i][value];
}
return $strQuery;
}
function PrePage($strQuery){
$prev=$this->Offset-$this->MaxLine;
if($prev>=0)
echo “<A href=$PHP_SELF?offset=”.$prev.$strQuery.” class=newslink>上一页</A>”;
else if($this->TheFirstPage!=NULL)
echo “<A href=”.$this->TheFirstPage.” class=newslink>上一页</A>”;
else echo “上一页”;
}
function NexPage($strQuery){
$next=$this->Offset $this->MaxLine;
$k=$this->Total-$this->StartRec;
if($next<$k)
echo “<A href=$PHP_SELF?offset=”.$next.$strQuery.” class=newslink>下一页</A>”;
else
echo “下一页”;
}
//————————————
// 记录分组
//———————————-
//显示分组
function NumPage() {
$first=($this->CGroup-1)*($this->PGroup) 1;
$last=($first $this->PGroup > $this->TPages)? ($this->TPages 1):($first $this->PGroup);
$pr=($this->CGroup-2>=0)?( ($this->CGroup-2)*($this->PGroup) 1 ):(-1);
$prev=($pr!=-1)?( ($pr-1)*$this->MaxLine):(0);
$ne=($this->CGroup*$this->PGroup 1<=$this->TPages)?($this->CGroup*$this->PGroup 1):(-1);
$next=($ne!=-1)?( ($ne-1)*$this->MaxLine):(0);
$k=count($this->PageQuery);
$strQuery=”"; //生成一个要传递参数字串
for($i=0;$i<$k;$i ){
$strQuery.=”&”.$this->PageQuery[$i][key].”=”.$this->PageQuery[$i][value];
}
if($first!=1)
echo “<A href=$PHP_SELF?offset=”.$prev.$strQuery.” > << </a>”;
for($i=$first;$i<$last;$i ) {
if($this->CPages!=$i){
$current=($i-1)*$this->MaxLine;
echo “<A href=$PHP_SELF?offset=”.$current.$strQuery.” >”.$i.”</a> “;
}
else echo “<font color=#e00729>”.$i.”</font> “;
}
if($ne!=-1)
echo “<A href=$PHP_SELF?offset=”.$next.$strQuery.” > >> </a>”;
}
//******end class
}
?>

分页显示Oracle数据库记录的类之一

星期一, 06月 2nd, 2008

<?php
/*********************************************
TOracleViewPagev 2.0
日期:2000-9-23
分页显示Oracle数据库记录de类

更新日期:2000-10-19
增加显示TopRecordde功能,允许第一页显示de记录数与其它页不同.
作者:sharetop
email:ycshowtop@21cn.com
***********************************************/
class TOracleViewPage {
var $Table; //表名
var $MaxLine; //每页显示行数
var $LinkId; //数据库连接号
var $Id; //排序参考字段
var $Offset; //记录偏移量
var $Total; //记录总数
var $Number; //本页读取de记录数
var $TopNumber;//读新记录时实际取出de记录数
var $Result; //读出de结果
var $TopResult;//读新记录时de结果
var $TheFirstPage;//特殊指定第一页de链接
var $StartRec; //指定第二页de起始记录号
var $TPages; //总页数
var $CPages; //当前页数
var $TGroup;
var $PGroup; //每页显示de页号个数
var $CGroup;
var $Condition; //显示条件 如:where id=’$id’ order by id desc
var $PageQuery; //分页显示要传递de参数
//————————————-
// 以下构造函数、析构函数及初始化函数
//————————————-
//构造函数
//参数:表名、最大行数、分页参考de字段、每页显示de页号数
function TOracleViewPage($TB,$ML,$id){
global $offset;
$this->Table=$TB;
$this->MaxLine=$ML;
$this->Id=$id;
$this->StartRec=0;
if(isset($offset)) $this->Offset=$offset;
else $this->Offset=0;
$this->Condition=”";
$this->TheFirstPage=NULL;
$this->PageQury=NULL;
}
//初始化
//参数:用户名、密码、数据库
function InitDB($user,$password,$db){
if (PHP_OS == “WINNT”) $dllid=dl(”php3_oci80.dll”);
$this->LinkId = OCILogon($user,$password,$db);
}
//断开
function Destroy(){
OCILogoff($this->LinkId);
}
//————————-
// Set 函数
//————————-
//设置显示条件
//如:where id=’$id’ order by id desc
//要求是字串,符合SQL语法(本字串将加在SQL语句后)
function SetCondition($s){
$this->Condition=$s;
}
//设置每组de显示个数
function SetNumGroup($pg){
$this->PGroup=$pg;
}
//设置首页,如无则为NULL
function SetFirstPage($fn){
$this->TheFirstPage=$fn;
}
//设置起始记录,如无则取默认0
function SetStartRecord($org){
$this->StartRec=$org;
}
//设置传递参数
// key参数名 value参数值
// 如:setpagequery(”id”,$id);如有多个参数要传递,可多次调用本函数.
function SetPageQuery($key,$value){
$tmp[key]=$key; $tmp[value]=$value;
$this->PageQuery[]=$tmp;
}
//——————————–
// Get 函数
//——————————–
//取记录总数
function GetTotalRec(){
$SQL=”SELECT Count(*) AS total FROM “.$this->Table.” “.$this->Condition;
$stmt = OCIParse($this->LinkId,$SQL);
$bool = OCIExecute($stmt);
if (!$bool) {
echo “连接失败!”;
OCILogoff($this->LinkId);
exit;
}
else {
OCIFetch($stmt);
$this->Total=OCIResult($stmt,1);
}
OCIFreeStatement($stmt);
}
//取总页数、当前页
function GetPage(){
$this->TPages=ceil($this->Total/$this->MaxLine);
$this->CPages=ceil($this->Offset/$this->MaxLine) 1;
}
//取总组数、当前组
function GetGroup() {
$this->TGroup=ceil($this->TPages/$this->PGroup);
$this->CGroup=ceil($this->CPages/$this->PGroup);
}