将csdn数据库密码文件 解析导入进 mysql

将csdn明文密码批量导入进mysql数据库 $conn=mysql_connect('localhost','root',''); //连接数据库 mysql_select_db('csdn',$conn); mysql_query("SET NAMES utf8"); $file=file('csdn.txt'); foreach($file as $line) { $u=explode('# ', $line); mysql_query("INSERT INTO `user` (username,password,email)VALUES('".trim($u[0])."','".trim($u[1])."','".trim($u[2])."')",$conn); } echo 'OK'; ?> 复制代码