/PHP/Presentar la respuesta del conteo de la tabla una tabla en php

Presentar la respuesta del conteo de la tabla una tabla en php

$sql = "SELECT COUNT(*) total FROM avisos";
$result = $pdo->query($sql); //$pdo sería el objeto conexión
$total = $result->fetchColumn();
echo 'Número de total de registros: ' . $total;

Source: es.stackoverflow.com

Similar codes

0 vote206 views1 answer
Javascritp
PHP
1 vote231 views1 answer
Protected gaurded in laravel
PHP Laravel
0 vote219 views1 answer
Get the current datetime in php when button is clicked
PHP
0 vote257 views2 answers
Loop variable in laravel
PHP Laravel
0 vote218 views2 answers
Check if today's date is after a date php
PHP
0 vote254 views1 answer
'mix' is not recognized as an internal or external command,laravel 8 npm run dev
PHP Laravel
0 vote277 views2 answers
Laravel eloquent multiple join with where conditions
PHP Laravel
0 vote229 views1 answer
Laravel unique funcation
PHP Laravel
0 vote231 views1 answer
Searching for new lines
PHP
0 vote201 views1 answer
Auth.php Class "\App\User" not found
PHP