mysqli prepared statements num_rows

[eMonk]

This keeps returning 0 results. Any ideas?

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

$qry1->store_result();
$result_1 = $qry1->num_rows;

echo $result_1;

[EddyTheDog]

Originally Posted by eMonk

This keeps returning 0 results. Any ideas?

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

$qry1->store_result();
$result_1 = $qry1->num_rows;

echo $result_1;

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

lol - Just kidding - It's a small world...

[valeriyCE]

It has to do with binding arrays that are not declared

$params = array('ss', 'stan', 'Stanley');
$tmp = array();
foreach($params as $key => $value) $tmp[$key] = &$params[$key];
call_user_func_array(array($stmt, 'bind_param'), $tmp);

use this style.

[Dankasaur]

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

$db->store_result();
$result_1 = $db->num_rows;

echo $result_1;

[eMonk]

Originally Posted by EddyTheDog

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

lol - Just kidding - It's a small world...

LOL. Dude, I've been trying to figure this out the past 2 days and no luck.

I've searched google but the sites I checked said to include store_result() which I tried but still 0 results returned.