/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 vote262 views2 answers
Install php 7.4 fpm
PHP
0 vote252 views1 answer
Contact form 7 get form id
PHP
1 vote226 views1 answer
Centos search directory php.exe
PHP
0 vote236 views1 answer
<?php function find total( $my_list ) { //Insert your code here } ?>
PHP
-1 vote235 views1 answer
Php lowercase assoc array
PHP
0 vote241 views2 answers
Smarty if
PHP
4 votes246 views2 answers
Remove index.php from url htaccess
PHP
14 votes358 views6 answers
Wp enqueue style
PHP Wordpress
2 votes254 views4 answers
Laravel print query with parameters
PHP Laravel
3 votes247 views2 answers
Php uuid generator
PHP

Share