/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

24 votes301 views6 answers
Laravel get auth user id
PHP
0 vote307 views1 answer
Sass download for windows
PHP
3 votes249 views2 answers
Set image asset path in laravel
PHP
14 votes235 views4 answers
Php get index of string
PHP
9 votes288 views6 answers
Laravel validation custom message
PHP Laravel
1 vote288 views1 answer
Php artisan cache:clear Failed to clear cache. Make sure you have the appropiate permissions
PHP
11 votes271 views3 answers
Remove package in laravel
PHP Laravel
6 votes243 views4 answers
Php check if string is integer
PHP
0 vote244 views1 answer
Php pass variable to anonymous function
PHP
-1 vote295 views2 answers
Elvis operator php
PHP

Share