/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

0 vote149 views1 answer
Handling deadlocks laravel
PHP
0 vote188 views1 answer
Laravel seeding with relationships
PHP Laravel
0 vote178 views1 answer
Wordpress disallow_file_edit
PHP Wordpress
1 vote196 views2 answers
Explode function in laravel
PHP Laravel
0 vote303 views1 answer
Show sender name laravel
PHP Laravel
6 votes210 views3 answers
Laravel ide helper
PHP Laravel
3 votes228 views6 answers
Jwt for Laravel
PHP
0 vote160 views1 answer
Throws php
PHP
2 votes238 views3 answers
Create new user fortify action how it work laravel 8
PHP Laravel
-4 votes219 views1 answer
Apache/2.4.52 (win64) openssl/1.1.1m php/8.1.2 server at localhost port 80
PHP

Share