/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

0 vote114 views1 answer
How to validate students who made payment in php and mysql
PHP
0 vote111 views1 answer
Configuration laravel dompdf
PHP Laravel
2 votes101 views1 answer
Php file get content json
PHP
1 vote98 views1 answer
Laravel set field unique
PHP
20 votes111 views4 answers
Laravel where is null
PHP Laravel
0 vote121 views1 answer
Write if and else in one line laravel
PHP Laravel
0 vote98 views1 answer
Upload image with watermark in codeigniter
PHP
2 votes101 views2 answers
Where is php.ini file in ubuntu
PHP
0 vote116 views1 answer
Populate old value of dropdown laravel
PHP Laravel
107 votes260 views6 answers
Php get current date
PHP

Share