/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

1 vote201 views1 answer
Get random posts wordpress
PHP
26 votes201 views4 answers
Where is cache file in laravel
PHP Laravel
2 votes161 views2 answers
Php modulus
PHP
0 vote122 views1 answer
Php pcntl
PHP
0 vote192 views1 answer
Laravel collection median
PHP Laravel
5 votes195 views6 answers
Csrf token laravel
PHP Laravel
0 vote177 views1 answer
Wordpress get all published post
PHP Wordpress
0 vote245 views2 answers
Codeigniter 4 db seed
PHP
0 vote154 views1 answer
What is carriage return in php
PHP
3 votes166 views1 answer
Install all necessary php packages for laravel
PHP

Share