给你们一个好东东帝国cms - 安全、强大、稳定、灵活

帝国备份王2008版发布	帝国CMS模板下载中心	测试：生成20万数据共用107分钟	《帝国下载系统》全面免费
帝国域名交易网	1G双线帝国空间+200M数据库=158	站长工具 - dotool.cn	广告联系QQ：627174919

skyarea
用户头衔：书生

精华贴   ：1
发贴数   ：7
经验值   ：30
注册时间：2003-09-15

信息

搜索

好友

发送悄悄话

【《帝国网站管理系统》基础教程下载】 [第 1 楼]

给你们一个好东东

连接和操作SQL SERVER和DBASE的集合类，功能全面，仅供参考~~~
BaseDB.php
<?php
/*
* Session Management for PHP4.1
*
* (C) Copyright 2001 Cameron Taggart (cameront@wolfenet.com)
*
* $Id: db_mssql.inc,v 1.3 2001/05/17 01:19:37 chrisj Exp $
* MS SQL Server database巨膀摸,盢mssql.dll┮矗ㄑぇㄧ计莱矪瞶
*ク�: connect,close database
* 簿笆癘魁皐,莉莱database 计沮
* *硈钡databaseよΑ:mssql.dll笆篈畐钡硈钡
*/
# echo " This is using the MSSQL class ";

//Error 矪瞶摸 //1:ゼConnect;2:ぃRes挡狦栋
class Error {
 var $Errno=0;
 var $Error='failed';
 var $Msg='function failed';
 var $ErrFile='BaseDB.php';
 var $ErrClass='BaseDB';
}

//Database膀摸
class BaseDB {
 var $Con=0;
 var $Res=false;
 var $RecordCount=-1; // 计沮癘魁羆计
 var $RecordNum=-1; //皐┮讽玡癘魁计
 var $EOF=true; //耞皐琌癘魁程ゼ
 var $BOF=true; //耞皐琌癘魁程玡狠
 var $Errno = '';
 var $Error = "";
 var $parent;
 var $Auto_Free = 0; ## set this to 1 to automatically free results
 var $Err=null;
 var $dbtype = "MSSQL";

 /* public: constructor */
 function getversion(){
return "1.1";
 }
 function BaseDB($type="mssql"){
 $this->dbtype = strtoupper($type);
 }

 function Set_dbtype($type){
 $this->dbtype=strtoupper($type);
 }

 function Get_dbtype(){
 return $this->dbtype;
 }
 //硈钡Database ,ServerName:databaseぇhost; DatabaseName:计沮畐; UserID:ノめ; Password:ノめ盞絏
 function Connect($ServerName,$DatabaseName,$UserID,$Password) {
 switch ($this->dbtype){
 case "MSSQL":
 if ( 0 == $this->Con ) {
 $this->Con=@mssql_connect($ServerName,$UserID,$Password);
 if (!$this->Con){
 $this->SetErr('BaseDB.php','BaseDB','ゴ秨计沮畐ア毖',$php_errormsg);
 return false;
 }
 else
 if(!@mssql_select_db($DatabaseName, $this->Con)){
 $this->SetErr('BaseDB.php','BaseDB','计沮畐DatabaseName岿粇',$php_errormsg);
 return false;
 }else
 return true;
 }
 break;
 case "MYSQL":
 if ( 0 == $this->Con ) {
 $this->Con=@mysql_connect($ServerName,$UserID,$Password);
 if (!$this->Con){
 if(strlen($emsg = @mysql_error()) == 0 && isset($php_errormsg))
 $emsg = $php_errormsg;
 $this->SetErr('BaseDB.php','BaseDB','ゴ秨计沮畐ア毖',$emsg);
 //echo "connect faled".$php_errormsg;
 return false;
 }
 else
 if(!@mysql_select_db($DatabaseName, $this->Con)){
 $this->SetErr('BaseDB.php','BaseDB','匡拒Database岿',@mysql_error());
 return false;
 }else
 return true;
 }
 break;
 case "PGSQL":
 case "POSTGRESQL":
 if ( 0 == $this->Con ) {
 $this->Con=@pg_pconnect("host=$ServerName user=$UserID password=$Password port=5432 dbname=$DatabaseName");
 //$this->Con=@odbc_pconnect('noa','noa','noa');
 if (!$this->Con){
 if(isset($php_errormsg))
 $emsg = $php_errormsg;
 if(strlen($msg = @pg_last_error()) > 0 )
 $emsg = $msg;
 $this->SetErr('BaseDB.php','BaseDB','ゴ秨计沮畐ア毖',$emsg);
 return false;
 }else
 return true;
 }
 break;
 case "ODBC":
 if ( 0 == $this->Con ) {
 $this->Con=@odbc_connect($DatabaseName,$UserID,$Password);
 //$this->Con=@odbc_pconnect('noa','noa','noa');
 if (!$this->Con){
 if(isset($php_errormsg))
 $emsg = $php_errormsg;
 if(strlen($msg = @odbc_error()) >0 )
 $emsg = $emsg."(".$msg.")";
 $this->SetErr('BaseDB.php','BaseDB','ゴ秨计沮畐ア毖',$emsg);
 return false;
 }else{
 return true;
 }
 }
 break;
 default :
 $this->SetErr('BaseDB.php','BaseDB','Mysql,MSsql,pgsql,ODBC',"计沮畐摸块岿粇,瞷やDB摸:MySQL,MSSQL,PgSQL/PostgreSQL,ODBC");
 return false;
 }
 }
 function Close(){ //闽超硈钡,睦Memory
 switch ($this->dbtype){
 case "MSSQL":
 if($this->Res){
 @mssql_free_result($this->Res) ;
 $this->Res=0;
 }
 if($this->Con){
 @mssql_close($this->Con);
 $this->Con=0;
 }
 break;
 case "MYSQL":
 if($this->Con){
 @mysql_close($this->Con);
 $this->Con=0;
 }
 break;
 case "PGSQL":
 case "POSTGRESQL":
 if($this->Con){
 @pg_close($this->Con);
 }
 break;
 case "ODBC":
 if($this->Con){
 @odbc_close($this->Con);
 }
 break;
 }
 }

 function BeginTrans($str=""){
 switch ($this->dbtype){
 case "MSSQL":
 if($this->exec("begin transaction"))
 return true;
 else
 return false;
 break;
 case "PGSQL":
 case "POSTGRESQL":
 if ($this->exec("begin"))
 return true;
 else
 return false;
 break;
 case "ODBC":
 @odbc_autocommit($this->Con, false);
 break;
 default:
 if(strlen($str) > 0){
 if($this->exec($str))
 return true;
 else
 return false;
 }
 return false;
 }
 }

 function CommitTrans($str=""){
 switch ($this->dbtype){
 case "MSSQL":
 if($this->exec("commit transaction"))
 return true;
 else
 return false;
 break;
 case "PGSQL":
 case "POSTGRESQL":
 if ($this->exec("COMMIT"))
 return true;
 else
 return false;
 break;
 case "ODBC":
 return (@odbc_commit($this->Con));
 default:
 if(strlen($str) > 0){
 if($this->exec($str))
 return true;
 else
 return false;
 }
 return false;
 }
 }

 function Rollback($str=""){
 switch ($this->dbtype){
 case "MSSQL":
 if($this->exec("rollback transaction"))
 return true;
 else
 return false;
 break;
 case "PGSQL":
 case "POSTGRESQL":
 if ($this->exec("ROLLBACK"))
 return true;
 else
 return false;
 break;
 case "ODBC":
 return (@odbc_rollback($this->Con));
 default:
 if(strlen($str) > 0){
 if($this->exec($str))
 return true;
 else
 return false;
 }
 return false;
 }
}

 //磅︽SQL粂,盢挡狦栋结ベRes ;SQL粂Ч俱ぇSQL粂
 function Open($strSQL){
if($this->Con==0){
 $this->SetErr('BaseDB.php','BaseDB','磅︽SQL粂',$this->dbtype." Server ゼミ硈钡");
 return '-1';
}
else{
 if(strlen($strSQL)==0){
 $this->SetErr('BaseDB.php','BaseDB','磅︽SQL粂ア毖','SQL粂ぃ');
 return '-1';
 }
 else{
 switch ($this->dbtype){
 case "MSSQL":
 $this->Res=@mssql_query($strSQL,$this->Con);
 break;
 case "MYSQL":
 $this->Res=@mysql_query($strSQL,$this->Con);
 break;
 case "PGSQL":
 case "POSTGRRESQL":
 $this->Res=@pg_query($this->Con,$strSQL);
 break;
 case "ODBC":
 $this->Res=@odbc_do($this->Con,$strSQL);
 break;
 default:
 return -1;
 }
 //echo '0'.$this->Res;
 if(!$this->Res){
 switch ($this->dbtype){
 case "MSSQL":
 $emsg = $php_errormsg;
 break;
 case "MYSQL":
 $emsg = @mysql_error();
 break;
 case "PGSQL":
 case "POSTGRESQL":
 $emsg = @pg_errormessage();
 break;
 case "ODBC":
 $emsg = @odbc_errormsg();
 break;
 default:
 $emsg = "";
 break;
 $this->SetErr('BaseDB.php','BaseDB','磅︽SQL粂ア毖',$emsg);
 //echo '1'.$this->Res;
 return '-1';
 }
 }
 else{
 switch ($this->dbtype){
 case "MSSQL":
 $this->RecordCount = @mssql_num_rows($this->Res);
 break;
 case "MYSQL":
 $this->RecordCount = @mysql_num_rows($this->Res);
 break;
 case "PGSQL":
 case "POSTGRESQL":
 $this->RecordCount = @pg_num_rows($this->Res);
 break;
 case "ODBC":
 $this->RecordCount = @odbc_num_rows($this->Res);
 break;
 default:
 return -1;
 }
 //echo 'sfsfs='.$this->RecordCount ;
 if($this->RecordCount>0){
 $this->EOF=false;
 $this->RecordNum=0;
 //
 return '1';
 }else{
 $this->EOF=true;
 $this->RecordCount=0;
 $this->SetErr('BaseDB.php','BaseDB','','琩高礚癘魁');
 // echo '2'.$this->Res;
 return '0';
 }

 }
 }
}
}

//磅︽SQL粂,礚挡狦栋.
 function Exec($strSQL){
if($this->Con!=0){
 //echo $strSQL;
 switch ($this->dbtype){
 case "MSSQL":
 if(!($res=@mssql_query($strSQL,$this->Con)))
 $emsg = $php_errormsg;
 break;
 case "MYSQL":
 if(!($res = @mysql_query($strSQL,$this->Con)))
 $emsg = @mysql_error();
 break;
 case "PGSQL":
 case "POSTGRESQL":
 if(!($res = @pg_query($this->Con,$strSQL)))
 $emsg = @pg_errormessage();
 break;
 case "ODBC":
 if(!($res = @odbc_do($this->Con,$strSQL)))
 $emsg = @odbc_errormsg();
 break;
 default:
 $emsg = "礚猭醚计沮畐摸";
 $res = false;
 }
 if(!$res){
 $this->SetErr('BaseDB.php','BaseDB','磅︽SQL粂ア毖',$emsg);
 return false;
 //$this->halt('Execute failed');
 }
 //$this->RecordCount=@mssql_num_rows($this->Res);
 return true;
}
else{
 $this->SetErr('BaseDB.php','BaseDB','磅︽SQL粂ア毖',$this->dbtype.' Server ゼミ硈钡');
 return false;
}
 }

//盢讽玡癘魁计舱い,计舱ま莱逆︗Θザ铅^计舱
function GetRow(){
if(!$this->Res){
 $this->SetErr('BaseDB.php','BaseDB','Get row failed','QUERY挡狦栋');
 return -1;
}
if(!$this->EOF){
 $resu = array();
 switch ($this->dbtype){
 case "MSSQL":

 $count = @mssql_num_fields($this->Res);
 break;
 case "MYSQL":
 $count = @mysql_num_fields($this->Res);
 break;
 case "PGSQL":
 case "POSTGRESQL":
 $r = @pg_fetch_row($this->Res, 0);
 $count = count($r);
 break;
 case "ODBC":
 $count = @odbc_num_fields($this->Res);
 break ;
 default:
 $this->SetErr('BaseDB.php','BaseDB','Get row failed','Database摸ぃ癸');
 return -1;
 }
 if($count==0){
 $this->SetErr('BaseDB.php','BaseDB','Get row failed','礚挡狦栋');
 return '-1';
 }
 for($i=0;$i<$count;$i++)
 {
 switch ($this->dbtype){
 case "MSSQL":
 $resu[strtoupper(@mssql_field_name($this->Res,$i))] = mssql_result($this->Res,$this->RecordNum,mssql_field_name($this->Res,$i));
 break;
 case "MYSQL":
 $resu[strtoupper(@mysql_field_name($this->Res,$i))] = mysql_result($this->Res,$this->RecordNum,mysql_field_name($this->Res,$i));
 break;
 case "PGSQL":
 case "POSTGRESQL":
 $Record = @pg_fetch_row($this->Res, $this->RecordNum);
 $resu[strtoupper(@pg_field_name($this->Res,$i))] = $Record[$i];
 break;
 case "ODBC":
 $Record=array();
 $r=$this->RecordNum+1;
 if(phpversion() >= '4.2.0')
 $stat = @odbc_fetch_into($this->Res, $Record, $r);
 else
 $stat = @odbc_fetch_into($this->Res, $r, $Record);
 if(is_array($r))
 $Record=$r;
 $resu[strtoupper(@odbc_field_name($this->Res,($i+1)))] = $Record[$i];
 break;
 }// echo mssql_field_name($this->Res,$i)." " ;
 }
 return $resu;
}
else{
 $this->SetErr('BaseDB.php','BaseDB','Get row failed','挡狦栋┪礚挡狦栋');
 return '-1';
}

}

 function GetCount(){ //眔癘魁计沮
return $this->RecordCount;
 }

 function affected_rows() { //眔磅︽SQL粂┮ま紇臫ぇ癘魁兵计
// Not a supported function in PHP3/4. Chris Johnson, 16May2001.
// return mssql_affected_rows($this->Query_ID);
switch ($this->dbtype){
 case "MSSQL":
 $rsRows = @mssql_query("Select @@rowcount as rows", $this->Con);
 if ($rsRows) {
 return @mssql_result($rsRows, 0, "rows");
 }
 else{
 $this->SetErr('BaseDB.php','BaseDB','Get affected row failed',$php_errormsg);
 return false;
 }
 break;
 case "MYSQL":
 return mysql_affected_rows();
 case "PGSQL":
 case "POSTGRESQL":
 return pg_affected_rows();
 case "ODBC":
 $num_rows = @odbc_num_rows($this->Res);
 if ($num_rows < 0) {
 $i=10;
 while (@odbc_fetch_row($this->Res, $i))
 $i*=10;

 $j=0;
 while ($i!=$j) {
 $k= $j+intval(($i-$j)/2);
 if (@odbc_fetch_row($this->Res, $k))
 $j=$k;
 else
 $i=$k;
 if (($i-$j)==1) {
 if (@odbc_fetch_row($this->Res, $i))
 $j=$i;
 else
 $i=$j;
 };
 };
 $num_rows=$i;
 }
 return $num_rows;
 default:
 return 0;
}
 }

 function GetField($FieldName){ //眔赣逆︗计沮,ぃ某ㄏノ
if(!$this->Res){
 $this->SetErr('BaseDB.php','BaseDB','Get Field failed','挡狦栋');
 return false;
}
else{
 if($this->EOF) {
 $this->SetErr('BaseDB.php','BaseDB','Get Field failed','挡狦栋');
 return false;
 }
 else{
 $row=$this->GetRow();
 if(is_array($row)){
 //echo $FieldName;
 $Fiel=$row[strtoupper($FieldName)] ;
 return $Fiel;
 }else{
 if($row==-1)
 $this->SetErr('BaseDB.php','BaseDB','Get Field failed',$php_errormsg);
 else
 $this->SetErr('BaseDB.php','BaseDB','Get Field failed','琩礚块戈');
 return false;
 }
 if(!$Fiel && $Fiel!=null){
 $this->SetErr('BaseDB.php','BaseDB','Get Field failed',$php_errormsg);
 return false;
 }else
 return $Fiel;
 }
}
 }

 function MoveNext(){ //皐簿
 if(!$this->Res){
 $this->SetErr('BaseDB.php','BaseDB','Get Field failed','挡狦栋');
 return false;
 }
 if($this->RecordNum>=$this->RecordCount){
 $this->SetErr('BaseDB.php','BaseDB','Move Next failed','皐程癘魁');
 return false;
 }
 $this->RecordNum=$this->RecordNum+1;
 //mssql_data_seek($this->Res,$this->RecordNum);
 if($this->RecordNum>=$this->RecordCount)
 $this->EOF=true;
 return true;
 }

 function MoveFirst(){ //皐簿程玡
 if(!$this->Res){
 $this->SetErr('BaseDB.php','BaseDB','Move First failed','挡狦栋');
 return false;
 }
 $this->RecordNum=0;
 //mssql_data_seek($this->Res,$this->RecordNum);
 if($this->RecordCount>0){
 $this->EOF=false;
 //$this->BOF=true;
 }
 return true;
 }

 function MoveLast(){ //皐簿程
 if(!$this->Res){
 $this->SetErr('BaseDB.php','BaseDB','Move First failed','挡狦栋');
 return false;
 }
 $this->RecordNum=$this->RecordCount;
 $this->BOF=false;
 $this->EOF=true;
 return true;
 }
 //皐玡簿
 function MovePrevious(){
if($this->RecordNum==0){
 $this->SetErr('BaseDB.php','BaseDB','Move Previous failed','皐材兵癘魁');
 return false;
}
$this->RecordNum=$this->RecordNum-1;
 if($this->RecordNum==0)
 $this->BOF=true;
 if($this->RecordCount>0)
 $this->EOF=false;
 return true ;
 }

 function Move($x){ //皐簿﹚︗竚
// echo $this->RecordCount;
 if(!$this->Res){
 $this->SetErr('BaseDB.php','BaseDB','Move First failed','挡狦栋');
 return false;
 }
 if($this->RecordCount<=$x){
 $this->SetErr('BaseDB.php','BaseDB','Move failed','璶簿笆ぇ癘魁计癘魁羆计');
 return false;
 }
 else
 $this->RecordNum=$x;
 return true;
 }

 function EOF(){ //耞皐琌挡狦栋程
 if($this->EOF)
 return true;
 else
 return false;
 }

 function BOF(){ //耞皐琌挡狦栋程玡狠
 if($this->BOF)
 return true;
 else
 return false;
 }
 /*************************************************************************************

 ************************************************************************************ */

function metadata($table) {
$count = 0;
$id = 0;
$res = array();
$id = mssql_query("select * from ".$table, $this->Con);
if (!$id) {
 $this->Errno = 1;
 $this->Error = "General Error (The MSSQL interface cannot return detailed error messages).";
 // $this->halt("Metadata query failed.");
 }
$count = mssql_num_fields($id);
for ($i=0; $i<$count; $i++) {
 $res[$i]["name"]= @mssql_field_name($id,$i);
}
return $res;
 }

 function SetErr($ErrFile,$ErrClass,$Msg,$Error){ //砞竚岿獺
 $obj=$this->Err ;
 if(!is_object($obj))
 $this->Err=new Error;
 $this->Err->ErrFile=$ErrFile;
 $this->Err->ErrClass=$ErrClass;
 $this->Err->Msg=$Msg;
 $this->Err->Error=$Error;
 return;
 }

 function GetErr(){ //眔岿獺摸
 $obj=$this->Err ;
 if(is_object($obj))
 return $this->Err;
 else
 return false;
 }

 function Geterror(){
 $obj=$this->Err;
 if(is_object($obj))
 return $this->Err->Error;
 else
 return "";
 }

}
?>

basecollect.php
<?
//*****************************************************************
//
//膀摸,膥┯Babased
//栋摸
//ク�:承の眔栋摸莱砰摸,穝糤,э,埃莱砰摸癘魁
//
//*****************************************************************

require_once 'BaseDB.php';

class basecollect extends BaseDB {

 var $fer="##@@##";
 function CreateObj($a){ //承砰摸 摸ㄏノ,荡祘Αㄏノ
 $obj=new $a;
 $obj->parent=$this;
 $obj->Set_tb_name($a);
 return $obj;
 }

 function GetObj($a){ //眔讽玡癘魁ぇ砰摸 摸ㄏノ,荡祘Αㄏノ
 $ar=$this->GetRow();
 if($ar=='0')
 return '0';
 if($ar=='-1')
 return '-1';
 else{
 $obj=$this->CreateObj($a);
 /*for(reset($ar);$key=key($ar);next($ar))
 {
 if(is_string($ar[$key]))
 $ar[$key]=stripcslashes($ar[$key]);
 } */
 $obj->properties=$ar;
 $obj->Setkey();
 return $obj;
 }
 }

 function AddSQL($ar,$table){ // 摸ㄏノ,荡祘Αㄏノ
 $sql="insert into ".$table." ";
 $sql1="(";
 $sql2=") values(";
 $arr=$ar;
 //echo 'fffffffffffffffffffffff' ;
 for(reset($arr);$key=key($arr);next($arr))
 {
 $sql1=$sql1.$key.",";
 if(is_string($arr[$key]))
 {
 if(strcmp($arr[$key],$this->fer)==0){
 //echo $arr[$key].'==='.$key;
 $this->SetErr('basecollect.php','basecollect','郎ア毖',$key.'逆︗计沮Αぃタ絋');
 //echo $this->geterror();
 return false;
 }
 $value=($arr[$key]);
 $value=str_replace("'","''",$value);
 $value=$this->ChgTitle($value);
 $sql2=$sql2."'".$value."',";
 }else
 {
 if(strcmp($arr[$key],$this->fer)==0){
 $this->SetErr('basecollect.php','basecollect','郎ア毖',$key.'逆︗计沮Αぃタ絋');
 return false;
 }
 $sql2=$sql2.$arr[$key].",";
 }
 }
 $sql1=substr($sql1,0,strlen($sql1)-1); // 奔程硆腹
 $sql2=substr($sql2,0,strlen($sql2)-1); // 奔程硆腹
 $sql2=$sql2.")";
 $sql=$sql.$sql1.$sql2;
 //echo $sql;
 if(!$this->Exec($sql)){
 $this->SetErr('basecollect.php','basecollect','',$key.'SQL粂岿!');
 return false;
 }else
 return true;

 }

 function ModifySQL($ar,$k,$table){ // 摸ㄏノ,荡祘Αㄏノ
 $sql="update ".$table." set ";
 $arr=$ar;
 for(reset($arr);$key=key($arr);next($arr))
 {
 // for(reset($k);$key1=key($k);next($k))
 // {
 // if(!strcmp($key,$key1)==0){
 if(is_string($arr[$key]))
 {
 if(strcmp($arr[$key],$this->fer)==0){
 $this->SetErr('basecollect.php','basecollect','郎ア毖',$key.'逆︗计沮Αぃタ絋');
 return false;
 }
 $value=($arr[$key]);
 $value=str_replace("'","''",$value);
 $value=$this->ChgTitle($value);
 $sql=$sql.$key."='".$value."', ";
 }else
 {
 if(strcmp($arr[$key],$this->fer)==0){
 $this->SetErr('basecollect.php','basecollect','郎ア毖',$key.'逆︗计沮Αぃタ絋');
 return false;
 }
 $sql=$sql.$key."=".$arr[$key].", ";
 }
 // }
 // }
 }
 $sql=substr($sql,0,strlen($sql)-2);
 $sql=$sql." where ";
 if(count($k)==0){
 $this->SetErr('basecollect.php','basecollect','郎ア毖','礚闽龄逆︗');
 return false;
 }
 for(reset($k);$key=key($k);next($k))
 {

 if(is_string($k[$key]))
 {
 if(strcmp($k[$key],$this->fer)==0){
 $this->SetErr('basecollect.php','basecollect','郎ア毖',$key.'逆︗计沮Αぃタ絋');
 return false;
 }
 //$value=stripslashes($k[$key]);
 //$value=str_replace("'","''",$value);
 $sql=$sql.$key."='".$k[$key]."' and ";

 }else
 {
 if(strcmp($k[$key],$this->fer)==0){
 $this->SetErr('basecollect.php','basecollect','郎ア毖',$key.'逆︗计沮Αぃタ絋');
 return false;
 }
 $sql=$sql.$key."=".$k[$key]." and ";
 }
 }
 //echo $sql;
 $sql=substr($sql,0,strlen($sql)-4);
 //echo ' Modify=='.$sql;
 // echo $sql;
 if(!$this->Exec($sql)){
 $this->SetErr('basecollect.php','basecollect','',$key.'SQL粂岿!');
 return false;
 }else
 return true;
 }

 function DeleteSQL($k,$table){ // 摸ㄏノ,荡祘Αㄏノ
 $sql="delete ".$table." where ";
 $arr=array();
 $arr=$k;
 for(reset($arr);$key=key($arr);next($arr))
 {
 if(strcmp($arr[$key],$this->fer)==0){
 //$this->Err->Error=$key."逆︗计沮Αぃタ絋";
 $this->SetErr('basecollect.php','basecollect','郎ア毖',$key.'逆︗计沮Αぃタ絋');
 return false;
 }
 if(is_string($arr[$key]))
 {
 $sql=$sql.$key."='".$arr[$key]."' and ";
 }else
 {
 $sql=$sql.$key."=".$arr[$key]." and ";
 }
 }
 $sql=substr($sql,0,strlen($sql)-4);
 // $this->Exec($sql);

 if(!$this->Exec($sql)){
 $this->SetErr('basecollect.php','basecollect','',$key.'SQL粂岿!');
 return false;
 }else
 return true;
 }

 function ChgTitle($title)
 {
 $length=mb_strlen($title) ;
 $b=mb_substr($title,($length-1),1);
 if(ord($b)>128 && strlen($b)==1)
 $title=mb_substr($title,0,($length-1)) ;
 return $title;
 }

}

?>

2003-09-15 01:27:42

已设置保密

顶部

引用

报告

编辑

删除

skyarea
用户头衔：书生

精华贴   ：1
发贴数   ：7
经验值   ：30
注册时间：2003-09-15

信息

搜索

好友

发送悄悄话

【《帝国网站管理系统》零基础实例入门教程】 [第 2 楼]

还有..............

basedb_dbase.php
<?php
/*
*Database for foxpro or Xbase
*ク�: connect,close database
* 簿笆癘魁皐,莉莱database 计沮
* *硈钡databaseよΑ:mssql.dll笆篈畐钡硈钡
*/
# echo " This is using the MSSQL class ";

//dError 矪瞶摸 //1:ゼConnect;2:ぃRes挡狦栋
require_once "basesingle.php";

class dError {
 var $Errno=0;
 var $Error='failed';
 var $Msg='funciotn failed';
 var $ErrFile='BaseDB.php';
 var $ErrClass='BaseDB';
}

//Database膀摸
class Basedb_dbase {
 var $Con=0;
 var $Res=false;
 var $RecordCount=-1; // 计沮癘魁羆计
 var $RecordNum=-1; //皐┮讽玡癘魁计
 var $EOF=true; //耞皐琌癘魁程ゼ
 var $BOF=true; //耞皐琌癘魁程玡狠
 var $Errno = '';
 var $Error = "";
 var $parent;
 var $Auto_Free = 0; ## set this to 1 to automatically free results
 var $Err=null;

 /* public: constructor */
 //硈钡Database ,ServerName:databaseぇhost; DatabaseName:计沮畐; UserID:ノめ; Password:ノめ盞絏
 function Connect($dbname) {
 $this->Con=@dbase_open($dbname,0);
if (!$this->Con ) {
 $this->SetErr('BaseDB.php','BaseDB','ゴ秨戈畐ア毖',$php_errormsg);
 return false;
}else{
 $this->RecordCount=dbase_numrecords($this->Con);
 $chk=dbase_numfields($this->Con);
 if ($chk==17){
 return true;
 }
 else{
 $this->SetErr('BaseDB.php','BaseDB','戈ず甧浪琩ア毖',$chk);
 return false;
 }
}
 }
 function Close(){ //闽超硈钡,睦Memory
if($this->Con){
 @dbase_close($this->Con);
 $this->Con=0;
}
 }

//盢讽玡癘魁计舱い,计舱ま莱逆︗Θザ铅^计舱
function GetRow(){
if(!$this->Con){
 $this->SetErr('BaseDB.php','BaseDB','Get Row Failed','ゼ硈钡莱戈畐┪硈钡戈畐ア毖');
 return false;
}
$ar=@dbase_get_record_with_names($this->Con,$this->RecordNum);
if(!is_array($ar)){
 return false;
 $this->SetErr('BaseDB.php','BaseDB','ゴ秨戈畐ア毖',$php_errormsg);
}

return $ar;
}

 function GetCount(){ //眔癘魁计沮
 return $this->RecordCount;
 }

 function GetField($FieldName){ //眔赣逆︗计沮,ぃ某ㄏノ
 $ar=$this->GetRow();
 if(array($ar)){
 $value=$ar[strtoupper($FieldName)];
 return $value;
 }else{
 return null;
 }
 }

 function MoveNext(){ //皐簿
 if($this->RecordNum>$this->RecordCount){
 $this->SetErr('BaseDB.php','BaseDB','Move Next failed','皐程癘魁');
 $this->RecordNum=$this->RecordCount ;
 return false;
 }
 $this->RecordNum=$this->RecordNum+1;
 //mssql_data_seek($this->Res,$this->RecordNum);
 if($this->RecordNum>=$this->RecordCount){
 $this->EOF=true;
 $this->RecordNum=$this->RecordCount ;
 }
 return true;
 }

 function MoveFirst(){ //皐簿程玡
 $this->RecordNum=1;
 //mssql_data_seek($this->Res,$this->RecordNum);
 if($this->RecordCount>0){
 $this->EOF=false;
 }
 return true;
 }

 function MoveLast(){ //皐簿程
 $this->RecordNum=$this->RecordCount;
 $this->BOF=false;
 $this->EOF=true;
 return true;
 }
 //皐玡簿
 function MovePrevious(){
if($this->RecordNum<=1){
 $this->SetErr('BaseDB.php','BaseDB','Move Previous failed','皐材兵癘魁');
 return false;
}
$this->RecordNum=$this->RecordNum-1;
 if($this->RecordNum==1)
 $this->BOF=true;
 if($this->RecordCount>0)
 $this->EOF=false;
 return true ;
 }

 function Move($x){ //皐簿﹚︗竚
// echo $this->RecordCount;
 if(!$this->Res){
 $this->SetErr('BaseDB.php','BaseDB','Move First failed','挡狦栋');
 return false;
 }
 if($this->RecordCount<$x){
 $this->SetErr('BaseDB.php','BaseDB','Move failed','璶簿笆ぇ癘魁计癘魁羆计');
 $this->RecordNum=$this->RecordCount;
 return false;
 }
 else
 $this->RecordNum=$x+1;
 return true;
 }

 function EOF(){ //耞皐琌挡狦栋程
 if($this->EOF)
 return true;
 else
 return false;
 }

 function BOF(){ //耞皐琌挡狦栋程玡狠
 if($this->BOF)
 return true;
 else
 return false;
 }
 /*************************************************************************************

 ************************************************************************************ */
 function SetErr($ErrFile,$ErrClass,$Msg,$Error){ //砞竚岿獺
 $obj=$this->Err ;
 if(!is_object($obj))
 $this->Err=new dError;
 $this->Err->ErrFile=$ErrFile;
 $this->Err->ErrClass=$ErrClass;
 $this->Err->Msg=$Msg;
 $this->Err->Error=$Error;
 return;
 }

 function GetErr(){ //眔岿獺摸
 $obj=$this->Err ;
 if(is_object($obj))
 return $this->Err;
 else
 return false;
 }

 function Geterror(){
 $obj=$this->Err;
 if(is_object($obj))
 return $this->Err->Error;
 else
 return "";
 }
}

class dbase extends Basedb_dbase{
 var $fer="##@@##";
 function CreateObj($a){ //承砰摸 摸ㄏノ,荡祘Αㄏノ
 $obj=new $a;
 $obj->parent=$this;
 $obj->Set_tb_name('connect');
 return $obj;
 }

 function GetItem(){ //眔讽玡癘魁ぇ砰摸 摸ㄏノ,荡祘Αㄏノ
 $ar=$this->GetRow();
 if(!is_array($ar))
 return $ar;
 else{
 $obj=$this->CreateObj("sbase");
 $obj->properties=$ar;
 return $obj;
 }
 }
}

class sbase extends basesingle{
function Getseqno(){
 return $this->GetValue("seqno");
}

function Getdeptcode(){
 return $this->GetValue("deptcode");
}

function Getpostcode(){
 return $this->GetValue("postcode");
}

function Getvouhtype(){
 return $this->GetValue("vouh_type");
}

function Getacctno(){
 return $this->getValue("acctno");
}

function Getsubno(){
 return $this->getValue("subno");
}

function Getd_c(){
 return $this->GetValue("d_c");
}

function Getdesc(){
 return $this->GetValue("desc");
}

function Getamount(){
 return $this->GetValue("amount");
}
}
?>

2003-09-15 01:29:37

已设置保密

顶部

引用

报告

编辑

删除

wm_chief
用户头衔：管理员

精华贴   ：21
发贴数   ：47766
经验值   ：108904
注册时间：2002-10-30

信息

搜索

好友

发送悄悄话

【《帝国网站管理系统》基础教程下载】 [第 3 楼]

这个数据库操作类够齐的了。。。
ｈｏｈｏ支持多种数据库的，收下了。。。
看我的mysql类。
<?
class mysqlquery
{var $sql;//sql语句执行结果
var $query;//sql语句
var $num;//返回记录数
var $r;//返回数组
var $id;//返回数据库id号
//########################################执行mysql_query()语句##############################
function query($query)
{
$this->$sql=mysql_query($query) or die(mysql_error());
return $this->$sql;
}
//########################################执行mysql_fetch_array()#############################
function fetch($sql)//此方法的参数是$sql就是sql语句执行结果
{
$this->$r=mysql_fetch_array($sql);
return $this->$r;
}
//#################执行fetchone(mysql_fetch_array())#####################################
//此方法与fetch()的区别是:1、此方法的参数是$query就是sql语句
//2、此方法用于while(),for()数据库指针不会自动下移，而fetch()可以自动下移。
function fetch1($query)
{
$this->$sql=$this->query($query);
$this->$r=mysql_fetch_array($this->$sql);
return $this->$r;
}
//############################执行mysql_num_rows()#######################
function num($query)//此类的参数是$query就是sql语句
{
$this->$sql=$this->query($query);
$this->$num=mysql_num_rows($this->$sql);
return $this->$num;
}
//###########################执行numone(mysql_num_rows())####################
//此方法与num()的区别是：1、此方法的参数是$sql就是sql语句的执行结果。
function num1($sql)
{$this->$num=mysql_num_rows($sql);
return $this->$num;
}
//###############################执行free(mysql_result_free())#################
//此方法的参数是$sql就是sql语句的执行结果。只有在用到mysql_fetch_array的情况下用
function free($sql)
{mysql_free_result($sql);
}
//###########################执行seek(mysql_data_seek())#################
//此方法的参数是$sql就是sql语句的执行结果,$pit为执行指针的偏移数
function seek($sql,$pit)
{mysql_data_seek($sql,$pit);
}
//###########################执行id(mysql_insert_id())####################
function lastid()//取得最后一次执行mysql数据库id号
{$this->$id=mysql_insert_id();
return $this->$id;
}
//############################################################################
}
?>

[零基础入门教程] [模板制作教程] [采集使用教程]

2003-09-15 13:59:42

已设置保密

顶部

引用

报告

编辑

删除