Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if($stmt == FALSE)
- {
- die($this->conn->error);
- }else {
- $stmt->bind_param("iii", $card_id, $card_type_id, $user_id);
- if ($stmt->execute()) {
- $res = array();
- $stmt->bind_result($id, $card_name, $category, $card_desc, $card_picture, $status, $created_at);
- // TODO
- // $card = $stmt->get_result()->fetch_assoc();
- $stmt->fetch();
- $res["id"] = $id;
- $res["card_name"] = $card_name;
- $res["category"] = $category;
- $res["card_desc"] = $card_desc;
- $res["card_picture"] = $card_picture;
- $res["status"] = $status;
- $res["created_at"] = $created_at;
- $stmt->close();
- return $res;
- } else {
- return NULL;
- }
- }
- }`
- `$app->get('/cards/users/:card_id', 'authenticate', function($card_id, $card_type_id) {
- global $user_id;
- $response = array();
- $db = new Card();
- // fetch card
- $result = $db->getCard($card_id, $card_type_id, $user_id);
- if ($result != NULL) {
- $response["error"] = false;
- $response["id"] = $result["id"];
- $response["card_name"] = $result["card_name"];
- $response["category"] = $result["category"];
- $response["card_desc"] = $result["card_desc"];
- $response["card_picture"] = $result["card_picture"];
- $response["status"] = $result["status"];
- $response["createdAt"] = $result["created_at"];
- echoRespnse(200, $response);
- } else {
- $response["error"] = true;
- $response["message"] = "The requested resource doesn't exists";
- echoRespnse(404, $response);
- }
- });`
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement