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 vote169 views1 answer
Generate a unique id
PHP
1 vote164 views1 answer
Create and download text file in php
PHP
0 vote199 views1 answer
Laravel face-auth
PHP Laravel
0 vote164 views1 answer
Php filter non utf-8 characters
PHP
0 vote199 views2 answers
Maatwebsite/excel package 5.2 laravel
PHP Laravel
0 vote235 views1 answer
WordPress oEmbed Funktion abschalten
PHP Wordpress
0 vote213 views1 answer
Laravel new project command doesn't create vendor
PHP Laravel
0 vote165 views1 answer
How pass optional route parameter in laravel
PHP
6 votes213 views2 answers
Laravel 6 get user id
PHP Laravel
2 votes199 views1 answer
You can also run `php --ini` in a terminal to see which files are used by PHP in CLI mode. Alternatively, you can run Composer with `--ignore-platform-req=ext-mb
PHP