要記得 SQL 如果有 SUM等函數，要加上 IFNULL(sum(num_field), 0)
否則，就會產生 NULL 的可能，導致後面如果有再拿資料處理的時候，就會發生錯誤。
記得喔！
SELECT IFNULL(sum(c_profit),0) as v_sum_profit, count(*) as v_count, IFNULL(sum(c_profit)/count(*),0) as v_avg
FROM max_orders
WHERE date(updated_at_in_ms)='2023-07-08'
and state='done'
and side='sell';
if ($_SERVER['SERVER_NAME'] == '127.0.0.1') {
$img_dir = "http://127.0.0.1:8091/scriptcase/file/doc/splay/".{products_code}."/prod/";
$img_dir_desc = "http://127.0.0.1:8091/scriptcase/file/doc/splay/".{products_code}."/desc/";
$img_dir_main = "http://127.0.0.1:8091/scriptcase/file/img/splay/".{products_code}."/";
} else {
$img_dir = "https://shopadmin.splaything.com/_lib/file/doc/splay/".{products_code}."/prod/";
$img_dir_desc = "https://shopadmin.splaything.com/_lib/file/doc/splay/".{products_code}."/desc/";
$img_dir_main = "https://shopadmin.splaything.com/_lib/file/img/splay/".{products_code}."/";
}
