/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

2 votes270 views5 answers
Laravel drop table migration
PHP Laravel
6 votes306 views1 answer
Laravel eloquent whereDateBetween
PHP Laravel
3 votes314 views1 answer
Laravel RuntimeException Session store not set on request.
PHP Laravel
0 vote252 views1 answer
Limit wordpress search to title
PHP
0 vote260 views1 answer
How to run database Query in WordPress?
PHP
0 vote252 views1 answer
Php datetime add 1 weeek
PHP
0 vote257 views2 answers
Return html in yajra datatables
PHP
0 vote291 views1 answer
Laravel vendor/laravel/framework/src/Illuminate/View/Compilers/Compiler.php:36
PHP Laravel
0 vote248 views1 answer
Angular post phph
PHP
0 vote250 views1 answer
Laravel showing index of problem
PHP

Share