/PHP/Count sql query in php

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

1 vote139 views1 answer
Laravel refresh server
PHP
1 vote131 views2 answers
How to make active color in menu laravel
PHP Laravel
11 votes127 views4 answers
Install phpmyadmin ubuntu 18.04
PHP
0 vote135 views1 answer
Laravel check if request wantsjson
PHP
0 vote136 views2 answers
Socket io laravel
PHP Laravel
2 votes120 views2 answers
Wpdb get last query
PHP
0 vote126 views1 answer
Convert am pm time to 24 hour in php
PHP
0 vote124 views1 answer
Model find by certain column laravel
PHP
2 votes123 views2 answers
Laravel pagination with get parameters
PHP
6 votes147 views2 answers
Laravel findorfail
PHP Laravel

Share