/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 vote285 views1 answer
Undefined type excel
PHP
2 votes327 views2 answers
Find string in text in laravel
PHP
0 vote289 views2 answers
Separate date from datetime php
PHP
0 vote374 views1 answer
Laravel select custom column
PHP Laravel
0 vote299 views1 answer
Codeigniter 4 query builder get inserted id
PHP
1 vote240 views2 answers
Php disable errors
PHP
1 vote352 views1 answer
Disabling Caching of Queries Laravel Model Cache
PHP Laravel
0 vote322 views1 answer
Check if column has value in laravel eloquent
PHP Laravel
0 vote319 views6 answers
Socialite laravel 7
PHP Laravel
28 votes260 views12 answers
Laravel middleware
PHP Laravel

Share