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 vote341 views1 answer
Getname eloquent slug laravel
PHP Laravel
1 vote307 views1 answer
Put img in timestamp using php
PHP
0 vote351 views1 answer
Dd function not laravel
PHP Laravel
1 vote386 views1 answer
Wordpress PHPMailer config
PHP
0 vote304 views1 answer
Symfony refresh endpoints
PHP
0 vote337 views1 answer
Php library to convert html to amp
PHP
0 vote335 views1 answer
Age php datetime
PHP
0 vote349 views1 answer
Laravel eloquent select one column in array
PHP Laravel
5 votes350 views3 answers
Enum table in laravel
PHP Laravel
1 vote371 views1 answer
How send parameter with command in laravel
PHP Laravel