function absences($f3, $params)
{
$db = $f3->get('db');
$curLehrer = DbWrapper::getLehrerById($db, $params['id']);
$f3->set('curLehrer', $curLehrer);
$allLehrer = DbWrapper::getAllLehrer($db);
$f3->set('allLehrer', $allLehrer);
$absences = DbWrapper::getSperrungenByLehrerId($db, $params['id']);
$f3->set('absences', $absences);
echo Template::instance()->render('absences.htm');
}
function reservierungen($f3)
{
if ($this->isLoggedIn($f3)) {
$f3->set('location', 'user_summary');
$db = $f3->get('db');
$f3->set('schuelerName', $this->getCurrentSchuelerName($f3));
$f3->set('reservations', DbWrapper::getReservationsByUserId($db, $f3->get('COOKIE.user_id')));
echo Template::instance()->render('userSummary.htm');
} else {
$f3->reroute('/login');
}
}
function release($f3, $params)
{
$lehrerId = $params['id'];
if ($f3->exists('POST.zeitId')) {
try {
$zeitId = $f3->get('POST.zeitId');
$userId = $f3->get('COOKIE.user_id');
Logger::Info($f3, "LehrerPost.release", "Lehrer: {$lehrerId}, Zeit: {$zeitId}, User: {$userId}");
DbWrapper::deleteReservation($f3->get('db'), $lehrerId, $zeitId, $userId);
} catch (Exception $e) {
Logger::Error($f3, "LehrerPost.release", "Lehrer: {$lehrerId}, Error: {$e->getMessage()}");
}
}
$f3->reroute('/lehrer/' . $lehrerId);
}
function lehrer($f3, $params)
{
$db = $f3->get('db');
$f3->set('location', 'lehrer_reserve');
$curLehrer = DbWrapper::getLehrerById($db, $params['id']);
$f3->set('curLehrer', $curLehrer);
$allLehrer = DbWrapper::getLehrerBySchuelerId($db, $f3->get('COOKIE.user_id'));
$f3->set('allLehrer', $allLehrer);
$reservations = DbWrapper::getReservationsByLehrerId($db, $params['id'], $f3->get('COOKIE.user_id'));
$f3->set('reservations', $reservations);
$f3->set('isLocked', filter_var($f3->get('settings.isLocked'), FILTER_VALIDATE_BOOLEAN));
$f3->set('curUserId', $f3->get('COOKIE.user_id'));
$f3->set('error', $f3->get('GET.errorMessage'));
echo Template::instance()->render('reservations.htm');
}
function login($f3)
{
if ($f3->exists('POST.schueler_name')) {
$schuelerName = $f3->get('POST.schueler_name');
try {
$schuelerId = DbWrapper::getSchuelerIdByName($f3->get('db'), $schuelerName);
Logger::Info($f3, "UserPost.login", "Name: {$schuelerName}, Id: {$schuelerId}");
$f3->set('COOKIE.user_id', $schuelerId);
$f3->set('COOKIE.user_name', $schuelerName);
$f3->reroute('/');
} catch (Exception $e) {
Logger::Error($f3, "UserPost.login", "Name: {$schuelerName}, Error: {$e->getMessage()}");
$f3->reroute('/login');
}
} else {
$f3->reroute('/login');
}
}
function getSettings($f3)
{
$db = $f3->get('db');
$dbResults = DbWrapper::getAllEinstellungen($db);
$settings = array();
foreach ($dbResults as $setting) {
$settings[$setting['name']] = $setting['wert'];
}
$f3->set('settings', $settings);
}
if ($_GET['table'] == 'books' || $_GET['table'] == 'authors') {
//save it for eventual use
$table = $_GET['table'];
} else {
//throw error in case of unsupported table name
throw new Exception('Invalid table name.');
}
//get database location and specify database file name
$dbName = $_SERVER["DOCUMENT_ROOT"] . '\\dbex\\booksexample.mdb';
//if database does not exist, display error message and exit
if (!file_exists($dbName)) {
die("Can't find database.");
}
//use odbc and pdo to connect to access database (without userid or password)
//relay database connection and table name to database wrapper
$dw = new DbWrapper(new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb)}; DBQ={$dbName}; Uid=; Pwd=;"), $table);
//check for additional parameters and store them
$additional = array();
foreach (array_keys($_GET) as $k) {
if ($k != 'table' && $k != 'method' && $k != 'id') {
$additional[$k] = $_GET[$k];
}
}
switch ($_GET['method']) {
case 'get':
//get single dataset from database specified by its id
//encode and display as json
print json_encode($dw->get($_GET['id']));
break;
case 'getAll':
//get all datasets from database, pass along all additional parameters
public static function exportToExcel2007($db, $exportFileName)
{
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("Lechner Michael");
$objPHPExcel->getProperties()->setLastModifiedBy("Lechner Michael");
$objPHPExcel->getProperties()->setTitle("Datenbankexport " . date('d.m.Y H:hi:m'));
$objPHPExcel->getProperties()->setSubject("Datenbankexport");
$objPHPExcel->getProperties()->setDescription("Datenbankexport");
$objPHPExcel->setActiveSheetIndex(0);
$activeSheet = $objPHPExcel->getActiveSheet();
$activeSheet->setTitle('LEHRER');
$activeSheet->SetCellValue('A1', 'lehrer_id');
$activeSheet->SetCellValue('B1', 'name');
$activeSheet->SetCellValue('C1', 'raum');
$activeSheet->SetCellValue('D1', 'klassen');
$activeSheet->getColumnDimension('B')->setAutoSize(true);
$activeSheet->getColumnDimension('C')->setAutoSize(true);
$activeSheet->getColumnDimension('D')->setAutoSize(true);
$rowCounter = 2;
foreach (DbWrapper::getAllLehrer($db) as $lehrer) {
$activeSheet->SetCellValue('A' . $rowCounter, $lehrer['lehrer_id']);
$activeSheet->SetCellValue('B' . $rowCounter, $lehrer['name']);
$activeSheet->SetCellValue('C' . $rowCounter, $lehrer['raum']);
$activeSheet->SetCellValue('D' . $rowCounter, $lehrer['klassen']);
// $objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCounter, json_encode($lehrer));
$rowCounter = $rowCounter + 1;
}
$activeSheet = $objPHPExcel->createSheet();
$activeSheet->setTitle('SCHUELER');
$activeSheet->SetCellValue('A1', 'schueler_id');
$activeSheet->SetCellValue('B1', 'name');
$activeSheet->SetCellValue('C1', 'klasse');
$activeSheet->getColumnDimension('B')->setAutoSize(true);
$activeSheet->getColumnDimension('C')->setAutoSize(true);
$rowCounter = 2;
foreach (DbWrapper::getAllSchueler($db) as $schueler) {
$activeSheet->SetCellValue('A' . $rowCounter, $schueler['schueler_id']);
$activeSheet->SetCellValue('B' . $rowCounter, $schueler['name']);
$activeSheet->SetCellValue('C' . $rowCounter, $schueler['klasse']);
$rowCounter = $rowCounter + 1;
}
$activeSheet = $objPHPExcel->createSheet();
$activeSheet->setTitle('ZEITEN');
$activeSheet->SetCellValue('A1', 'zeit_id');
$activeSheet->SetCellValue('B1', 'zeit');
$activeSheet->getColumnDimension('B')->setAutoSize(true);
$rowCounter = 2;
foreach (DbWrapper::getAllZeiten($db) as $zeit) {
$activeSheet->SetCellValue('A' . $rowCounter, $zeit['zeit_id']);
$activeSheet->SetCellValue('B' . $rowCounter, $zeit['zeit']);
$rowCounter = $rowCounter + 1;
}
$activeSheet = $objPHPExcel->createSheet();
$activeSheet->setTitle('EINSTELLUNGEN');
$activeSheet->SetCellValue('A1', 'name');
$activeSheet->SetCellValue('B1', 'wert');
$activeSheet->getColumnDimension('A')->setAutoSize(true);
$activeSheet->getColumnDimension('B')->setAutoSize(true);
$rowCounter = 2;
foreach (DbWrapper::getAllEinstellungen($db) as $einstellung) {
$activeSheet->SetCellValue('A' . $rowCounter, $einstellung['name']);
$activeSheet->SetCellValue('B' . $rowCounter, $einstellung['wert']);
$rowCounter = $rowCounter + 1;
}
$activeSheet = $objPHPExcel->createSheet();
$activeSheet->setTitle('SPERRUNGEN');
$activeSheet->SetCellValue('A1', 'lehrer_id');
$activeSheet->SetCellValue('B1', 'zeit_id');
$activeSheet->getColumnDimension('A')->setAutoSize(true);
$activeSheet->getColumnDimension('B')->setAutoSize(true);
$rowCounter = 2;
foreach (DbWrapper::getAllSperrungen($db) as $sperrung) {
$activeSheet->SetCellValue('A' . $rowCounter, $sperrung['lehrer_id']);
$activeSheet->SetCellValue('B' . $rowCounter, $sperrung['zeit_id']);
$rowCounter = $rowCounter + 1;
}
$activeSheet = $objPHPExcel->createSheet();
$activeSheet->setTitle('RESERVIERUNGEN');
$activeSheet->SetCellValue('A1', 'lehrer_id');
$activeSheet->SetCellValue('B1', 'zeit_id');
$activeSheet->SetCellValue('C1', 'schueler_id');
$activeSheet->getColumnDimension('A')->setAutoSize(true);
$activeSheet->getColumnDimension('B')->setAutoSize(true);
$activeSheet->getColumnDimension('C')->setAutoSize(true);
$rowCounter = 2;
foreach (DbWrapper::getAllReservierungen($db) as $reservierung) {
$activeSheet->SetCellValue('A' . $rowCounter, $reservierung['lehrer_id']);
$activeSheet->SetCellValue('B' . $rowCounter, $reservierung['zeit_id']);
$activeSheet->SetCellValue('C' . $rowCounter, $reservierung['schueler_id']);
$rowCounter = $rowCounter + 1;
}
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save($exportFileName);
}
$db->query('', '
SET NAMES {string:utf8}', array('db_error_skip' => true, 'utf8' => 'utf8'));
$replaces = array('{$db_prefix}' => $db_prefix, '{BOARDDIR}' => TMP_BOARDDIR, '{$boardurl}' => $boardurl, '{$enableCompressedOutput}' => isset($_POST['compress']) ? '1' : '0', '{$databaseSession_enable}' => isset($_POST['dbsession']) ? '1' : '0', '{$current_version}' => CURRENT_VERSION, '{$current_time}' => time(), '{$sched_task_offset}' => 82800 + mt_rand(0, 86399));
foreach ($txt as $key => $value) {
if (substr($key, 0, 8) == 'default_') {
$replaces['{$' . $key . '}'] = addslashes($value);
}
}
$replaces['{$default_reserved_names}'] = strtr($replaces['{$default_reserved_names}'], array('\\\\n' => '\\n'));
// If the UTF-8 setting was enabled, add it to the table definitions.
if (!empty($databases[$db_type]['utf8_support'])) {
$replaces[') ENGINE=MyISAM;'] = ') ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;';
}
// Populate database
$db_table = db_table_install();
$db_wrapper = new DbWrapper($db, $replaces);
$db_table_wrapper = new DbTableWrapper($db_table);
$exists = array();
require_once ELK_INSTALL_DIR . '/install_1-1.php';
$install_instance = new InstallInstructions_install_1_1($db_wrapper, $db_table_wrapper);
$methods = get_class_methods($install_instance);
$tables = array_filter($methods, function ($method) {
return strpos($method, 'table_') === 0;
});
$inserts = array_filter($methods, function ($method) {
return strpos($method, 'insert_') === 0;
});
$others = array_filter($methods, function ($method) {
return substr($method, 0, 2) !== '__' && strpos($method, 'insert_') !== 0 && strpos($method, 'table_') !== 0;
});
foreach ($tables as $table_method) {
while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
$table = $row[0];
$arr = explode(' ', $row[1]);
$type = end($arr);
if (preg_match('/#/', $table)) {
continue;
}
$create = DbWrapper::getCreate($table);
$rs = preg_match("/ENGINE=.+COMMENT='(.+)'\$/", $create, $matches);
$comment = $rs ? $matches[1] : '';
$table_info = compact('table', 'type', 'comment', 'create');
$found = true;
if ($f) {
$found = false;
// 这里可以用 like 语句-
$fields = DbWrapper::getFields($table);
foreach ($fields as $field) {
if (preg_match('/' . $f . '/', $field['Field'])) {
$table_info['find_field'] = $found = true;
$table_info['field_matches'][] = $field;
}
}
}
if ($found) {
$tables[] = $table_info;
}
}
$tpl = 'index-list';
}
// render
include 'index.phtml';
function changePassword($f3, $params)
{
$this->ensureAdmin($f3);
$newPassword = $f3->get('POST.password');
Logger::Info($f3, "AdminPost.changePassword", "Changing the admin password");
DbWrapper::updateEinstellung($f3->get('db'), 'adminPassword', $newPassword);
$f3->reroute('/admin/index');
}
<?php
if (!isset($_POST['user']) || !isset($_POST['message'])) {
echo 'No POST parameters were found.';
die;
}
require 'db.php';
$db = new DbWrapper();
$db->newMessage($_POST['user'], $_POST['message']);
<?php
if (!isset($_POST['user']) || !isset($_POST['image'])) {
die;
}
require 'db.php';
$db = new DbWrapper();
$db->newUser($_POST['user'], $_POST['image']);
<?php require 'db.php'; $db = new DbWrapper(); echo json_encode($db->getUsers());
<?php require 'db.php'; $db = new DbWrapper(); echo json_encode($db->getMessages());
