/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

4 votes127 views1 answer
Disable register laravel
PHP
0 vote213 views1 answer
Comment supprimer les onglets WooCommerce dans WordPress
PHP
8 votes137 views10 answers
Pluck array in laravel
PHP
0 vote159 views1 answer
Download symfony exe
PHP Symfony
12 votes142 views4 answers
Give custom field name in laravel form validation error message
PHP
0 vote178 views1 answer
Php description limit
PHP
8 votes145 views2 answers
How to check even or odd number in php
PHP
4 votes147 views6 answers
Php sort
PHP
0 vote170 views1 answer
Laravel collection intersectKey
PHP
19 votes149 views4 answers
Php get ip address of visitor
PHP

Share