/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

1 vote138 views1 answer
Config smp gamil laravel
PHP Laravel
1 vote124 views1 answer
Filemtime($current_file_name);
PHP
2 votes129 views2 answers
Find string in text in laravel
PHP
0 vote130 views1 answer
Php artisan spark not working in codeigniter
PHP
0 vote136 views1 answer
Wp mail
PHP Wordpress
2 votes126 views2 answers
Last insert id model codeigniter
PHP
0 vote160 views2 answers
Laravel get request in blade
PHP Laravel
11 votes123 views3 answers
Change date format php
PHP
1 vote121 views1 answer
File_get_contents timeout
PHP
0 vote127 views1 answer
PHP redirect parent page
PHP

Share