发信人: bb_rain()
整理人: tang(2001-01-31 09:00:37), 站内信件
|
<?
/*********************************************************************
*********
Database Module for PHP3 & PHP4 ( SQL Server, v 1.00 )
Copyright (C) 2000 heyin.com, All Rights Reserved.
http://www.heyin.com
Rain ( Email: [email protected] Oicq: 1235686 )
db_mssql.php, 2000/8/12
**********************************************************************
*********/
class DBModule {
var $Host; // database host
var $Username; // database username
var $Password; // database password
var $DataSource; // database name
var $handle; // data handle
var $result; // result handle
var $FD_NAME; // field name array
var $COUNT; // output data count
var $LINES;
// Initialize
function DBModule() {
global $DATA_HOST,$DATA_USERNAME,$DATA_PASSWORD,$DATA_SOURCE;
$this->Host=$DATA_HOST;
$this->Username=$DATA_USERNAME;
$this->Password=$DATA_PASSWORD;
$this->DataSource=$DATA_SOURCE;
}
// open database
function Open() {
$this->handle=mssql_connect($this->Host,$this->Username,$this->Pas
sword) or die(mssql_error());
mssql_select_db($this->DataSource,$this->handle) or die(mssql_erro
r());
}
// close database
function Close() {
mssql_close($this->handle);
}
// exec SQL
function Query($SQL) {
$this->result = mssql_query($SQL) or die(mssql_error());
}
// return OUT
function dbFetchArray() {
$this->LINES = mssql_fetch_array($this->result);
}
// return COUNT
function dbNumRows() {
$this->COUNT = mssql_num_rows($this->result);
}
// return FD_NAME
function dbFieldName() {
unset($this->FD_NAME);
$count = mssql_num_fields($this->result);
for ($i=0;$i<$count;$i++) {
$this->FD_NAME[$i] = mssql_field_name($this->result,$i);
}
}
}
?>
--
HEYIN 软件 http://www.heyin.com
虚拟社区，聊天室，交友程序，网上超市，电子商务 ...
※ 来源:．月光软件站 http://www.moon-soft.com．[FROM: 61.133.178.72]
|
|