Code for batch importing plain text passwords into mysql database
Release： 2016-07-25 08:52:03
Original
1120 people have browsed it
-
-
set_time_limit(13600); //设置时间 - $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';
- ?>
-
|
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
-
2024-10-22 09:46:29
-
2024-10-13 13:53:41
-
2024-10-12 12:15:51
-
2024-10-11 22:47:31
-
2024-10-11 19:36:51
-
2024-10-11 15:50:41
-
2024-10-11 15:07:41
-
2024-10-11 14:21:21
-
2024-10-11 12:59:11
-
2024-10-11 12:17:31
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
