/PHP/Count sql query in php

Count sql query in php

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 vote287 views1 answer
Composer Fatal error: Call to undefined function Symfony\Polyfill\Mbstring\iconv() in phar
PHP
1 vote299 views2 answers
How to refresh a php variable without reloading page
PHP
14 votes278 views6 answers
Install php 8 ubuntu
PHP
0 vote300 views2 answers
Laravel-check-if-related-model-exists
PHP
0 vote352 views1 answer
CODEIGNITER codeigniter 4 auth
PHP CodeIgniter
0 vote274 views1 answer
Add like and equal in same query in laravel
PHP
4 votes293 views4 answers
Laravel meta csrf
PHP
10 votes328 views2 answers
Try and catch laravel
PHP Laravel
18 votes269 views4 answers
Carbon time laravel
PHP
0 vote291 views2 answers
Php send values in $_SESSION to other page
PHP

Share