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 vote178 views2 answers
Recaptcha v3 laravel 8
PHP Laravel
0 vote121 views3 answers
Laravel transform object to array
PHP
0 vote206 views1 answer
Installation request for pokemon-tcg/pokemon-tcg-sdk-php ^1.2 -> satisfiable by pokemon-tcg/pokemon-tcg-sdk-php[1.2.0]
PHP
1 vote148 views1 answer
Laravel difference between fill and update
PHP Laravel
1 vote237 views1 answer
Wordpress image text acf
PHP Wordpress
1 vote136 views2 answers
Laravel query builder sum
PHP
3 votes165 views1 answer
Check file size validation laravel
PHP
0 vote135 views1 answer
Wordpress show notice only on plugin page
PHP
21 votes128 views3 answers
Php delete array item by value
PHP
53 votes175 views6 answers
Laravel join
PHP