function tearDown() { $sql = DB::newDirectSql("DROP TABLE simple3_table;"); $sql->exec(); DB::closeConnection(); ActiveRecord::dispose(); }
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; } }
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; }
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> </p>"; } $db->closeConnection(); }
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;
$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); }
function tearDown() { DB::closeConnection(); }
public function tearDown() { ActiveRecord::dispose(); DB::closeConnection(); }
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; }
private function disposeDatabase() { DB::closeConnection(); }
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(); }
function tearDown() { DB::newDirectSql($this->teardown_sql)->exec(); DB::closeConnection(); }
public function tearDown() { $this->__dropTable(); DB::closeConnection(); }