/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

0 vote457 views1 answer
Laravel one session per user
PHP Laravel
1 vote295 views1 answer
Laravel failed jobs retry
PHP
0 vote297 views1 answer
Joomla redirect
PHP
0 vote388 views1 answer
How to use “find_in_set” in cakephp 3 find method
PHP CakePHP
0 vote295 views1 answer
Codeigniter select where
PHP
6 votes280 views4 answers
Get featured image id wordpress
PHP
0 vote320 views1 answer
Remove repeated columns laravel
PHP Laravel
3 votes312 views2 answers
Clear cache via route laravel
PHP Laravel
17 votes280 views3 answers
Php refresh page without reloading
PHP
46 votes295 views6 answers
Add column to migration laravel
PHP

Share