/PHP/Php count result query

Php count result query

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 vote218 views1 answer
Hex to bin php
PHP
2 votes211 views1 answer
Get user ip laravel
PHP
0 vote196 views1 answer
Laravel auth trying to get property 'instid' of non-object
PHP Laravel
0 vote196 views1 answer
Return pdft download and back with msg in laravel
PHP
101 votes219 views6 answers
Php array append
PHP
0 vote179 views1 answer
- the requested php extension ext-intl * is missing from your system. install or enable php's intl extension.
PHP
0 vote201 views6 answers
Convert php to python online
PHP
0 vote224 views1 answer
Post request data not getting from guzzle laravel
PHP
20 votes271 views4 answers
Php all date formats
PHP
1 vote273 views1 answer
Save error cakephp 2
PHP CakePHP

Share