加入收藏 | 设为首页 | 会员中心 | 我要投稿 广州站长网 (https://www.020zz.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 站长学院 > PHP教程 > 正文

PHP里mysqli_affected_rows作用行数返回值

发布时间:2022-02-18 06:29:57 所属栏目:PHP教程 来源:互联网
导读:mysqli中关于update操作影响的行数可以有两种返回形式: 1. 返回匹配的行数 2. 返回影响的行数 默认情况下mysqli_affected_rows返回的值为影响的行数,如果我们需要返回匹配的行数,可以使用mysqli_real_connect函数进行数据库连接的初始化,并在函数的flag参
  mysqli中关于update操作影响的行数可以有两种返回形式:
 
  1. 返回匹配的行数 2. 返回影响的行数
 
  默认情况下mysqli_affected_rows返回的值为影响的行数,如果我们需要返回匹配的行数,可以使用mysqli_real_connect函数进行数据库连接的初始化,并在函数的flag参数位加上:
 
  MYSQLI_CLIENT_FOUND_ROWS return number of matched rows, not the number of affected rows
 
  普通格式:
 
  int mysqli_affected_rows ( mysqli link )
  oop格式:
  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);
  //开源代码Cuoxin.com
  /* Delete table Language */
  mysqli_query($link, "DROP TABLE Language");
  
  /* close connection */
  mysqli_close($link);
  ?>
  oop模式,代码如下:
 
  <?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();
  ?>
 

(编辑:广州站长网)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    热点阅读