<?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
?>