/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 vote143 views1 answer
Get post data in php javascript
PHP
0 vote157 views3 answers
Laravel disable Logging
PHP
1 vote161 views1 answer
Laravel Validation check array size min and max
PHP
5 votes169 views3 answers
Wordpress get_permalink
PHP Wordpress
0 vote169 views1 answer
Give @s potion off weekness
PHP
9 votes221 views2 answers
How to Log Query in Laravel
PHP Laravel
2 votes160 views2 answers
Payizone
PHP
7 votes198 views2 answers
Turn on php errors
PHP
4 votes153 views2 answers
Composer allowed memory size
PHP
1 vote161 views1 answer
SQLSTATE[HY000]: General error: 1005 Can't create table ``.`labels` (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter table `labels` add constraint
PHP

Share