/PHP/Get count sql query in php

Get 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

2 votes345 views1 answer
Laravel create new request
PHP
4 votes347 views5 answers
Php run command line
PHP
0 vote347 views1 answer
Return last inserted id mysql opencart
PHP
4 votes409 views2 answers
Wordpress order by
PHP Wordpress
8 votes314 views4 answers
Laravel set date format
PHP
13 votes463 views2 answers
Wp get logged in user id
PHP Wordpress
5 votes393 views3 answers
Php user ip from post request
PHP
0 vote350 views2 answers
Bigtext migration laravel
PHP Laravel
0 vote347 views1 answer
Livewire pagination bootstrap
PHP
0 vote408 views1 answer
Jpeg nach und nach laden
PHP

Share