Fatal Error - call to member

[stwallace]

Hello,

I recently created a membership listing form for a website. It has an administrative backend that will allow a user to insert, update, and delete member information. The backend seems to be working fine but on the public side, I sporadically receive an error that says:

Fatal error: Call to a member function on a non-object in /home/content/c/a/l/calvertmba/html/admin/members-admin/viewlist.php on line 10

Here is line 10 of my code:
$maxRecord = 10;
$sqlbase = "SELECT FROM members ".$myData->whereStr.$myData->getOrderString();
$sql = $sqlbase."LIMIT ".(($myData->actPageNr-1)$maxRecord).",".$maxRecord;
$Result = $MyDb->f_ExecuteSql($sql);
$ResultRowNr = $MyDb->f_GetSelectedRows($Result);
$ResultTotalRow = $MyDb->f_ExecuteSql($sqlbase);
$totalRows = $MyDb->f_GetSelectedRows($ResultTotalRow);

I created the database on my local server using PHPAdmin 2.6.3 & Mysql 5.0.2. The forms were created using PHP Wizard 0.3. They are residing on a server that is running Mysql 4.1

Any help would be greatly appreciated. I'm trying to finish this project by the end of the week.

Thank you

[halojoy]

this line looks bad, to me:

$sqlbase = "SELECT * FROM members ".$myData->whereStr.$myData->getOrderString();

Usually this non-object error is when class object has NOT been created with new
and you try to run a function with
$myData->funcname();
or
$MyDb->funcname();

[NogDog]

Since you did not specify which of those lines is line 10, the best I can say for now is that either $myData is not an object or $MyDb is not an object. Check your code for where those variables first get set (if they do), that you have spelled them consistently, that they should be objects, and that you did proper error-checking to make sure that initial assignment worked OK. It might also help to turn on all levels of error reporting if you have not already done so:

<?php
error_reporting(E_ALL & E_STRICT);

[stwallace]

halojoy wrote:

this line looks bad, to me:

$sqlbase = "SELECT * FROM members ".$myData->whereStr.$myData->getOrderString();

Usually this non-object error is when class object has NOT been created with new
and you try to run a function with
$myData->funcname();
or
$MyDb->funcname();

Thank you for such a quick response. I'm new to PHP. I use form wizard to generate the forms and code for me. I will go through it again usiing the suggestions offerred.

This is line 10
$sqlbase = "SELECT * FROM members ".$myData->whereStr.$myData->getOrderString();

[troybtj]

ETA:

NogDog wrote:

<?php
error_reporting(E_ALL & E_STRICT);

Set error_reporting at the top of all files until in production if you are having any problems.

Above that line 10, do you have anything like:

myData=new CLASS_USED();

Where CLASS_USED is the .php file that defines the functions of whereStr, etc. ?

[stwallace]

Not in the viewlist.php file. Here is the entire code:
<?php
include('general/header.inc');
require_once('general/general.php');

if (isset($GET['order'])) $myData->setOrderingInfo($GET['order']);
if (isset($GET['page'])) $myData->actPageNr = $GET['page'];
if (isset($POST['formdata'])) $myData->getWhereClause($POST['formdata']);

$maxRecord = 10;
$sqlbase = "SELECT FROM members ".$myData->whereStr.$myData->getOrderString();
$sql = $sqlbase."LIMIT ".(($myData->actPageNr-1)$maxRecord).",".$maxRecord;
$Result = $MyDb->f_ExecuteSql($sql);
$ResultRowNr = $MyDb->f_GetSelectedRows($Result);
$ResultTotalRow = $MyDb->f_ExecuteSql($sqlbase);
$totalRows = $MyDb->f_GetSelectedRows($ResultTotalRow);

?>

However, in the header.inc file there is :

<?php
session_start();
include('usersession.php');
include('db/db_connection.php');

if (!isset($SESSION['usr']))
{
$myData = new usersession();
}
else
{
$myData = unserialize($SESSION['usr']);
}

?>

Should this statement in usersession.php be empty?
var $whereStr=' ';

I notice I do have trouble if I call the page three or 4 attempts. Then I have to close my browser and re-open it. Everything comes back.

[troybtj]

The multi-session error is due to the use of "include ("header.inc"); rather than require_once (header.inc) (or include_once of same);

It is creating a new PHPSESSION for each instance you load due to the include, require_once would only create one session, depending on your session timeout.

That's a rather big bug, once that is corrected and error reporting is turned on full, the issue should be narrowed down some.