/PHP/Get count sql query in php

Get 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 vote344 views1 answer
Query relationships laravel and select some columns
PHP
0 vote441 views1 answer
Laravel creating event get data
PHP Laravel
0 vote391 views1 answer
Définir un nombre maximum de mots sur les titres des publications WordPress
PHP
0 vote376 views1 answer
Take and skip in laravel
PHP Laravel
0 vote394 views1 answer
Wp php get rows number from mysql
PHP Wordpress
12 votes342 views2 answers
Laravel update from query
PHP
0 vote396 views1 answer
Filter from taggable laravel
PHP Laravel
0 vote323 views1 answer
Php test if three values are equal
PHP
0 vote349 views1 answer
Php array common element
PHP
10 votes337 views3 answers
Php how to loop through array_rand
PHP

Share