sqlsrv扩展的使用方法可以参考官方在线手册的说明,亦可以使用以下类
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));
var_dump(sqlsrv_errors());
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->affected
用php连接mssql的体会
最新推荐文章于 2021-04-10 03:31:54 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)