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;
}
$email_address = $app->request->post('email_address');
$result = DB::statement("INSERT INTO users (username, password_hash, email_address) VALUES ('{$username}', '{$password}', '{$email_address}')");
if (!$result) {
$app->flash('error', mysql_error());
} else {
$app->flash('success', "New User {$username} Created!");
}
$app->flash('username', $username);
$app->flash('email_address', $email_address);
$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'));
