/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 vote234 views1 answer
Php extend parent constructor
PHP
6 votes274 views2 answers
Laravel generate key
PHP Laravel
4 votes269 views1 answer
Limit offset array php
PHP
7 votes322 views1 answer
Laravel wher in
PHP Laravel
0 vote268 views1 answer
Laravel API Endpoint "401 Unauthorized" on Server But Works Fine On Localhost
PHP
3 votes279 views3 answers
Html special characters php
PHP
6 votes293 views2 answers
How to calculate the sum of values in a list PHP
PHP
44 votes283 views6 answers
Php foreach array
PHP
0 vote276 views1 answer
Php create word pairs from sentence
PHP
7 votes263 views4 answers
Laravel error messages
PHP

Share