/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 vote209 views1 answer
Expression #1 of ORDER BY contains aggregate function and applies to the result of a non-aggregated query laravel
PHP
0 vote278 views1 answer
Php sigmoid function
PHP
0 vote236 views1 answer
1.0E-6 to decimal in php
PHP
0 vote169 views1 answer
Laravel collection tap
PHP
1 vote244 views1 answer
Laravel refresh server
PHP Laravel
11 votes547 views5 answers
Php header allow cross origin
PHP
3 votes221 views2 answers
Get json from url php
PHP
4 votes216 views1 answer
Open php ini from terminal
PHP
0 vote205 views1 answer
Laravel blade short if
PHP
0 vote222 views1 answer
Snap store phpstrom
PHP

Share