/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 vote138 views1 answer
Php function crop image
PHP
2 votes167 views2 answers
Disable Bitnami Banner Wordpress
PHP
0 vote134 views1 answer
Drupal 8 date formater service
PHP
2 votes145 views2 answers
Php get all in object as array
PHP
0 vote169 views1 answer
Redirect back in laravel livewire
PHP Laravel
0 vote145 views1 answer
$age = 20; print ($age >= 18) ? "Adult" : "Not Adult";
PHP
1 vote212 views1 answer
Wordpress display post comment number
PHP Wordpress
0 vote176 views1 answer
How to set timezone for iran in laravel
PHP Laravel
12 votes159 views6 answers
Laravel model where
PHP Laravel
1 vote130 views1 answer
Extract all arrays from sql response in php
PHP

Share