Question

How to get the number of rows in a result query 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 ($con->connect_error) 
    die('Connection Error: ' . $con->server_info);

if ($result = $con->query("SELECT * FROM images")) 
{

    $row_count = $result->num_rows;

    echo $row_count;

    $result->close();
}
                                 
$con->close();


/*
run: 

13  

*/

 

70+ SQL courses for beginners and professionals