[Resolved] Class help

Reformed

I have written a few classes, but they have been fairly basic. I am now trying to write a class that will, upon instantiation, check for a session; if the session does not exist, it is created. This class does not work so far and I wondered if I could get some pointers.

class PrevNext {

//call the constructor check for an existing session and create one if non exist
function PrevNext() {
	if(!$_SESSION['peopleIndex']) {
		$this->db = DB::connect($this->dsn);
			if(DB::isError($this->dsn)) {
				die($this->db->getMessage());
					$this->result = $this->db->getAll("select people_id, lname from people_info order by lname asc");
						if(DB::isError($this->result)) {
							die($this->result->getMessage());
					}
						$_SESSION['peopleIndex'] = $this->result;
			}
	}
}
}

The problem is that the session is not being written. Is there something that needs to be done because the session is being written in a class?

Shrike

class PrevNext {

//call the constructor check for an existing session and create one if non exist
function PrevNext() {
	if(!$_SESSION['peopleIndex']) {
		$this->db = DB::connect($this->dsn);
			if(DB::isError($this->dsn)) {
				die($this->db->getMessage()); // If there's an error script will exit, if not it won't process the rest of the code
					$this->result = $this->db->getAll("select people_id, lname from people_info order by lname asc");
						if(DB::isError($this->result)) {
							die($this->result->getMessage());
					}
						$_SESSION['peopleIndex'] = $this->result;
			}
	}
}
}

The problem is that the session is not being written. Is there something that needs to be done because the session is being written in a class? [/B][/QUOTE]

ahundiak

Also, use
$this->db =& DB::connect($this->dsn);

When opening the connection.

Reformed

I am still unable to make this class work and I have traced the problem to DB. It seems that DB is not working as soon as I put it into a class. Here is the new code and the error it produces in Zend's debugger:

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

class PrevNext {

//call the constructor check for an existing session and create one if non exist
function getIndex() {
	if(!$_SESSION['peopleIndex']) {
		$this->db = &DB::connect($this->dsn);
			$this->result = $this->db("SELECT people_id, lname FROM people_info ORDER BY lname");
		return $this->result;
	}
}
}
?>

Here is the error:

Debug session started.
Notice: /Users/donfitzsimmons/Sites/WindstormDev/lib/config.php line 5 - Constant APP_ROOT already defined
Notice: /Users/donfitzsimmons/Sites/WindstormDev/lib/config.php line 8 - Constant SITE_URL already defined
Notice: /Users/donfitzsimmons/Sites/WindstormDev/lib/config.php line 11 - Constant DB_NAME already defined
Notice: /Users/donfitzsimmons/Sites/WindstormDev/lib/config.php line 13 - Constant DB_PASS already defined
Notice: /Users/donfitzsimmons/Sites/WindstormDev/lib/config.php line 15 - Constant DB_USER_NAME already defined
Notice: /Users/donfitzsimmons/Sites/WindstormDev/lib/config.php line 17 - Constant DB_HOST already defined
Notice: /Users/donfitzsimmons/Sites/WindstormDev/lib/NextPrev.php line 9 - Undefined index: peopleIndex
Debug Warning: /Users/donfitzsimmons/Sites/WindstormDev/lib/DB.php line 279 - connect(DB/.php): failed to open stream: No such file or directory
Debug Warning: /Users/donfitzsimmons/Sites/WindstormDev/lib/DB.php line 279 -

connect(): Failed opening 'DB/.php' for inclusion (include_path='.:/usr/local/lib/php')
Debug Error: /Users/donfitzsimmons/Sites/WindstormDev/lib/NextPrev.php line 11 - Call to undefined function: db()
Debug session ended.

ahundiak

Start by getting rid of the "constant already defined" notices. You are probably including several files more than once. Go through input.php and make sure require_once is being used when appropiate.

Next, check $this->db to see if it's an error object. If so, the message will give you more information. Make sure that $this->dsn has the correct connection information.