PHP中mysqli_affected_rows作用行数返回值分析

int mysqli_affected_rows ( mysqli link )

class mysqli {
int affected_rows
}

<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
 
if (!$link) {
printf("Can't connect to localhost. Error: %sn", mysqli_connect_error());
exit();
}
 
/ Insert rows /
mysqli_query($link, "CREATE TABLE Language SELECT from CountryLanguage");
printf("Affected rows (INSERT): %dn", mysqli_affected_rows($link));
 
mysqli_query($link, "ALTER TABLE Language ADD Status int default 0″);
 
/ update rows /
mysqli_query($link, "UPDATE Language SET Status=1 WHERE Percentage > 50″);
printf("Affected rows (UPDATE): %dn", mysqli_affected_rows($link));
 
/ delete rows /
mysqli_query($link, "DELETE FROM Language WHERE Percentage < 50″);
printf("Affected rows (DELETE): %dn", mysqli_affected_rows($link));
 
/ select all rows /
$result = mysqli_query($link, "SELECT CountryCode FROM Language");
printf("Affected rows (SELECT): %dn", mysqli_affected_rows($link));
 
mysqli_free_result($result);

/ Delete table Language /
mysqli_query($link, "DROP TABLE Language");
 
/ close connection /
mysqli_close($link);
?>

<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
 
/ check connection /
if (mysqli_connect_errno()) {
printf("Connect failed: %sn", mysqli_connect_error());
exit();
}
 
/ Insert rows /
$mysqli->query("CREATE TABLE Language SELECT from CountryLanguage");
printf("Affected rows (INSERT): %dn", $mysqli->affected_rows);
 
$mysqli->query("ALTER TABLE Language ADD Status int default 0″);
 
/ update rows /
$mysqli->query("UPDATE Language SET Status=1 WHERE Percentage > 50″);
printf("Affected rows (UPDATE): %dn", $mysqli->affected_rows);
 
/ delete rows /
$mysqli->query("DELETE FROM Language WHERE Percentage < 50″);
printf("Affected rows (DELETE): %dn", $mysqli->affected_rows);
 
/ select all rows /
$result = $mysqli->query("SELECT CountryCode FROM Language");
printf("Affected rows (SELECT): %dn", $mysqli->affected_rows);
 
$result->close();
 
/ Delete table Language /
$mysqli->query("DROP TABLE Language");
 
/ close connection /
$mysqli->close();
?>