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

2 votes133 views1 answer
Change key with the value php
PHP
5 votes140 views2 answers
Route() and with() in laravel
PHP
0 vote256 views1 answer
ErrorException Undefined index(laravel 7 array helpers)
PHP Laravel
0 vote165 views2 answers
Parse error: syntax error, unexpected 'if' (T_IF) in /opt/lampp/htdocs/testphp.php on line 30
PHP
1 vote134 views1 answer
Php sql connection string
PHP
0 vote145 views1 answer
Acf wp_query custom field
PHP
2 votes188 views2 answers
Last insert id model codeigniter
PHP CodeIgniter
2 votes140 views1 answer
Retrieving a cookie in php
PHP
1 vote153 views2 answers
How to use custom domain name on localhost on linux ubuntu
PHP
0 vote168 views6 answers
Laravel get last id
PHP Laravel