php读取txt文件组成SQL并插入数据库的代码（原创自Zjmainstay）

以下是网学网为您推荐的PHP-php读取txt文件组成SQL并插入数据库的代码（原创自Zjmainstay），希望本篇文章对您学习有所帮助。

/**
* $splitChar 字段分隔符
* $file 数据文件文件名
* $table 数据库表名
* $conn 数据库连接
* $fields 数据对应的列名
* $insertType 插入操作类型，包括INSERT,REPLACE
*/
复制代码 代码如下:
<?php
/**
* $splitChar 字段分隔符
* $file 数据文件文件名
* $table 数据库表名
* $conn 数据库连接
* $fields 数据对应的列名
* $insertType 插入操作类型，包括INSERT,REPLACE
*/
function loadTxtDataIntoDatabase($splitChar,$file,$table,$conn,$fields=array(),$insertType=''INSERT''){
if(empty($fields)) $head = "{$insertType} INTO `{$table}` VALUES(''";
else $head = "{$insertType} INTO `{$table}`(`".implode(''`,`'',$fields)."`) VALUES(''"; //数据头
$end = "'')";
$sqldata = trim(file_get_contents($file));
if(preg_replace(''/\s*/i'','''',$splitChar) == '''') {
$splitChar = ''/(\w+)(\s+)/i'';
$replace = "$1'',''";
$specialFunc = ''preg_replace'';
}else {
$splitChar = $splitChar;
$replace = "'',''";
$specialFunc = ''str_replace'';
}
//处理数据体，二者顺序不可换，否则空格或Tab分隔符时出错
$sqldata = preg_replace(''/(\s*)(\n+)(\s*)/i'',''\''),(\'''',$sqldata); //替换换行
$sqldata = $specialFunc($splitChar,$replace,$sqldata); //替换分隔符
$query = $head.$sqldata.$end; //数据拼接
if(mysql_query($query,$conn)) return array(true);
else {
return array(false,mysql_error($conn),mysql_errno($conn));
}
}
//调用示例1
require ''db.php'';
$splitChar = ''|''; //竖线
$file = ''sqldata1.txt'';
$fields = array(''id'',''parentid'',''name'');
$table = ''cengji'';
$result = loadTxtDataIntoDatabase($splitChar,$file,$table,$conn,$fields);
if (array_shift($result)){
echo ''Success!<br/>'';
}else {
echo ''Failed!--Error:''.array_shift($result).''<br/>'';
}
/*sqlda ta1.txt
|0|A
|1|B
|1|C
|2|D
-- cengji
CREATE TABLE `cengji` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parentid` int(11) NOT NULL,
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `parentid_name_unique` (`parentid`,`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1602 DEFAULT CHARSET=utf8
*/
//调用示例2
require ''db.php'';
$splitChar = '' ''; //空格
$file = ''sqldata2.txt'';
$fields = array(''id'',''make'',''model'',''year'');
$table = ''cars'';
$result = loadTxtDataIntoDatabase($splitChar,$file,$table,$conn,$fields);
if (array_shift($result)){
echo ''Success!<br/>'';
}else {
echo ''Failed!--Error:''.array_shift($result).''<br/>'';
}
/* sqldata2.txt
Aston DB19 2009
Aston DB29 2009
Aston DB39 2009
-- cars
CREATE TABLE `cars` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`make` varchar(16) NOT NULL,
`model` varchar(16) DEFAULT NULL,
`year` varchar(16) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8
*/
//调用示例3
require ''db.php'';
$splitChar = '' ''; //Tab
$file = ''sqldata3.txt'';
$fields = array(''id'',''make'',''model'',''year'');
$table = ''cars'';
$insertType = ''REPLACE'';
$result = loadTxtDataIntoDatabase($splitChar,$file,$table,$conn,$fields,$insertType);
if (array_shift($result)){
echo ''Success!<br/>'';
}else {
echo ''Failed!--Error:''.array_shift($resul