/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

1 vote143 views1 answer
Php get all txt files in directory
PHP
0 vote156 views1 answer
Laravel: get last id
PHP Laravel
2 votes164 views1 answer
Laravel model wherein update
PHP Laravel
0 vote132 views1 answer
Cpanel composer update kill
PHP
0 vote164 views1 answer
Laravel imap - Get message attachments
PHP Laravel
0 vote188 views1 answer
Php auto reset score
PHP
2 votes163 views2 answers
Laravel dropIndex
PHP
0 vote143 views1 answer
Multidimensional session-array
PHP
3 votes111 views3 answers
Php pi
PHP
0 vote151 views1 answer
Dompdf with qr code
PHP

Share