<?

# *********************************************************
# 変数クラス
# *********************************************************
class PgValue {

	var $LineMax;

	var $strData1;
	var $strData2;
	var $nData3;
	var $dtData4;
	var $strData5;

	var $StartKey;
	var $EndKey;

# *********************************************************
# コンストラクタ
# *********************************************************
	function PgValue( ) {

		global $start_key;
		global $end_key;

		$this->LineMax	= 5;

		if ( isset( $start_key ) ) {
			$this->StartKey		= $start_key;
			$this->EndKey		= $end_key;
		}
		else {
			$this->StartKey		= "";
			$this->EndKey		= "";
		}
	}

}

?>

<?
# *********************************************************
# データベースクラス
# *********************************************************
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 );
	}

}

?>