php sqlite

最新推荐文章于 2021-12-11 11:07:21 发布

原创最新推荐文章于 2021-12-11 11:07:21 发布 · 133 阅读

0 ·

CC 4.0 BY-SA版权

php记录专栏收录该内容

20 篇文章

订阅专栏

本文展示了一个使用PHP操作SQLite数据库的具体实例，包括设置字符集、创建数据库连接、执行SQL查询并遍历结果集。此外，还提供了从CSV文件导入数据到数据库的方法。

<?php

header("Content-type: text/html; charset=utf-8");

$db = new SQLite3("mobile_price.db");

//$db->query('PRAGMA encoding = "UTF-8";');

//$db->query('CREATE TABLE mobile_price ( id INTEGER PRIMARY KEY, province TEXT, value10 REAL, value20 REAL, value30 REAL, value50 REAL, value100 REAL, value200 REAL, value300 REAL, value500 REAL, type INTEGER);');

//dbToSqlite($db,'dianxin.csv');

//dbToSqlite($db,'yidong.csv');

//dbToSqlite($db,'liantong.csv');

//$db->exec("insert into mobile_price( id, province, value10, value20, value30, value50, value100, value200, value300, value500, type) values (null,null,'1','1','1','1','1','1','100.22','1.1','1')");

$rc = $db->query('select * from mobile_price');

while($row = $rc->fetchArray()){

var_dump($row);

}

$db->close();

function dbToSqlite($db,$filename){

$file = fopen($filename,'r');

while ($data = fgetcsv($file)) { //每次读取CSV里面的一行内容

switch($filename){

case 'dianxin.csv':

$db->exec("insert into mobile_price( id, province, value10, value20, value30, value50, value100, value200, value300, value500, type) values (null,'{$data['1']}',null,null,null,{$data['2']},{$data['3']},null,null,null,'1')");

break;

case 'yidong.csv':

$db->exec("insert into mobile_price( id, province, value10, value20, value30, value50, value100, value200, value300, value500, type) values (null,'{$data['1']}',{$data['2']},{$data['3']},{$data['4']},{$data['5']},{$data['6']},{$data['7']},{$data['8']},{$data['9']},'2')");

break;

case 'liantong.csv':

$db->exec("insert into mobile_price( id, province, value10, value20, value30, value50, value100, value200, value300, value500, type) values (null,'{$data['1']}',null,{$data['2']},{$data['3']},{$data['4']},{$data['5']},{$data['6']},{$data['7']},{$data['8']},'3')");

break;

}