While loop PHP get_result not working

Question

I am trying to get rows from the database using MySQl prepared statements and get result. However this is not working.

Please can someone see where I am going wrong? I have been trying solutions for hours but I can't get it to work. The page just doesn't load as if the query has failed.

 $tag = trim($_GET['tag']);

 $stmt = $mysqli->prepare('SELECT posts.* FROM tags JOIN posts ON posts.id = tags.post_id WHERE tag = ?');
 $stmt->bind_param('s', $tag);
 $stmt->execute();
 $stmt->store_result();
 $result = $stmt->get_result();

 while ($row = $result->fetch_assoc()) {

     echo $row['tag'];

 }      

 $stmt->free_result();
 $stmt->close();

Have you checked that your query is getting results?

i alarmed alien
– i alarmed alien

2014-10-04 20:58:40 +00:00
Commented Oct 4, 2014 at 20:58 — i alarmed alien
– i alarmed alien, Commented Oct 4, 2014 at 20:58
Yes it is returning 4 rows

David
– David

2014-10-04 21:42:59 +00:00
Commented Oct 4, 2014 at 21:42 — David
– David, Commented Oct 4, 2014 at 21:42

Community · Accepted Answer · 2023-11-17 20:33:26Z

1

Try this:

$stmt = $mysqli->prepare('SELECT posts.id FROM tags JOIN posts ON posts.id = tags.post_id WHERE tag = ?');

...

$stmt->bind_result($id);    

while ($stmt->fetch()) {

    // var_dump entire row to ensure the key you expect is avail
    var_dump($id);

}

Upate

If you want to do a select *, vs having to specify EVERY column individually, check out this post (not the accepted answer, but the highest scoring answer). Otherwise I strongly urge you to check out PDO, as it makes these basic read ops much easier.

edited Nov 17, 2023 at 20:33

CommunityBot

11 silver badge

answered Oct 4, 2014 at 21:51

Mike Purcell

20k10 gold badges54 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Mike Purcell Over a year ago

Notice the correction, should be $stmt in the while loop, not $result

David Over a year ago

The query now does return results. However nothing comes out in the var_dump function

Mike Purcell Over a year ago

Ok, corrected code, you are using mysqli api, which you should consider as deprecated, and use PDO instead. Notice in the query you have to specify the column you are selecting, so you can correctly bind the result after. More info @ us2.php.net/manual/en/mysqli-stmt.bind-result.php

David Over a year ago

That works now, thank you! Would there be a way to achieve this using $stmt->get_result() though incase I needed to search posts.* to gather all variables?

Collectives™ on Stack Overflow

While loop PHP get_result not working

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related