/** * Persists a status into database. * * @param Status $status * * @return bool */ public function persist(Status $status) { $action = 'INSERT'; if (!is_null($status->getId())) { $action = 'UPDATE'; } $query = $action . ' INTO status (message, userName, publishDate, client) VALUES (:message, :userName, :publishDate, :client)'; return $this->con->executeQuery($query, array('message' => $status->getMessage(), 'userName' => $status->getUserName(), 'publishDate' => $status->getPublishDate()->format('Y-m-d H:i'), 'client' => $status->getClient())); }
public function persist(Status $status) { $request = "INSERT INTO statuses(status_message,status_user_id,status_date) value(?,?,?)"; $param = array('1' => array($status->getMessage(), PDO::PARAM_STR), '2' => array($status->getUser(), PDO::PARAM_STR), '3' => array($status->getDate(), PDO::PARAM_STR)); $this->connection->prepareAndExecuteQuery($request, $param); }