/PHP/Php count result query

Php count result query

Get count sql query in php

$result=mysql_query("SELECT count(*) as total from Students");
$data=mysql_fetch_assoc($result);
echo $data['total'];

2

Source: stackoverflow.com

Count sql query in php

$sql = "SELECT COUNT(*) AS total from Members";
$result = $conn->query($sql);
$data =  $result->fetch_assoc();
echo $data['total'];

1

Php count result query

PHP Count result

0

Similar codes

1 vote304 views1 answer
Class 'illuminate support facades input' not found laravel 7
PHP
0 vote303 views1 answer
Wordpress get page number
PHP
0 vote343 views1 answer
Make() laravel
PHP Laravel
1 vote451 views1 answer
Symfony get path to route
PHP Symfony
0 vote392 views1 answer
Symfony change php version
PHP Symfony
19 votes345 views5 answers
Php check string
PHP
0 vote314 views1 answer
Explicit Octal numeral notation - PHP 8.1
PHP
-1 vote365 views2 answers
Laravel OrderBy on Eloquent whereHas relationship
PHP Laravel
0 vote301 views1 answer
Php get slug
PHP
7 votes377 views2 answers
If notexists in laravel query
PHP

Share