/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 vote345 views1 answer
Howto+add+header+bar+laravel+app
PHP
0 vote285 views1 answer
Php setcookie infinite
PHP
0 vote365 views3 answers
Laravel 'Choice question must have at least 1 choice available.'
PHP Laravel
0 vote322 views1 answer
Session flash data (old input)
PHP
14 votes341 views2 answers
Php 3 digit decimal
PHP
0 vote337 views2 answers
Octobercms mail
PHP
0 vote376 views1 answer
Wordpress get the main url
PHP Wordpress
0 vote326 views1 answer
Wordpress get archive title
PHP
0 vote313 views1 answer
Remove images from the the_content()
PHP
32 votes318 views6 answers
Php implode array
PHP

Share