/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

0 vote361 views1 answer
Laravel capsule schema datatime CURRENT_TIMESTAMP
PHP Laravel
0 vote330 views3 answers
Laravel query builder get last insert id
PHP
1 vote350 views1 answer
How to mantain text in form after error php
PHP
10 votes311 views2 answers
How to convert array into json php
PHP
5 votes364 views3 answers
Laravel get parameters from request
PHP
0 vote342 views1 answer
How to add logo in FPDF PHP
PHP
0 vote309 views1 answer
Laravel withValidator
PHP
0 vote330 views1 answer
Laravel model where set fields laravel
PHP
0 vote359 views1 answer
Laravelda urlga keladigan so`rovlarni cheklash
PHP
0 vote353 views1 answer
Laravel media library regenerate
PHP

Share