/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

0 vote254 views2 answers
If condition in laravel blade in select option
PHP
0 vote156 views1 answer
Php jquery plus 1 day
PHP
0 vote180 views1 answer
Wordpress set category front end
PHP Wordpress
0 vote163 views1 answer
Dompdf with qr code
PHP
0 vote143 views1 answer
Laravel migration first or model first
PHP Laravel
0 vote169 views6 answers
Create global function laravel
PHP
1 vote164 views2 answers
Php url parse
PHP
0 vote222 views1 answer
Laravel ailed: WebSocket opening handshake was canceled
PHP Laravel
3 votes158 views2 answers
Smarty assign
PHP
0 vote156 views1 answer
Php json pretty print and slash
PHP

Share