Php 7 count result in database

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$link = mysqli_connect("host", "username", "password","db_name");
mysqli_set_charset($link, "utf8mb4");

$result = mysqli_query($link, "SELECT count(*) FROM blackandwhite");
$num_rows = mysqli_fetch_row($result)[0];

echo "$num_rows Rows\n";

Source: stackoverflow.com

Php count result query

PHP Count result

Similar codes

0 vote318 views1 answer
Wordpress featured image as a background image
PHP
4 votes356 views3 answers
Laravel restore soft delete
PHP Laravel
1 vote376 views1 answer
Php artisan cache:clear Failed to clear cache. Make sure you have the appropiate permissions
PHP
8 votes332 views4 answers
Php directory listing
PHP
45 votes331 views6 answers
Laravel outer join
PHP
3 votes325 views1 answer
Laravel eager loading where clause
PHP
-1 vote366 views1 answer
Laravel orderby with relation
PHP Laravel
0 vote360 views2 answers
New static laravel
PHP Laravel
0 vote381 views1 answer
How to add a additional condition in a join using query builder laravel 5.3?
PHP Laravel
1 vote329 views1 answer
Laravel query get big table records
PHP