I having some problems with the following code:
[ BEGIN CODE SNIPPET ]
<?
session_start();
if(!isset($_SESSION["iMemberID"])){
$_SESSION["iMemberID"] = 19;
}
require_once("../classes/class.mysql.php");
require_once("../_global.php");
require_once("../classes/class.members.php");
require_once("../classes/class.mail.php");
$objMember = new members($_SESSION["objDB"]); //intialize member class
$objMember->setMemberID($_SESSION["iMemberID"]);
//$objMember->fnGetProfile();
$objMail = new memberMail($objMember); //initialize memberMail class
$objMail->members($_SESSION["objDB"]);
$objMail->setMemberID($_SESSION["iMemberID"]);
$iMailCount = $objMail->fnGetMailCount();
?>
You have <? echo $iMailCount ?> emails
[ END CODE SNIPPET ]
Everything works fine when the page is initally loaded into the
browser, however, upon a page refresh, it appears to blow up on either
function call:
//$objMember->fnGetProfile();
or
$iMailCount = $objMail->fnGetMailCount();
I'm not sure if I've provided enough info to be useful, but here's
some other info that may or may not be relevant:
_globals.php
<?
/*
* Set array for global (site-wide) variables
*/
$aSiteSettings = array(
// DB Settings
"sDSN" => "dbDSN",
"sDBServer" => "dbServer",
"sDBLogin" => "dbLogin",
"sDBPassword" => "dbPassword",
);
if(!isset($_SESSION["MemberCheck"])){
$_SESSION["MemberCheck"] = "Guest";
}
if(!isset($_SESSION["objDB"])){
$_SESSION["objDB"] = new MySQLConnector($aSiteSettings["sDBServer"],
$aSiteSettings["sDBLogin"], $aSiteSettings["sDBPassword"],
$aSiteSettings["sDSN"]); //initialize MySQLConnector Class
}
?>
class.members.php [snippet]
// Setters
function setMemberID($iMemberID){
return $this->_iMemberID = $iMemberID;
}
// Getters
function getMemberID(){
return $this->_iMemberID;
}
class.mail.php [snippet]
class memberMail extends members {
var $iMailID;
function memberMail(){
parent::members();
}
function fnGetMailCount() {
$sql = "
SELECT
iMessageID
FROM
tblEmail
WHERE
iToMemberID = ". $this->getMemberID();
$this->mySQLConnector->performQuery($sql);
return $this->mySQLConnector->getNumRows();
}
}
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
