PHP tables_list函数代码示例

    function head()
    {
        if (!isset($_GET['sql'])) {
            return;
        }
        $suggests = array();
        foreach ($this->keywords as $keyword) {
            $suggests[] = "{$keyword} ";
        }
        foreach (array_keys(tables_list()) as $table) {
            $suggests[] = $table;
            foreach (fields($table) as $field => $foo) {
                $suggests[] = "{$table}.{$field} ";
            }
        }
        ?>
<script type="text/javascript" src="static/jquery.min.js"></script>
<script type="text/javascript" src="static/tabcomplete/tabcomplete.js"></script>
<style>.hint { color: #bdc3c7; }</style>
<script type="text/javascript">
$(function(){
	$('.sqlarea').tabcomplete(<?php 
        echo json_encode($suggests);
        ?>
);
});
</script>
<?php 
    }

    function head()
    {
        if (!isset($_GET['sql'])) {
            return;
        }
        $tables = array_keys(tables_list());
        $suggests = array_merge($this->keywords, $tables);
        foreach ($tables as $table) {
            foreach (fields($table) as $field => $foo) {
                $suggests[] = "{$table}.{$field}";
            }
        }
        ?>
<script type="text/javascript" src="static/jquery.min.js"></script>
<script type="text/javascript" src="static/jquery.a-tools.js"></script>
<script type="text/javascript" src="static/jquery.asuggest.js"></script>
<script type="text/javascript">
$(function(){
	if (navigator.appName == 'Microsoft Internet Explorer') {
		return;
	}

    $('.sqlarea').attr('onkeydown', '').asuggest(['<?php 
        echo implode("', '", str_replace("'\\", '', $suggests));
        ?>
'], {
        stopSuggestionKeys: [$.asuggestKeys.TAB, $.asuggestKeys.RETURN, $.asuggestKeys.SPACE, 190 /* PERIOD */],
        ignoreCase: true
    });
});
</script>
<?php 
    }

    function head()
    {
        if (!isset($_GET['sql'])) {
            return;
        }
        $suggests = $tables = array_keys(tables_list());
        foreach ($tables as $table) {
            foreach (fields($table) as $field => $foo) {
                $suggests[] = "{$table}.{$field}";
            }
        }
        ?>
<script type="text/javascript" src="static/jquery.min.js"></script>
<script type="text/javascript" src="static/tabcomplete/tabcomplete.js"></script>
<style>.hint { color: #bdc3c7; }</style>
<script type="text/javascript">
$(function(){
	$('.sqlarea').tabcomplete(['<?php 
        echo implode("', '", str_replace("'\\", '', $suggests));
        ?>
']);
});
</script>
<?php 
    }

<input type="hidden" name="token" value="<?php 
echo $token;
?>
">

<table cellspacing="0">
<?php 
$prefixes = array();
if (DB != "") {
    $checked = $TABLE != "" ? "" : " checked";
    echo "<thead><tr>";
    echo "<th style='text-align: left;'><label class='block'><input type='checkbox' id='check-tables'{$checked} onclick='formCheck(this, /^tables\\[/);'>" . lang('Tables') . "</label>";
    echo "<th style='text-align: right;'><label class='block'>" . lang('Data') . "<input type='checkbox' id='check-data'{$checked} onclick='formCheck(this, /^data\\[/);'></label>";
    echo "</thead>\n";
    $views = "";
    $tables_list = tables_list();
    foreach ($tables_list as $name => $type) {
        $prefix = preg_replace('~_.*~', '', $name);
        $checked = $TABLE == "" || $TABLE == (substr($TABLE, -1) == "%" ? "{$prefix}%" : $name);
        //! % may be part of table name
        $print = "<tr><td>" . adminer_checkbox("tables[]", $name, $checked, $name, "checkboxClick(event, this); formUncheck('check-tables');", "block");
        if ($type !== null && !preg_match('~table~i', $type)) {
            $views .= "{$print}\n";
        } else {
            echo "{$print}<td align='right'><label class='block'><span id='Rows-" . h($name) . "'></span>" . adminer_checkbox("data[]", $name, $checked, "", "checkboxClick(event, this); formUncheck('check-data');") . "</label>\n";
        }
        $prefixes[$prefix]++;
    }
    echo $views;
    if ($tables_list) {
        echo "<script type='text/javascript'>ajaxSetHtml('" . is_adminer_escape(ME) . "script=db');</script>\n";

 function table_status($name = "", $fast = false)
 {
     $return = array();
     foreach (tables_list() as $table => $type) {
         $return[$table] = array("Name" => $table);
         if ($name == $table) {
             return $return[$table];
         }
     }
     return $return;
 }

 function table_status($name = "", $fast = false)
 {
     global $connection;
     $return = array();
     $data = tables_list();
     foreach ($data as $index => $val) {
         $index = trim($index);
         $return[$index] = array('Name' => $index, 'Engine' => 'standard');
         if ($name == $index) {
             return $return[$index];
         }
     }
     return $return;
 }

 function count_tables($databases)
 {
     foreach ($databases as $db) {
         return array($db => count(tables_list()));
     }
 }

function entry_audit()
{
    global $_STATE;
    if (!isset($_POST["chkTable"])) {
        $_STATE->msgStatus = "No tables were loaded";
        return;
    }
    tables_list();
    try {
        //Use an unprintable char as the delimiter:
        $db = new db_connect("\r" . $_POST["txtName"] . "\r" . $_POST["txtPswd"]);
    } catch (PDOException $e) {
        $_STATE->msgStatus = "Connection failed: " . $e->getMessage();
        return;
    }
    foreach ($_POST["chkTable"] as $ID => $value) {
        if (!array_key_exists($ID, $_STATE->records)) {
            throw_the_bum_out(NULL, "Evicted(" . __LINE__ . "): invalid table name " . $_POST["chkTable"]);
        }
        if ($value == "on") {
            $_STATE->msgStatus .= $ID;
            if ($_STATE->records[$ID]->MDBname == "") {
                throw_the_bum_out(NULL, "Evicted(" . __LINE__ . "): non-loadable table " . $_POST["chkTable"]);
            }
            if (!load($db, $_STATE->records[$ID])) {
                $_STATE->msgStatus .= "<br>attempted load of " . $GLOBALS["MDBload_path"] . $_STATE->records[$ID]->MDBname . ".csv" . " failed";
            }
            $_STATE->msgStatus .= "<br>";
        }
    }
    $db = NULL;
    return;
}

 function table_status($name = "", $fast = false)
 {
     $return = tables_list();
     if ($return) {
         foreach ($return as $key => $type) {
             // _stats have just info about database
             $return[$key] = array("Name" => $key, "Engine" => $type);
         }
         if ($name != "") {
             return $return[$name];
         }
     }
     return $return;
 }

 /** Rename database from DB
  * @param string new name
  * @param string
  * @return bool
  */
 function rename_database($name, $collation)
 {
     $return = false;
     if (create_database($name, $collation)) {
         //! move triggers
         $rename = array();
         foreach (tables_list() as $table => $type) {
             $rename[] = table($table) . " TO " . idf_escape($name) . "." . table($table);
         }
         $return = !$rename || queries("RENAME TABLE " . implode(", ", $rename));
         if ($return) {
             queries("DROP DATABASE " . idf_escape(DB));
         }
         restart_session();
         set_session("dbs", null);
     }
     return $return;
 }

function entry_audit()
{
    global $_STATE;
    if (!isset($_POST["chkTable"])) {
        $_STATE->msgStatus = "No tables were refreshed";
        return;
    }
    if ($_POST["txtCount"] != "" && !is_numeric($_POST["txtCount"])) {
        $_STATE->msgStatus = "Invalid 'Stop after' count";
        return;
    }
    tables_list();
    try {
        //Use an unprintable char as the delimiter:
        $db = new db_connect("\r" . $_POST["txtName"] . "\r" . $_POST["txtPswd"]);
    } catch (PDOException $e) {
        $_STATE->msgStatus = "Connection failed: " . $e->getMessage();
        return;
    }
    foreach ($_POST["chkTable"] as $ID => $value) {
        if (!array_key_exists($ID, $_STATE->records)) {
            throw_the_bum_out(NULL, "Evicted(" . __LINE__ . "): invalid table name " . $_POST["chkTable"]);
        }
        if ($value == "on") {
            $_STATE->msgStatus .= $ID;
            if (!refresh($db, $_STATE->records[$ID])) {
                $_STATE->msgStatus .= ": attempted refresh failed";
            }
            $_STATE->msgStatus .= "<br>";
        }
    }
    $db = NULL;
    return;
}

function upgrade(&$new_date)
{
    global $_DB, $_STATE;
    //	$diff = date_diff($_STATE->fields["Close Date"]->value, COM_NOW(), true);
    //	if ($diff->m > 2) {
    $sql = "SELECT MAX(logdate) AS max_date FROM " . $_DB->prefix . "b00_timelog;";
    $stmt = $_DB->query($sql);
    $row = $stmt->fetchObject();
    $max_date = new DateTime($row->max_date);
    $stmt->closeCursor();
    $diff = date_diff($max_date, $new_date->value, true);
    $interval = new DateInterval("P" . $diff->days . "D");
    $diff = 1;
    if ($max_date > $new_date->value) {
        $diff = -1;
    }
    tables_list();
    foreach ($_POST["chkDate"] as $chkDate) {
        up_date($chkDate, $interval, $diff);
    }
    echo "<br>Done!";
    exit;
}

    /** Prints navigation after Adminer title
     * @param string can be "auth" if there is no database connection, "db" if there is no database selected, "ns" with invalid schema
     * @return null
     */
    function navigation($missing)
    {
        global $VERSION, $connection, $token, $jush, $drivers;
        ?>
<h1>
<?php 
        echo $this->name();
        ?>
 <span class="version"><?php 
        echo $VERSION;
        ?>
</span>
<a href="http://www.adminer.org/#download" id="version"><?php 
        echo version_compare($VERSION, $_COOKIE["adminer_version"]) < 0 ? h($_COOKIE["adminer_version"]) : "";
        ?>
</a>
</h1>
<?php 
        if ($missing == "auth") {
            $first = true;
            foreach ((array) $_SESSION["pwds"] as $driver => $servers) {
                foreach ($servers as $server => $usernames) {
                    foreach ($usernames as $username => $password) {
                        if (isset($password)) {
                            if ($first) {
                                echo "<p onclick='eventStop(event);'>\n";
                                $first = false;
                            }
                            echo "<a href='" . h(auth_url($driver, $server, $username)) . "'>({$drivers[$driver]}) " . h($username . ($server != "" ? "@{$server}" : "")) . "</a><br>\n";
                        }
                    }
                }
            }
        } else {
            $databases = get_databases();
            ?>
<form action="" method="post">
<p class="logout">
<?php 
            if (DB == "" || !$missing) {
                echo "<a href='" . h(ME) . "sql='" . bold(isset($_GET["sql"])) . ">" . lang('SQL command') . "</a>\n";
                if (support("dump")) {
                    echo "<a href='" . h(ME) . "dump=" . urlencode(isset($_GET["table"]) ? $_GET["table"] : $_GET["select"]) . "' id='dump'" . bold(isset($_GET["dump"])) . ">" . lang('Dump') . "</a>\n";
                }
            }
            ?>
<input type="submit" name="logout" value="<?php 
            echo lang('Logout');
            ?>
" onclick="eventStop(event);">
<input type="hidden" name="token" value="<?php 
            echo $token;
            ?>
">
</p>
</form>
<form action="">
<p>
<?php 
            hidden_fields_get();
            echo $databases ? html_select("db", array("" => "(" . lang('database') . ")") + $databases, DB, "this.form.submit();") : '<input name="db" value="' . h(DB) . '">';
            ?>
<input type="submit" value="<?php 
            echo lang('Use');
            ?>
"<?php 
            echo $databases ? " class='hidden'" : "";
            ?>
 onclick="eventStop(event);">
<?php 
            if ($missing != "db" && DB != "" && $connection->select_db(DB)) {
                if (support("scheme")) {
                    echo "<br>" . html_select("ns", array("" => "(" . lang('schema') . ")") + schemas(), $_GET["ns"], "this.form.submit();");
                    if ($_GET["ns"] != "") {
                        set_schema($_GET["ns"]);
                    }
                }
                if ($_GET["ns"] !== "" && !$missing) {
                    echo '<p><a href="' . h(ME) . 'create="' . bold($_GET["create"] === "") . ">" . lang('Create new table') . "</a>\n";
                    $tables = tables_list();
                    if (!$tables) {
                        echo "<p class='message'>" . lang('No tables.') . "\n";
                    } else {
                        $this->tablesPrint($tables);
                        $links = array();
                        foreach ($tables as $table => $type) {
                            $links[] = preg_quote($table, '/');
                        }
                        echo "<script type='text/javascript'>\n";
                        echo "var jushLinks = { {$jush}: [ '" . js_adminer_escape(ME) . "table=\$&', /\\b(" . implode("|", $links) . ")\\b/g ] };\n";
                        foreach (array("bac", "bra", "sqlite_quo", "mssql_bra") as $val) {
                            echo "jushLinks.{$val} = jushLinks.{$jush};\n";
                        }
                        echo "</script>\n";
                    }
                }
//.........这里部分代码省略.........