[13] => Array

(

[payment_success_at] =>

[user_name] => ?.琳琳?

[remarks] =>

[product_name] => 香菇

[sku_name] => 斤

[product_property] => 斤

[price_original] => 5.50

[price_current] => 5.50

[consignee] => ?.琳琳?

)

以上代碼中用戶名中存在特殊符號,導致phpexcel導出時無法識別,會出現部分字段數據丟失的問題.

以下處理:

iconv('gb2312//ignore', 'utf-8', iconv('utf-8', 'gb2312//ignore', $value['consignee']));

處理后:

[13] => Array

(

[user_name] => .琳琳

[remarks] =>

[product_name] => 香菇

[sku_name] => 斤

[product_property] => 斤

[price_original] => 5.50

[price_current] => 5.50

[product_quantity] => 2

[consignee] => .琳琳

)

就可以正常導出了.