要記得 SQL 如果有 SUM等函數，要加上 IFNULL(sum(num_field), 0)

要記得 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';

SC 如果有需要區分Local Server 及 線上 Server，可以這樣判斷

 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}."/";

}