duanna1407 2018-02-03 19:23
浏览 100
已采纳

为什么mysqli_affected_rows将链接作为参数而不是查询?

Is there any reason for mysqli_affected_rows takes $link as first parameter instead of query?

example usage for mysqli_num_rows

$con = mysqli_connect(..);
$query = mysqli_query($con, "SELECT * FROM table WHERE id='5'");
echo mysqli_num_rows($query);
//output: 1

example usage for mysqli_affected_rows

$con = mysqli_connect(..);
mysqli_query($con, "UPDATE table SET column='value' WHERE id='5'");
echo mysqli_affected_rows($con);
//output: 1

Shouldn't it be better that mysqli_affected_rows takes $query instead?

  • 写回答

1条回答 默认 最新

  • duanchuan6350 2018-02-03 19:26
    关注

    Because mysqli_num_rows counts the number of the results in the query.

    But mysqli_affected_rows queries the server to get information of the last event.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 Python3.5 相关代码写作
  • ¥20 测距传感器数据手册i2c
  • ¥15 RPA正常跑,cmd输入cookies跑不出来
  • ¥15 求帮我调试一下freefem代码
  • ¥15 matlab代码解决,怎么运行
  • ¥15 R语言Rstudio突然无法启动
  • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
  • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
  • ¥15 用windows做服务的同志有吗
  • ¥60 求一个简单的网页(标签-安全|关键词-上传)