/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 vote236 views1 answer
Preg_replace rules for php 7.3
PHP
3 votes242 views2 answers
How to check null and empty array in laravel 8
PHP
30 votes232 views6 answers
Laravel auth
PHP
0 vote277 views1 answer
Laravel move/rename file ftp
PHP Laravel
0 vote245 views1 answer
Get the current script file name
PHP
0 vote268 views1 answer
Laravel filter get pagiination does not flter Appending To Pagination Links
PHP Laravel
11 votes238 views4 answers
Redirect back with input laravel in request
PHP
0 vote244 views1 answer
Php language is used for
PHP
0 vote217 views1 answer
2.30 will display 2.3 in php
PHP
0 vote245 views1 answer
Insert views laravel database
PHP Laravel

Share