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

3 votes159 views2 answers
Laravel where condition on relationship
PHP Laravel
1 vote141 views2 answers
Php string replace space
PHP
7 votes134 views1 answer
Php configuration
PHP
14 votes191 views4 answers
Php get index of string
PHP
1 vote137 views1 answer
Highlight search text in php
PHP
26 votes145 views6 answers
Php validate email
PHP
2 votes144 views2 answers
Laravel migration remove unique
PHP
46 votes231 views3 answers
How to check laravel version in cmd
PHP Laravel
3 votes150 views3 answers
Url in laravel
PHP
1 vote137 views1 answer
Convert any phone number in us number format php
PHP