PHP mysql_multi::DATABASE_LIST Exemples

Exemple #1

Fichier : system.mysql.php Projet : BillTheBest/1.6.x

function selectDB_list()
{
    $dbs = members_list_access_db($_GET["user"], $_GET["host"], $_GET["instance-id"]);
    $search = null;
    if ($_POST["query"] != null) {
        $search = $_POST["query"];
        $search = "*{$search}*";
        $search = str_replace("**", "*", $search);
        $search = str_replace("**", "*", $search);
        $search = str_replace("*", ".*?", $search);
    }
    $q = new mysql();
    if (is_numeric($_GET["instance-id"]) && $_GET["instance-id"] > 0) {
        $q = new mysql_multi($_GET["instance-id"]);
    }
    $data = array();
    $data['page'] = 1;
    $data['total'] = 0;
    $data['rows'] = array();
    $array = $q->DATABASE_LIST();
    if (!$q->ok) {
        $data['rows'][] = array('id' => $ligne[time() + 1], 'cell' => array($q->mysql_error, "", "", ""));
        $data['rows'][] = array('id' => $ligne[time()], 'cell' => array($sql, "", "", ""));
        echo json_encode($data);
        return;
    }
    $data['total'] = count($array);
    $classtr = null;
    $t = time();
    $c = 0;
    while (list($key, $line) = each($array)) {
        if ($search != null) {
            if (!preg_match("#{$search}#i", $key)) {
                continue;
            }
        }
        $database = $key;
        $value = 0;
        if ($dbs[$database] != null) {
            $value = 1;
        }
        $c++;
        $md5 = md5($database);
        $enable = Field_checkbox($md5, 1, $value, "SelectDBEN('{$database}','{$md5}')");
        $data['rows'][] = array('id' => "DatabaseMysql" . $md5, 'cell' => array($enable, "<span style='font-size:16px'>{$database}</span>"));
    }
    echo json_encode($data);
}