1. 返回匹配的行数
2. 返回影响的行数
默认情况下mysqli_affected_rows返回的值为影响的行数,如果我们需要返回匹配的行数,可以使用mysqli_real_connect函数进行数据库连接的初始化,并在函数的flag参数位加上:
mysqli_client_found_rows return number of matched rows, not the number of 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);
?>
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!!
点击进行留言回复
网友评论