php - query for private message chart system -
i have mysql table messages allow users of new site send private messages 1 another, while coding message page realize if user1 send message user2 , after sometime user2 decides delete message in he's inbox message user1 inbox deleted, pointed on how can figure user1 or user2 should delete message in he's inbox? maybe needs create every user table or kind of concept behind this?
i have tried multiple inserting different id's based on people sending messages sending 1 message 2 times server user1 should have he's own message user2 besides being bad programming seems not possible because in html form receiver can't change sender. try vice verse (swap) variables on insetting .php page original receiver sender, can echo messages using session user data coursing user2 see messages have been send him while user1 sees messages way suppose be.
if codes needed please let me know can provide.
have 1 table. store sender, recipient, owner , mailbox in separate columns.
check if user asking delete message owner before allowing deleted. (delete messages message_id=? , owner=?).
when message sent, store twice. once in sender's sent mailbox , ones in recipients inbox mailbox.
Comments
Post a Comment