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

5 votes115 views4 answers
Php get value from url
PHP
0 vote128 views1 answer
Laravel response download video laravel medialibrary
PHP Laravel
1 vote115 views1 answer
Laravel model increase the value by one
PHP
2 votes116 views2 answers
Laravel eloquent get all where in
PHP
40 votes105 views5 answers
Print date in php
PHP
0 vote186 views1 answer
Check multiple roles with Blade directive @can?
PHP
1 vote136 views1 answer
Laravel iseed
PHP Laravel
0 vote114 views1 answer
Install a package only composer dont update
PHP
0 vote121 views1 answer
Add new colum to existing table
PHP
4 votes118 views4 answers
Chunk in laravel
PHP