Advertisement
Guest User

Untitled

a guest
Nov 1st, 2014
168
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.77 KB | None | 0 0
  1. if($stmt == FALSE)
  2. {
  3. die($this->conn->error);
  4. }else {
  5. $stmt->bind_param("iii", $card_id, $card_type_id, $user_id);
  6. if ($stmt->execute()) {
  7. $res = array();
  8. $stmt->bind_result($id, $card_name, $category, $card_desc, $card_picture, $status, $created_at);
  9. // TODO
  10. // $card = $stmt->get_result()->fetch_assoc();
  11. $stmt->fetch();
  12. $res["id"] = $id;
  13. $res["card_name"] = $card_name;
  14. $res["category"] = $category;
  15. $res["card_desc"] = $card_desc;
  16. $res["card_picture"] = $card_picture;
  17. $res["status"] = $status;
  18. $res["created_at"] = $created_at;
  19. $stmt->close();
  20. return $res;
  21. } else {
  22. return NULL;
  23. }
  24. }
  25. }`
  26.  
  27. `$app->get('/cards/users/:card_id', 'authenticate', function($card_id, $card_type_id) {
  28. global $user_id;
  29. $response = array();
  30. $db = new Card();
  31.  
  32. // fetch card
  33. $result = $db->getCard($card_id, $card_type_id, $user_id);
  34.  
  35. if ($result != NULL) {
  36. $response["error"] = false;
  37. $response["id"] = $result["id"];
  38. $response["card_name"] = $result["card_name"];
  39. $response["category"] = $result["category"];
  40. $response["card_desc"] = $result["card_desc"];
  41. $response["card_picture"] = $result["card_picture"];
  42. $response["status"] = $result["status"];
  43. $response["createdAt"] = $result["created_at"];
  44. echoRespnse(200, $response);
  45. } else {
  46. $response["error"] = true;
  47. $response["message"] = "The requested resource doesn't exists";
  48. echoRespnse(404, $response);
  49. }
  50. });`
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement