/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 vote108 views1 answer
Get the number of affected rows in php using pdo update statement
PHP
0 vote102 views3 answers
Add ACF to single.php
PHP
1 vote111 views4 answers
Laravel unique id
PHP
0 vote124 views1 answer
Bulk write mongodb php
PHP
76 votes141 views5 answers
Php show error
PHP
2 votes109 views1 answer
Carbon time ago laravel
PHP Laravel
3 votes66 views3 answers
Php artisan make services
PHP Laravel
1 vote105 views1 answer
Php artisan add row in table
PHP
0 vote93 views2 answers
Get wordpress page link by id
PHP
-1 vote92 views3 answers
Unsplash php api
PHP

Share