/PHP/Count sql query in php

Count sql query in php

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 vote271 views1 answer
How to get full path of uploaded file in php
PHP
1 vote160 views3 answers
Laravel get url segment
PHP
1 vote161 views1 answer
Function in first collection laravel
PHP Laravel
0 vote272 views1 answer
Drupal 8 entity_view
PHP Drupal
1 vote166 views2 answers
Doument root phpp
PHP
0 vote184 views1 answer
Laravel property
PHP Laravel
0 vote147 views1 answer
Hash not found laravel
PHP
0 vote159 views2 answers
How to connect to a mysql database using php
PHP
0 vote186 views1 answer
Laravel take value from different array by key
PHP Laravel
8 votes146 views6 answers
Php isset
PHP

Share