/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 votes152 views1 answer
Global laravel request()
PHP
0 vote147 views1 answer
Wp tax_query in
PHP Wordpress
0 vote160 views2 answers
Add blade in blade laravel
PHP Laravel
2 votes201 views2 answers
Laravel date default now
PHP
4 votes166 views2 answers
What sign is less than or equal to php
PHP
1 vote166 views2 answers
Php get array key like
PHP
6 votes183 views5 answers
Laravel collection map
PHP
0 vote138 views1 answer
Diferencias empty() e isset()
PHP
0 vote174 views1 answer
Laravel delete controller still cached
PHP Laravel
10 votes163 views1 answer
Php sort array by subarray value
PHP

Share