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 vote287 views1 answer
Drupal 8 show php errors settings.php
PHP Drupal
0 vote242 views1 answer
Import class route laravel
PHP Laravel
8 votes215 views3 answers
Validate time in laravel
PHP
104 votes341 views6 answers
Php append to array
PHP
0 vote228 views1 answer
Function to find total number of students in wplms
PHP
0 vote261 views1 answer
Wordpress navigation link classes
PHP
5 votes272 views1 answer
Eloquent chunk laravel model chunk
PHP Laravel
0 vote261 views4 answers
Date format change in laravel blade
PHP Laravel
8 votes205 views1 answer
Get all routes laravel
PHP
22 votes235 views6 answers
Php get url
PHP