/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

3 votes343 views1 answer
How validate array in laravel in request
PHP
3 votes338 views3 answers
Newline not working php
PHP
48 votes449 views6 answers
Laravel joins
PHP Laravel
0 vote361 views1 answer
Laravel orm latest()
PHP
2 votes410 views2 answers
Sentence get first second word php laravel
PHP Laravel
1 vote327 views1 answer
Laravel + join 2 eloquent queries
PHP
0 vote369 views2 answers
Add blade in blade laravel
PHP Laravel
0 vote373 views1 answer
Laravel set innodb scema builder
PHP Laravel
2 votes331 views2 answers
Add hour minute in datetime in php
PHP
4 votes356 views2 answers
Php get browser
PHP

Share