Prepared Statement do not return rows even the data is existed

Question

Hello how should I make this work:

I am wondering why when I'm using a prepared statement it doesn't work. I tried using the query method and it works.

Here's what I've tried:

$query = new mysqli('localhost','root', '', 'sample');

$rows = $query->query('SELECT * FROM `sample`.`sample_user` WHERE `userName` = "test" AND `userPass` = "data"');
echo $rows->num_rows; // this returns 1 since I have this record from my database

I'm trying to enhanced it by using a prepared statement :

$query = new mysqli('localhost','root', '', 'sample');
$prepared = $query->prepare('SELECT * FROM `sample`.`sample_user` WHERE `userName` = ? AND `userPass` = ?');

$prepared->bind_param("ss", $userName, $userPass );
$prepared->execute();
echo $prepared->num_rows; //this returns 0

I'm stuck with this issue. Maybe there's something I missed.

Consult the duplicate; there are a few things you didn't do/use. — Funk Forty Niner, Jan 21 '18 at 15:35
what do you mean? I don't understand what you mean by *"can you closed this thread"*. — Funk Forty Niner, Jan 21 '18 at 15:42
I already closed the question with a duplicate where it shows you how to do this correctly. You didn't store nor bound the results. — Funk Forty Niner, Jan 21 '18 at 15:44
Yeah, sorry for that, I thought it works without calling the get_result() — Ricardo Raz, Jan 21 '18 at 15:45
The manual https://secure.php.net/manual/en/mysqli-stmt.get-result.php states => *"MySQL Native Driver Only... Available only with mysqlnd."*. — Funk Forty Niner, Jan 21 '18 at 15:48

score 1 · Answer 1 · answered Jan 21 '18 at 15:35

1

Yeah you need to return the results, binding just bind the query to the params you provide.

 /* Get the result */
 $result = $stmt->get_result();

 /* Get the number of rows */
 $num_of_rows = $result->num_rows;

answered Jan 21 '18 at 15:35

Ahmed Alaa El-Din

1,813
1
16
19

Prepared Statement do not return rows even the data is existed

1 Answers1