/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

0 vote123 views1 answer
Send notification php to PC
PHP
1 vote114 views3 answers
Instamojo payment gateway integration in php
PHP
6 votes140 views1 answer
Laravel Route::group definition
PHP Laravel
0 vote120 views1 answer
Laravel search and return record with pagination
PHP
3 votes153 views2 answers
Phpmailer send attachment
PHP
0 vote146 views1 answer
Codeigniter update or create
PHP
22 votes132 views3 answers
Whats the difference between using date function and DATETime in php
PHP
7 votes159 views3 answers
Laravel migration seed fresh
PHP Laravel
2 votes138 views6 answers
Get last id in laravel
PHP
2 votes109 views2 answers
Wordpress activate plugin
PHP

Share