Posted by cyber0ne on 08/11/06 14:32

Using PHP 5.1.2

I'm working on a personal project to get used to PHP, and I seem to be
stuck at the moment on a class I'm writing. Here is the code for the
class, with a comment highlighting where it dies when a function is
called externally from the code that instantiates the class:

----------BEGIN PASTE----------
class DataAccess{

private $databaseConnection;

function __construct()
{
@ $databaseConnection = new mysqli("this", "is", "fake", "data");
if (mysqli_connect_errno())
{
// TODO: generate an error
}
}

function __destruct()
{
$databaseConnection->close();
}

function GetArticlesForCategory($cid)
{
$querySelect = "SELECT stuff WHERE something = " . $cid;

// Testing shows that the following line is where the code dies.
$resultSet = $databaseConnection->query($querySelect);
// End dying code

if ($resultSet)
{
$rowCount = $resultSet->num_rows;
if ($rowCount > 0)
{
$i = 0;
while ($i < $rowCount)
{
$rows[$i] = $resultSet->fetch_assoc();
$i++;
}
$resultSet->free();
return $rows;
}
else
{
// TODO: report an empty set
$resultSet->free();
return;
}
}
else
{
// TODO: generate an error
$resultSet->free();
return;
}
}

}
------------END PASTE------------

The error log seems to be claiming that $databaseConnection is
undefined on that line of code. Is there maybe something syntactic
that I'm missing? I've tried replacing all 3 references to
$databaseConnection in the class functions with
$this->$databaseConnection, but that didn't seem to change anything.

Any ideas?

[Back to original message]