/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

1 vote129 views3 answers
Laravel eloquent bulk insert
PHP Laravel
1 vote113 views2 answers
Laravel required_with
PHP
0 vote113 views1 answer
Mr deepfakes forum
PHP
0 vote122 views1 answer
JQuery is not defined load-scripts.php
PHP
1 vote127 views2 answers
Many to many relationship laravel example
PHP
-1 vote138 views1 answer
Laravel merge two arrays helper
PHP Laravel
1 vote128 views2 answers
Throttle laravel
PHP Laravel
16 votes101 views6 answers
Php console log
PHP
0 vote121 views1 answer
Sort json in php
PHP
1 vote134 views1 answer
Definir una constante para llamar archivos en puglins de WordPress
PHP Wordpress

Share