//File: query.php
//描述: 資料庫批量導入腳本
//功能: 可進行單行和批量插入.
//作者: SworDs
//QQ: 78623269
//日期: 2005-1-21
//其他:好老了啊，剛學PHP寫的，連抄帶查！2006.5.19從倉庫裡翻出來,。。。
error_reporting(7);
if ( function_exists('ini_get') ) {
$onoff = ini_get('register_globals');
} else {
$onoff = get_cfg_var('register_globals');
}
if ($onoff != 1) {
@extract($_POST, EXTR_SKIP);
@extract($_GET, EXTR_SKIP);
}
// 去掉轉義字元
function stripslashes_array(&$array) {
while(list($key,$var) = each($array)) {
if ($key != 'argc' && $key != 'argv' && (strtoupper($key) != $key || ''.intval($key) == "$key")) {
if (is_string($var)) {
$array[$key] = stripslashes($var);
}
if (is_array($var)) {
$array[$key] = stripslashes_array($var);
}
}
}
return $array;
}
// 判斷 magic_quotes_gpc 狀态
if (get_magic_quotes_gpc()) {
$_POST = stripslashes_array($_POST);
}
?>
資料庫批量導入腳本 by SworDs
body,td {
font-family: "sans-serif";
font-size: "12px";
line-height: "150%";
}
.INPUT {
FONT-SIZE: "12px";
COLOR: "#000000";
BACKGROUND-COLOR: "#FFFFFF";
height: "18px";
border: "1px solid #666666";
}
.firstalt {BACKGROUND-COLOR: "#EFEFEF"}
.secondalt {BACKGROUND-COLOR: "#F5F5F5"}
if ($_GET['action'] == "sql") {
$servername = isset($servername) ? $servername : 'localhost';
$dbusername = isset($dbusername) ? $dbusername : 'root';
$dbpassword = isset($dbpassword) ? $dbpassword : '';
$dbname = isset($dbname) ? $dbname : '';
}
if($doquery) {
if(@mysql_connect($servername,$dbusername,$dbpassword) AND @mysql_select_db($dbname))
{
echo "資料庫連接配接執行!\n";
}
else
{
echo "出錯: ".mysql_error();
}
$a_query = explode(";",$_POST['sql_query']);
while (list(,$query) = each($a_query)) {
$query = trim($query);
if ($query) {
if (strstr($query,'CREATE TABLE')) {
ereg('CREATE TABLE ([^ ]*)',$query,$regs);
mysql_query("DROP TABLE IF EXISTS $regs[1]");
echo "
正在建立表: ".$regs[1]." …… ";
[email protected]_query($query);
if ($result)
{
echo "成功!
\n";
} else {
echo "失敗!
\n";
}
} else {
[email protected]_query($query);
echo ($result) ? "SQL語句成功執行\n" : "出錯: ".mysql_error();
}
}
}
mysql_close();
}
elseif(connect){
if(@mysql_connect($servername,$dbusername,$dbpassword) AND @mysql_select_db($dbname)) {
echo "資料庫連接配接執行!\n";
}else{
echo "出錯: ".mysql_error();
}
}
?>
| 資料庫批量導入腳本 By SworDs |
| Host: User: Pass: DB: |