Inbox and Outbox system with PHP and Mysql

Question

I created a Inbox and Outbox system on my website where users can send and receive text messages.

I have created a tables in my DB

-Messagebox

MessageBox table contains the following 5 fields :

 messageID Message SentBy SentTo Created

Inbox.php

 $you=$_COOKIE['username'];       $st= "SELECT* FROM Messagebox WHERE sentto='$you' ORDER BY ID DESC LIMIT 10";

outbox.php

  $you=$_COOKIE['username'];
$st= "SELECT*FROM messagebox WHERE sentby='$you' ORDER BY ID DESC LIMIT 10";

My problem is that When UserA sends a message to UserB ,UserA can see the message in Inbox and the Sender can see the sent message in his Outbox.

If The sender deletes the messege from Outbox ,Or UserA deletes the message from Inbox ,Then the messege is deleted from both sides.

How can I implement my system?

Any help would be greatly appriciated!

Add visibility flag in your table and only delete it when both have — slash197
– slash197, Commented Jun 24, 2015 at 6:13
Or store the message twice like E-Mail does. Once for the sender and once for the receiver. — Andresch Serj
– Andresch Serj, Commented Jun 24, 2015 at 6:41

Community · Accepted Answer · 2017-05-23 12:24:57Z

2

You can add two flags for delete purpose. One flag is for deletedByReceiver and another is for deletedBySender. Set the appropriate flag whenever message deleted.

Another option is to maintain on more table which maintain the our and in of each message with message id. For more go through : Messaging system in php mysql

edited May 23, 2017 at 12:24

CommunityBot

11 silver badge

answered Jun 24, 2015 at 7:04

Santosh Jagtap

1,0951 gold badge9 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Inbox and Outbox system with PHP and Mysql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related