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

9 votes129 views5 answers
Laravel updateOrInsert
PHP
1 vote166 views2 answers
Laravel observer get old value
PHP
2 votes167 views1 answer
Laravel validate integer between
PHP Laravel
0 vote151 views1 answer
Multe data on database laravel
PHP Laravel
6 votes192 views3 answers
Check the php version in ubuntu
PHP
0 vote140 views1 answer
Why css not working with php file
PHP
0 vote129 views1 answer
PHP Warning: Module 'soap' already loaded in Unknown on line 0
PHP
16 votes127 views2 answers
Allert in php
PHP
0 vote147 views1 answer
How to display the site tagline in wordpress
PHP Wordpress
6 votes145 views2 answers
Laravel check if request has value
PHP