求一个php操作mssql的类！函数越全越好！

xledoo · 2006-06-03

谢谢大家了~
php+mssql的类~找到几个，可都是用MYSQL改的！连返回的错误信息都是
$this->Error = @mysql_error($this->LinkID);
$this->ErrNo = @mysql_errno($this->LinkID);

大家给有个吧~！:lovely:

可可 · 2006-06-03

调调的沙发.

小叶 · 2006-06-03

Pear的DB库，ADOdb的库

xledoo · 2006-06-03

小叶同志~~谢谢你哈~
不过觉得那种东西太专业了，我初学。光要搞懂怎么用它们估计就得花点工夫了！
我自己写了一个，只是不知道全不全。我放上来大家看下吧！

xledoo · 2006-06-03

大家帮忙看一下！

一个PHP+MSSQL的类！

<?php

class dbsql
{
var $dbhost;
var $dbuser;
var $dbpass;
var $dbname;
var $link =0;
var $doresult ="";
var $lastid = "";

function dbsql($dbhost,$dbuser,$dbpass,$dbname) {
$this->dbhost = $dbhost;
$this->dbuser = $dbuser;
$this->dbpass = $dbpass;
$this->dbname = $dbname;
}

function connect(){
$this->link = @mssql_connect($this->dbhost,$this->dbuser,$this->dbpass);
if(!$this->link){
$this->halt("Connect to this Server ( '$this->dbhost','$this->dbuser','dbpass' ) : Failed");
return 0;
}
if(!@mssql_select_db($this->dbname)){
$this->halt("Select to($this->dbname) Failed.");
return 0;
}
return 1;
}

function select(){
if(@mssql_select_db($this->dbname))
return 1;
else
return 0;
}

function query($sql){
if($this->link == 0){
$this->halt("Execute SQL Failed: Hava not valid database connect.");
return 0;
}

ob_start();
$this->doresult = mssql_query($sql,$this->link);
$error = ob_get_contents();
ob_end_clean();
if($error){

$this->halt("Execute SQL: Query($sql,$this->linkID) failed.");
return 0;
}
$reg = "#insert into#";
if(preg_match($reg,$sql)){
$sql = "select @@IDENTITY as id";
$res = mssql_query($sql,$this->link);
$this->lastid = mssql_result($res,0,id);
}
return $this->doresult;
}

function num_rows($result=""){
if($result != "") $this->doresult = $result;
$row = @mssql_num_rows($this->doresult);
if($row >= 0) return $row;
$this->halt("Get a row of result Failed: Result $result is invalid.");
return 0;
}

function lastid(){
return $this->lastid;
}

function result($result="",$row=0,$field=0){
if($result != "") $this->doresult = $result;
$fieldvalue = @mssql_result($this->doresult,$row,$field);
if($fieldvalue != "") return $fieldvalue;
$this->halt("Get field: Result($this->doresult,$row,$field) failed.");
return 0;
}
//mssql_fetch_array的究竟用哪一个好呢？用短一点的这个经常会出错！
/* function fetch_array($query) {
return mssql_fetch_array($query);
}
*/
//下面这个也有问题！
function fetch_array($result){
if(!empty($result)) $this->doresult = $result;
$record = @mssql_fetch_array($this->doresult);
if(array($record)) //这里原来是if(is_array($record))，但是出错了，改为现在的array就正常。is_array和array的区别在哪里？ return $record;
$this->halt("Get the next record Failed: the Result $result is invalid.");
return 0;
}

function free_result($result=""){
if($result != "") $this->doresult = $result;
return @mssql_free_result($this->doresult);
}

function halt($errmsg) {
$message="<Title>Web Info</Title>";
$message.="Web info: $errmsg\n\n";
$message.=" Script: ".$_SERVER["SCRIPT_NAME"]."\n ";
$message.="IPAdd: ".$_COOKIE['UserIP']."\n ";
echo "";
echo $message;
echo ' Similar error report has beed dispatched to administrator before.';
function_exists('exit') ? exit() : exit();
}

}

?>
点击展开...

小叶 · 2006-06-03

技术比我牛多了，以后偶不敢回贴了。

小叶 · 2006-06-03

xledoo · 2006-06-03

:cry:
不要啊~~我不懂的~依葫芦画而已啊~
请教大家了~

21andy · 2006-06-05

作者: 小叶:

Pear的DB库，ADOdb的库
点击展开...

正解!
可惜偶没有:ghost:

论坛

求一个php操作mssql的类！函数越全越好！

xledoo New Member

可可 New Member

小叶 New Member

xledoo New Member

xledoo New Member

小叶 New Member

小叶 New Member

xledoo New Member

21andy New Member

快捷检索

求一个php操作mssql的类！函数越全越好！

xledoo New Member

可可 New Member

小叶 New Member

xledoo New Member

xledoo New Member

小叶 New Member

小叶 New Member

xledoo New Member

21andy New Member