Example #1
0
 /**
  * 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);
 }