/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

1 vote251 views2 answers
Laravel collection isNotEmpty
PHP Laravel
5 votes244 views1 answer
Php psr4
PHP
3 votes248 views5 answers
How to create slug in laravel
PHP
0 vote319 views1 answer
How to select and deselect all items without use name in laravel
PHP Laravel
0 vote265 views1 answer
Add query string to url laravel
PHP Laravel
0 vote317 views1 answer
Symfony change php version
PHP Symfony
0 vote258 views2 answers
Laravel livewire-datatable delete column pop up issue
PHP
0 vote247 views1 answer
Php remove nbsp from string
PHP
7 votes268 views2 answers
Last recode of DB using laravel
PHP Laravel
0 vote258 views2 answers
How to link external php file to html
PHP

Share