/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

3 votes214 views1 answer
Laravel remove controller
PHP
5 votes196 views2 answers
16 digit random password generator php code without function
PHP
0 vote193 views1 answer
Verta sample jalali laravel problem return object
PHP
0 vote206 views1 answer
Serve https with php local
PHP
6 votes195 views4 answers
Laravel get env variable
PHP
0 vote232 views1 answer
How to get meta information from pagination in laravel controller
PHP Laravel
0 vote219 views3 answers
Laravel 'Choice question must have at least 1 choice available.'
PHP Laravel
0 vote206 views1 answer
Populate old value of dropdown laravel
PHP
0 vote238 views2 answers
Laravel eloquent multiple join with where conditions
PHP
0 vote177 views2 answers
Php form detect if number has decimals
PHP

Share