/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

0 vote127 views2 answers
Laravel has one through relationship
PHP
11 votes132 views5 answers
Uuid in laravel
PHP
1 vote129 views3 answers
Php get end date of month
PHP
7 votes129 views4 answers
Laravel blade uppercase
PHP
2 votes129 views2 answers
Php modulus
PHP
0 vote119 views2 answers
Wordpress profile queries
PHP
3 votes155 views2 answers
Create variable in laravel blade
PHP Laravel
0 vote164 views1 answer
How to get yearly chart in laravel
PHP Laravel
8 votes152 views3 answers
Route parameter type laravel
PHP Laravel
8 votes122 views4 answers
Php directory listing
PHP

Share