public function update(){ if($this->id && $this->message) { $stmt = $this->conn->prepare(" UPDATE ".$this->messageTable." SET message = ? WHERE id = ?"); $stmt->bind_param("si", $this->message, $this->id); if($stmt->execute()){ $sqlQuery = " SELECT id, message, user, DATE_FORMAT(created,'%d %M %Y %H:%i:%s') AS post_date FROM ".$this->messageTable." WHERE id = '".$this->id."'"; $stmt2 = $this->conn->prepare($sqlQuery); $stmt2->execute(); $result = $stmt2->get_result(); $record = $result->fetch_assoc(); echo json_encode($record); } } }