class db_sql1 {
var $querynum = 0;
var $lastInsertID=0;
function connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect = 0){
if($pconnect){
if(!@mssql_pconnect($dbhost, $dbuser, $dbpw)){
$this->halt('Can not connect to MSSql Server');
}
} else {
if(!@mssql_connect($dbhost, $dbuser, $dbpw)){
$this->halt('Can not connect to MSSql Server');
}
}
mssql_select_db($dbname);
}
function select_db($dbname) {
return mssql_select_db($dbname);
}
function fetch_array($query, $result_type = MSQL_ASSOC){
return mssql_fetch_array($query, $result_type);
}
function query($sql, $silence = 0){
$query = mssql_query($sql);
if(!$query && !$silence) {
$this->halt('MSSQL Query Error', $sql);
}
$this->querynum++;
$this->lastInsertID = @mssql_result("SELECT @@IDENTITY AS 'id'",0,"id");
return $query;
}
function unbuffered_query($sql, $silence = 0){
$funcname = @function_exists('mssql_unbuffered_query') ? 'mssql_unbuffered_query' : 'mssql_query';
$query = $funcname($sql);
if(!$query && !$silence) {
$this->halt('MSSQL Query Error', $sql);
}
$this->querynum++;
return $query;
}
function affected_rows(){
return mssql_rows_affected();
}
function result($query, $row){
$query = @mssql_result($query, $row);
return $query;
}
function num_rows($query){
$query = mssql_num_rows($query);
return $query;
}
function num_fields($query) {
return mssql_num_fields($query);
}
function free_result($query) {
return mssql_free_result($query);
}
function insert_id() {
return $this->lastInsertID;
}
function fetch_row($query) {
$query = mssql_fetch_row($query);
return $query;
}
function close() {
return mssql_close();
}
function halt($message = '', $sql = '') {
$errmsg = '';
$errmsg = "Tips: $message\n\n";
$errmsg .= "Time: ".gmdate("Y-n-j g:ia", $timestamp )."\n";
if($sql){
$errmsg .= "SQL: ".htmlspecialchars($sql)."\n";
}
$errmsg .= "Error: " .mssql_get_last_message()."\n";
}
}
?>