Here below is given the Connection class
class Database
{
var $sServer;
var $sDatabase;
var $sUsername;
var $sPassword;
var $dbConnection;
var $dbResultSet;
var $iCount;
var $iFieldsCount;
var $iAutoNumber;
var $sError;
function Database( )
{
$this->sServer = DB_SERVER;
$this->sDatabase = DB_NAME;
$this->sUsername = DB_USER;
$this->sPassword = DB_PASSWORD;
$this->dbConnection = NULL;
$this->dbResultSet = NULL;
$this->iCount = 0;
$this->iAutoNumber = 0;
$this->sError = NULL;
if (!$this->dbConnection)
$this->connect( );
}
function connect( )
{
$this->dbConnection = @mysqli_connect($this->sServer, $this->sUsername, $this->sPassword, $this->sDatabase);
if (!$this->dbConnection)
{
print "Error: Unable to connect to the database Server.";
exit( );
}
if (!@mysqli_select_db($this->dbConnection, $this->sDatabase))
{
print "Error: Unable to locate the Database.";
exit( );
}
}
function query($sQuery, $bFlag = false)
{
@mysqli_free_result($this->dbResultSet);
$this->dbResultSet = @mysqli_query($this->dbConnection, $sQuery);
if (!$this->dbResultSet)
{
$this->sError = @mysqli_error($this->dbConnection);
$this->iCount = 0;
$this->iFieldsCount = 0;
return false;
}
else
{
$this->iCount = @mysqli_num_rows($this->dbResultSet);
$this->iFieldsCount = @mysqli_num_fields($this->dbResultSet);
return true;
}
}
function getCount( )
{
return $this->iCount;
}
function getField($iIndex, $sField)
{
if ($this->dbResultSet === false)
return false;
if ($iIndex >= @mysqli_num_rows($this->dbResultSet))
return false;
if (@is_string($sField) && !(@strpos($sField, ".") === false))
{
$sTableField = @explode(".", $sField);
$sField = -1;
$sTableFields = @mysqli_fetch_fields($this->dbResultSet);
for ($sRowId = 0; $sRowId < @mysqli_num_fields($this->dbResultSet); $sRowId++)
{
if ($sTableFields[$sRowId]->table == $sTableField[0] && $sTableFields[$sRowId]->name == $sTableField[1])
{
$sField = $sRowId;
break;
}
}
if ($sField == -1)
return false;
}
@mysqli_data_seek($this->dbResultSet, $iIndex);
$sDbLine = @mysqli_fetch_array($this->dbResultSet);
return isset($sDbLine[$sField])? $sDbLine[$sField] : false;
}
function execute($sQuery, $bFlag = true)
{
@mysqli_free_result($this->dbResultSet);
if (!@mysqli_query($this->dbConnection, $sQuery))
{
$this->sError = @mysqli_error($this->dbConnection);
$this->iCount = 0;
$this->iFieldsCount = 0;
return false;
}
else
{
$this->iAutoNumber = @mysqli_insert_id($this->dbConnection);
$this->iCount = 0;
$this->iFieldsCount = 0;
}
return true;
}
function close( )
{
@mysqli_free_result($this->dbResultSet);
@mysqli_close($this->dbConnection);
}
function error( )
{
return $this->sError;
}
}
class Database
{
var $sServer;
var $sDatabase;
var $sUsername;
var $sPassword;
var $dbConnection;
var $dbResultSet;
var $iCount;
var $iFieldsCount;
var $iAutoNumber;
var $sError;
function Database( )
{
$this->sServer = DB_SERVER;
$this->sDatabase = DB_NAME;
$this->sUsername = DB_USER;
$this->sPassword = DB_PASSWORD;
$this->dbConnection = NULL;
$this->dbResultSet = NULL;
$this->iCount = 0;
$this->iAutoNumber = 0;
$this->sError = NULL;
if (!$this->dbConnection)
$this->connect( );
}
function connect( )
{
$this->dbConnection = @mysqli_connect($this->sServer, $this->sUsername, $this->sPassword, $this->sDatabase);
if (!$this->dbConnection)
{
print "Error: Unable to connect to the database Server.";
exit( );
}
if (!@mysqli_select_db($this->dbConnection, $this->sDatabase))
{
print "Error: Unable to locate the Database.";
exit( );
}
}
function query($sQuery, $bFlag = false)
{
@mysqli_free_result($this->dbResultSet);
$this->dbResultSet = @mysqli_query($this->dbConnection, $sQuery);
if (!$this->dbResultSet)
{
$this->sError = @mysqli_error($this->dbConnection);
$this->iCount = 0;
$this->iFieldsCount = 0;
return false;
}
else
{
$this->iCount = @mysqli_num_rows($this->dbResultSet);
$this->iFieldsCount = @mysqli_num_fields($this->dbResultSet);
return true;
}
}
function getCount( )
{
return $this->iCount;
}
function getField($iIndex, $sField)
{
if ($this->dbResultSet === false)
return false;
if ($iIndex >= @mysqli_num_rows($this->dbResultSet))
return false;
if (@is_string($sField) && !(@strpos($sField, ".") === false))
{
$sTableField = @explode(".", $sField);
$sField = -1;
$sTableFields = @mysqli_fetch_fields($this->dbResultSet);
for ($sRowId = 0; $sRowId < @mysqli_num_fields($this->dbResultSet); $sRowId++)
{
if ($sTableFields[$sRowId]->table == $sTableField[0] && $sTableFields[$sRowId]->name == $sTableField[1])
{
$sField = $sRowId;
break;
}
}
if ($sField == -1)
return false;
}
@mysqli_data_seek($this->dbResultSet, $iIndex);
$sDbLine = @mysqli_fetch_array($this->dbResultSet);
return isset($sDbLine[$sField])? $sDbLine[$sField] : false;
}
function execute($sQuery, $bFlag = true)
{
@mysqli_free_result($this->dbResultSet);
if (!@mysqli_query($this->dbConnection, $sQuery))
{
$this->sError = @mysqli_error($this->dbConnection);
$this->iCount = 0;
$this->iFieldsCount = 0;
return false;
}
else
{
$this->iAutoNumber = @mysqli_insert_id($this->dbConnection);
$this->iCount = 0;
$this->iFieldsCount = 0;
}
return true;
}
function close( )
{
@mysqli_free_result($this->dbResultSet);
@mysqli_close($this->dbConnection);
}
function error( )
{
return $this->sError;
}
}