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, doleg@moldtelecom.md, 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>]&nbsp;[<a href=$t onClick=\"return desc('$t');\">desc</a>]</td><td width=100% valign=top>&nbsp;<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="&nbsp;";
        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();'>
&nbsp;<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>&nbsp;
<a href=# style='color=#0000ff' onClick='return(showt())'>Show tables</a>&nbsp;
<a href=<?=$indexphp?>>Re-Login</a>
</div>
</form>
</center>
</body>
</html>