php 往資料庫插入資料指令碼

標籤：mysql指令碼   php   shell

        php 往資料庫插入資料指令碼

<?php

add_user_pwd();

/**

 * 添加密碼賬戶到資料庫

 */

function add_user_pwd() 

{

/* 串連mysql */

$type = ‘mysql‘;

$dbname = ‘jihua‘;

$host = ‘127.0.0.1‘;

$username = ‘root‘;

$password = ‘root‘;

$dsn = "$type:host=$host;dbname=$dbname";

try {

$pdo = new PDO($dsn, $username, $password);

} catch(Exception $e) {

die(‘MYSQL串連錯誤‘);

}

/* 讀取檔案資訊 */

$file = fopen("test1.txt", "r");

$i = 0;

while(! feof($file)) {

if(($i % 100) == 0) {

$pdo->exec(‘set autocommit=0‘);

}

list($username, $password) = explode(‘ ‘,fgets($file));

$username = trim($username);

$password = trim($password);

$sql = "insert into gc_user (`username`,`pwd`)

     VALUES(‘{$username}‘,‘{$password}‘)";

   echo $sql.‘<br>‘;

   $pdo->exec($sql);

if((++$i%100) == 0) {

flush();

$pdo->exec(‘set autocommit=1‘);

}

}

/* 關閉資料庫 */

fclose($file);

echo ‘----------------------------------<br>‘;

echo ‘----------------------------------<br>‘;

echo ‘----------------------------------<br>‘;

echo ‘----------------------------------<br>‘;

echo ‘----------------------------------<br>‘;

echo ‘----------------------------------<br>‘;

echo ‘----------------------------------<br>‘;

echo ‘總共：‘.$i.‘ 資料‘;

}

本文出自 “Linux修仙之路” 部落格，請務必保留此出處http://8999a.blog.51cto.com/11385098/1963637

php 往資料庫插入資料指令碼