PHP Database::exist_database Examples

Example #1

File: dossier.inc.php Project: Kloadut/noalyss_ynh

     echo _('Désolé, vous n\'avez pas coché la case');
     echo HtmlInput::button_anchor(_('Retour'), '?action=dossier_mgt');
     return;
 }
 $cn = new Database();
 $msg = "dossier";
 $name = $cn->get_value("select dos_name from ac_dossier where dos_id=\$1", array($dossier_id));
 if (strlen(trim($name)) == 0) {
     echo "<h2 class=\"error\"> {$msg} " . _('inexistant') . "</h2>";
     return;
 }
 /**
  * Check if db exists
  */
 $str_name = domaine . 'dossier' . $dossier_id;
 $database_exist = $cn->exist_database($str_name);
 // if db exists for postgres then drop it
 if ($database_exist == 1) {
     $sql = "drop database " . domaine . "dossier" . sql_string($_REQUEST['d']);
     ob_start();
     if ($cn->exec_sql($sql) == false) {
         ob_end_clean();
         echo "<h2 class=\"error\"> ";
         echo _('Base de donnée ') . domaine . "dossier" . $_REQUEST['d'] . _("est accèdée, déconnectez-vous d'abord") . "</h2>";
         exit;
     }
     ob_flush();
 }
 // clean tables about this dossier
 $sql = "delete from  jnt_use_dos where dos_id=\$1";
 $cn->exec_sql($sql, array($dossier_id));

Example #2

File: setup.php Project: Kloadut/noalyss_ynh

	<?php 
    exit;
}
/*
 * If multi folders
 */
$Resdossier = $cn->exec_sql("select dos_id, dos_name from ac_dossier");
$MaxDossier = $cn->size($Resdossier);
//----------------------------------------------------------------------
// Upgrade the folders
//----------------------------------------------------------------------
for ($e = 0; $e < $MaxDossier; $e++) {
    $db_row = Database::fetch_array($Resdossier, $e);
    echo "<h3>Patching " . $db_row['dos_name'] . '</h3>';
    $name = $cn->format_name($db_row['dos_id'], 'dos');
    if ($cn->exist_database($name) > 0) {
        $db = new Database($db_row['dos_id'], 'dos');
        $db->apply_patch($db_row['dos_name']);
        Dossier::synchro_admin($db_row['dos_id']);
    } else {
        echo_warning(_("Dossier inexistant") . " {$name}");
    }
}
//----------------------------------------------------------------------
// Upgrade the template
//----------------------------------------------------------------------
$Resdossier = $cn->exec_sql("select mod_id, mod_name from modeledef");
$MaxDossier = $cn->size();
echo "<h2>Mise &agrave; jour mod&egrave;le</h2>";
for ($e = 0; $e < $MaxDossier; $e++) {
    $db_row = Database::fetch_array($Resdossier, $e);