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

3 votes107 views3 answers
Php remove everything after symbol
PHP
1 vote130 views1 answer
Run laravel mix
PHP Laravel
1 vote144 views1 answer
Laravel get extension from url
PHP Laravel
0 vote113 views1 answer
Wordpress check shortcode exists
PHP Wordpress
0 vote112 views1 answer
Downgrade php version vagrant
PHP
1 vote130 views1 answer
Laravel select all except some columns
PHP Laravel
22 votes124 views5 answers
Update or insert in laravel
PHP
1 vote121 views4 answers
In_array validation laravel
PHP Laravel
0 vote135 views1 answer
Laravel get relation camelcase api
PHP Laravel
0 vote116 views1 answer
Laravel carbon first day of month
PHP Laravel