bind_result

[eMonk]

What am I doing wrong in the code below? 

$qry1 = $db->prepare("SELECT id FROM user WHERE username = ? AND password = ?");
$qry1->bind_param('ss', $_GET['username'], sha1($_GET['password']));
$qry1->execute(); 

$db->bind_result($result_1);

Fatal error: Call to undefined method mysqli::bind_result()

[mac_gyver]

that's because ->bind_result() is a method of the mysqli_stmt class. it's not a method of the mysqli class.

[eMonk]

I'm trying this now but still getting an error:

 

Fatal error: Call to undefined method mysqli_stmt::get_result()

$result_1 = $qry1->get_result();

I'm new to mysqli prepared statements been reading about it online and in my php book but can't seem to figure this part out?

[mac_gyver]

i recommend you make use of the php.net documentation. there are examples and conditions/limitations listed in the documentation.

 

a) why did you switch from using ->bind_result()?

 

b) there's a very specific restriction for when ->get_result() is available -

 

MySQL Native Driver Only

Available only with mysqlnd.