1、windows服务器php+mssql连接class,内含读、写、改、删。
<?php
class db_mssql {
var $querynum = 0;
var $connid = 0;
var $insertid = 0;
var $cursor = 0;
function connect($dbhost = 'localhost', $dbuser, $dbpw, $dbname, $pconnect = 0) {
$func = $pconnect == 1 ? 'mssql_pconnect' : 'mssql_connect';
if(!$this->connid = @$func($dbhost, $dbuser, $dbpw)) $this->halt('Can not connect to MsSQL server');
if($dbname) {
if(!@mssql_select_db($dbname , $this->connid)) $this->halt('Cannot use database '.$dbname);
}
return $this->connid;
}
function select_db($dbname) {
return mssql_select_db($dbname , $this->connid);
}
function query($sql, $type = '', $expires = 3600, $dbname = '') {
$this->querynum++;
$sql = trim($sql);
if(preg_match("/^(select.*)limit ([0-9]+)(,([0-9]+))?$/i", $sql, $matchs)