/PHP/Get count sql query in php

Get 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 vote200 views1 answer
Définir un nombre maximum de mots sur les titres des publications WordPress
PHP
1 vote190 views2 answers
Laravel sail alias
PHP Laravel
0 vote160 views1 answer
View-source.https//moodle.alaqsa.edu.ps/mod/quiz/review.php
PHP
0 vote183 views3 answers
@parent laravel
PHP
19 votes150 views4 answers
Remove first letter php
PHP
6 votes163 views3 answers
Eloquent relationships
PHP
1 vote230 views2 answers
Add filter in wordpress
PHP Wordpress
0 vote187 views1 answer
Push to aws instance ssh without using laravel
PHP Laravel
2 votes142 views2 answers
In PackageManifest.php line 131: Undefined index: name laravel 7
PHP
0 vote181 views1 answer
Laravel validate form data unique array
PHP Laravel

Share