'Hello, World!']; } /** * @Action * @View(renderType="html") * * @return void */ public function plaintext() { return RequestContext::get('response')->withHeader('Content-Type', 'text/plain; charset=utf-8')->write('Hello, World!'); } /** * @Action * * @return void */ public function dbModel() { return World::find(mt_rand(1, 10000)); } /** * @Action * * @return void */ public function dbQueryBuilder() { return Db::query()->from('World')->field('id', 'randomNumber')->where('id', '=', mt_rand(1, 10000))->select()->get(); } /** * @Action * * @return void */ public function dbRaw() { $db = Db::getInstance(); $stmt = $db->prepare('SELECT id, randomNumber FROM World WHERE id = ?'); $stmt->execute([mt_rand(1, 10000)]); return $stmt->fetch(); } /** * @Action * * @return void */ public function queryModel($queries) { if($queries > 1) { $queryCount = min($queries, 500); } else { $queryCount = 1; } $list = []; while ($queryCount--) { $list[] = World::find(mt_rand(1, 10000)); } return $list; } /** * @Action * * @return void */ public function queryQueryBuilder($queries) { if($queries > 1) { $queryCount = min($queries, 500); } else { $queryCount = 1; } $list = []; while ($queryCount--) { $list[] = Db::query()->from('World')->field('id', 'randomNumber')->where('id', '=', mt_rand(1, 10000))->select()->get(); } return $list; } /** * @Action * * @return void */ public function queryRaw($queries) { if($queries > 1) { $queryCount = min($queries, 500); } else { $queryCount = 1; } $list = []; $db = Db::getInstance(); $stmt = $db->prepare('SELECT id, randomNumber FROM World WHERE id = ?'); while ($queryCount--) { $stmt->execute([mt_rand(1, 10000)]); $list[] = $stmt->fetch(); } return $list; } /** * @Action * @View(renderType="html") * * @return void */ public function fortunes() { RequestContext::use(function(&$context){ $context['response'] = $context['response']->withHeader('Content-Type', 'text/html; charset=UTF-8'); }); $list = Fortune::select(); $rows = []; foreach($list as $item) { $rows[$item->id] = $item->message; } $rows[0] = 'Additional fortune added at request time.'; asort($rows); return [ 'rows' => $rows, ]; } /** * @Action * @View(renderType="html") * * @return void */ public function fortunesRaw() { $rows = []; foreach(Db::getInstance()->query('SELECT id, message FROM Fortune')->fetchAll() as $item) { $rows[$item['id']] = $item['message']; } $rows[0] = 'Additional fortune added at request time.'; asort($rows); $html = ''; foreach ($rows as $id => $message) { $message = \htmlspecialchars($message, ENT_QUOTES, 'UTF-8'); $html .= "
id | message |
---|