/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

11 votes292 views3 answers
Laravel get last month records
PHP Laravel
0 vote283 views2 answers
Laravel form put method
PHP Laravel
1 vote233 views3 answers
Logout in php
PHP
0 vote264 views1 answer
Andebol
PHP
0 vote204 views1 answer
Php list directories only
PHP
1 vote351 views1 answer
Autoload file in laravel
PHP Laravel
7 votes276 views2 answers
Php one line if without else
PHP
16 votes286 views2 answers
How to fetch data from database in php
PHP
0 vote293 views1 answer
Phpexcel rangetoarray date format
PHP
0 vote234 views1 answer
Php date('d') is one day behind
PHP

Share