/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

0 vote140 views1 answer
Phpunit bridge vs phpunit
PHP
1 vote146 views1 answer
Php convert hex to rgba
PHP
0 vote157 views1 answer
Laravel throw 503
PHP Laravel
11 votes153 views5 answers
Get count laravel
PHP Laravel
0 vote138 views3 answers
Laravel how to fetch user from user model based on id from post
PHP
0 vote184 views2 answers
Laravel date format valdiate
PHP Laravel
0 vote169 views1 answer
Laravel share
PHP Laravel
0 vote128 views2 answers
Laravel loop variable
PHP
7 votes165 views5 answers
Laravel remove public from url
PHP
0 vote141 views1 answer
Default sort yii2
PHP

Share