/PHP/Php count result query

Php count result query

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 vote143 views1 answer
Laravel eloquent pass to next element
PHP Laravel
3 votes103 views3 answers
Twig in array
PHP
0 vote113 views1 answer
Implode with br in php
PHP
1 vote155 views2 answers
Laravel update only changed fields
PHP Laravel
0 vote95 views1 answer
Php clone datetime
PHP
0 vote144 views1 answer
Separate numbers with commas laravel
PHP Laravel
0 vote106 views1 answer
Php execute powershell script with parameters
PHP
51 votes157 views2 answers
Display errors in codeigniter
PHP CodeIgniter
0 vote64 views1 answer
Laravel sintax
PHP
0 vote113 views1 answer
Update laravel .env variables dynamically
PHP

Share