<?php // hangreHandler.php require_once $_SERVER['DOCUMENT_ROOT'] . '/hangee/m/lib/__core.php'; $handler = new JsonHandler(); $request = $handler->getRequest(); if ($request == null) { $handler->sendError('Invalid Request!'); die; } $char = $request->character; $query = "select * from hangee_words where word like '{$char}%' and page < 500 order by word asc"; $db = new MySql(); $db->connect(); $res = $db->query($query); $words = array(); while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) { $current = new WordRecord(); $current->wid = $row['id']; $current->page = $row['page']; $current->word = $row['word']; $current->sense = $row['sense']; $words[] = $current; } $db->close(); $handler->sendData($words);
<?php // initListHandler.php require_once $_SERVER['DOCUMENT_ROOT'] . '/hangee/m/lib/__core.php'; $handler = new JsonHandler(); $query = "select id from hangee_words order by id asc"; $db = new MySql(); $db->connect(); $res = $db->query($query); $wids = array(); while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) { $wids[] = $row['id']; } $db->close(); $handler->sendData($wids);