预处理语句SELECT在非对象上调用成员函数fetch_assoc（）

Question

I'm trying to fetch the database with a prepared statement, but I get a "Call to a member function fetch_assoc() on a non-object " error.

What am I doing wrong?

Thanks for your help!!

$peopleID = $_GET['peopleID'];  
$stmt = $link->prepare("SELECT * FROM people WHERE peopleID = ?");
$stmt->bind_param('i', $peopleID);


$result = $stmt->execute();
$stmt->store_result();

if ($stmt->num_rows >= "1") { 
while($row = $result->fetch_assoc()) {
    $firstname = $row ['firstname'];
    $lastname = $row ['lastname'];
}
}

Answer 1

mysqli_stmt::execute() returns a bool (true/false), not a mysqli_result.
Since php 5.3 you can use mysqli_stmt::get_result to get the mysqli_result from a statement instance.

$stmt = $link->prepare("SELECT * FROM people WHERE peopleID = ?");
if ( !$stmt ) {
    yourErrorHandler();
}
else if ( !$stmt->bind_param('i', $_GET['peopleID']) ) {
    yourErrorHandler();
}
else if ( !$stmt->execute() ) {
    yourErrorHandler();
}
else {
    $result = $stmt->get_result();


    ...
}