Drew C King

<?php
    $db = new mysqli("localhost", "db_username", "db_password", "db_name");
 
    if (mysqli_connect_errno()) 
    {
        die("Connect failed: " . mysqli_connect_error());
    }
 
    // some relatively simple SQL
    // ...update a user's info
    $username = "dcking";
    $age = 28;
    $email = "drew@drewcking.com";
 
 
    $sql = "UPDATE user SET email = ?, age = ? WHERE username = ?";
 
    if ($stmt = $db->prepare($sql)) 
    {
        $stmt->bind_param("sis", $email, $age, $username);
        $stmt->execute();
 
        echo "User records updated: " . $stmt->affected_rows;
 
        $stmt->close();
    }
    else
    {
        die("Could not prepare SQL statement: $sql");
    }
 
    $mysqli->close();
?>