/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

7 votes277 views5 answers
Laravel foreach loop index in controller
PHP
12 votes303 views3 answers
Call controller function from another controller laravel
PHP Laravel
0 vote252 views1 answer
Php fpdf in phpmailer
PHP
0 vote241 views1 answer
Tailwindcss - bootstrap - vue - react
PHP
0 vote244 views1 answer
What does defined di in php
PHP
19 votes285 views6 answers
Laravel 8 make model with migration and controller
PHP Laravel
0 vote265 views1 answer
Merge cell collumn phpOffice
PHP
-2 votes260 views2 answers
Call jquery function in php code
PHP
0 vote252 views1 answer
Php file upload code not working in ubuntu
PHP
0 vote261 views2 answers
How to check user already exists in php
PHP

Share