Affected Rows – MySQLi Functions

Syntax :

Description :

It used to get the information about number of affected rows in a previous MySQL operation like  INSERT, UPDATE ,DELETE , SELECT etc.

For SELECT statements mysqli_affected_rows() is similar to mysqli_num_rows().

Parameter :

• connection – This is a Required parameter. It is a link identifier returned by mysqli_connect() function.

Output :

It will returns below values :

•  -1  indicates that the query returned an error.
• = 0 no records were updated for an UPDATE query , no rows matched the WHERE clause in the query or that no query has been executed yet.
• > 0  indicates the number of rows affected.

 mysqli_affected_rows() –  MySQLi Functions Example in Procedural style  :

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "tutorialmines";
$conn = new mysqli($servername, $username, $password, $dbname);

/* checking connection status */
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected to database successfully. \n";

/* Performing INSERT operation */
$sql = "INSERT INTO employee ( name, salary, age ) VALUES ( 'Emp3', '5000', '23');";
mysqli_query($conn,$sql);
echo "<br>Affected rows after INSERT operation are: " . mysqli_affected_rows($conn);

/* Performing UPDATE operation */
$sql = "UPDATE employee SET salary = '8000' WHERE id = 7;";
mysqli_query($conn,$sql);
echo "<br>Affected rows after UPDATE operation are: " . mysqli_affected_rows($conn);

/* Performing DELETE operation */
$sql = "DELETE FROM employee WHERE id = 7";
mysqli_query($conn,$sql);
echo "<br>Affected rows after DELETE are: " . mysqli_affected_rows($conn);

/* selecting all rows to see effect on affected rows */
$sql = "SELECT * FROM employee";
mysqli_query($conn,$sql);
echo "<br>Affected rows are: " . mysqli_affected_rows($conn);

$conn->close();
?>

Output of above code in the browser is as below: