MYSQLi bind_result返回null [英] MYSQLi bind_result is returning null

问题描述

我试图在查询中输出从数据库中获取的变量，但未返回任何内容.使用MYSQLi准备的语句.

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.

请参见下面的代码:

$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;

我看不到我要去哪里错了?附言:我是刚准备好的声明的新手，所以请放轻松！

I cannot see where I am going wrong? PS I am new to prepared statements so please go easy on me!

推荐答案

您忘记了要获取结果的行. fetch().

you forgetting the line to fetch the result. fetch() .

尝试:

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

这篇关于MYSQLi bind_result返回null的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！