弱水叁仟 發表於 2011-9-28 17:20:22

MYSQL_OUTPUT 脱裤(脱库)通用脚本(修正版)

<br><div class="msgheader"><div class="right"><span style="CURSOR: pointer" class="copybut"><u>复制代码</u></span></div>代码如下:</div><div class="msgborder" id="phpcode1"> <br />&lt;html&gt; <br />&lt;head&gt; <br />&lt;title&gt;:: hExI3_Securi7y_TeAm...SCRIPT_FILENAME : &lt;?=$_SERVER["PHP_SELF"]?&gt;&lt;/title&gt; <br />&lt;style type="text/css"&gt; <br />.font{ <br />size : 2px; <br />} <br />&lt;/style&gt; <br />&lt;/head&gt; <br />&lt;body&gt; <br />&lt;h4&gt;Mysql Database on Tables to Txt...&lt;/h4&gt; <br />#_E-mail:go_root#Hotmail.com <br /> <br />#_Author:HYrz<br /> <br />-------------------------------------------------------- <br /> <br />&lt;form action="" method="POST" name="Submit"&gt; <br />&lt;b&gt;Host: &lt;/b&gt; &lt;input type="text" name="host" value="127.0.0.1:3306"&gt;<br /> <br />&lt;b&gt; User: &lt;/b&gt; &lt;input type="text" name="user" value="root"&gt;<br /> <br />&lt;b&gt; Password: &lt;/b&gt; &lt;input type="text" name="pass" value="root"&gt;<br /> <br />&lt;b&gt;Database Check: &lt;/b&gt; &lt;input type="text" name="database" value="phpwms"&gt; <br />&lt;b&gt; Tables is: &lt;/b&gt; &lt;input type="text" name="table" value="pw_admin"&gt;<br /> <br />&lt;b&gt;New_Data Filename:&lt;/b&gt; &lt;input type="text" name="back_file" value="data.txt"&gt; <br /> <br /> <br />&lt;a href = "https://www.jb51.net"&gt;琼殿技术社区&lt;/a&gt;<br /> <br />&lt;input type="submit" name="submit" value="0utPut"&gt; <br /> <br />&lt;/form&gt; <br />&lt;/body&gt; <br />&lt;?php <br />ini_set('display_errors', 1); <br />set_time_limit(0); <br />//error_reporting(E_ALL); <br />function ShowMessage($Str) <br />{ <br />$FILENAME = $_SERVER["PHP_SELF"]; <br />Die('&lt;script&gt;document.write("'.$Str.'")&lt;/script&gt;'); <br />Die('&lt;script&gt;window.localtion="'.$FILENAME.'";&lt;/script&gt;'); <br />} <br />function _Printf($Str, $type = '') <br />{ <br />if (empty($type)) <br />echo '&lt;font color="red" face="verdana" size="2px"&gt;[+]&amp;nbsp'.$Str.'&lt;/font&gt;<br />'; <br />else <br />echo '&lt;font color="red" face="verdana" size="2px"&gt;[#] '.$Str.'&lt;/font&gt;<br />'; <br />} <br />function dirsize($dir) { <br />@$dh = opendir($dir); <br />$size = 0; <br />while ($file = @readdir($dh)) { <br />if ($file != "." and $file != "..") { <br />$path = $dir."/".$file; <br />if (is_dir($path)) { <br />$size += dirsize($path); <br />} elseif (is_file($path)) { <br />$size += filesize($path); <br />} <br />} <br />} <br />@closedir($dh); <br />return $size; <br />} <br />if (empty($_POST['submit'])) exit(); <br />$db_host = $_POST["host"]; <br />$db_user = $_POST["user"]; <br />$db_pass = $_POST["pass"]; <br />$db_database = $_POST["database"]; <br />$db_table = $_POST["table"]; <br />$backDB_Filename = $_POST["back_file"]; <br />//endPost <br />if (empty($db_host)){ <br />$_POST["host"] = $db_host; <br />ShowMessage("Messagebox: Host Error!"); <br />}elseif (empty($db_user)) { <br />$_POST["user"] = $db_user; <br />ShowMessage("Messagebox: User Error!"); <br />}elseif (empty($db_pass)){ <br />$_POST["pass"] = $db_pass; <br />ShowMessage("Messagebox: Pass Error!"); <br />}elseif (empty($db_database)) { <br />$_POST["database"] = $db_database; <br />ShowMessage("Messagebox: Database Error!"); <br />}elseif (empty($db_table)) { <br />$_POST["table"] = $db_table; <br />ShowMessage("Messagebox: table Error!"); <br />}elseif (empty($backDB_Filename)) { <br />$_POST["back_file"] = $backDB_Filename; <br />ShowMessage("Messagebox: backDB_Filename Error!"); <br />} #endif <br />if (!is_dir('data_xiaosan')) { <br />mkdir('data_xiaosan',0777); <br />}#endif <br />$sql = mysql_connect($db_host,$db_user,$db_pass) or ShowMessage('&lt;font color="red" Size=2px&gt;[#] connect Error ! &lt;/font&gt;'); <br />mysql_select_db($db_database,$sql) or die("Could not connect: " . mysql_error()); <br />$result = mysql_query("SELECT * FROM $db_table",$sql) or die("Could not connect: " . mysql_error()); <br />$FieldCount = mysql_query("SELECT CoUnt(*) FrOm $db_table",$sql); <br />$F_Num = mysql_fetch_row($FieldCount); <br />_Printf('InforMatIon : --------------','Main'); <br />_Printf("TableCounts :". + $F_Num); <br />if ($F_Num &lt; 500){ <br />$SuB1 = $F_Num / 2; <br />} else $SuB1 = 500; //endif <br />$i = 0; <br />$tmp = ''; <br />while ($row = mysql_fetch_array($result, MYSQL_NUM)) { <br />$i = $i+1; <br />$tmp .= implode("::", $row)."\n"; <br />if(!($i%$SuB1)){ <br />$filename_ = 'data_xiaosan/'.intval($i/$SuB1).$backDB_Filename; <br />file_put_contents($filename_,$tmp); <br />$tmp = ''; <br />}#endif <br />}#endwhile <br />mysql_free_result($result); <br />mysql_close($sql); <br />if (dirsize('data_xiaosan')&gt;1){ <br />_Printf("&lt;b&gt;Msg : OutPut_Succ!&lt;/b&gt;");}else <br />_Printf("Err : output fail !"); //endPri <br />?&gt; <br />&lt;/html&gt; <br /></div>
頁: [1]
查看完整版本: MYSQL_OUTPUT 脱裤(脱库)通用脚本(修正版)