Statistical picture of how the number of home page

[jiajieit]

How to display images have been uploaded by the number of servers in the home page.

I want to show the dashboard above picture number (guest status) in the home page, and ask what function to achieve?

 

[Rodolfo]

CHV\DB::queryFetchSingle('SELECT COUNT(*) AS total from ' . CHV\DB::getTable('images'));

 

[jiajieit]

CHV\DB::queryFetchSingle('SELECT COUNT(*) AS total from ' . CHV\DB::getTable('images'));

thank

 

[jiajieit]

CHV\DB::queryFetchSingle('SELECT COUNT(*) AS total from ' . CHV\DB::getTable('images'));

Hello, Rodolfo,
After using this code can not display images correctly quantity，As shown below；

footer.php

 

[Rodolfo]

You are missing the echo.

echo CHV\DB::queryFetchSingle('SELECT COUNT(*) AS total from ' . CHV\DB::getTable('images'));

 

[jiajieit]

You are missing the echo.

echo CHV\DB::queryFetchSingle('SELECT COUNT(*) AS total from ' . CHV\DB::getTable('images'));

Hello Rodolfo, I added the echo display "Array".

 

[Rodolfo]

echo CHV\DB::queryFetchSingle('SELECT COUNT(*) AS total from ' . CHV\DB::getTable('images'))['total'];

 

[jiajieit]

echo CHV\DB::queryFetchSingle('SELECT COUNT(*) AS total from ' . CHV\DB::getTable('images'))['total'];

thanks

 

[agenciaclose]

Thank was very useful this information