/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

1 vote161 views1 answer
Laravel dusk run failed tests
PHP Laravel
4 votes114 views1 answer
Php session variable
PHP
12 votes146 views2 answers
Php loop x times
PHP
0 vote138 views1 answer
Placeholder for select php
PHP
6 votes143 views4 answers
Session has laravel blade
PHP
1 vote148 views1 answer
Protected gaurded in laravel
PHP
0 vote167 views1 answer
How to make:trait in commend line in laravel
PHP Laravel
7 votes178 views6 answers
Laravel loop index
PHP
0 vote223 views1 answer
Befreie den WordPress-Header von unnötigen Einträgen
PHP Wordpress
0 vote218 views1 answer
Condition for both of one should be true laravel eloquent
PHP Laravel

Share