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); }