Prepared Statement - Row as array()

[malikah]

Just wondering how to get the whole row as an array in the following prepared statement:

 

function verifyUsernameAndPass($un, $pw)
{
$query = "SELECT * FROM login WHERE user = ? AND pass = ? LIMIT 1";

if($stmt = $this->conn->prepare($query))
{
	$stmt->bind_param('ss', $un, $pw);
	$stmt->execute();

	if($stmt->fetch())
	{
		$stmt->close();
		return true;
	}
}
}

[Daniel0]

http://php.net/manual/en/mysqli-stmt.bind-result.php

[malikah]

http://php.net/manual/en/mysqli-stmt.bind-result.php

 

Yea, already been there - nothing I try will put the row into an array. I've tried putting one of the array() variables into a $_SESSION[] variable but it comes back as blank..

[Daniel0]

Well, then maybe show the code using that method so we can tell you what you're doing wrong.