Storing MySQL data in variables in PHP

Question

I'm in the process of making a forum, I'm trying to take values from a MySQL and put them in the $f_id, $f_name, $f_desc and $f_date" variables. It's not working for some reason:

<?php session_start(); require"db_connect.php"; $sql = "SELECT forum_id, forum_name, forum_desc, forum_date FROM forum_tbl"; if ($query = $db->prepare($sql)){ $query->bind_result($f_id, $f_name, $f_desc, $f_date); $query->execute(); }else{ echo $db->error; } ?>

And the contents of connect.php:

<?php $db = new mysql("DOMAIN","USERNAME","PASSWORD") or die ("ERROR"); ?>

Are any error messages displayed? When you say "It's not working" what do you mean exactly? What indicates that its not working? — Lumberjack
– Lumberjack, Commented Sep 12, 2013 at 18:43

Community · Accepted Answer · 2017-05-23 12:05:12Z

You have a few issues.

As answered by Ridz, it's not mysql it's mysqli.
You need to call execute() before bind_result()

You are not fetching your results.

if ($query = $db->prepare($sql)){ $query->execute(); $query->bind_result($f_id, $f_name, $f_desc, $f_date); } // fetch results while ($query->fetch()) { echo $f_id, $f_name, $f_desc, $f_date; }

Welcome to StackOverflow.

Ridz · Accepted Answer · 2013-09-12 18:40:50Z

1

bind_result is a mysqli function.

$db = new mysqli("DOMAIN","USERNAME","PASSWORD") or die ("ERROR");

answered Sep 12, 2013 at 18:40

Ridz

4071 gold badge6 silver badges16 bronze badges

1 Comment

Jason McCreary Over a year ago

+ this is at least part of the problem.

Collectives™ on Stack Overflow

Storing MySQL data in variables in PHP

2 Answers 2

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Related