如何使用php将csv文件正确上传到mysql数据库中?
我在phpmyadmin中有一列(已上传,列名),在此列中将存储上载的csv文件。
我有一个将csv文件上传到mysql数据库的小脚本,但是单击“提交”按钮并且csv文件未保存在数据库中后,出现一些错误“ 404:找不到文件”。
这是带有html的php文件:
<?php
include "dbase.php"; //Connect to Database
$deleterecords = "TRUNCATE TABLE contracts"; //empty the table of its current records
mysql_query($deleterecords);
//Upload File
if (isset($_POST['submit'])) {
if (is_uploaded_file($_FILES['filename']['tmp_name'])) {
echo "<h1>" . "File ". $_FILES['filename']['name'] ." uploaded successfully." . "</h1>";
echo "<h2>Displaying contents:</h2>";
readfile($_FILES['filename']['tmp_name']);
}
//Import uploaded file to Database
$handle = fopen($_FILES['filename']['tmp_name'], "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$import="INSERT into contracts(uploaded) values('$data[0],$data[1]')";
mysql_query($import) or die(mysql_error());
}
fclose($handle);
echo "Import done";
//view upload form
}else {
echo "Upload new csv by browsing to file and clicking on Upload<br />\n";
echo "<form enctype='multipart/form-data' action='upload.php' method='post'>";
echo "File name to import:<br />\n";
echo "<input size='50' type='file' name='filename'><br />\n";
echo "<input type='submit' name='submit' value='Upload'></form>";
}
?>
数据库连接:
<?
$filename=$_POST['filename'];
$db=mysql_connect('localhost', 'username', 'password', '3306')
or die(mysql_error());
if(!$db)
die("no db");
if(!mysql_select_db("databasename",$db))
die("No database selected.");
?>
我认为您的脚本文件名为not upload.php
,这就是为什么您遇到“未找到”错误的原因。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句