function storyInfo() { $uri = g('uri'); $userId = g('userId'); st_db_object()->rawQuery("CALL MOVESTORIESFORWARD()"); $db_data = st_db_object()->rawQuery("\n SELECT \n (SELECT COUNT(*) FROM `story_user` WHERE `story_user`.`FK_story_id` = `story`.`id`) AS num_players,\n `story`.`time_limit` AS time_limit,\n (CASE\n WHEN `story`.`current_turn` > 0 THEN\n (SELECT MAX(`turn`.`timestamp`) FROM `turn` WHERE `turn`.`FK_story_id` = `story`.`id`)\n ELSE\n `story`.`started_at`\n END) AS turn_start,\n NOW() AS now_time,\n `story`.`current_turn` AS current_turn,\n (SELECT `story_user`.`turn_order` FROM `story_user` WHERE `story_user`.`FK_user_id` = ? AND `story_user`.`FK_story_id` = `story`.`id` LIMIT 1) AS turn_order\n FROM \n `story` \n WHERE \n `story`.`uri` = ?\n ", array($userId, $uri)); echo json_encode($db_data[0]); }
function complete() { //get search term $searchTerm = $_GET['term']; //get matched data from skills table $query = st_db_object()->rawQuery("SELECT * FROM user WHERE name LIKE '%" . $searchTerm . "%' ORDER BY name ASC"); $data = []; foreach ($query as $row) { $data[] = $row['name']; } //return json data echo json_encode($data); }
<?php define('ST_BASE_DIR', dirname(empty($_SERVER['SCRIPT_FILENAME']) ? dirname(__FILE__ . "/../") : $_SERVER['SCRIPT_FILENAME']) . '/../'); define('ST_INCLUDE_DIR', ST_BASE_DIR . 'include/'); require ST_INCLUDE_DIR . 'st-index.php'; //get search term $searchTerm = $_GET['term']; //get matched data from skills table $query = st_db_object()->rawQuery("SELECT * FROM user WHERE name LIKE '%" . $searchTerm . "%' ORDER BY name ASC"); $data = []; foreach ($query as $row) { $data[] = $row['name']; } //return json data echo json_encode($data);
function __construct() { $this->db = st_db_object(); }
function __construct() { $this->db = st_db_object(); session_start(); }