热卖商品
新闻详情
CSV文件内容显示问题 - VoidCC
来自 : cn.voidcc.com/question/p-sfbom
发布时间:2021-03-24
0
我想要从一个CSV文件内容为我用下面的代码:CSV文件内容显示问题
?php $fo = fopen(\"record.csv\", \"rb+\"); while(!feof($fo)) { $contents[] = fgetcsv($fo,0,\';\'); print_r($contents); fclose($fo);
但我的记录显示在下面的格式:
䅲牡礊⠊††嬰崠㴾⁁牲慹ਠ††† ਠ†††††⁛そ‽㸠\"Search Transactions Results\" ††††⤊ਠ†⁛ㅝ‽㸠䅲牡礊††††⠊††††††嬰崠㴾 ∀吀爀愀渀猀愀挀琀椀漀渀 䤀䐀∀Ⰰ∀刀攀昀攀爀攀渀挀攀 吀爀愀渀猀愀挀琀椀漀
我csv文件格式:
\"Search Transactions Results\" \"Transaction ID\",\"Reference Transaction ID\",\"Date\",\"Type\",\"Subject\",\"Item Number\",\"Item Name\",\"Invoice ID\",\"Name\",\"Email\",\"Shipping Name\",\"Shipping Address Line 1\",\"Shipping Address Line 2\",\"Shipping Address City\",\"Shipping State/Province\",\"Shipping Zip/Postal Code\",\"Shipping Address Country\",\"Shipping Method\",\"Address Status\",\"Contact Phone Number\",\"Gross Amount\",\"Receipt ID\",\"Custom Field\",\"Option 1 Name\",\"Option 1 Value\",\"Option 2 Name\",\"Option 2 Value\",\"Note\",\"Auction Site\",\"Auction User ID\",\"Item URL\",\"Auction Closing Date\",\"Insurance Amount\",\"Currency\",\"Fees\",\"Net Amount\",\"Shipping Handling Amount\",\"Sales Tax Amount\",\"To Email\",\"Time\",\"Time Zone\" \"1T\",\"\",5/5/2010 2:10:44 PM,\"Payment Processed\",\"CFP Self Study Kit\",\"1\",\"CFP Self Study Kit\",\"\",\"User1\",\"[emailprotected]\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"N\",\"\",\"68.18\",\"R1\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",,\"\",\"USD\",\"-2.62\",\"65.56\",\"0\",\"0\",\"[emailprotected]\",\"01:40\",\"Asia/Calcutta\" \"2T\",\"\",5/19/2010 4:04:08 PM,\"Payment Processed\",\"CFP Self Study Kit\",\"1\",\"CFP Self Study Kit\",\"\",\"User2\",\"[emailprotected]\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"N\",\"\",\"68.18\",\"R2\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",,\"\",\"USD\",\"-2.62\",\"65.56\",\"0\",\"0\",\"[emailprotected]\",\"03:34\",\"Asia/Calcutta\" \"3T\",\"1RT\",5/19/2010 5:28:45 PM,\"Currency Conversion Completed\",\"\",\"\",\"\",\"\",\" \",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"N\",\"\",\"17492.6\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",,\"\",\"INR\",\"0\",\"17492.6\",\"0\",\"0\",\"\",\"04:58\",\"Asia/Calcutta\" \"4T\",\"2RT\",5/19/2010 5:28:45 PM,\"Currency Conversion Completed\",\"\",\"\",\"\",\"\",\" \",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"N\",\"\",\"-393.36\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",,\"\",\"USD\",\"0\",\"-393.36\",\"0\",\"0\",\"\",\"04:58\",\"Asia/Calcutta\" \"5T\",\"\",5/19/2010 5:28:45 PM,\"Transfer to Bank Initiated\",\"P1006\",\"\",\"P1006\",\"\",\" \",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"N\",\"\",\"-17492.6\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",,\"\",\"INR\",\"0\",\"-17492.6\",\"0\",\"0\",\"\",\"04:58\",\"Asia/Calcutta\" \"6T\",\"\",5/20/2010 5:38:02 PM,\"Transfer to Bank Completed\",\"P1006\",\"\",\"P1006\",\"\",\" \",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"N\",\"\",\"-17492.6\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",,\"\",\"INR\",\"0\",\"-17492.6\",\"0\",\"0\",\"\",\"05:08\",\"Asia/Calcutta\" \"7T\",\"\",5/21/2010 12:32:37 PM,\"Payment Processed\",\"FP - LVC Plus\",\"\",\"FP - LVC Plus\",\"\",\"User3\",\"user[emailprotected]\",\"User3\",\"NEW DELHI\",\"BEHIND KARNATAKA BANK LD\",\"SOUTH\",\"NEW DELHI\",\"110023\",\"IN\",\"\",\"N\",\"\",\"283.96\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",,\"\",\"USD\",\"-9.95\",\"274.01\",\"0\",\"0\",\"[emailprotected]\",\"00:02\",\"Asia/Calcutta\" \"8T\",\"\",5/25/2010 4:40:48 PM,\"Transfer to Bank Initiated\",\"P1006\",\"\",\"P1006\",\"\",\" \",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"N\",\"\",\"-12569.85\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",,\"\",\"INR\",\"0\",\"-12569.85\",\"0\",\"0\",\"\",\"04:10\",\"Asia/Calcutta\" \"9T\",\"3RT\",5/25/2010 4:40:48 PM,\"Currency Conversion Completed\",\"\",\"\",\"\",\"\",\" \",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"N\",\"\",\"-274.01\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",,\"\",\"USD\",\"0\",\"-274.01\",\"0\",\"0\",\"\",\"04:10\",\"Asia/Calcutta\" \"10T\",\"4RT\",5/25/2010 4:40:48 PM,\"Currency Conversion Completed\",\"\",\"\",\"\",\"\",\" \",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"N\",\"\",\"12569.85\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",,\"\",\"INR\",\"0\",\"12569.85\",\"0\",\"0\",\"\",\"04:10\",\"Asia/Calcutta\" \"11T\",\"\",5/26/2010 4:57:39 PM,\"Transfer to Bank Completed\",\"P1006\",\"\",\"P1006\",\"\",\" \",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"N\",\"\",\"-12569.85\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",,\"\",\"INR\",\"0\",\"-12569.85\",\"0\",\"0\",\"\",\"04:27\",\"Asia/Calcutta\" \"Total\",\"-247.05 USD\",\"-15.19\",\"-262.24\" \"Total\",\"0.00 INR\",\"0.00\",\"0.00\"
我想检索“类型”=“支付处理”的记录。我想以一种键值格式检索内容,例如,交易ID- 1T,因为我必须将这些值存储在数据库中,但显示不正确。 我无法找出相同的原因,请帮助我。
由于
本文链接: http://csvsouth.immuno-online.com/view-694747.html
发布于 : 2021-03-24
阅读(0)
最新动态
2021-03-24
2021-03-24
2021-03-24
2021-03-24
2021-03-24
2021-03-24
2021-03-24
2021-03-24
2021-03-24
2021-03-24
2021-03-24
2021-03-24