某裤子txt格式转存到MySQL

该段代码利用thinkPHP框架将某CTO网站泄露的裤子转存到MySQL数据库

裤子是用TXT格式储存在123.txt文件中,单行格式为:

CD是觉;3517aa7a6463596612b68e0b3da0c1c1;adpa@126.com

0.以下是转存PHP操作代码:

 public function keli(){
        $filePath = "C:\\Users\\gl\\Desktop\\123.txt";
        $cto = new CtoModel();
        $handle = fopen($filePath, "r");
        if ($handle) {
            while (!feof($handle)) {
                $buffer = fgets($handle, 4096);
                $pattern = '/;/';
              //$str = "CD是觉;3517aa7a6463596612b68e0b3da0c1c1;adpa@126.com";
                list($count, $key, $mail) = split ('[;]', $buffer);
                //echo "账号: $count<br>邮箱: $mail<br>加密后的密码: $key \n<hr>"; 
                //抽取的数据写入数据库
                if ($mail != null) {
                $data['username'] = $count;
                $data['email'] = $mail;
                $data['psw_encrypt'] = $key;                
                $cto->data($data)->add();
                }
                else {
                    //此处可另外将失败的账号输出到一个文件中保存
                    //以下为浏览器显示
                    echo "<hr>";
                    echo "用户:".$count."放弃写入...";
                    echo "<hr>";
                }

            }
            fclose($handle);
            echo "<hr><h2>写入数据库成功<hr>";

        }

1.以下为数据库格式: