mysqli_affected_rows() 函数

zhgc

mysqli_affected_rows() 函数

1. <?php
   
2. // 假定数据库用户名：root，密码：123456，数据库：RUNOOB
   
3. $con=mysqli_connect("localhost","root","123456","RUNOOB");
   
4. if (mysqli_connect_errno($con))
   
5. {
   
6.     echo "连接 MySQL 失败: " . mysqli_connect_error();
   
7. }
   
8. 
   
9. // 执行查询并输出受影响的行数
   
10. mysqli_query($con,"SELECT * FROM websites");
    
11. echo "受影响的行数: " . mysqli_affected_rows($con);
    
12. 
    
13. echo "<br>";
    
14. 
    
15. mysqli_query($con,"DELETE FROM websites WHERE alexa>1000");
    
16. echo "受影响的行数: " . mysqli_affected_rows($con);
    
17. 
    
18. mysqli_close($con);
    
19. ?>

复制代码