将txt文件数据转换面sqlite数据的方法

程序员文章站 2022-05-17 18:28:41

...

快递100的数据调用接口，我是用来开发微信公众平台的快递查询功能的。

$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(20) NOT NULL,
company TEXT NOT NULL
)";
$dbh->exec($create_sql);
for($i=0;$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);
}