Fatal error: Call to a member function query() on a non-object PLEASE HELP

damiendarien · December 15, 2010

<?php

class OnlineStore {

private $DBConnect = NULL;
private $storeID = "";
private $inventory = array();
private $shoppingCart = array();
function __construct() {
	include("inc_OnlineStoreDB.php");
	$this->DBConnect = $DBConnect;
}
function __destruct() {
	if (!$this->DBConnect->connect_error)
		$this->DBConnect->close();
}

public function setStoreID($storeID) {
	if ($this->storeID != $storeID) {
		$this->storeID = $storeID;
		$SQLstring = "SELECT * FROM inventory " .
					" where storeID = 'jw" .
					$this->storeID . "'";
		$QueryResult = $this->DBConnect->query($SQLstring);
		if ($QueryResult === FALSE) {
			$this->storeID = "";
		} else {
			$this->inventory = array();
			$this->shoppingCart = array();
			while (($Row = $QueryResult->fetch_assoc()) !== NULL) {
				$this->inventory[$Row['productID']] = array();
				$this->inventory[$Row['productID']]['name'] = $Row['name'];
				$this->inventory[$Row['productID']]['description'] = $Row['description'];
				$this->inventory[$Row['productID']]['price'] = $Row['price'];
				$this->shoppingCart[$Row['productID']] = 0;
			}
		}
	}
}

public function getStoreInformation() {
	$retval = FALSE;
	if ($this->storeID != "") {
		$SQLstring = "SELECT * FROM store_info " .
					" WHERE storeID = '" .
					$this->storeID . "'";
		$QueryResult = @$this->DBConnect->query($SQLstring);
		if ($QueryResult !== FALSE) {
			$retval = $QueryResult->fetch_assoc();
		}
	}
	return($retval);
}

public function getProductList() {
	$retval = FALSE;
	$subtotal = 0;
	if (count($this->inventory) > 0) {
		echo "<table width='100%'>\n";
		echo "<tr><th>Product</th><th>Description</th>" .
				"<th>Price Each</th><th># in Cart</th>" .
				"<th>Total Price</th><th> </th></tr>\n";
		foreach ($this->inventory as $ID => $Info) {
			echo "<tr><td>" .
					htmlentities($Info['name']) . "</td>\n";
			echo "<td>" . htmlentities($Info['description']) . "</td>\n";
			printf("<td class='currency'>$%.2f</td>\n", $Info['price']);
			echo "<td class='currency'>" . $this->shoppingCart[$ID] . "</td>\n";
			printf("<td class='currency'>$%.2f</td>\n", $Info['price'] * $this->shoppingCart[$ID]);
			echo "<td><a href='" . $_SERVER['SCRIPT_NAME'] . "?PHPSESSID=" . session_id() . "&ItemToAdd=$ID'>Add " . " Item</a></td>\n";
			$subtotal += ($Info['price'] * $this->shoppingCart[$ID]);
		}
		echo "<tr><td colspan='4'>Subtotal</td>\n";
		printf("<td class='currency'>$%.2f</td>\n", $subtotal);
		echo "<td>$nbsp;</td></tr>\n";
		echo "</table>";
		$retval = TRUE;
	}
	return($retval);
}

public function addItem() {
	$ProdID = $_GET['ItemToAdd'];
	if (array_key_exists($ProdID, $this->shoppingCart))
		$this->shoppingCart[$ProdID] += 1;
}


}

?>

having an issue to where nothing is appearing on the page and getting the

Fatal error: Call to a member function query() on a non-object in C:\xampp\htdocs\PHP\Chapter.10\class_OnlineStore.php on line 24

HERE IS THE MAIN PAGE

<?php
session_start();
require_once("class_OnlineStore.php");

$storeID = "COFFEE";
$storeInfo = array();

if (class_exists("OnlineStore")) {
if (isset($_SESSION['currentStore']))
	$Store = unserialize($_SESSION['currentStore']);
else {
	$Store = new OnlineStore();
}
$Store->setStoreID($storeID);
$storeInfo = $Store->getStoreInformation();
} else {
$ErrorMsgs[] = "The OnlineStore class is not available!";
$Store = NULL;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title><?php echo $storeInfo['name']; ?></title>
<link rel="stylesheet" type="text/css" href="<?php echo $storeInfo['css_file']; ?>" />
</head>

<body>
<h1><?php echo htmlentities($storeInfo['name']); ?></h1>
<h2><?php echo htmlentities($storeInfo['description']); ?></h2>
<p><?php echo htmlentities($storeInfo['welcome']); ?></p>

<?php 
$Store->getProductList();
$_SESSION['currentStore'] = serialize($Store);
?>	

</body>
</html>

I HAVE REVIEWED IT OVER AND OVER AGAIN AND I CANT SEE THE PROBLEM. MAYBE SOMEONE FROM THE OUTSIDE CAN HELP OUT.

damiendarien · December 15, 2010

****UPDATE****

Now i got it to show up but as far as the table being layed out properly --- ITS NOT. thanks

damiendarien · December 15, 2010

problem with the table has been fixed. (operator error) didnt have CSS in the same folder.

added __wakup() to make the rest work.

Thanks to whoever looked.

aboyce2107 · April 11, 2015

I'm having the same problem, and I'm getting Fatal error: Call to a member function fetch_assoc() on a non-object. I've spent the last few hours and most of yesterday trying to figure it out! I'd appreciate any help!!!

Barand · April 11, 2015

The most likely cause is that your query has an error and failed.

aboyce2107 · April 20, 2015

I figured it out, after leaving the PC for a few hours. The problem was it would only open in a new browser, but will error out after hitting refresh. Once I added the __wakeup() function and the necessary info in that function it worked just fine.

Sign In

Fatal error: Call to a member function query() on a non-object PLEASE HELP

Recommended Posts

damiendarien

Link to comment

Share on other sites

damiendarien

Link to comment

Share on other sites

damiendarien

Link to comment

Share on other sites

aboyce2107

Link to comment

Share on other sites

Barand

Link to comment

Share on other sites

aboyce2107

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information