/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 vote248 views2 answers
Php decrement variable
PHP
1 vote280 views1 answer
Php remove span tags from string
PHP
2 votes285 views3 answers
Php setinterval
PHP
2 votes276 views4 answers
First day of month php
PHP
4 votes255 views1 answer
Get order status change history opencart
PHP
3 votes316 views2 answers
How to change laravel port
PHP Laravel
3 votes287 views3 answers
Pluck array in laravel
PHP Laravel
9 votes262 views3 answers
Get env app url laravel
PHP
7 votes266 views3 answers
Laravel 8 – Remove Public from URL
PHP
0 vote277 views1 answer
Php create word pairs from sentence
PHP

Share