How to convert TXT file data to the surface of SQLite data

Express 100 data Call interface, I was used to develop the public platform of the Express query function. $kuaidi _data = file_get_contents ("Kuaidiinfo.txt"); $SP = explode ("\ n", $kuaidi _data); Var_dump ($SP); $conut = count ($SP); echo "". $conut. " "; $code = Array (); $company = Array (); $dbname = "Data.dat"; $DBH =new PDO ("SQLite:". $dbname); $create _sql = "Create TABLE Kuaidi ( ID INTEGER PRIMARY KEY, Code VARCHAR () is not NULL, Company TEXT is not NULL )"; $DBH->exec ($create _sql); for ($i =0; $i < $conut; $i + +) { $kdinfo = Explode ("", $sp [$i]); $code = $kdinfo [0]; $company = $kdinfo [1]; $inserte _sql = "INSERT into Kuaidi VALUES (', '". $code. "', '". $company. "')"; $inserte _sql = "INSERT into Kuaidi (' Code ', ' Company ') VALUES ('". $code. "', '". Strtoupper ($company). "')"; $inserte _sql = "INSERT into Kuaidi VALUES ('", "Fdsfds", "FDSFDSF") "; echo $inserte _sql. " "; $DBH->exec ($inserte _sql); } Copy Code AAE AAE Global Special Delivery Anjie Chit Express Anxindakuaixi Letter Tatsu Express Biaojikuaidi Puma Express BHT BHT Baifudongfang East International Logistics Coe China Orient (COE) Changyuwuliu Long Yu Logistics Datianwuliu Daejeon Logistics Debangwuliu Darbond Logistics DHL DHL Dpex Dpex Dsukuaidi D Speed Express Disifang Hand Quartet EMS EMS Express FedEx FedEx (Overseas) Feikangda Logistics Fenghuangkuaidi Phoenix Express Feikuaida Fast Up Guotongkuaidi Express Ganzhongnengda Logistics in Hong Kong Guangdongyouzhengwuliu Guangdong Post Logistics Gongsuda co-speed up Huitongkuaidi Huitong Express Hengluwuliu Heng Lu Logistics Huaxialongwuliu Huaxia Dragon Logistics Haihongwangsong Sea Red Haiwaihuanqiu Overseas Global Jiayiwuliu Jia Yi Logistics Jinguangsudikuaijian Jing Guang Express Jixianda Rush JJWL Logistics (Jia Ji) JYMWL Logistics Jindawuliu King Logistics Jialidatong Kerry Chase Jykd Jin Yue Express Kuaijiesudi Express Express LIANB FedEx (Domestic) Lianhaowuliu-Hao-Tong Logistics Longbanwuliu Dragon State Logistics Lijisong Immediate Delivery Lejiedi Letie Hand Minghangkuaidi Civil Aviation Express Meiguokuaidi American Express Menduimen Door OCS OCS Peisihuoyunkuaidi-Si Freight Quanchenkuaidi all Morning Express Quanfengkuaidi Full Peak Express Quanjitong All-through logistics Quanritongkuaidi Day Pass Express Quanyikuaidi Full One Express Rufengda such as wind up Santaisudi three-State Express Shenghuiwuliu Shenghui Logistics Shentong Shentong Shunfeng Shun Fung Sue Speed Logistics Shengfeng Shengfeng Logistics Saiaodi Sai o Pass Tiandihuayu Tiandi Hua Yu Tiantian Daily Express TNT TNT UPS UPS Wanjiawuliu million Home logistics Wenjiesudi Feng Air Courier Wuyuan Tientsin WXWL Vientiane Logistics Xinbangwuliu New State Logistics Xinfengwuliu Xinfeng Logistics Yafengsudi Air Express Yibangwuliu One State Express Youshuwuliu Excellent speed Logistics Youzhengguonei Postal Parcel Registered mail Youzhengguoji Post International parcel registered letter Yuanchengwuliu far into the logistics Yuantong Yuantong Express Yuanweifeng Source Wei Feng Express Yuanzhijiecheng Yuan Zhi Jie Cheng Express Yunda Yun da Express Yuntongkuaidi Express Express Yuefengwuliu Logistics Yad Source Anda Yinjiesudi Silver-Czech Express Zhaijisong Home Emergency Delivery Zhongtiekuaiyun in Iron Express Zhongtong in-Pass Express Zhongyouwuliu in Mail Logistics Zhongxinda Zhong Xin da Zhimakaimen Sesame Door Copy Code

