/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

0 vote188 views1 answer
Text box should accept only alphanumeric not special characters in php
PHP
0 vote174 views1 answer
Dynamic function name php
PHP
0 vote203 views1 answer
Laravel nova card duplicate keys
PHP
1 vote220 views1 answer
Convert php array to javascript json laravel
PHP Laravel
1 vote191 views1 answer
"DROP DATABASE" statements are disabled.
PHP
7 votes272 views2 answers
Laravel migrate fresh and seed
PHP Laravel
0 vote190 views1 answer
Pusher-php-server laravel
PHP
1 vote269 views1 answer
Hobrew switch php
PHP
7 votes225 views2 answers
Turn on php errors
PHP
1 vote178 views2 answers
Wordpress get link to post by id
PHP

Share