Just to add a correction to the where clause in the class.mail.php:
class.mail.php
<?
class memberMail extends members {
function fnGetMail() {
$sql = "SELECT * FROM tblEmail
WHERE iToMemberID = ". getMemberID() ."Order by dtEmailDate Desc";
//return "testing return working";
$this->mySQLConnector->performQuery($sql);
return $this->mySQLConnector->fetchRow();
}
.
.
.
.
}
?>
--- In php-list@yahoogroups.com, "balthork" <[EMAIL PROTECTED]> wrote:
> I am new to php and have written a few classes to use. I have a
> generic mysql class to do db functions. I'm passing this by reference
> to a members class. The members class is then extended by a mail
> class.
>
> I have the following code to execute:
> <?
> $_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"]); //setter - iMemberID
>
> $objMail = new memberMail($objMember);
> $objMail = fnGetMail();
> $iNbrMessages = $objMail->getNumRows();
> ?>
>
> I'm using PHP5 and I can return a string from fnGetMail(), but when I
> try to run the mySQLConnector functions, it fails and does not show
> any error. I'm sure I've made a silly mistake or am missing something
> obvious, but I can't seem to find it.
>
>
> _global.php
> <?
> require_once("classes/class.mysql.php");
>
> /*
> * Set array for global (site-wide) variables
> */
> $aSiteSettings = array(
> // DB Settings
> "sDSN" => "dsn1",
> "sDSNGeography" => "dsn2",
> "sDBServer" => "servername",
> "sDBLogin" => "dbLogin",
> "sDBPassword" => "dbPassword"
> );
>
>
> if(!isset($_SESSION["objDB"])){
> $_SESSION["objDB"] = new MySQLConnector($aSiteSettings["sDBServer"],
> $aSiteSettings["sDBLogin"], $aSiteSettings["sDBPassword"],
> $aSiteSettings["sDSN"]); //initialize MySQLConnector Class
> }
> ?>
>
>
>
> class.mysql.php
> <?
> class MySQLConnector {
> var $conId; // connection identifier
> var $host; // MySQL host
> var $user; // MySQL username
> var $password; // MySQL password
> var $database; // MySQL database
> var $result; // result set
> // constructor
> function MySQLConnector($host,$user,$password,$database){
> // validate incoming parameters
> (!empty($host))?$this->host=$host:die('Host parameter not
> valid');
> (!empty($user))?$this->user=$user:die('User parameter not
> valid');
> (!empty($password))?$this->password=$password:die('Password
> parameter not valid');
> (!empty($database))?$this->database=$database:die('Database
> parameter not valid');
> // connect to MySQL and select database
> $this->connectDB();
> }
> // connect to MYSQL server and select database
> function connectDB(){
>
> $this->[EMAIL PROTECTED]($this->host,$this->user,$this->password)
> or die('Error connecting to the server '.mysql_error());
> @mysql_select_db($this->database,$this->conId) or die('Error
> selecting database');
> }
> // perform query
> function performQuery($query){
> $this->[EMAIL PROTECTED]($query,$this->conId) or die('Error
> performing query '.$query);
> }
> // fetch row
> function fetchRow(){
> return mysql_fetch_array($this->result,MYSQL_ASSOC);
> }
> // get number of rows
> function getNumRows(){
> return mysql_num_rows($this->result);
> }
> // get number of affected rows
> function getAffectedRows(){
> return mysql_affected_rows($this->conId);
> }
> // get ID from last inserted row
> function getInsertID(){
> return mysql_insert_id($this->conId);
> }
> }
> ?>
>
>
>
> class.members.php
> <?
> class members {
> var $iMemberID;
> var $iProfileID;
>
> function members(&$MySQLConnector){
> $this->mySQLConnector = &$MySQLConnector; // Pass
> class.mysql.php by
> reference
> }
> .
> .
> .
> .
>
> // Setters
> function setMemberID($iMemberID){
> return $this->_iMemberID = $iMemberID;
> }
>
> function setProfileID($iProfileID){
> return $this->_iProfileID = $iProfileID;
> }
>
> // Getters
> function getMemberID(){
> return $this->_iMemberID;
> }
>
> function getProfileID(){
> return $this->_iProfileID;
> }
> }
> ?>
>
>
>
> class.mail.php
> <?
> class memberMail extends members {
> function fnGetMail() {
> $sql = "
> SELECT
> *
> FROM
> tblEmail
> WHERE
> iToMemberID = getMemberID()
> Order by dtEmailDate Desc
> ";
> //return "testing return working";
>
> $this->mySQLConnector->performQuery($sql);
> return $this->mySQLConnector->fetchRow();
> }
> .
> .
> .
> .
> }
> ?>
Community email addresses:
Post message: php-list@yahoogroups.com
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/
