前台代码:
<form action="index" style="float: left;" method="post" enctype="multipart/form-data" onsubmit="return file_submit()">
<input type="file" name="csv_file" size="50"/></div>
<input type="submit" value="提交"/>
</form>
后台代码
判断文件是否存在:
if($_FILES["csv_file"]!='')
文件上传:
$csv_filename = $_FILES["csv_file"]["name"]; $dir = "./upload/"; if (is_dir($dir) == false) { mkdir($dir, 0777); } $info = move_uploaded_file($_FILES["csv_file"]["tmp_name"], $dir . $csv_filename);
文件读取:
- 经过上传的文件读取文件信息到数组
$csv_file = fopen($dir.$csv_filename, 'r'); $csvList = input_csv($csv_file); dump($csvList);
- 不经过上传读取文件到数组
$csv_file = fopen($_FILES["csv_file"]["tmp_name"], 'r'); $csvList = input_csv($csv_file); dump($csvList);
数据库插入
$insert = M('tablename')->addAll($csvList);
备注:
Upload: $_FILES["csv_file"]["name"] Type: $_FILES["csv_file"]["type"] Size(Kb): ($_FILES["csv_file"]["size"] / 1024) Temp file: $_FILES["csv_file"]["tmp_name"]