Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > How to convert txt file data to sqlite data

How to convert txt file data to sqlite data

WBOY
Release： 2016-07-25 08:49:25
Original
1291 people have browsed it
The data calling interface of Express 100 is used by me to develop the express query function of the WeChat public platform.
  1. $kuaidi_data = file_get_contents("kuaidiinfo.txt");
  2. $sp = explode("n",$kuaidi_data);
  3. //var_dump($sp);
  4. $conut = count( $sp);
  5. echo "".$conut."
    ";
  6. //$code = array();
  7. //$ company = array();
  8. $dbname = "data.dat";
  9. $dbh=new PDO("sqlite:".$dbname);
  10. $create_sql = "CREATE TABLE kuaidi(
  11. id INTEGER PRIMARY KEY,
  12. code VARCHAR (20) NOT NULL,
  13. company TEXT NOT NULL
  14. )";
  15. $dbh->exec($create_sql);
  17. for($i=0;$i<$conut;$i++){
  18. $kdinfo = explode(" ",$sp[$i]);
  19. $code = $kdinfo[0];
  20. $company = $kdinfo[1];
  22. //$inserte_sql = "INSERT INTO kuaidi VALUES('',' ".$code."','".$company."')";
  23. $inserte_sql = "INSERT INTO kuaidi (`code`,`company`) VALUES('".$code."','". strtoupper($company)."')";
  24. //$inserte_sql = "INSERT INTO kuaidi VALUES('',"fdsfds","fdsfdsf")";
  25. echo $inserte_sql."
    ";
  26. $dbh->exec($inserte_sql);
  27. }
Copy code
  1. aae aae global express
  2. anjie Anjie Express
  3. anxindakuaixi Anxinda Express
  4. biaojikuaidi Biaoji Express
  5. bht bht
  6. baifudongfang Baifu Oriental International Logistics
  7. coe China Eastern (COE)
  8. changyuwuliu Changyu Logistics
  9. datianwuliu Datian Logistics
  10. debangwuliu Debon Logistics
  11. dhl dhl
  12. dpex dpex
  13. dsukuaidi d express express
  14. disifang delivery to all directions
  15. ems ems express
  16. fedex fedex (overseas)
  17. feikangda Feikangda Logistics
  18. fenghuangkuaidi Phoenix Express
  19. feikuaida Feiquaida
  20. guotong kuaidi Guotong Express
  21. ganzhongnengda Hong Kong China Nengda Logistics
  22. guangdongyouzhengwuliu Guangdong Post Logistics
  23. gongsuda Gongsuda
  24. huitongkuaidi Huitong Express
  25. hengluwuliu Henglu Logistics
  26. huaxialongwuliu Huaxialong Logistics
  27. haihongwangsong Haihong
  28. haiwaihuanqiu Overseas Global
  29. jiayiwuliu Jiayi Logistics
  30. jin guangsudikuaijian Beijing-Guangzhou Express
  31. jixianda Jixianda
  32. jjwl Jiaji Logistics
  33. jymwl Jiayunmei Logistics
  34. jindawuliu Jinda Logistics
  35. jialidatong Kerry Chase
  36. jykd Jinyue Express
  37. kuaijiesudi Express Express
  38. lianb FedEx (domestic)
  39. lianhaowuliu Lianhaotong Logistics
  40. longbanwuliu Longbang Logistics
  41. lijisong Send now
  42. lejiedi Lejie Express
  43. minghangkuaidi Civil Aviation Express
  44. meiguokuaidi American Express
  45. menduimen door to door
  46. ocs OCS
  47. peisihuoyunkuaidi Peisi Freight
  48. quanchenkuaidi Quanchen Express
  49. quanfengkuaidi Quanfeng Express
  50. quanjitong Quanjitong Logistics
  51. quanritongkuaidi Quan Nippon Express
  52. quanyikuaidi Quanyi Express
  53. rufengda Rufengda
  54. santaisudi Sanzhou Express
  55. shenghuiwuliu Shenghui Logistics
  56. shentong STO
  57. shunfeng SF Express
  58. sue Suer Logistics
  59. shengfeng Shengfeng Logistics
  60. saiaodi Saiaodi
  61. tiandihuayu Tiandi Huayu
  62. tiantian Tiantian Express
  63. tnt tnt
  64. ups ups
  65. wanjiawuliu Wanjia Logistics
  66. wenjiesudi Wenjie Air Express
  67. wuyuan Wuyuan
  68. wxwl Vientiane Logistics
  69. xinbangwuliu Xinbang Logistics
  70. xinfengwuliu Xinfeng Logistics
  71. yafengsudi Yafeng Express
  72. yibangwuliu Yibang Express
  73. youshuwuliu Yousu Logistics
  74. youzhengguonei Postal parcel registration Letter
  75. youzhengguoji Post International Parcel Registered Mail
  76. yuanchengwuliu Yuancheng Logistics
  77. yuantong Yuantong Express
  78. yuanweifeng Yuanweifeng Express
  79. yuanzhijiecheng Yuanzhijiecheng Express
  80. yunda Yunda Express
  81. yuntongkuaidi Express Express
  82. yuefengwuliu Yuefeng Logistics
  83. yad Yuan Anda
  84. yinjiesudi Yinjie Express
  85. zhaijisong Home Delivery
  86. zhongtiekuaiyun China Railway Express
  87. zhongtong Zhongtong Express
  88. zhongyouwuliu China Post Logistics
  89. zhongxinda Zhongxinda
  90. zhimakaimen Open Sesame
Copy code


Related labels：
将txt文件数据转换面sqlite数据的方法
source：php.cn
Previous article：Message board for newcomers Next article：How to back up files
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Possibility to store ASP Classic code as string in MYSQL database Is it possible to store asp classic code into a MySQL database and have it execute the cod...
From 2024-04-06 13:38:43
0
1
358
How to find JSON data based on other content in a JSON object when duplicates exist? I'm currently implementing some data charts on a website, and I have a JSON that contains ...
From 2024-04-04 10:57:45
0
1
413
After copying website to local, WordPress homepage redirects to duplicate copy Background: I have multiple websites running on rpi4 using nginx and wordpress. I want to ...
From 2024-03-31 15:26:18
0
2
280
Function is called multiple times when using useEffect passed to child React component I have a page with multiple ChildComponent tags and I want each ChildComponent to be told ...
From 2024-03-30 15:36:26
0
2
386
Why does every time I save my Vite React project, a new canvas element is added to the page body instead of replacing the existing canvas element? I'm trying to start learning ThreeJs (I'm also new to Javascript web development). After w...
From 2024-03-30 09:57:49
0
1
396
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template