get_db_select PHP 코드 예제들

예제 #1

0

파일 보기

파일: ourdba.php 프로젝트: Esdras1995/Guardtour

function print_header()
{
    global $err_msg, $VERSION, $DB, $dbh, $self, $is_sht;
    $dbn = $DB['db'];
    ?>



<html>



<head><title>pma</title>



<style type="text/css">



body,th,td{font-family:Arial,Helvetica,sans-serif;font-size:80%;padding:0px;margin:0px}



div{padding:3px}



.inv{background-color:#006699;color:#FFFFFF}



.inv a{color:#FFFFFF}



table.res tr{vertical-align:top}



tr.e{background-color:#CCCCCC}



tr.o{background-color:#EEEEEE}



tr.h{background-color:#9999CC}



.err{color:#FF3333;font-weight:bold;text-align:center}



.frm{width:400px;border:1px solid #999999;background-color:#eeeeee;text-align:left}



</style>







<script type="text/javascript">



function frefresh(){



 var F=document.DF;



 F.method='get';



 F.refresh.value="1";



 F.submit();



}



function go(p,sql){



 var F=document.DF;



 F.p.value=p;



 if(sql)F.q.value=sql;



 F.submit();



}



function ays(){



 return confirm('Are you sure to continue?');



}



function chksql(){



 var F=document.DF;



 if(/^\s*(?:delete|drop|truncate|alter)/.test(F.q.value)) return ays();



}



<?php 
    if ($is_sht) {
        ?>



function chkall(cab){



 var e=document.DF.elements;



 if (e!=null){



  var cl=e.length;                   



  for (i=0;i<cl;i++){var m=e[i];if(m.checked!=null && m.type=="checkbox"){m.checked=cab.checked}}



 }



}



function sht(f){



 document.DF.dosht.value=f;



}



<?php 
    }
    ?>



</script>







</head>



<body>



<form method="post" name="DF" action="<?php 
    echo $self;
    ?>
" enctype="multipart/form-data">



<input type="hidden" name="refresh" value="">



<input type="hidden" name="p" value="">







<div class="inv">



<a href="http://phpminiadmin.sourceforge.net/" target="_blank"><b>phpMiniAdmin <?php 
    echo $VERSION;
    ?>
</b></a>



<?php 
    if ($_SESSION['is_logged'] && $dbh) {
        ?>



 | 



Database: <select name="db" onChange="frefresh()"><option value='*'> - select/refresh -<?php 
        echo get_db_select($dbn);
        ?>
</select>



<?php 
        if ($dbn) {
            $z = " &#183;<a href='{$self}?db={$dbn}";
            ?>



<?php 
            echo $z;
            ?>
&q=show+tables'>show tables</a>



<?php 
            echo $z;
            ?>
&q=show+table+status'>status</a>



<?php 
            echo $z;
            ?>
&shex=1'>export</a>



<?php 
            echo $z;
            ?>
&shim=1'>import</a>



<?php 
        }
        ?>



 | <a href="file:///E|/www/test/jay/?showcfg=1">Settings</a> 



<?php 
    }
    ?>



<?php 
    if ($GLOBALS['ACCESS_PWD']) {
        ?>
 | <a href="?logoff=1">Logoff</a> <?php 
    }
    ?>



 | <a href="?phpinfo=1">phpinfo</a>



</div>







<div class="err"><?php 
    echo $err_msg;
    ?>
</div>







<?php 
}

예제 #2

0

파일 보기

파일: phpminiadmin.php 프로젝트: nukem/NEC

function print_header()
{
    global $err_msg, $VERSION, $DB, $dbh, $self, $is_sht, $xurl;
    $dbn = $DB['db'];
    ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head><title>phpMiniAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<style type="text/css">
body{font-family:Arial,sans-serif;font-size:80%;padding:0;margin:0}
th,td{padding:0;margin:0}
div{padding:3px}
pre{font-size:125%}
.inv{background-color:#069;color:#FFF}
.inv a{color:#FFF}
table.res th, table.res td{padding:2px}
table.res tr{vertical-align:top}
tr.e{background-color:#CCC}
tr.o{background-color:#EEE}
tr.h{background-color:#99C}
tr.s{background-color:#FF9}
.err{color:#F33;font-weight:bold;text-align:center}
.frm{width:400px;border:1px solid #999;background-color:#eee;text-align:left}
.dot{border-bottom:1px dotted #000}
</style>

<script type="text/javascript">
function $(i){return document.getElementById(i)}
function frefresh(){
 var F=document.DF;
 F.method='get';
 F.refresh.value="1";
 F.submit();
}
function go(p,sql){
 var F=document.DF;
 F.p.value=p;
 if(sql)F.q.value=sql;
 F.submit();
}
function ays(){
 return confirm('Are you sure to continue?');
}
function chksql(){
 var F=document.DF;
 if(/^\s*(?:delete|drop|truncate|alter)/.test(F.q.value)) return ays();
}
function tmv(tr){
 tr.sc=tr.className;
 tr.className='h';
}
function tmo(tr){
 tr.className=tr.sc;
}
function tc(tr){
 tr.className='s';
 tr.sc='s';
}
function after_load(){
}
<?php 
    if ($is_sht) {
        ?>
function chkall(cab){
 var e=document.DF.elements;
 if (e!=null){
  var cl=e.length;                   
  for (i=0;i<cl;i++){var m=e[i];if(m.checked!=null && m.type=="checkbox"){m.checked=cab.checked}}
 }
}
function sht(f){
 document.DF.dosht.value=f;
}
<?php 
    }
    ?>
</script>

</head>
<body onload="after_load()">
<form method="post" name="DF" action="<?php 
    echo $self;
    ?>
" enctype="multipart/form-data">
<input type="hidden" name="XSS" value="<?php 
    echo $_SESSION['XSS'];
    ?>
">
<input type="hidden" name="refresh" value="">
<input type="hidden" name="p" value="">

<div class="inv">
<a href="http://phpminiadmin.sourceforge.net/" target="_blank"><b>phpMiniAdmin <?php 
    echo $VERSION;
    ?>
</b></a>
<?php 
    if ($_SESSION['is_logged'] && $dbh) {
        ?>
 | 
<a href="?<?php 
        echo $xurl;
        ?>
&q=show+databases">Databases</a>: <select name="db" onChange="frefresh()"><option value='*'> - select/refresh -</option><option value=''> - show all -</option><?php 
        echo get_db_select($dbn);
        ?>
</select>
<?php 
        if ($dbn) {
            $z = " &#183;<a href='{$self}?{$xurl}&db={$dbn}";
            echo $z;
            ?>
&q=show+tables'>show tables</a>
<?php 
            echo $z;
            ?>
&q=show+table+status'>status</a>
<?php 
            echo $z;
            ?>
&shex=1'>export</a>
<?php 
            echo $z;
            ?>
&shim=1'>import</a>
<?php 
        }
        ?>
 | <a href="?showcfg=1">Settings</a> 
<?php 
    }
    if ($GLOBALS['ACCESS_PWD']) {
        ?>
 | <a href="?<?php 
        echo $xurl;
        ?>
&logoff=1">Logoff</a> <?php 
    }
    ?>
 | <a href="?phpinfo=1">phpinfo</a>
</div>

<div class="err"><?php 
    echo $err_msg;
    ?>
</div>

<?php 
}

예제 #3

0

파일 보기

파일: phpminiadmin.php 프로젝트: AlvaCorp/maxon

function print_header()
{
    global $err_msg, $VERSION, $DB, $dbh, $self, $is_sht, $xurl, $SHOW_T;
    $dbn = $DB['db'];
    ?>
<!DOCTYPE html>
<html>
<head><title>phpMiniAdmin</title>
<meta charset="utf-8">
<style type="text/css">
body{font-family:Arial,sans-serif;font-size:80%;padding:0;margin:0}
th,td{padding:0;margin:0}
div{padding:3px}
pre{font-size:125%}
.nav{text-align:center}
.ft{text-align:right;margin-top:20px;font-size:smaller}
.inv{background-color:#069;color:#FFF}
.inv a{color:#FFF}
table.res{width:100%;border-collapse:collapse;}
table.wa{width:auto}
table.res th,table.res td{padding:2px;border:1px solid #fff;vertical-align: top}
table.restr{vertical-align:top}
tr.e{background-color:#CCC}
tr.o{background-color:#EEE}
tr.e:hover, tr.o:hover {background-color:#FF9}
tr.h{background-color:#99C}
tr.s{background-color:#FF9}
.err{color:#F33;font-weight:bold;text-align:center}
.frm{width:400px;border:1px solid #999;background-color:#eee;text-align:left}
.frm label.l{width:100px;float:left}
.dot{border-bottom:1px dotted #000}
.ajax{text-decoration: none;border-bottom: 1px dashed;}
.qnav{width:30px}
</style>

<script type="text/javascript">
var LSK='pma_',LSKX=LSK+'max',LSKM=LSK+'min',qcur=0,LSMAX=32;

function $(i){return document.getElementById(i)}
function frefresh(){
 var F=document.DF;
 F.method='get';
 F.refresh.value="1";
 F.submit();
}
function go(p,sql){
 var F=document.DF;
 F.p.value=p;
 if(sql)F.q.value=sql;
 F.submit();
}
function ays(){
 return confirm('Are you sure to continue?');
}
function chksql(){
 var F=document.DF,v=F.q.value;
 if(/^\s*(?:delete|drop|truncate|alter)/.test(v)) if(!ays())return false;
 if(lschk(1)){
  var lsm=lsmax()+1,ls=localStorage;
  ls[LSK+lsm]=v;
  ls[LSKX]=lsm;
  //keep just last LSMAX queries in log
  if(!ls[LSKM])ls[LSKM]=1;
  var lsmin=parseInt(ls[LSKM]);
  if((lsm-lsmin+1)>LSMAX){
   lsclean(lsmin,lsm-LSMAX);
  }
 }
 return true;
}
function tc(tr){
 if (tr.className=='s'){
  tr.className=tr.classNameX;
 }else{
  tr.classNameX=tr.className;
  tr.className='s';
 }
}
function lschk(skip){
 if (!localStorage || !skip && !localStorage[LSKX]) return false;
 return true;
}
function lsmax(){
 var ls=localStorage;
 if(!lschk() || !ls[LSKX])return 0;
 return parseInt(ls[LSKX]);
}
function lsclean(from,to){
 ls=localStorage;
 for(var i=from;i<=to;i++){
  delete ls[LSK+i];ls[LSKM]=i+1;
 }
}
function q_prev(){
 var ls=localStorage;
 if(!lschk())return;
 qcur--;
 var x=parseInt(ls[LSKM]);
 if(qcur<x)qcur=x;
 $('q').value=ls[LSK+qcur];
}
function q_next(){
 var ls=localStorage;
 if(!lschk())return;
 qcur++;
 var x=parseInt(ls[LSKX]);
 if(qcur>x)qcur=x;
 $('q').value=ls[LSK+qcur];
}
function after_load(){
 var p=document.DF.pwd;
 if (p) p.focus();
 qcur=lsmax();
}
function logoff(){
 if(lschk()){
  var ls=localStorage;
  var from=parseInt(ls[LSKM]),to=parseInt(ls[LSKX]);
  for(var i=from;i<=to;i++){
   delete ls[LSK+i];
  }
  delete ls[LSKM];delete ls[LSKX];
 }
}
function cfg_toggle(){
 var e=$('cfg-adv');
 e.style.display=e.style.display=='none'?'':'none';
}
<?php 
    if ($is_sht) {
        ?>
function chkall(cab){
 var e=document.DF.elements;
 if (e!=null){
  var cl=e.length;
  for (i=0;i<cl;i++){var m=e[i];if(m.checked!=null && m.type=="checkbox"){m.checked=cab.checked}}
 }
}
function sht(f){
 document.DF.dosht.value=f;
}
<?php 
    }
    ?>
</script>

</head>
<body onload="after_load()">
<form method="post" name="DF" action="<?php 
    eo($self);
    ?>
" enctype="multipart/form-data">
<input type="hidden" name="XSS" value="<?php 
    eo($_SESSION['XSS']);
    ?>
">
<input type="hidden" name="refresh" value="">
<input type="hidden" name="p" value="">

<div class="inv">
<a href="http://phpminiadmin.sourceforge.net/" target="_blank"><b>phpMiniAdmin <?php 
    eo($VERSION);
    ?>
</b></a>
<?php 
    if ($_SESSION['is_logged'] && $dbh) {
        ?>
 | <a href="?<?php 
        eo($xurl);
        ?>
&q=show+databases">Databases</a>: <select name="db" onChange="frefresh()"><option value='*'> - select/refresh -</option><option value=''> - show all -</option>
<?php 
        echo get_db_select($dbn);
        ?>
</select>
<?php 
        if ($dbn) {
            $z = " &#183; <a href='" . hs($self . "?{$xurl}&db={$dbn}");
            echo $z . '&q=' . urlencode($SHOW_T);
            ?>
'>show tables</a>
<?php 
            echo $z;
            ?>
&shex=1'>export</a>
<?php 
            echo $z;
            ?>
&shim=1'>import</a>
<?php 
        }
        ?>
 | <a href="?showcfg=1">Settings</a>
<?php 
    }
    if ($GLOBALS['ACCESS_PWD']) {
        ?>
 | <a href="?<?php 
        eo($xurl);
        ?>
&logoff=1" onclick="logoff()">Logoff</a> <?php 
    }
    ?>
 | <a href="?phpinfo=1">phpinfo</a>
</div>

<div class="err"><?php 
    eo($err_msg);
    ?>
</div>

<?php 
}

예제 #4

0

파일 보기

파일: index.php 프로젝트: noprom/cryptdb

function print_header()
{
    global $err_msg, $VERSION, $DB, $CRYPTDB, $dbh, $self, $is_sht, $xurl, $SHOW_T;
    $dbn = $DB['db'];
    ?>

<!-- HTML BODY -->


<!DOCTYPE html>
<html>
<head><title>CryptDB</title>
<link href="/menu_assets/styles.css" rel="stylesheet" type="text/css">

<style>
body
{
background-color:#E0E0E0;
}
</style>
<h1 align="center" style="color:#990000;">CryptDB</h1>
<meta charset="utf-8">

<script type="text/javascript">
var LSK='pma_',LSKX=LSK+'max',LSKM=LSK+'min',qcur=0,LSMAX=32;

function $(i){return document.getElementById(i)}
function frefresh(){
    var F=document.DF;
    F.method='get';
    F.refresh.value="1";
    F.submit();
}
function go(p,sql){
    var F=document.DF;
    F.p.value=p;
    if(sql)F.q.value=sql;
    F.submit();
}
function ays(){
    return confirm('Are you sure to continue?');
}
function chksql(){
    var F=document.DF,v=F.q.value;
    if(/^\s*(?:delete|drop|truncate|alter)/.test(v)) if(!ays())return false;
    if(lschk(1)){
        var lsm=lsmax()+1,ls=localStorage;
        ls[LSK+lsm]=v;
        ls[LSKX]=lsm;
        //keep just last LSMAX queries in log
        if(!ls[LSKM])ls[LSKM]=1;
        var lsmin=parseInt(ls[LSKM]);
        if((lsm-lsmin+1)>LSMAX){
            lsclean(lsmin,lsm-LSMAX);
        }
    }
    return true;
}
function tmv(tr){
    tr.sc=tr.className;
    tr.className='h';
}
function tmo(tr){
    tr.className=tr.sc;
}
function tc(tr){
    tr.className='s';
    tr.sc='s';
}
function lschk(skip){
    if (!localStorage || !skip && !localStorage[LSKX]) return false;
    return true;
}
function lsmax(){
    var ls=localStorage;
    if(!lschk() || !ls[LSKX])return 0;
    return parseInt(ls[LSKX]);
}
function lsclean(from,to){
    ls=localStorage;
    for(var i=from;i<=to;i++){
        delete ls[LSK+i];ls[LSKM]=i+1;
    }
}
function after_load(){
    qcur=lsmax();
}
function logoff(){
    if(lschk()){
        var ls=localStorage;
        var from=parseInt(ls[LSKM]),to=parseInt(ls[LSKX]);
        for(var i=from;i<=to;i++){
            delete ls[LSK+i];
        }
        delete ls[LSKM];delete ls[LSKX];
    }
}

<?php 
    if ($is_sht) {
        ?>
function chkall(cab){
    var e=document.DF.elements;
    if (e!=null){
        var cl=e.length;
        for (i=0;i<cl;i++){
            var m=e[i];if(m.checked!=null && m.type=="checkbox"){
                m.checked=cab.checked
            }
        }
    }
}
function sht(f){
    document.DF.dosht.value=f;
}


<?php 
    }
    ?>
</script>

</head>

<?php 
    /*
     * Footer tags
     */
    function print_footer()
    {
        ?>
</form>
</body></html>
<?php 
    }
    ?>

<body onload="after_load()">
<form method="post" name="DF" action="<?php 
    echo $self;
    ?>
" enctype="multipart/form-data">
<input type="hidden" name="XSS" value="<?php 
    echo $_SESSION['XSS'];
    ?>
">
<input type="hidden" name="refresh" value="">
<input type="hidden" name="p" value="">


<!-- HEADER MENU -->
<div class="inv">
<?php 
    if (isset($_SESSION['is_logged']) && $dbh) {
        ?>
Databases:
<select name="db" onChange="frefresh()">
<?php 
        echo get_db_select($dbn);
        ?>
</select>
Tables:
<form action="'<?php 
        echo $self;
        ?>
'" method="post" >
<select name="cryptdb_describe_table" onChange="this.form.submit()">
<?php 
        $a = 0;
        if (isset($_REQUEST['refresh'])) {
            ?>
    <option selected value="">---</option>
<?php 
        }
        $array = get_db_tables($dbn);
        foreach ($array as $key => $value) {
            $accesskey = "Tables_in_" . $dbn;
            ?>

<?php 
            if (isset($_POST['cryptdb_describe_table']) && $_POST['cryptdb_describe_table'] == $value[$accesskey]) {
                ?>
<option selected value="<?php 
                echo $value[$accesskey];
                ?>
"><?php 
                echo $value[$accesskey];
                ?>
</option>
<?php 
            } else {
                ?>
<option value="<?php 
                echo $value[$accesskey];
                ?>
"><?php 
                echo $value[$accesskey];
                ?>
</option>
<?php 
            }
            ?>


<?php 
        }
        ?>
</select>
</form>

<?php 
        if ($dbn) {
            $z = " &#183; <a href='{$self}?{$xurl}&db={$dbn}";
            if (isset($_POST['cryptdb_describe_table']) && $dbn) {
                $z . '&q=' . urlencode($var);
            }
            ?>

<?php 
        }
    }
    ?>




<?php 
    if (isset($GLOBALS['ACCESS_PWD'])) {
        ?>
 | <a href="?<?php 
        echo $xurl;
        ?>
&logoff=1" onclick="logoff()">Logoff</a> <?php 
    }
    ?>
</div>
<div class="err"><?php 
    echo $err_msg;
    ?>
</div>

<?php 
}

PHP get_db_select 예제들