• Welcome to the Chevereto user community!

    Here users from all over the world gather around to learn the latest about Chevereto and contribute with ideas to improve the software.

    Please keep in mind:

    • 😌 This community is user driven. Be polite with other users.
    • 👉 Is required to purchase a Chevereto license to participate in this community (doesn't apply to Pre-sales).
    • 💸 Purchase a Pro Subscription to get access to active software support and faster ticket response times.

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