/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

1 vote206 views1 answer
Mysqli_query insert in laravel
PHP Laravel
3 votes104 views2 answers
Remove cookies php
PHP
0 vote117 views2 answers
Php number multiple of
PHP
10 votes90 views4 answers
Error logs wp
PHP
0 vote113 views1 answer
Advanced custom fields echo string replace
PHP
0 vote102 views1 answer
Woocommerce product hooks
PHP
0 vote120 views1 answer
Import facade laravel
PHP Laravel
0 vote151 views1 answer
Laravel Excel numbers formatted as text still appearing as number
PHP Laravel
2 votes117 views2 answers
How set variable public in static method in laravel
PHP Laravel
36 votes100 views3 answers
Php current date get
PHP

Share