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 vote171 views2 answers
New static laravel
PHP Laravel
1 vote196 views1 answer
Laravel validation required_if one parameter exist
PHP Laravel
2 votes143 views1 answer
Your composer dependencies require a php version ">= 7.3.0"
PHP
0 vote210 views1 answer
Get slogan wp
PHP Wordpress
1 vote154 views1 answer
Send mail infinityfree phpmailer
PHP
0 vote169 views1 answer
Laravel 6 use username instead of id
PHP
1 vote164 views1 answer
Php debug telegram bot
PHP
0 vote153 views1 answer
WP_Query
PHP
0 vote159 views2 answers
Convert string to array laravel
PHP
0 vote177 views1 answer
Laravel firstorcreate usage
PHP