/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

4 votes349 views4 answers
Multiple middleware laravel
PHP
0 vote297 views2 answers
"codeigniter 4" cart
PHP
0 vote432 views2 answers
Drupal 8 add message
PHP Drupal
0 vote312 views1 answer
Export laravel path fedora
PHP
0 vote301 views4 answers
Php check if all values in array are equal
PHP
0 vote328 views1 answer
Multiple laravel site in one directory
PHP
0 vote310 views1 answer
Show phpinfo just modules
PHP
0 vote505 views1 answer
Download laravel 8 zip
PHP Laravel
0 vote369 views2 answers
Php get last digit of number
PHP
32 votes301 views6 answers
Php if else
PHP

Share