/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 votes142 views1 answer
TRANSACTON LARAVEL QUERY BUILDER
PHP Laravel
0 vote95 views1 answer
Protocals supported by php
PHP
0 vote115 views1 answer
Drupal 9 custom access checking for routes
PHP
9 votes100 views3 answers
Laravel join 2 tables eloquent
PHP
5 votes98 views3 answers
Mobile number validation in laravel 8
PHP
14 votes111 views6 answers
Ternary operator php
PHP
1 vote117 views1 answer
Laravel realation with has
PHP Laravel
2 votes111 views4 answers
Laravel print query with parameters
PHP
0 vote139 views1 answer
Search query codeigniter
PHP CodeIgniter
0 vote98 views1 answer
Livewire call function from other component
PHP

Share