CODEWITHSUNDEEP
phpmysqliprepared-statement
user3170837
user3170837

Reputation: 141

MYSQLi bind_result is returning null

I am trying to output the variables that I get from the database in my query but nothing is being returned. Using MYSQLi prepared statements.

Please see code below:

$stmt = $con->prepare("SELECT first_name, last_name FROM transactions WHERE order_id = ?");
$stmt->bind_param('i', $order_id);
$stmt->execute(); 
$stmt->store_result();
$stmt->bind_result($first_name, $last_name);
$stmt->close();


// Output review live to page 
echo $first_name;

Where am I going wrong?

Upvotes: 5

Views: 2467

Answers (1)

echo_Me
echo_Me

Reputation: 37233

You forgot the line to fetch the result. fetch().

Try that:

  $stmt->bind_result($first_name, $last_name);
  $stmt->fetch();  // ----- > you forget that line to fetch results.
  $stmt->close();

Upvotes: 11

Related Questions