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;
}
}
