protected function do_get() { // Call the parent parent::do_get(); try { $db = DemoDB::getConnection(); $sql = "SELECT person_id, name FROM person WHERE person_id=:person_id"; $stmt = $db->prepare($sql); $stmt->bindValue(":person_id", $this->id); $ok = $stmt->execute(); if ($ok) { $row = $stmt->fetch(PDO::FETCH_ASSOC); if ($row != null) { $this->statusCode = 200; // Produce utf8 encoded json $this->headers[] = "Content-type: text/json; charset=utf-8"; $this->body = json_encode($row); } else { $this->exit_error(404); } } else { $this->exit_error(500, print_r($db->errorInfo(), true)); } } catch (PDOException $e) { $this->exit_error(500, $e->getMessage()); } }
protected function do_get() { // Call the parent parent::do_get(); if ($_GET["id"] == "*") { if (isset($_GET["team_owner_id"])) { if (is_numeric($_GET["team_owner_id"])) { $this::getTeamsByOwnerId(); } else { $this->exit_error(400, "idNotPositiveInteger"); } } else { if (isset($_GET["project_id"])) { if (is_numeric($_GET["project_id"])) { $this::getTeamsByProjectId(); } else { $this->exit_error(400, "project_idNotPositiveInteger"); } } else { if (isset($_GET["team_member_id"])) { if (is_numeric($_GET["team_member_id"])) { $this::getTeamsByMemberId(); } else { $this->exit_error(400, "team_member_idNotPositiveInteger"); } } } } } else { $this::getTeamByTeamId(); } }
protected function do_get() { // Call the parent parent::do_get(); if ($_GET["id"] == "*") { if (isset($_GET["owner_id"])) { if (is_numeric($_GET["owner_id"])) { // $this->getAllProjectsByOwnerIdOrClassId(null); return; } else { $this->exit_error(400, "owner_idNotPositiveInteger"); } } if (isset($_GET["class_id"])) { if (is_numeric($_GET["class_id"])) { $this->getStudentsByClassId($_GET["class_id"]); return; } else { $this->exit_error(400, "class_idNotPositiveInteger"); } } $this->getAllStudents(); } else { $this->getStudentById(); } }
protected function do_get() { // Call the parent parent::do_get(); if (isset($_GET["id"])) { if (is_numeric($_GET["id"])) { try { $db = DemoDB::getConnection(); $sql = "SELECT * FROM Class where id=:id;"; $stmt = $db->prepare($sql); $stmt->bindValue(":id", $_GET["id"], PDO::PARAM_INT); $ok = $stmt->execute(); if ($ok) { $nb = $stmt->rowCount(); if ($nb == 0) { $this->exit_error(404); } if (isset($this->statusCode)) { $this->statusCode = 200; } while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { if ($row != null) { if (isset($this->headers)) { $this->headers[] = "Content-type: text/json; charset=utf-8"; } // Produce utf8 encoded json $this->body = json_encode($row); } else { $this->exit_error(404); } } } else { $this->exit_error(500, print_r($db->errorInfo(), true)); } } catch (PDOException $e) { $this->exit_error(500, $e->getMessage()); } } else { if ($_GET["id"] == "*") { try { $db = DemoDB::getConnection(); $sql = "SELECT * FROM Class"; $stmt = $db->prepare($sql); $ok = $stmt->execute(); if ($ok) { $sbody = "{"; $nb = $stmt->rowCount(); if ($nb == 0) { $this->exit_error(404); } if (isset($this->statusCode)) { $this->statusCode = 200; } while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { if ($row != null) { if (isset($this->headers)) { $this->headers[] = "Content-type: text/json; charset=utf-8"; } // Produce utf8 encoded json $sbody .= "\"" . $row["id"] . "\":" . json_encode($row) . ","; } else { $this->exit_error(404); } } $sbody = rtrim($sbody, ","); $this->body = $sbody . "}"; } else { $this->exit_error(500, print_r($db->errorInfo(), true)); } } catch (PDOException $e) { $this->exit_error(500, $e->getMessage()); } } else { $this->exit_error(400, "idNotPositiveInteger"); } } } else { $this->exit_error(400, "idRequired"); } }
protected function do_get() { parent::do_get(); // TODO: Change the autogenerated stub }