/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

8 votes189 views6 answers
Command not found: laravel
PHP
22 votes180 views4 answers
Php secure password hash
PHP
0 vote178 views1 answer
Php stmt prepare error
PHP
0 vote177 views1 answer
Laravel replace white space with dash
PHP
0 vote185 views1 answer
Refresh database tables yii 1
PHP
0 vote214 views5 answers
Get recoed between two datetime laravel
PHP
0 vote235 views4 answers
Laravel get last created id
PHP Laravel
28 votes146 views12 answers
Laravel middleware
PHP
0 vote292 views1 answer
Modal align center yii2
PHP Yii
0 vote163 views2 answers
Get taxonomies
PHP

Share