/PHP/Count sql query in php

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

2 votes185 views1 answer
When image update laravel delete remove image
PHP
2 votes195 views2 answers
If browser url is having query string after domain name in it check using php
PHP
40 votes189 views6 answers
Random string in php
PHP
9 votes181 views4 answers
Add another field in existing migration laravel
PHP
18 votes245 views5 answers
Create model, controller and migration in single command laravel
PHP Laravel
1 vote164 views2 answers
Laravel init
PHP
11 votes184 views3 answers
Get full url php
PHP
2 votes258 views3 answers
Laravel get query result as array
PHP
0 vote236 views1 answer
CURL error 6: Could not resolve host: api.themoviedb.org (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://api.themoviedb.org/3/movie/popular?api_key=5cb73b68870b70a436b10ea06298de07
PHP
12 votes250 views4 answers
Php json pretty print
PHP

Share