/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

4 votes124 views2 answers
Laravel collection random
PHP
0 vote155 views1 answer
Download data from s3 and save to local disk laravel
PHP Laravel
0 vote137 views1 answer
PHP 2-Dimentional array
PHP
0 vote151 views2 answers
Delete in wordpress query
PHP Wordpress
0 vote130 views2 answers
Yyyymmdd to yyyy-mm-dd php
PHP
1 vote166 views1 answer
Laravel start que listener
PHP Laravel
0 vote142 views1 answer
How to add logo in FPDF PHP
PHP
2 votes130 views2 answers
Php delete a folder
PHP
0 vote136 views1 answer
Real time ip in php
PHP
0 vote139 views1 answer
Php get result sql server
PHP

Share