PHP/MySQL Database/mysqli prepare

Result Binding in Prepared Statements

 
<?php
    $mysqli = mysqli_connect("hostname", "user", "pass", "database");
    if(mysqli_connect_errno()) {
        die("Could not connect: ".mysqli_connect_error());
    }
    $query = "SELECT first, last, phone FROM contacts WHERE first LIKE "John%"";
    $stmt = mysqli_prepare($mysqli, $query);
    mysqli_execute($stmt);
    mysqli_stmt_bind_result($stmt, $first, $last, $phone);
    while(($res = mysqli_stmt_fetch($stmt))) {
        echo "First: $first<BR/>\n";
        echo "Last: $last<BR/>\n";
        echo "Phone: $phone<BR/>\n";
    }
    if($res === false) {
        die("An error occurred fetching: ".mysqli_error($mysqli));
    }
    mysqli_stmt_close($stmt);
    mysqli_close($mysqli);
?>