Simple PHP Mysql client

\nnot connect\";"));} else{die(eval($text.";echo \$etext.\"\";"));} $version=mysql_fetch_row(mysql_query('SELECT version()')); if(!empty($_POST['db'])){@mysql_select_db($_POST['db'])or die(eval($text.";echo \$etext.\"Could not select db
\";"));} if(empty($_POST['table_sel']) && !empty($_POST['table_sel2']))$_POST['table_sel']=$_POST['table_sel2']; function select(){ global $connect; if(isset($_POST['table_sel2']) && $_POST['table_sel']!=$_POST['table_sel2']){$_POST['sort']=null;$_POST['br_st']=null;} $sort=(!empty($_POST['sort'])?'ORDER BY `'.trim($_POST['sort']).'` '.(($_POST['asc']==='asc')?'ASC':'DESC').' ':''); $co=((isset($_POST['br_st']) && isset($_POST['br_en']) && isset($_POST['brow']))?$_POST['br_en'].','.$_POST['br_st']:'0,20'); $_POST['querysql']=((!empty($_POST['querysql']) && isset($_POST['push']))?$_POST['querysql']:"SELECT * FROM `".$_POST['table_sel']."` $sort limit $co"); $result=@mysql_query($_POST['querysql'],$connect) or print("

"); if(is_resource($result)){ $meta=mysql_fetch_field($result); $tables=$meta->table; $tr=0; if($tables==true){ $tr=1; if($quer=mysql_query("select count(*) from $tables"))$n=mysql_fetch_array($quer); else $tr=2; } else{ $_POST['table_sel']=$tables; if($tr==1)$n=mysql_fetch_row(mysql_query('select count(*) from '.$_POST['table_sel'])); } if($tr>0){ print($tr==1)?"":''; $arr=array(); for ($i=0;$i"; $fields=@mysql_list_fields($_POST['db'],$tables,$connect); $coms=@mysql_num_fields($fields); if($coms>0){ echo "\n"; for($i=0;$i<$coms;$i++){ $lk=mysql_field_name($fields, $i); print((count($arr)>0 && array_search($lk,$arr)!==false)?"":"\n"); }} while($line=mysql_fetch_assoc($result)){ $linet=$line; if($tr>0){ if(count($arr)==0){ while(list($key,$val)=each($line)){$up_e.="`$key`='".addslashes($val)."' and ";} $up_e=substr($up_e,0,-5);} else{ while(list($key,$val)=each($line)){ if(array_search($key,$arr)!==false){$up_e.="`$key`='".addslashes($val)."' and ";}} $up_e=substr($up_e,0,-4); } $up_e=urlencode($up_e); print "\n"; } else echo "\n"; $up_e=''; foreach($line as $col_value){ echo "\n"; } echo "\n";} echo "

	$lk	$lk
".(($tr==1)?"":' ')."
".((strlen($col_value)>40)?''.htmlspecialchars($col_value).'':htmlspecialchars($col_value))."

"; if($tr==1){ echo "

Sort by Showrow(s) start from

"; } mysql_free_result($result); } else{ if($result===false)echo mysql_error($connect); else echo 'Query susceful! %)'; } } function load($file){ global $far; if(file_exists($file)){ eval("\$zd=".$far[$_POST['compr']]."open(\$file,'r');"); ($_POST['compr']<2)?eval("\$buff='';while(!".$far[$_POST['compr']]."eof(\$zd)){\$buff.=".$far[$_POST['compr']]."gets(\$zd);}"):eval("\$buff=bzread(\$zd);"); eval($far[$_POST['compr']]."close(\$zd);"); return($buff); } else{ print 'no such file!'; } } function write($data){ global $dump,$fp,$far; ($_POST['save']==0)?$dump.=$data:(isset($fp)?eval($far[$_POST['compr']]."write(\$fp,\$data);"):null);} function sqlh(){ if($_POST['save']>0){ global $server,$dbtr; write("#\n#Server : ".getenv('SERVER_NAME')." #DB_Host : ".$server." #DB : ".$_POST['db']. (($dbtr==0)?" #Table : ".$_POST['table_sel']:"")."\n#\n\n");}} function sql($tabel_sel){ global $connect; $row=mysql_fetch_row(mysql_query("SHOW CREATE TABLE `$tabel_sel`",$connect)); write("DROP TABLE IF EXISTS `$tabel_sel`;\n".$row[1].";\n\n");} function test($aaa){ $d=array(); while(list($key,$val)=each($aaa)){$d[$key]=addslashes($val);} return($d);} function sql1($table_sel){ global $connect,$dbtr; $result=mysql_query("SELECT ".(!empty($_POST['ufiled'])?$_POST['ufiled']:'*')." FROM `$table_sel` ".(($dbtr==0)?'LIMIT '.$_POST['ulimits'].','.$_POST['ulimite']:''),$connect); while($line=mysql_fetch_assoc($result)){ ((!isset($key))?($key=implode('`, `',array_keys($line))):null); $ddd=test(array_values($line)); $val=implode('\', \'',$ddd); write("INSERT INTO `".$table_sel."`(`".$key."`) VALUES ('".$val."');\n");} mysql_free_result($result);} function head($tmpfname,$name){ header("Content-Type: application/octet-stream; name=\"$name\""); header("Content-Length: ".filesize($tmpfname).""); header("Content-disposition: attachment; filename=\"$name\""); $fd=fopen($tmpfname,"r"); while(!feof($fd)){ echo fgets($fd,4096);} fclose($fd); ($_POST['save']==1)?unlink($tmpfname):null; exit;} function csv($table_sel){ global $connect,$far,$dbtr; $res=mysql_query("SELECT ".(!empty($_POST['ufiled'])?$_POST['ufiled']:'*')." FROM `$table_sel` ".(($dbtr==0)?'LIMIT '.$_POST['ulimits'].','.$_POST['ulimite']:''),$connect); $i=0; $keys=''; while($key=@mysql_field_name($res,$i++))$keys.=$key."; "; write("# Fields: \n#".$keys."\n\n"); if(mysql_num_rows($res)>0){ while($row=mysql_fetch_assoc($res)){ $values=array_values($row); foreach($values as $k=>$v){$values[$k]=addslashes($v);} $values=implode($_POST['cvs_term'],$values); write($values."\n"); } }} if(isset($_POST['back']) && (isset($_POST['table_sel']) || $_POST['dbtr']=1 )){ $dbtr=$_POST['dbtr']; $dump=''; if($_POST['save']>0){ $tmpfname=($_POST['save']==1)?tempnam($_POST['save_p'],"sess_"):$_POST['local']; if(is_writeable(dirname($tmpfname))){ eval("\$fp=".$far[$_POST['compr']]."open(\$tmpfname,'w');"); } } sqlh(); switch($_POST['as']){ case 0: switch($_POST['as_sql']){ case 0: if($dbtr==1){ $it=0; while($table_sel=@mysql_tablename(mysql_list_tables($_POST['db']),$it++)){ sql($table_sel); }} else sql($_POST['table_sel']); break; case 1: if($dbtr==1){ $it=0; while($table_sel=@mysql_tablename(mysql_list_tables($_POST['db']),$it++)){ sql($table_sel); sql1($table_sel); }} else { sql($_POST['table_sel']); sql1($_POST['table_sel']); } break; case 2: if($dbtr==1){ $it=0; while($table_sel=@mysql_tablename(mysql_list_tables($_POST['db']),$it++)){ sql1($table_sel); }} else sql1($_POST['table_sel']); break;} if($_POST['save']>0){ if(isset($fp)){ eval($far[$_POST['compr']]."close(\$fp);"); ($_POST['save']==1)?head($tmpfname,(($dbtr==1)?$_POST['db']:$_POST['table_sel']).$far[$_POST['compr']+3]):($message=''.$_POST['local'].' Saved');} else $message='No writeable select Dir'; } break; case 1: //----------------------------------- if($dbtr==1){ $it=0; while($table_sel=@mysql_tablename(mysql_list_tables($_POST['db']),$it++)){ write("\n# Table: $table_sel\n"); csv($table_sel); }} else csv($_POST['table_sel']); if($_POST['save']>0){ eval($far[$_POST['compr']]."close(\$fp);"); ($_POST['save']==1)?head($tmpfname,(($dbtr==1)?$_POST['db']:$_POST['table_sel']).$far[$_POST['compr']+3]):''; } //------------------------------ break;}} eval($text.";echo \$etext.\"\n

\";"); if(!isset($_POST['dd'])){ $db_list=mysql_list_dbs($connect); echo ""; } else echo "\n"; echo "

\n"; if(!empty($_POST['db'])){ $it=0; $table_selt=array(); while($table_selt[]=@mysql_tablename(mysql_list_tables($_POST['db']),$it++)); if(isset($_POST['table_sel']) && array_search($_POST['table_sel'],$table_selt)===false)$_POST['table_sel']=''; if(mysql_num_rows(mysql_list_tables($_POST['db']))>0){ if(!isset($_POST['dt'])){ echo ""; } else { if(!empty($_POST['table_sel']))$nt=mysql_fetch_array(mysql_query("select count(*) from ".$_POST['table_sel'])); echo "\n"; }} else echo ' No tables =\'; echo "

SQL Search Export Import "; if(!empty($_POST['table_sel']))echo " Browse Insert"; echo "

\n".(isset($message)?$message:'');} if(isset($_POST['push']) && !empty($_POST['querysql']))$_POST['go']=4; if(isset($_POST['back']))$_POST['go']=2; if(isset($_POST['brow']))$_POST['go']=4; if(isset($_POST['editr']) && isset($_POST['edit']))$_POST['go']=6;// EDIT if(isset($_POST['ed_save']))$_POST['go']=7;//INSERT if(isset($_POST['search']))$_POST['go']=8; if(isset($_POST['up']) && (!empty($_POST['load']) || !empty($_POST['upload'])))$_POST['go']=9; elseif(isset($_POST['up']))$_POST['go']=3; if((isset($_POST['dell']) && isset($_POST['edit']))|| isset($_POST['delp']))$_POST['go']=10; if(!isset($_POST['go']) && !empty($_POST['table_sel']))$_POST['go']=4; if(isset($_POST['go'])){ switch($_POST['go']){ case 0: //SQL echo "

\n"; break; case 1: echo "

Location	Options	Search conditions	Limit

"; break; case 3: //IMPORT echo "

Load file:
Local file:
Text".(function_exists('gzencode')?'Gzip':'').(function_exists('bzcompress')?'Bzip2':'')."

"; break; case 4: //BROWSE if(!empty($_POST['table_sel']) || isset($_POST['querysql']))select(); //+++++++++++++++++++++++++++++++++++BROWSE _ END ++++++++++++++++++++++++++++++ break; case 2: //EXPORT if(!isset($_POST['back'])){ echo '

Export as

SQL

CSV

SQL

Only structure

All

Only data

CSV

Terminated

View

Download

Temp path

Save as local file

Compression

None

Gzip

Bzip2

'.(!empty($_POST['table_sel'])?'':'').'

Backup

All DataBase

Only One Table

'; if(isset($nt)){ echo '

If backup only one table, use this options(optional)
Use Fileds (Separator as ","),if emty then use All Fileds
Limit:

'; } echo ''; } if(isset($_POST['back']) && $_POST['save']==0)echo ""; break; case 5: //INSERT IN TABLE if(!empty($_POST['table_sel'])){ echo "

\n"; $fields=mysql_list_fields($_POST['db'],$_POST['table_sel'],$connect); for($i=0;$i\n";} echo "

".mysql_field_name($fields,$i).'

'.mysql_field_type($fields,$i).'('.mysql_field_len($fields,$i).")

".((mysql_field_len($fields,$i)<40)?"":"")."

"; } break; case 6: //EDIT if($_POST['table_sel']===$_POST['table_sel2']){ $up_e=$_POST['edit']; echo ""; $up_e=urldecode($_POST['edit']); echo "

\n"; $fi=0; $result=mysql_query("SELECT * FROM `".$_POST['table_sel']."` WHERE $up_e",$connect); while($line=mysql_fetch_assoc($result)){ foreach($line as $key=>$col_value){ echo "\n"; $fi++;}} echo "

".mysql_field_name($result,$fi).'

'.mysql_field_type($result,$fi).'('.mysql_field_len($result,$fi).")

".((mysql_field_len($result,$fi)<40)?"":"")."

"; } else select(); break; case 7: //INSERT/UPDATE $ted=''; reset($_POST); while(list($key,$val)=each($_POST)){ if(preg_match('/^ed_key:(.+)/',$key,$m)){ $ted.="`".$m[1]."`= '".addslashes($val)."', "; }} $ted=substr($ted,0,-2); $query=((isset($_POST['insert']))?"INSERT":"UPDATE")." `".$_POST['table_sel']."` SET $ted ".((isset($_POST['insert']))?'':"WHERE ".urldecode($_POST['edit'])." LIMIT 1 "); echo "

".htmlspecialchars($query,ENT_QUOTES)."

"; $result=mysql_query($query,$connect) or print("

".mysql_error($connect)."

"); echo "

".mysql_info($connect)."

"; break; case 8: //SEARCH; print "

"; $j=0; function spdb($line){ global $connect,$j,$sql; $fields=mysql_list_fields($_POST['db'], $line, $connect ); $columns=mysql_num_fields($fields); for($i=0;$i<$columns;$i++){ $nomField=mysql_field_name($fields,$i); $sql="SELECT ".$nomField." FROM ".$line." WHERE ".$nomField.' '.$_POST['opts'].(!preg_match('/NULL/',$_POST['opts'])?" ".(!preg_match('/[><]/',$_POST['opts'])?"'":'').addslashes($_POST['seart']).(!preg_match('/[><]/',$_POST['opts'])?"'":''):'').(!empty($_POST['limits'])?' LIMIT '.$_POST['limits']:''); $query=mysql_query($sql) or print(mysql_error($connect)); if(mysql_num_rows($query)>0){ while($result=mysql_fetch_array($query)){ echo "Table: ".$line." Field: ".$nomField."
SQL: ".htmlspecialchars($sql)."
".htmlspecialchars($result[0])."
"; echo "

"; $j++; }}}} if($_POST['locas']==0){ $tables=mysql_list_tables($_POST['db']); while($line=mysql_fetch_row($tables)){ spdb($line[0]); }} else{ spdb($_POST['table_sel']); } echo "

Results: ".$j.'

'; break; case 9: if(is_uploaded_file($_FILES['upload']['tmp_name'])) { $data=load($_FILES['upload']['tmp_name']); } elseif(!empty($_POST['load'])){ $data=load($_POST['load']); } if(isset($data)){ $arrup=explode(';',$data); if(preg_match('/^[ \n\r]?$/',$arrup[count($arrup)-1]))array_splice($arrup,-1); foreach($arrup as $aup){ mysql_query($aup,$connect) or $err=1; } print(isset($err)?mysql_error($connect):'Query susceful!'); } break; case 10: //DELETE if(!isset($_POST['table_sel2']) || $_POST['table_sel']===$_POST['table_sel2']){ $code='DELETE FROM `'.$_POST['table_sel'].'` WHERE '.urldecode($_POST['edit']).' LIMIT 1'; isset($_POST['delp'])?mysql_query($code):print("

".htmlspecialchars($code).'

'); } else select(); break; }} echo "

\n"; } else eval($text.";echo \$etext;"); echo ""; exit; ?>