public function save(Emoji $emoji) { $connection = static::connectDatabase(); $dbQuery = $connection->prepare('INSERT INTO emojis (emojiname, emojichar, category, created_by, created_at, updated_at) VALUES(?,?,?,?,?,?)'); $name = $emoji->getName(); $char = $emoji->getChar(); $category = $emoji->getCategory(); $createdBy = $emoji->getCreatedBy(); $createdAt = $emoji->getCreatedAt(); $updatedAt = $emoji->getUpdatedAt(); $dbQuery->bindParam(1, $name); $dbQuery->bindParam(2, $char); $dbQuery->bindParam(3, $category); $dbQuery->bindParam(4, $createdBy); $dbQuery->bindParam(5, $createdAt); $dbQuery->bindParam(6, $updatedAt); $dbQuery->execute(); if ($dbQuery->rowCount() > 0) { return true; } else { throw new PDOException("Cannot save emoji data."); } }
public static function update(Slim $app, $id) { self::setContentType($app); $name = $app->request->params('emojiname'); $char = $app->request->params('emojichar'); $category = $app->request->params('category'); self::setTimeZone(); $updatedAt = date('Y-m-d H:i:s'); $emoji = new Emoji($name, $char, $category); $emoji->setUpdatedAt($updatedAt); $emojiOperation = new EmojiOperations(); try { $result = $emojiOperation->update($id, $emoji); if ($result) { self::$response->body($emojiOperation->jsonify(['status' => 200, 'message' => 'Record modified successfully.'])); return self::$response; } $response->body($emojiOperation->jsonify(['status' => '500', 'message' => 'An error occured while processing request.'])); return self::$response; } catch (PDOException $e) { self::$response->body($emojiOperation->jsonify(['status' => 304, 'message' => $e->getMessage()])); return self::$response; } }