示例#1
0
 public function persist(Status $status)
 {
     $query = "INSERT INTO STATUSES VALUES (:status_id, :status_message, :status_user, :status_date);";
     if (isset($_SESSION['is_authenticated']) && $_SESSION['is_authenticated']) {
         $user_id = $_SESSION['user_id'];
     } else {
         $user_id = null;
     }
     return $this->connection->executeQuery($query, [':status_id' => $status->getId(), ':status_user' => $status->getOwner()->getId(), ':status_message' => $status->getText(), ':status_date' => $status->getDate()->format('Y-m-d H:i:s')]);
 }
示例#2
0
 function persist(Status $status)
 {
     $requete = "INSERT INTO statuses(id, user, message, date) value(:id, :user, :message, :date)";
     $param = array('id' => $status->getId(), 'user' => $status->getUser(), 'message' => $status->getMessage(), 'date' => $status->getDate());
     $this->conn->prepareAndExecuteQuery($requete, $param);
 }