<?php $dbhost; $username; $passwd; $database; $table; $conn = mysql_connect("$dbhost","$username","$passwd"); mysql_select_db("$database",$conn); mysql_query("SET NAMES UTF8"); $handle = fopen('$filename', 'r'); while($data = fgetcsv($handle, 4096, "/t")) { $str ="INSERT INTO $table VALUES ('$data[0]', '$data[1]', '$data[2]')"; mysql_query($str); } echo "导入成功"; ?>
|