/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 vote126 views1 answer
How to integrate gravity forms in wordpress theme using form id
PHP Wordpress
0 vote99 views2 answers
Laravel collection every
PHP
1 vote119 views1 answer
Laravel helper function for check string is exist in another string
PHP Laravel
0 vote110 views1 answer
Contractors php
PHP
0 vote114 views1 answer
How to add to array in single without repetation
PHP
0 vote105 views2 answers
Php numeros enteros
PHP
1 vote196 views2 answers
How to create a logout button in wordpress
PHP Wordpress
7 votes130 views3 answers
Get table name from model laravel
PHP Laravel
0 vote240 views1 answer
Laravel media library regenerate
PHP Laravel
0 vote99 views1 answer
Laravel follow and unfollow relationship
PHP

Share