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 vote303 views1 answer
Laravel model find one
PHP Laravel
1 vote311 views2 answers
Regular expression for strong password in php
PHP
1 vote301 views3 answers
Laravel invoice toturial
PHP Laravel
0 vote279 views5 answers
PHP detect spam name
PHP
0 vote271 views1 answer
Image_lib codeigniter add _thumb
PHP
1 vote312 views1 answer
How can set defult value for yield in laravel
PHP Laravel
13 votes277 views6 answers
Wordpress get user by id
PHP
16 votes300 views2 answers
Php get first character of each word
PHP
1 vote321 views1 answer
How validate if one parameter is exist another parameter must exist in laravel
PHP Laravel
0 vote296 views1 answer
Laravel collection tap
PHP Laravel