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
    // ...remove a specific user record
    $id = 123;
 
    $sql = "DELETE user WHERE id = ? LIMIT 1";
 
    if ($stmt = $db->prepare($sql)) 
    {
        $stmt->bind_param("i", $id);
        $stmt->execute();
 
        echo "Number of user records deleted: " . $stmt->affected_rows;
 
        // clean up your mess!
        $stmt->close();
    }
    else
    {
        die("Could not prepare SQL statement: $sql");
    }
 
    $mysqli->close();
?>