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

0 vote116 views1 answer
Increase php_values
PHP
0 vote226 views1 answer
Yii 2 create migration with fields
PHP Yii
44 votes113 views3 answers
Calculate array length in php
PHP
3 votes148 views1 answer
Php curl print status
PHP
11 votes155 views5 answers
Laravel check auth
PHP Laravel
74 votes133 views6 answers
Php string to int
PHP
0 vote136 views1 answer
Php unsupported file types
PHP
13 votes128 views4 answers
Laravel login by id
PHP Laravel
0 vote141 views1 answer
Wordpress admin settings form
PHP Wordpress
0 vote138 views2 answers
Laravel roles and permissions
PHP Laravel