[RESOLVED] Fatal error: Call to a member function query() on a non-object

[Springles]

$queryresult = $this->db->query($sql);

	if ($this->db->fetchArray($queryresult)) {
		$errors[] = "Username already taken";
	}

I get this error:

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

[bradgrafelman]

Sounds like you didn't initialize $this->db with an object, just as the error states.

[Springles]

My curent code, but im still getting the same error.

<?php
include("../sql_information.php");

class infos {

private $sql_initialize;

function login_details() {

	$sql_initialize = new MySQLDatabase();
	$sql_initialize;
	$errors = array();
	$register_password = mysql_real_escape_string($_POST['register_password']);
	$confirm_password = mysql_real_escape_string($_POST['confirm_password']);
	//escape string going to the query
	$register_user_name = mysql_real_escape_string($_POST['register_user_name']);
	$sql = "SELECT 1 FROM data_manager.user_accounts WHERE user_name='$register_user_name'";
	$queryresult = $this->sql_initialize->query($sql);


	if ($this->sql_initialize->fetchArray($queryresult)) {
		$errors[] = "Username already taken";
	}

	if ($register_password !== $confirm_password) {
		$errors[] = "Passwords mismatch";
	}

	if (!$errors) {
		//$register_password = mysql_real_escape_string($register_password);
		$sql = "INSERT INTO `data_manager`.`user_accounts` (`id`, `user_name`, `password`) VALUES (NULL, '$register_user_name', '$register_password')";
		mysql_query($sql);
		print "registered !";
		//header("Location: complete.php");
		exit;
	} else {
		foreach ($errors as $err) echo $err;
	}
}
}
?>

[Springles]

Im getting this error:

Fatal error: Call to a member function query() on a non-object in C:\EasyPHP-5.3.6.0\www\Database Manager\install\registration.php on line 18

[bradgrafelman]

You create a local variable, $sql_initialize, but then later try to reference the attribute $this->sql_initialize, which has never been initialize to anything.

I'm guessing you should get rid of the local variable and simply modify $this->sql_initialize instead.