public static function find($username)
{
$result = DB::statement("SELECT * FROM " . self::$tablename . " WHERE username='******'");
if (1 == count($result)) {
return new User($result[0]);
}
return false;
}
$app->redirectTo('Menu@CreateUser');
});
$app->get('/freeform', function () use($app) {
return $app->render('freeform_select.html', array('page' => 'FreeformSelect'));
})->name('Menu@FreeformSelect');
$app->post('/freeform/run', function () use($app) {
$result = DB::statement($app->request->post('query'));
if (!$result) {
$app->flash('error', mysql_error());
} elseif (is_bool($result)) {
$app->flash('success', "Query was successful, but returned no results.");
} else {
$columns = array();
foreach ($result[0] as $column => $data) {
if (!is_int($column)) {
array_push($columns, $column);
}
}
$app->flash('columns', $columns);
$app->flash('rows', $result);
}
$app->flash('query', $app->request->post('query'));
return $app->redirectTo('Menu@FreeformSelect');
})->name('Menu@doFreeformSelect');
$app->post('/down', function () use($app) {
$app->auth->doLogout();
DB::tearDown();
$app->redirectTo('home');
})->name('DB@tearDown');
// Run app
$app->run();
