/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

2 votes172 views2 answers
Laravel get default locale
PHP
0 vote205 views1 answer
Get single row in codeigniter
PHP
29 votes163 views1 answer
Php generate random string fixed length
PHP
0 vote191 views3 answers
Ubuntu update php 7.4 to 8
PHP
0 vote174 views1 answer
Sanitize_text_field
PHP
33 votes193 views5 answers
Php elseif
PHP
0 vote238 views1 answer
Language_attributes for wordpress
PHP
2 votes232 views2 answers
How to make doctrine schema update in symfony 2.8
PHP Symfony
0 vote187 views1 answer
Cake php 2.x joins
PHP
1 vote207 views1 answer
How to use plugin shortcode in wordpress template
PHP

Share