Mysqli Fetch

[mostafatalebi]

Hello everybody

I have a question regarding my mysqli fetch() command. What does is do?

as the name suggest it fetches some information. I know this.

 

///////////////////////////////////////////////////////////////////////

But why in such circumstance it is not used:

(Loging in user)

 

$stmt = $mysqli_variable->prepare("SELECT * FROM users WHERE username=$user AND password=$pass");

$stmt->execute();

$stmt->store_result();

$stmt->close();

 

////////////////////////////////////////////////////////////////////

 

(for storing the ID of currently logged user)[changed areas are in red]

While in here we have it:

 

$stmt = $mysqli_variable->prepare("SELECT id FROM users WHERE username=$user AND password=$pass");

$stmt->execute();

$stmt->bind_result($id);

$stmt->fetch(); /// Why here we have fetch and in above script we don't have?

$stmt->close();

[Barand]

RTFM

http://uk3.php.net/manual/en/mysqli-stmt.fetch.php