/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

10 votes385 views2 answers
ForeignId in laravel
PHP Laravel
0 vote319 views1 answer
Wordpress post types supports thumbnail
PHP
1 vote268 views1 answer
Laravel find or skip
PHP
0 vote380 views2 answers
Access paginator object attribute in laravel
PHP Laravel
2 votes339 views2 answers
If post php
PHP
4 votes304 views3 answers
Composer detected issues in your platform: your composer dependencies require the following php extensions to be installed: xml
PHP
2 votes336 views2 answers
Carbon subdays
PHP
0 vote329 views1 answer
Auth log out laravel
PHP
0 vote490 views1 answer
Yii form custom label
PHP Yii
4 votes299 views2 answers
Define in php
PHP

Share