/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 vote206 views1 answer
$request laravel undefined inside function query
PHP
1 vote266 views3 answers
Create new laravel project with specific version
PHP Laravel
11 votes182 views3 answers
Change date format php
PHP
0 vote193 views1 answer
Blade loop last
PHP
0 vote183 views1 answer
Php connection mysqli database
PHP
16 votes253 views4 answers
Carbon diffforhumans
PHP
0 vote191 views1 answer
How to use custome functions in laravel
PHP
62 votes554 views6 answers
Clear cache laravel
PHP Laravel
0 vote223 views2 answers
Laravel collection remove duplicates
PHP Laravel
0 vote180 views1 answer
Docker compose php
PHP

Share