/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

1 vote158 views2 answers
Wordpress login user programmatically
PHP Wordpress
1 vote141 views1 answer
Digitalocean phpmyadmin 404 not found
PHP
0 vote214 views1 answer
Laravel checkbox checked
PHP Laravel
0 vote145 views3 answers
Php serialize()
PHP
8 votes148 views3 answers
Validate time in laravel
PHP
0 vote155 views1 answer
Cashier mollie
PHP
0 vote195 views1 answer
Laravel random value from array
PHP
0 vote143 views1 answer
Wordpress on publish hook
PHP
1 vote256 views1 answer
Enable cors cakephp
PHP CakePHP
0 vote152 views1 answer
Editing items in collection in laravel
PHP

Share