php表单导入MySQL,使用PHP代码和HTML表单将excel(.csv)导入MySQL

我们前一段时间使用过它，它运行得很好。只需查看您的文件和目录权限。 csv_upload_mysql_conf.inc只是数据库链接。这将一次解析多个文件，并将它们放在一个名为import的表中。相应更新。

/* The conf file */

include_once "csv_upload_mysql_conf.inc";

$php_self = $_SERVER['PHP_SELF'];

$file_open = 0;

$file_exts = array

( 'csv');

#Our Form.....

$form = <<< EOFFORM

Selected file:

Files You Selected:

• No Files Selected

function makeFileList() {

var input = document.getElementById('userfile[]');

var ul = document.getElementById('fileList');

while (ul.hasChildNodes()) {

ul.removeChild(ul.firstChild);

}

for (var i = 0; i < input.files.length; i++) {

var li = document.createElement('li');

li.innerHTML = input.files[i].name;

ul.appendChild(li);

}

if(!ul.hasChildNodes()) {

var li = document.createElement('li');

li.innerHTML = 'No Files Selected';

ul.appendChild(li);

}

}

EOFFORM;

#End Form;

if(!isset($_POST['selected'])){

echo "$form";

}

elseif($_POST['selected'] == "yes"){

$uploaddir = 'uploads/';

if(count($_FILES['userfile']['name'])) {

foreach ($_FILES['userfile']['name'] as $key => $error) {

if ($error == UPLOAD_ERR_OK) {

$tmp_name = $_FILES['userfile']['tmp_name'][$key];

$name = $_FILES['userfile']['name'][$key];

$f_type = trim(strtolower(end(explode('.', $name))));

if (!in_array($f_type, $file_exts)) die("Sorry, $f_type files not allowed");

}

$uploadfile = $uploaddir . $name;

if (! file_exists($uploadfile)) {

if (move_uploaded_file($tmp_name, $uploadfile)) {

print "File is valid, and was successfully uploaded. ";

$flag = 1;

chmod($uploadfile, 0777);

} else {

print "File Upload Failed. ";

$flag = 0;

}

$flag = 1;

if ($flag == 1) {

echo "\n parsing Data...";

flush();

if (file_exists($uploadfile)) {

$fp = fopen($uploadfile, 'r') or die (" Can't open the file");

$fileopen = 1;

$length = calculate_length($uploadfile);

}

$replace = "REPLACE";

$field_terminater = ",";

$enclose_option = 1;

$enclosed = '"';

$escaped = '\\\\';

$line_terminator = 1;

$local_option = 1;

$sql_query = 'LOAD DATA';

if ($local_option == "1") {

$sql_query .= ' LOCAL';

}

$sql_query .= ' INFILE \'' . $uploadfile . '\'';

if (!empty($replace)) {

$sql_query .= ' ' . $replace;

}

$sql_query .= ' INTO TABLE ' . "`import`";

if (isset($field_terminater)) {

$sql_query .= ' FIELDS TERMINATED BY \'' . $field_terminater . '\'';

}

if (isset($enclose_option) && strlen($enclose_option) > 0) {

$sql_query .= ' OPTIONALLY';

}

if (strlen($enclosed) > 0) {

$sql_query .= ' ENCLOSED BY \'' . $enclosed . '\'';

}

if (strlen($escaped) > 0) {

$sql_query .= ' ESCAPED BY \'' . $escaped . '\'';

}

if (strlen($line_terminator) > 0){

$sql_query .= ' LINES TERMINATED BY \'' . '\r\n' . '\'';

}

$result = mysql_query ($sql_query);

echo mysql_error() ;

if(mysql_affected_rows() > 1) {

echo "

The csv data was added.

";

}

else {

error_log(mysql_error());

echo "

Couldn't enter the data to db

";

}

if ($file_open ==1) {

fclose($fp) or die("Couldn't close the file");

}

}

}

}

echo "";

}

}

function calculate_length($fp) {

$length = 1000;

$array = file($fp);

for($i=0;$i

{

if ($length < strlen($array[$i]))

{

$length = strlen($array[$i]);

}

}

unset($array);

return $length;

}

?>