/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 votes230 views2 answers
Date_default_timezone_set for india in php laravel
PHP Laravel
0 vote219 views1 answer
Laravel create pivot migration
PHP
3 votes211 views1 answer
Codeigniter form_validation email
PHP
0 vote226 views2 answers
General error: 1215 Cannot add foreign key constraint laravel
PHP Laravel
0 vote203 views1 answer
Php get cosine sim
PHP
2 votes202 views2 answers
Stristr php
PHP
0 vote207 views1 answer
Set default value for column in laravel model
PHP
0 vote202 views1 answer
File form validation codeigniter
PHP
0 vote196 views1 answer
How to wp create post type in wordpress
PHP
2 votes186 views1 answer
Webpack font awesome
PHP

Share