/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

2 votes187 views2 answers
Carbon subdays
PHP
1 vote180 views3 answers
Htaccess php version
PHP
-2 votes164 views4 answers
Codeigniter 3 update
PHP
31 votes211 views6 answers
Make model with migration laravel
PHP Laravel
3 votes180 views3 answers
Php extract zip
PHP
17 votes288 views6 answers
Laravel auth user in constructor
PHP Laravel
0 vote184 views1 answer
Laravel routes return view in web.php
PHP
8 votes175 views1 answer
Php split string along spaces
PHP
0 vote207 views1 answer
Check if column has value in laravel eloquent
PHP Laravel
1 vote175 views3 answers
Php +=
PHP

Share