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

2

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.

edited May 23, 2017 at 12:05

CommunityBot

11 silver badge

answered Sep 12, 2013 at 18:45

Jason McCreary

73.3k23 gold badges140 silver badges177 bronze badges

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

Comments

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

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related