• Welcome to the Chevereto User Community!

    Here, users from all over the world come together to learn, share, and collaborate on everything related to Chevereto. It's a place to exchange ideas, ask questions, and help improve the software.

    Please keep in mind:

    • This community is user-driven. Always be polite and respectful to others.
    • Support development by purchasing a Chevereto license, which also gives you priority support.
    • Go further by joining the Community Subscription for even faster response times and to help sustain this space

Site has hosted xxxx picture, today uploaded xx

Status
Not open for further replies.

webjin

Chevereto Member
Hello, how to join the bottom of the home page echo 《Site has hosted xxxx picture, today uploaded xx》 code.
xxxx=Total
xx=Total today
Know can help me? THX
 
Total:
Code:
$total = CHV\DB::queryFetchSingle('SELECT COUNT(*) AS total FROM chv_images);

Today:
Code:
$today = CHV\DB::queryFetchSingle('SELECT COUNT(*) AS today  FROM chv_images WHERE DATE(image_date) = CURDATE()');
 
Total:
Code:
$total = CHV\DB::queryFetchSingle('SELECT COUNT(*) AS total FROM chv_images);

Today:
Code:
$today = CHV\DB::queryFetchSingle('SELECT COUNT(*) AS today  FROM chv_images WHERE DATE(image_date) = CURDATE()');
thanks
 
Status
Not open for further replies.
Back
Top