W webjin Chevereto Member May 16, 2015 #1 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
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
E evilmoe2 Not needed May 16, 2015 #2 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()');
W webjin Chevereto Member May 16, 2015 #3 evilmoe2 said: 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()'); Click to expand... thanks
evilmoe2 said: 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()'); Click to expand... thanks