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 vote197 views1 answer
Laravel: Session message exist while click on browser back button
PHP Laravel
0 vote200 views1 answer
Laravel group concat values showing duplicate
PHP Laravel
0 vote255 views1 answer
Laravel max length format
PHP
0 vote231 views1 answer
How do i implement blockchain payments on laravel website
PHP Laravel
0 vote175 views1 answer
Php extract number from string without comma
PHP
8 votes169 views3 answers
Delay in php
PHP
0 vote180 views1 answer
Can i do a relation between 2 coulnm in mongodb laravel
PHP
0 vote176 views1 answer
Get the matched value from 2 array in php
PHP
0 vote296 views1 answer
How to add watermark in FPDF PHP - Parte 2
PHP
0 vote201 views2 answers
How make custom menu in wordpress
PHP Wordpress