一個 php 連接 sql server的類

 
<?php
/**


@desc   A simple and convenient php sqlsrv  class
*/
class sqlsrv{
var $error_log = array();
 var $sql_log = array();
 var $query_id;
 var $num_rows;
 var $conn;
//connection
 function sqlsrv($server, $user, $pass, $dbname) {

 $this->conn = @sqlsrv_connect($server, array('UID' => $user ,'PWD'=> $pass, 'Database' => $dbname));
 if($this->conn === false) {
     $this->error_log[] = sqlsrv_errors();
     die();
 }

}
//query source
 function query($sql){

 $stmt = sqlsrv_query($this->conn, $sql);
 $this->sql_log[] = $sql;
 if($stmt === false) {
     $this->error_log[] = sqlsrv_errors();
 } else {
     $this->query_id = $stmt;
     $this->num_rows = $this->affectedRows();
 }

}
//fetch data
 function fetch_all($sql) {

 $this->query($sql);
 $data = array();
 while($row = @sqlsrv_fetch_array($this->query_id, SQLSRV_FETCH_ASSOC)) {
     $data[] = $row;
 }
 return $data;

}
 // $DB->count(select   *   from  users)
 function fetch_one($sql){

 $this->query($sql);
 return  sqlsrv_fetch_array($this->query_id, SQLSRV_FETCH_ASSOC);


}
 // $DB->count(select   count(*)   from  users)
 function count($sql){

 $count=$this->fetch_one($sql);
 return $count[""];


}
function affectedRows() {

 return ($this->query_id) ? @sqlsrv_num_rows($this->query_id) : false;

}
}


?>
</pre>