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 vote114 views1 answer
Wordpress php query randomise
PHP Wordpress
0 vote90 views1 answer
Pusher in laravel array_merge(): Argument #2 is not an array
PHP
0 vote88 views1 answer
Laravel storage save file folder on disk
PHP
0 vote101 views1 answer
Laravel reroute 419
PHP
-1 vote129 views1 answer
Email php using html
PHP
0 vote182 views1 answer
Activerecord yii2 select with limit(start,end) not working
PHP Yii
0 vote88 views2 answers
Php to javascript converter
PHP
19 votes107 views6 answers
Laravel 8 make model with migration and controller
PHP Laravel
4 votes134 views2 answers
Laravel sum column values
PHP
1 vote93 views1 answer
Set subject for mail inlaravel
PHP