/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

1 vote165 views2 answers
Belongs to many laravel
PHP
0 vote124 views1 answer
MySQL table in new page after click php
PHP
0 vote158 views3 answers
Laravel postgres deadlock
PHP
0 vote190 views3 answers
When you click on the search button, it is moved to the page laravel
PHP Laravel
2 votes163 views1 answer
Install composer without requirement
PHP
0 vote174 views1 answer
Stupidity
PHP
1 vote192 views2 answers
Get all values inside session laravel
PHP Laravel
3 votes155 views1 answer
Laravel policy create
PHP
0 vote183 views1 answer
How to wp create post type in wordpress
PHP Wordpress
4 votes202 views1 answer
Uuid package generator laravel
PHP Laravel

Share