function liste_bases($server_db) { if (is_null($server_db) or !($result = sql_listdbs($server_db))) { return ''; } $noms = array(); // si sqlite : result est deja un tableau if (is_array($result)) { $noms = $result; } else { while ($row = sql_fetch($result, $server_db)) { $noms[] = reset($row); } } return $noms; }
function install_etape_liste_bases($server_db, $login_db, $disabled = array()) { $bases = $checked = array(); $noms = sql_listdbs($server_db); if (!$noms) { return ''; } foreach ($noms as $nom) { $id = spip_htmlspecialchars($nom); $dis = in_array($nom, $disabled) ? " disabled='disabled'" : ''; $base = " name=\"choix_db\" value=\"" . $nom . '"' . $dis . " type='radio' id='{$id}'"; $label = "<label for='{$id}'>" . ($dis ? "<i>{$nom}</i>" : $nom) . "</label>"; if (!$checked and !$dis and ($nom == $login_db or $GLOBALS['table_prefix'] == $nom)) { $checked = "<input{$base} checked='checked' />\n{$label}"; } else { $bases[] = "<input{$base} />\n{$label}"; } } if (!$bases && !$checked) { return false; } if ($checked) { array_unshift($bases, $checked); $checked = true; } return array($checked, $bases); }
function install_etape_liste_bases($server_db, $login_db, $disabled=array()) { $result = sql_listdbs($server_db); if (!$result) return ''; $bases = $checked = $noms = array(); // si sqlite : result est deja un tableau if (is_array($result)){ $noms = $result; } else { while ($row = sql_fetch($result, $server_db)) { $noms[] = array_shift($row); } } foreach ($noms as $nom){ $id = htmlspecialchars($nom); $dis = in_array($nom, $disabled) ? " disabled='disabled'" : ''; $base = " name=\"choix_db\" value=\"" . $nom . '"' . $dis . " type='radio' id='$id'"; $label = "<label for='$id'>" . ($dis ? "<i>$nom</i>" : $nom) . "</label>"; if (!$checked AND !$dis AND (($nom == $login_db) OR ($GLOBALS['table_prefix'] == $nom))) { $checked = "<input$base checked='checked' />\n$label"; } else { $bases[]= "<input$base />\n$label"; } } if (!$bases && !$checked) return false; if ($checked) {array_unshift($bases, $checked); $checked = true;} return array($checked, $bases); }