import.php

来自「全国大学英语四六级网上报名程序」· PHP 代码 · 共 20 行

<?php  
$hostname="localhost"; 
$username="jsjdj"; 
$password="jsjdj.2004";  
$dbname="jsjdj"; 
mysql_connect($hostname,$username,$password); 
mysql_select_db("$dbname"); 
$mydate=file("login.txt"); 
$n=count($mydate); 
for($i=0;$i<$n;$i++){ 
$date=explode(",",$mydate[$i]); 
$date[0]=trim($date[0]);
$date[1]=trim($date[1]);
$str="insert into login values('$date[0]','$date[1]')";
mysql_query($str); 
} 
mysql_close(); 
echo "ok!"; 
?>