/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

39 votes152 views3 answers
Php get first 5 characters of string
PHP
0 vote188 views1 answer
Laravel deploy without moving public directory
PHP Laravel
0 vote259 views1 answer
Laravel @extends
PHP Laravel
4 votes148 views3 answers
Wp notice
PHP Wordpress
0 vote188 views1 answer
Integrity constraint violation laravel socialite google login
PHP Laravel
0 vote158 views1 answer
Php get property with ~
PHP
0 vote155 views3 answers
Serialise php
PHP
1 vote185 views4 answers
Current url route laravel
PHP Laravel
-1 vote184 views1 answer
Laravel hide columns
PHP Laravel
8 votes178 views4 answers
Php yesterday
PHP

Share