/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

8 votes91 views6 answers
Php isset
PHP
5 votes112 views3 answers
Mobile number validation in laravel 8
PHP Laravel
0 vote125 views1 answer
Merge two objects php laravel
PHP Laravel
0 vote100 views1 answer
Wordpress execute query
PHP Wordpress
0 vote100 views1 answer
Argument 1 passed to symfonycomponenthttpfoundationesponse::setcontent() must be of the type string or null, object given, called in
PHP Symfony
0 vote96 views3 answers
Check if any values are the same in an array php
PHP
1 vote87 views1 answer
Symfony call another controller
PHP
0 vote143 views3 answers
Laravel - How to create custom configuration variables and access
PHP
2 votes100 views1 answer
Php switch case multiple values per line
PHP
1 vote100 views3 answers
Function default value
PHP

Share