<?php
/**
* Created by PhpStorm.
* User: Administrator
* Date: 2018/1/13
* Time: 19:38
*/
header("Content-Type: text/html; charset=utf-8");
$action = $_POST['action'];
$csv = $_POST['csv'];
if($action == 'action'){
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("myjob", $con);
for($i=1;$i<4;$i++){
$a = $csv[$i]['username'];
$b = $csv[$i]['pay_money'];
$c = $csv[$i]['pay_type'];
mysql_query("INSERT INTO job (username, money, type)
VALUES ('$a', '$b', '$c')");
}
mysql_close($con);
}
?>
html+php+csv.js+mysql将csv数据导入mysql(附完整测试代码)
需积分: 47 117 浏览量
2018-01-14
09:13:40
上传
评论 1
收藏 38KB RAR 举报
csv.rar （7个子文件） 
csv 
localhost.sql 2KB csv.php 712B js jquery-1.8.0.min.js 90KB csv.js 13KB csv.min.js 5KB
csv.html 2KB 111.csv 56B资源评论
