Object instance and session

[Stefano Esposito <ragnarok@xxxxxxxx>]

Hi all,

i've a self-defined class describing an user. In the login page i create an instance of the user object and store it in $_SESSION['user']. When accessing $_SESSION['user'] from other pages (of course I do require('user.php'); and session_start();) i got this errors:



Warning: mysqli::query() [function.mysqli-query]: Couldn't fetch mysqli in /home/httpd/html/uss_tyco3/user.php on line 390

Warning: user::get_unita_row() [function.user-get-unita-row]: Couldn't fetch mysqli in /home/httpd/html/uss_tyco3/user.php on line 391

Fatal error: Call to a member function fetch_assoc() on a non-object in /home/httpd/html/uss_tyco3/user.php on line 396

The constructor is:

function __construct ($nick, $pwd)
{
	$conn = new mysqli ("localhost", "****", "*************", "tyco");
	$this->conn = $conn;
	$query = "SELECT * FROM `users` WHERE `nick`='$nick'";
	$res = $conn->query($query);
	if (!$res->num_rows)
	{
		/* The nick isn't registered */
		$this->log("Nick inesistente: $nick");
		return 1;
	}
	$row = $res->fetch_assoc();
	$res->free_result();
	if ($row['password'] != $pwd)
	{
		/* Wrong password */
		$this->log("Password errata, nick: $nick");
		return 2;
	}
	$query = "INSERT INTO `online` (`user`) VALUES ('$nick') ON ";
	$query .= "DUPLICATE KEY UPDATE `time`='".time()."'";
	$conn->query ($query);
	if ($conn->error)
	{
		/* Error in mysql query */
		$this->log($conn->error);
		return FALSE;
	}

	$this->nick = $nick;
	$this->pwd = $pwd;
	$this->admin = (bool)$row['admin'];
	$this->master = (bool)$row['master'];
	$this->log("Login: $nick");
}




The method i'm calling when getting those errors is:

function get_unita_row ()
{
	$query = "SELECT * FROM `unita` WHERE `id`='$this->unita'";
	$res = $this->conn->query($query);
	if ($this->conn->error)
	{
		$this->log($this->conn->error);
		return FALSE;
	}
	$row = $res->fetch_assoc();
	$res->free_result();
	return $row;
}




Any hint?

Thanks,
Stefano
 
 
 --
 Email.it, the professional e-mail, gratis per te: http://www.email.it/f
 
 Sponsor:
 250 biglietti da visita Gratis + 42 modelli e Etichette per Indirizzo Gratis + Porta biglietti Gratis -Offerta limitata!
 Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6782&d=24-7

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php