/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

0 vote240 views1 answer
Laravel schedule kernel code sample
PHP
0 vote223 views1 answer
Wordpress post type template
PHP
1 vote233 views1 answer
Laravel set field unique
PHP
8 votes218 views2 answers
Replace exact word in php
PHP
1 vote240 views1 answer
ErrorExceptionUndefined array key "password"
PHP
2 votes228 views1 answer
Laravel set appends
PHP
0 vote277 views1 answer
Laravel deploy without moving public directory
PHP Laravel
0 vote251 views1 answer
Laravel log query for model (full)
PHP
62 votes251 views5 answers
Convert string to int php 7
PHP
0 vote222 views1 answer
Convert html to pdf using php.php
PHP

Share