PHP中mysqli_affected_rows作用行数返回值
本文章来给各位同学介绍关于PHP中mysqli_affected_rows作用行数返回值,有需要了解的朋友可参考。
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
}
看下例子:
普通模式
代码如下 | 复制代码 |
$link = mysqli_connect("localhost", "my_user", "my_password", "world"); if (!$link) { /* Insert rows */ mysqli_query($link, "ALTER TABLE Language ADD Status int default 0″); /* update rows */ /* delete rows */ /* select all rows */ mysqli_free_result($result); /* Delete table Language */ /* close connection */ |
oop模式
代码如下 | 复制代码 |
$mysqli = new mysqli("localhost", "my_user", "my_password", "world"); /* check connection */ /* Insert rows */ $mysqli->query("ALTER TABLE Language ADD Status int default 0″); /* update rows */ /* delete rows */ /* select all rows */ $result->close(); /* Delete table Language */ /* close connection */ |

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

In this chapter, we will understand the Environment Variables, General Configuration, Database Configuration and Email Configuration in CakePHP.

PHP 8.4 brings several new features, security improvements, and performance improvements with healthy amounts of feature deprecations and removals. This guide explains how to install PHP 8.4 or upgrade to PHP 8.4 on Ubuntu, Debian, or their derivati

To work with date and time in cakephp4, we are going to make use of the available FrozenTime class.

To work on file upload we are going to use the form helper. Here, is an example for file upload.

In this chapter, we are going to learn the following topics related to routing ?

CakePHP is an open-source framework for PHP. It is intended to make developing, deploying and maintaining applications much easier. CakePHP is based on a MVC-like architecture that is both powerful and easy to grasp. Models, Views, and Controllers gu

Visual Studio Code, also known as VS Code, is a free source code editor — or integrated development environment (IDE) — available for all major operating systems. With a large collection of extensions for many programming languages, VS Code can be c

Validator can be created by adding the following two lines in the controller.
