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 vote210 views1 answer
Symfony 5 server start php bin cosleole
PHP Symfony
0 vote110 views1 answer
Ttl jwt
PHP
0 vote105 views1 answer
Phpmailer add reply to
PHP
0 vote89 views2 answers
Sage theme get template
PHP
1 vote111 views1 answer
Php sql last 10 rows
PHP
1 vote101 views1 answer
Get specific columns using with() function in laravel eloquent
PHP
8 votes101 views2 answers
Php find differences between two arrays
PHP
2 votes108 views2 answers
Setinterval php
PHP
3 votes109 views2 answers
Wordpress logout to home page
PHP
2 votes108 views2 answers
Get session id in laravel
PHP