/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

3 votes340 views5 answers
Laravel delete multiple rows
PHP Laravel
1 vote326 views1 answer
Laravel dusk run failed tests
PHP
35 votes367 views3 answers
Run seeder command in laravel
PHP Laravel
0 vote312 views1 answer
Auto complete order paid2
PHP
0 vote395 views1 answer
Symfony see all make command
PHP Symfony
0 vote351 views1 answer
Envoyer des donnees js a php
PHP
2 votes390 views3 answers
Spartie all user with role get laravel
PHP Laravel
8 votes332 views3 answers
How to check if user is logged in wordpress
PHP
1 vote351 views1 answer
Php uppercase with accent
PHP
2 votes368 views1 answer
Laravel delete relationship data
PHP Laravel

Share