|
领会一下精神吧,好久没用这几个函数连数据库了呵呵
[PHP]
<?
$file = "c.txt";
$fp = fopen ($file, "r");
$conn = mysql_connect("","","");
mysql_select_db("dbname",$conn);
while (!feof ($fp)) {
$buffer = fgets($fp, 4096);
$block=explode(" ",$buffer);
$id=$block[0];
$name=$block[1];
$sex=$block[2];
$sql="INSERT INTO tablename(col1,col2,col3) VALUES($id,$name,$sex)";
mysql_query($sql);
}
mysql_close($conn);
fclose ($fp);
?>
[/PHP]
|