/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 vote247 views1 answer
Enable tab completion in terraform
PHP
6 votes268 views2 answers
Default time zone india php
PHP
1 vote242 views3 answers
Calculate time difference php
PHP
2 votes254 views1 answer
Compser udate wiith --ignore-platform-req
PHP
0 vote265 views1 answer
Same column in and where laravel query
PHP
1 vote253 views2 answers
Change php version using htaccess
PHP
7 votes254 views1 answer
Php artisan passport install command
PHP
3 votes315 views6 answers
Laravel jwt token
PHP Laravel
25 votes255 views2 answers
Php switch 2 variables
PHP
0 vote270 views1 answer
Give @s potion off weekness
PHP

Share