/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

17 votes344 views6 answers
Update query laravel
PHP Laravel
1 vote333 views1 answer
Paystack gateway integration laravel
PHP Laravel
1 vote314 views2 answers
Get duplicate value from array php
PHP
4 votes297 views3 answers
Switch in laravel
PHP
0 vote454 views1 answer
Yii2 gridview action change urls
PHP Yii
3 votes319 views6 answers
Laravel find query
PHP Laravel
0 vote306 views1 answer
Php 8 Match Expression / Switch Case
PHP
0 vote300 views1 answer
Php call method from another class
PHP
2 votes309 views2 answers
Laravel foreach first
PHP
7 votes312 views6 answers
Get params from url php
PHP

Share