All pastes #391937 Raw Edit

Untitled

public text v1 · immutable
·published 2007-03-12 15:18 UTC
rendered paste body
<?php 
/**************************************************************************
File: 		DBResultSet.php
Author: 	Kris Felscher (KF)
Date:		02/19/2007
Description:
	This script contains functionality used in conjunction with DBHandler.
	It provides data access functions.
	
Version History:
DATE		VERSION		USER		DESCRIPTION
---------------------------------------------------------------------------
02/19/2007	1.0			KF			Initial Version

To Do:

Known Bugs:
**************************************************************************/
class DBResultSet{
	//data members
	private $strSQL;
	private $databasename;
	private $connection;
	private $result;

//constructor
	public function __construct($strSQL, $databasename, $connection ){
  	$this->strSQL = $strSQL;
		$this->connection = $connection;
		$this->databasename = $databasename;
		$this->result = mysqli_query( $connection, $strSQL) or
      		die ( mysqli_error($connection). " Error no: " . mysqli_errno($connection));
  }

//destructor

	public function __destruct(){
		$this->close();
	}

	public function close(){
		unset($result);
	}

// public methods

	public function getRow(){
		return mysqli_fetch_array($this->result);
	}

	public function getColumnCount(){
		return mysqli_field_count($this->connection);
	}
	
	public function getRowCount() {
		return mysqli_num_rows($this->result);
	}

}//end class
?>