public function updateMessage($id) { //$message_status = new MessageStatus; if (Request::isMethod('post')) { $message = Input::get('message'); if ($message) { //insert the message in the db $message_id = Message::insertGetId(array('message' => $message, 'member_id' => Auth::user()->id, 'chatroom_id' => $id)); //get list of active members in the group $active_chatroom_members = ChatRoomMember::select()->where('chatroom_id', $id)->where('member_id', '<>', Auth::user()->id)->lists('member_id'); //update message status of all active members $message_status = new MessageStatus(); foreach ($active_chatroom_members as $active_chatroom_member) { $message_status->member_id = $active_chatroom_member; $message_status->chatroom_id = $id; $message_status->message_id = $message_id; $message_status->is_read = 0; $message_status->save(); } } return $message; } }