/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 vote258 views1 answer
How to redirect to another page in php automatic after 2 second
PHP
0 vote270 views1 answer
Protocals supported by php
PHP
27 votes324 views6 answers
Php for loop array
PHP
1 vote289 views1 answer
Laravel make:listner
PHP Laravel
1 vote279 views1 answer
String replace twig
PHP
2 votes309 views2 answers
Laravel date default now
PHP Laravel
3 votes236 views1 answer
Php location
PHP
75 votes308 views6 answers
Php display errors
PHP
1 vote266 views1 answer
Regex php password
PHP
30 votes279 views1 answer
For ($i=0, $len=count($
PHP

Share