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 vote285 views3 answers
Print query statement in laravel
PHP Laravel
16 votes258 views3 answers
Wp_debug
PHP
40 votes254 views2 answers
$dom->getElementById
PHP
2 votes280 views2 answers
Access json with php
PHP
1 vote270 views2 answers
Laravel return response view
PHP Laravel
0 vote310 views1 answer
List database table rows plugin wordpress
PHP Wordpress
1 vote275 views1 answer
Php numbers from 1 to 100 array
PHP
0 vote325 views1 answer
Laravel eloquent only today
PHP Laravel
1 vote271 views1 answer
Static function model laravel
PHP
9 votes292 views2 answers
A facade root has not been set laravel
PHP