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

1 vote202 views2 answers
How add field to table by another migration in laravel
PHP
3 votes199 views2 answers
Tcpdf Array and string offset access syntax with curly braces is deprecated
PHP
0 vote207 views1 answer
Php subtract seconds from datetime
PHP
2 votes197 views1 answer
15000 tl to usd
PHP
0 vote222 views2 answers
Laravel pdf export
PHP Laravel
5 votes222 views2 answers
Laravel print exception message
PHP Laravel
0 vote220 views1 answer
24 hours date format php
PHP
0 vote209 views1 answer
Php send 204
PHP
2 votes214 views2 answers
Setinterval php
PHP
30 votes232 views6 answers
Php sessions
PHP