本文實例講述了PHP編程實現csv文件導入mysql數據庫的方法。分享給大家供大家參考，具體如下：
config.db.php內容如下；
|
1
2
3
4
5
6
7
8
9
|
<?php$username="root";$userpass="123";$dbhost="localhost";$dbdatabase="credits2stakes";//生成一個連接$db_connect=mysql_connect($dbhost,$username,$userpass) or die("Unable to connect to the MySQL!");//選擇一個需要操作的數據庫mysql_select_db($dbdatabase,$db_connect); |
index.php內容如下：
|
1
2
3
4
|
<meta http-equiv="Content-Type"content="text/html; charset=utf-8" /><form name="frm1" enctype="multipart/form-data" action="insertdb.php" method="post"> <input name="filename" type="file" /><input name="submit" type="submit" value="import" /></form> |
insertdb.php內容如下：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
<?phpsession_start();header("Content-type:text/html;charset:utf-8");//全局變量$file=$_FILES['filename'];$max_size="2000000"; //最大文件限制（單位：byte）$fname=$file['name'];$ftype=strtolower(substr(strrchr($fname,'.'),1));//文件格式$uploadfile=$file['tmp_name'];if($_SERVER['REQUEST_METHOD']=='POST'){ if(is_uploaded_file($uploadfile)){ if($file['size']>$max_size){ echo "Import file is too large"; exit; } if($ftype!='csv'){ echo "Import file type is error"; exit; } }else{ echo "The file is not empty!"; exit; }}require("./config.db.php"); //連接mysql數據庫$row=0;$filename=$file['tmp_name'];$handle=fopen($filename,'r');while(!feof($handle) && $data=fgetcsv($handle,1000,',')){ $arr_result=array(); if($row==0){ $row++; continue; } if($row>0 && !empty($data)){ $num=count($data); for($i=0;$i<$num;$i++){ array_push($arr_result,$data[$i]); } //$name = iconv('gb2312','utf-8',$arr_result[1]); //$sex = iconv('gb2312','utf-8',$arr_result[2]); $sql="insert into inviter(inviter,invitees,time) value($arr_result[1],$arr_result[2],$arr_result[3])"; //echo $sql; mysql_query("set names utf8"); $result=mysql_query($sql); if($result){ echo "插入成功！！！"; }else{ echo "插入失敗！！！"; } } $row++;}fclose($handle);?> |
希望本文所述對大家PHP程序設計有所幫助。
