function tearDown()
 {
     $sql = DB::newDirectSql("DROP TABLE simple3_table;");
     $sql->exec();
     DB::closeConnection();
     ActiveRecord::dispose();
 }
示例#2
0
 private static function startRoute(array &$params)
 {
     $controllerName = 'App\\Controllers\\' . ucfirst(self::$currentRoute[1][0]);
     $actionName = self::$currentRoute[1][1];
     $controller = new $controllerName();
     $controller->before();
     $controller->response = call_user_func_array([$controller, $actionName], $params);
     $controller->after();
     DB::closeConnection();
     if (Config::get('short_response') == true) {
         $response = preg_replace(['/<!--([^\\[|(<!)].*)/', '/(?<!\\S)\\/\\/\\s*[^\\r\\n]*/', '/\\s{2,}/', '/(\\r?\\n)/'], '', ob_get_contents());
         ob_clean();
         echo $response;
     }
 }
示例#3
0
function getTranslations()
{
    //Die Übersetzungen
    $id = null;
    $liste = null;
    if (isset($_SESSION) && isset($_SESSION['user_id']) && isset($_SESSION['listen'])) {
        $id = $_SESSION['user_id'];
        $liste = $_SESSION['listen'];
    } else {
        header("Location: ?site=login&error=4");
        exit;
    }
    $translations = array();
    $db = new DB();
    $result = $db->selectTranslations($id, $liste);
    foreach ($result as $paar) {
        //Alle Translations dem translation-array anhängen
        $translation = utf8_encode($paar['translation']);
        array_push($translations, $translation);
    }
    $db->closeConnection();
    return $translations;
}
示例#4
0
文件: manage.php 项目: maede97/EF_INF
function showSelectionDialog()
{
    //Gibt Item-Spinner für PDF-Maker aus
    $id = $_SESSION['user_id'];
    $db = new DB();
    $result = $db->selectListsFromId($id);
    if (count($result) == 0) {
        echo "<p>Du besitzt noch keine Tabellen.</p>";
    } else {
        echo "<form method='GET' name='liste' action='content/pdf.php'>";
        echo "<select name='liste'>";
        foreach ($result as $row) {
            //Print voci-tables into html table
            echo "<option value=" . $row['listen_id'] . ">" . $row['titel'] . " - ";
            echo $row['sprache'] . "</option>";
        }
        echo "</select>";
        echo "<input type='submit' value='PDF erhalten' title='PDF anfordern'>";
        echo "</form>";
        echo "<p>&nbsp;</p>";
    }
    $db->closeConnection();
}
示例#5
0
require_once "framework/core/lib/controller/AbstractController.class.php";
DB::openDefaultConnection();
// You can't simply echo everything right away because we need to set some headers first!
$output = '';
// Here we buffer the JavaScript code we want to send to the browser.
$delimiter = "\n";
// for eye candy... code gets new lines
$output .= 'var tinyMCEFileList = new Array(';
$all_documenti = call("documenti", "index", array("__filter_folder__EQUAL" => $_GET["folder"]));
$server_path = "http://" . Host::current();
// Since TinyMCE3.x you need absolute image paths in the list...
if (count($all_documenti) > 0) {
    foreach ($all_documenti as $doc) {
        $output .= $delimiter . '["' . utf8_encode($doc["nome"]) . '", "' . utf8_encode($server_path . $doc["save_folder"] . $doc["hash_name"]) . '"],';
    }
    $output = substr($output, 0, -1);
    // remove last comma from array item list (breaks some browsers)
}
$output .= $delimiter;
DB::closeConnection();
// Finish code: end of array definition. Now we have the JavaScript code ready!
$output .= ');';
// Make output a real JavaScript file!
header('Content-type: text/javascript');
// browser will now recognize the file as a valid JS file
// prevent browser from caching
header('pragma: no-cache');
header('expires: 0');
// i.e. contents have already expired
// Now we can send data to the browser because all headers have been set!
echo $output;
示例#6
0
文件: pdf.php 项目: maede97/EF_INF
 $id = $_SESSION['user_id'];
 $liste = $_GET['liste'];
 $db = new DB();
 $result = $db->selectListTitleFromId($id, $liste);
 //Global, dass auch danach im Header der Titel steht
 global $title;
 $title = $result[0]['titel'];
 //Make PDF
 $result = $db->selectWordsFromId($liste);
 //Alle Wörter zu einer Liste hinzufügen
 $woerter = $translations = array();
 foreach ($result as $paar) {
     array_push($woerter, html_entity_decode($paar['wort']));
     array_push($translations, html_entity_decode($paar['translation']));
 }
 $db->closeConnection();
 //Ab hier auch wieder angepasst.
 $pdf = new PDF();
 $pdf->AliasNbPages();
 $pdf->AddPage();
 $pdf->SetFillColor(150);
 //Wörter in PDF einfüllen
 for ($i = 0; $i < count($woerter); $i++) {
     $filler = ($i + 1) % 2;
     //Fett:
     $pdf->SetFont('Times', 'B', 12);
     $pdf->Cell(95, 10, $woerter[$i], 0, 0, '', $filler);
     //Nicht Fett
     $pdf->SetFont('Times', '', 12);
     $pdf->Cell(95, 10, $translations[$i], 0, 1, '', $filler);
 }
示例#7
0
 function tearDown()
 {
     DB::closeConnection();
 }
示例#8
0
 public function tearDown()
 {
     ActiveRecord::dispose();
     DB::closeConnection();
 }
示例#9
0
 public static function restore_table($table_name)
 {
     $backup_dir = new Dir(self::$current_backup_dir);
     if (!$backup_dir->exists()) {
         return false;
     }
     if (!DB::isConnectionOpen()) {
         $keep_open = false;
         DB::openDefaultConnection();
     } else {
         $keep_open = true;
     }
     $importer = DB::newTableDataImportExport();
     $importer->import_data_from_file(self::getTableBackupFile($table_name));
     if (!$keep_open) {
         DB::closeConnection();
     }
     return true;
 }
示例#10
0
 private function disposeDatabase()
 {
     DB::closeConnection();
 }
示例#11
0
 function tearDown()
 {
     $sql1 = DB::newDirectSql("DROP TABLE test_tab_colori_dipinto;");
     $sql1->exec();
     $sql2 = DB::newDirectSql("DROP TABLE test_tab_dipinti;");
     $sql2->exec();
     $sql3 = DB::newDirectSql("DROP TABLE test_tab_colori;");
     $sql3->exec();
     $sql4 = DB::newDirectSql("DROP TABLE test_tab_autori;");
     $sql4->exec();
     DB::closeConnection();
     ActiveRecord::dispose();
 }
示例#12
0
 function tearDown()
 {
     DB::newDirectSql($this->teardown_sql)->exec();
     DB::closeConnection();
 }
示例#13
0
 public function tearDown()
 {
     $this->__dropTable();
     DB::closeConnection();
 }