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 vote275 views1 answer
Install tymon jwt laravel
PHP Laravel
0 vote221 views1 answer
Laravel collection times
PHP
19 votes214 views3 answers
Php json decoding as string incorrectly
PHP
2 votes245 views2 answers
Access json with php
PHP
0 vote245 views1 answer
Wp functions ajax get
PHP
0 vote284 views1 answer
Wordpress add new page programmatically
PHP Wordpress
32 votes233 views6 answers
Php implode array
PHP
74 votes246 views6 answers
Php string to int
PHP
0 vote280 views1 answer
Laravel telescope redirect to localhost
PHP Laravel
0 vote225 views1 answer
Twig request
PHP