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'));