pdo/prepared语句结果错误

ncgqoxb0  于 2021-06-21  发布在  Mysql
关注(0)|答案(0)|浏览(239)

我有下面的代码,我正试图获得一个数组中的一行数据。我不确定我是否把准备好的声明和pdo混在一起了。
我得到以下错误:

Uncaught Error: Cannot use object of type mysqli_stmt as array in...

代码:

// Prepare a select statement
 $sql = "SELECT * FROM pupils WHERE pupil_id = ?";

 if($stmt = $mysqli->prepare($sql)){
     // Bind variables to the prepared statement as parameters
     $stmt->bind_param("i", $param_pupil_id);
     // Set parameters

     $param_pupil_id = $_POST['pupil_num'];
   // Attempt to execute the prepared statement

     if($stmt->execute()){

      $stmt->store_result(); 

         if($stmt->num_rows == 1){   

           $stmt->bind_result($id, $pupil_id, $name, $eal, $pp);
//Updated code
           echo $stmt->fetch()->$name;

         } else{
             echo "error";
         }
     } else{
         echo "Oops! Something went wrong. Please try again later.";
     }
 }

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题