/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

0 vote108 views1 answer
Update session laravel
PHP
0 vote176 views1 answer
Laravel where 2 column
PHP Laravel
51 votes259 views6 answers
Create model with controller laravel
PHP Laravel
5 votes136 views1 answer
Redirect wordpress
PHP Wordpress
0 vote111 views1 answer
Php isset tableau
PHP
2 votes112 views1 answer
Php get current url host
PHP
0 vote123 views1 answer
$this meaning in codeigniter
PHP
1 vote138 views1 answer
How to add an custom error to validater error in laravel
PHP Laravel
-1 vote118 views3 answers
Grouping route in laravel
PHP Laravel
9 votes116 views3 answers
Uninstall phpmyadmin
PHP

Share