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();