CODEWITHSUNDEEP
phpsqlexecute
helpmii
helpmii

Reputation: 11

Fatal error: Call to a member function execute() on a non-object

$sql = "UPDATE Student ".
           "SET score = $total_score ".
           "WHERE student_id = $student_id";
    $stmt = $mysqli->prepare($sql);
    $stmt->execute();
    $query = "SELECT faculty_id ".
             "From Student s ".
             "WHERE student_id =$student_id";
    $state =$mysqli->prepare($query);
    $state->execute();
    $state->bind_result($faculty_id);
    if ($state->fetch())
    {if (strpos($faculty_id, '1') > 0) {
            include ('./Registration_Step_3_Student.php');
        } else 
        {
            include ('./Registration_Step_3_Mentor.php');
        }   
    }

So whenever i try to run my second query called $state, i get this error that states it cannot be execute. I am relatively new to SQL and PHP so any help would be appreciated. Thanks!

Upvotes: 0

Views: 5261

Answers (1)

meda
meda

Reputation: 45490

Since you are using mysqli you should learn how to bind properly, please read up on bind_Param

mysqli_stmt::prepare returns an false when failing, you should never execute the statement when it does:

$sql = "UPDATE Student SET score = ? WHERE student_id = ?";
$stmt = $mysqli->prepare($sql);
if($stmt){
    $stmt->bind_param('si', $total_score, $student_id);
    if($stmt->execute()){
        $query = "SELECT faculty_id From `Student s` WHERE student_id = ?";
        $state =$mysqli->prepare($query);
        $stmt->bind_param('i', $student_id);
        if($state->execute()){
            var_dump($state->fetch());
        }else{
            echo 'SELECT failed';
             printf("Error: %s.\n", $state->error);
        }       
    }else{
       echo 'failed to execute UPDATE';
    }
}else{
      echo 'failed to prepare() UPDATE \n';
       printf("Error: %s.\n", $stmt->error);

}

Hope this helps

Upvotes: 1

Related Questions