|
<?
# *********************************************************
# データベースクラス
# *********************************************************
class DB {
var $Connect;
var $Result;
var $Field;
var $Cols;
var $Rows;
# *********************************************************
# コンストラクタ
# *********************************************************
function DB( $Server, $DbName, $User, $Password ) {
$ret = $this->Connect = mssql_connect( $Server, $User, $Password );
mssql_select_db( $DbName, $this->Connect );
$this->Cols = 0;
$this->Rows = 0;
}
# *********************************************************
# クエリー
# *********************************************************
function Query( $SqlQuery ) {
$this->Result = mssql_query( $SqlQuery, $this->Connect );
if ( $this->Result == FALSE ) {
$this->Cols = 0;
$this->Rows = 0;
}
else {
$this->Cols = mssql_num_fields( $this->Result );
$this->Rows = mssql_num_rows( $this->Result );
}
return $this->Result;
}
# *********************************************************
# SQL実行
# *********************************************************
function Execute( $Sql ) {
return mssql_query( $Sql, $this->Connect );
}
# *********************************************************
# フェッチ
# *********************************************************
function Fetch( ) {
$this->Field = mssql_fetch_array( $this->Result );
return $this->Field;
}
# *********************************************************
# フィールド名
# *********************************************************
function FieldName( $i ) {
return mssql_field_name( $this->Result, $i );
}
# *********************************************************
# 開放
# *********************************************************
function Free( ) {
mssql_free_result( $this->Result );
}
# *********************************************************
# 接続解除
# *********************************************************
function Close( ) {
mssql_close( $this->Connect );
}
}
?>
| |