/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

6 votes175 views2 answers
Create migration model and seeder laravel at once
PHP Laravel
3 votes185 views4 answers
Mac os change the php verison
PHP
7 votes168 views1 answer
Laravel if syntax
PHP
0 vote176 views2 answers
Gate and policy in laravel
PHP
0 vote183 views1 answer
Symfony\Component\HttpKernel\Exception\NotFoundHttpException: POST http://localhost/post
PHP Symfony
73 votes196 views6 answers
Iterate through array javascript
PHP
0 vote236 views3 answers
Upload multiple files in codeigniter
PHP CodeIgniter
5 votes171 views3 answers
Laravel model limit
PHP
25 votes198 views2 answers
Clear cache without using composer in laravel 8
PHP Laravel
1 vote189 views3 answers
Extract date from DateTime object php
PHP

Share