Question

How to gets the number of affected rows in a previous MySQL SQL operation using MySQLi in PHP

Answer 1

$db_host        = 'localhost';
$db_user        = 'root';
$db_password    = '';
$db_name        = 'allonpage';

$con = new mysqli("localhost", $db_user, $db_password , $db_name);

if (mysqli_connect_errno()) 
{
    printf("Connection Error: %s\n", mysqli_connect_error());
    exit();
}

$result = $con->query("SELECT * FROM images");
echo "Affected rows : " . $con->affected_rows;

$result->close();

$con->close();


/*
run: 

Affected rows : 11

*/

 

70+ SQL courses for beginners and professionals