PHP MySQL Affected Rows | affected_rows | mysqli_affected_rows | Object Oriented | Procedure

Hello guy, today we will learn the affected rows function and it is a function of PHP MySQL. It returns a number of rows that are affected by our query.

The affected_rows / mysqli_affected_rows() function returns the number of affected rows in the previous SELECT, INSERT, UPDATE, REPLACE, or DELETE query. Return Value: The number of rows affected. -1 indicates that the query returned an error. PHP Version: 5+

<?php

//DB connection

include("DB_connection.php");

//::::Object Oriented style::::

$connect -> query("SELECT * FROM students");

//similar use

/*query("INSERT INTO students (column names) value ( values));

OR

update, delete query

*/

$affectedRows = $connect -> affected_rows;

//output

echo "Affected Rows:".$affectedRows;

//close connection

$connect -> close();

//::::Procedural style::::

mysqli_query($connect, "SELECT * FROM students");

echo "Affected rows: " . mysqli_affected_rows($connect);

//close connection

mysqli_close($connect);