mysqli prepared statements num_rows - GoFuckYourself.com

eMonk · 08-06-2013, 04:52 PM

This keeps returning 0 results. Any ideas?

Code:

$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 · 08-06-2013, 05:02 PM

Quote:

Originally Posted by eMonk

This keeps returning 0 results. Any ideas?

Code:

$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 · 08-06-2013, 05:11 PM

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 · 08-06-2013, 05:13 PM

Code:

$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 · 08-06-2013, 05:19 PM

Quote:

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.

08-06-2013, 05:11 PM	#3
valeriyCE Registered User Industry Role: Join Date: Jul 2013 Posts: 82	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. __________________ Freewebcams.com http://www.freewebcamcash.com/ CrakRevenue - 150Countries+ Best GERMAN CPA Plug Rush Cheapest Traffic .5cpm