/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

0 vote335 views1 answer
Modifier laravel migration to add a comment a column (MySQL/PostgreSQL)
PHP Laravel
0 vote285 views1 answer
Php preg_match html cross origin
PHP
0 vote272 views1 answer
Php?gs=3
PHP
0 vote326 views1 answer
Wp show logo
PHP Wordpress
0 vote272 views2 answers
Remove php 8 in ubuntu
PHP
49 votes292 views6 answers
Laravel migrate seed
PHP
0 vote291 views6 answers
Hash password decrypt laravel
PHP Laravel
0 vote264 views1 answer
Laravel faker realtext
PHP
0 vote345 views1 answer
Run laravel localhost network
PHP Laravel
0 vote271 views1 answer
Laravel favicon
PHP

Share