Mysqli for PHP(Data bind)

Mysqli supply with many new features for the php programming,also it's an OOP.

The below example can show you some: databind

$mysqli = new mysqli('localhost', 'aaron', 'xxxxxx', 'amo');

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

$stmt = $mysqli->prepare("INSERT INTO user(name,password)VALUES (?, ?)");
$stmt->bind_param("ss",$name, $password);  # "ss" on behalf of  string(name) string(password)

$name = "KEN";
$password = "121312";

/* execute prepared statement */
$stmt->execute();

printf("%d Row inserted.\n", $stmt->affected_rows);

/* close statement and connection */
$stmt->close();

/* Clean up table CountryLanguage */
$mysqli->query("DELETE FROM USER WHERE NAME='Bavarian'");
printf("%d Row deleted.\n", $mysqli->affected_rows);

/* close connection */
$mysqli->close();