Version: 1.0
Type: Full Script
Category: Databases
License: BSD License
Description: A smallest tool for remote MySQL administration!
Cool interface fits only 6 kb!!!
<? // ================================================================ // MySQL client // // Version: 02, 09-Jan-2003 // Author: Oleg Dubas, [email protected], cleverscripts.com // This software can be distributed unlimited for free // Please, report any bugs... // ================================================================ $indexphp = ereg_replace(".*/","",$_SERVER['PHP_SELF']); error_reporting(E_ALL ^ E_WARNING ^ E_NOTICE); $db_host = $_REQUEST['db_host']; $db_user = $_REQUEST['db_user']; $db_pass = $_REQUEST['db_pass']; $db_base = $_REQUEST['db_base']; ?> <html> <head><title>MySQL client</title> <meta http-equiv="expires" content="0"> <meta http-equiv='Content-Type' content='text/html; charset=windows-1252'> <style type="text/css"> td,body { font-family:Verdana;font-size:13px;} table, td, th { border-color: #EEEEEE #CCCCCC #CCCCCC #EEEEEE; border-style: solid; border-width: 1px; background-color:#FFFFFF;} th{color: #FFFFFF; background-color: #3366CC;font-size:10pt;font-weight:bold;text-align:left;} .th1{color: #FFFFFF; background-color: #3366CC;font-size:10pt;font-weight:bold;text-align:center;} .thc {background-color:#3366CC;font-weight:bold;color:#ffffff;text-align:center;} .thl {background-color:#eaeaea;font-weight:bold;text-align:left;} .thr {background-color:#eaeaea;font-weight:bold;text-align:right;} input, textarea, select{font-family: Verdana,Arial,Helvetica; font-size: 11px;} </style> <? // ========= login section ========= if(!$db_host || !$db_base){?> </head><body bgcolor=#FFFFFF><center><table border=1 cellpadding=2><form action=<?=$indexphp?> method=POST><tr><th colspan=2>Fill database data:</th></tr> <tr bgcolor=#E0E0E0><td class=thr>Host:</td><td><input type=text name=db_host value='localhost' style='width:140px'></td></tr> <tr bgcolor=#E0E0E0><td class=thr>Username:</td><td><input type=text name=db_user value='root' style='width:140px'></td></tr> <tr bgcolor=#E0E0E0><td class=thr>Password:</td><td><input type=password name=db_pass style='width:140px'></td></tr> <tr bgcolor=#E0E0E0><td class=thr valign=top<?if($db_host)echo" style='color:#FF0000'";?>>Database:</td><td> <? $db_list = mysql_list_dbs();if(!mysql_error()){ echo "<select multiple size=10 name=db_base style='width:140px' size=1>"; while ($row = mysql_fetch_object($db_list)) echo "<option value='$row->Database'>".$row->Database . "</option>"; echo "</select>";} else echo "<input type=text name=db_base]>"; ?> </td></tr><tr bgcolor=#E0E0E0><td class=th1 colspan=2><input type=submit value="Login >>"></td></tr></form></table></center></body></html> <? exit; } // ========= main section ========== $query = $_REQUEST['query']; if(!$query)$query = "show tables"; $history = $_REQUEST['history']; if($history) { $history = explode(" ", trim($history)); foreach($history as $hk=>$h) if($h) $history[$hk] = str_replace("bla_SPACE_bla"," ",$h);} if(!count($history)) $history[]="show tables"; ?> <script language=JavaScript> var history=new Array(<? foreach($history as $h) echo '"'.$h.'",';?>""); var inHist=<?=count($history)?>,hLen=<?=count($history)?>; function hi_back(){document.f1.query.value=history[--inHist];setHistButtons();} function hi_forw(){document.f1.query.value=history[++inHist];setHistButtons(); } function setHistButtons(){document.f1.h_back.disabled=(inHist==0);document.f1.h_forw.disabled=(inHist>=<?=count($history)?>-1);} function init(){f1.query.focus(); setHistButtons();} function prepare(){var i,j,h,s=''; var regexp = /s/; for(i=0;i<history.length;i++) if(history[i].length){h=history[i];while(h.search(regexp)!=-1) h = h.replace(regexp, "bla_SPACE_bla");s+=h+" ";} var q = document.f1.query.value; while(q.search(regexp)!=-1) q = q.replace(regexp, "bla_SPACE_bla");document.f1.history.value=s+q; } function go(p){document.f1.query.value='select * FROM '+p;prepare();document.f1.submit();return false; } function drop(p){document.f1.query.value='drop table '+p;prepare();document.f1.submit();return false; } function desc(p){document.f1.query.value='describe '+p;prepare();document.f1.submit();return false; } function showt(){document.f1.query.value='show tables';prepare();document.f1.submit();return false; } function rep(){document.f1.query.value=history[hLen-1];prepare();document.f1.submit();return false; } </script></head> <body onLoad="init();" bgcolor=#ffffff alink=#0000ff vlink=#0000ff><? echo "<form method=POST><div align=right>Current database: n<select name=db_base size=1 onchange='submit();'>n"; $db_list = mysql_list_dbs(); while ($row = mysql_fetch_object($db_list)) echo "<option ",($db_base==$row->Database?"selected":"")," value='$row->Database'>",$row->Database,"</option>n"; echo "</select>n<input type=hidden name=db_host value=$db_host><input type=hidden name=db_user value=$db_user><input type=hidden name=db_pass value=$db_pass>"; echo "</div></form>"; $q=stripslashes($query); if(!mysql_connect($db_host,$db_user,$db_pass))die('Error connecting to SQL server'); if(eregi("^use ",$q))$db_base=substr($q,4); if(eregi('show tables',$q))$tv1=1; if($q){ $orderby=''; if(stristr($q,'order by')) $orderby=''; echo"$q$orderby<BR><br>"; if($db_base)mysql_select_db($db_base); if($w=mysql_query($q.$orderby)){ echo'<table width=100% cellpadding=2 bordercolor=#bbbbbb border=1><tr align=center>'; $i=0; if($tv1!=1) while($a=mysql_field_name($w,$i++)){ if(stristr($q,'ORDER BY'))echo"<td class=thc><i>$a</i></td>"; else echo"<td class=thc><i><a href=$a style='color:#ffffff;text-decoration:none;' onclick=" return sortby('$a');">$a</a></i></td>"; $d[]=$a; } else echo "<td colspan=2 class=thc>Tables in <b>"$db_base"</b></td>"; echo'</tr>'; while($a=mysql_fetch_array($w)){ echo"<tr>n"; if($tv1) { $t=$a[0]; echo "<td class=thr>[<a href=$t onClick="return( confirm('Delete table '$t?'')? drop('$t'):false )" style="color:#ff0000">kill</a>] [<a href=$t onClick="return desc('$t');">desc</a>]</td><td width=100% valign=top> <a href=$t onClick="return go('$t');">$t</a></td>";} reset($d); while ($b=each($d)){ $t=$a[$b[1]]; echo'<td valign=top>'; $t1=nl2br(htmlentities(stripslashes($t))); if($t1=="")$t1=" "; echo "$t1</td>"; } print("</tr>n"); } echo'</table>'; } } ?> <center><form name=f1 method=POST onsubmit='prepare();submit();'><input type=text name=query size=60> <input name=h_back type=button value='<' onclick='hi_back();'><input name=h_forw type=button value='>' onclick='hi_forw();'> <input type=button value=Submit onclick='prepare();submit();'> <input type=hidden name=db_host value=<?=$db_host?>><input type=hidden name=db_user value=<?=$db_user?>><input type=hidden name=db_pass value=<?=$db_pass?>><input type=hidden name=db_base value=<?=$db_base?>> <input type=hidden name=history value=''><br><br> <? if(mysql_error()) echo "<font color=#ff0000><b>MySQL error:</b></font> ",mysql_error(),"<br><br>"; ?> <div align=right> <a href=# style='color=#0000ff' onClick='return(rep())'>Repeat query</a> <a href=# style='color=#0000ff' onClick='return(showt())'>Show tables</a> <a href=<?=$indexphp?>>Re-Login</a> </div> </form> </center> </body> </html>
