We are looking for an email system where 2 users can email each other. We want this to operate like Facebook's email.

This will be developed in PHP and MySQL. No MVC or frameworks please. Straight PHP or object oriented PHP 5.0 will be accepted.

Some details:

When members look at their email, they will see 2 views:

1. A view of just subjects and the date / time that the email was received.

2. A view to read the body of the email with a button to reply to the sender and a delete button in that view.

Main details:

1. One member can click on a link to send an email to another member on a member page. So, we will need a page developed where the emails can be clicked.

2. The receiving member can reply and they can constantly reply back and forth to each other. Please have database fields called "sender" and "receiver". VARCHAR (35) for both.

3. We have to give all members a "Sent" folder.

4. The database email "table" would have records with the following:


- sender


- receiver


- email date and time


- subject (it would start with "re:" in front of the subject for any replies.


- the email body


- the date that the email was read.


- a parent ID which will be the database record ID of the first email that was sent in that series of emails.

5. We need a web page that would show the entire conversation between the two people in order of the emails sent.

6. We also need a button to allow either side to delete only the email from THEIR view. The other person would still see the email until he deletes it, if he deletes it. Maybe 2 database fields called "sender_deleted" and "receiver_deleted" as char(1) with a value of 1 if it was deleted and a value of 0 if it is not deleted.

7. We would need to keep track of "reads" for each side. So, if you send me an email and I have not viewed it yet, it would tell me that I have a new email. Once I read the email, it is no longer new. New emails in the subject list would appear bold and unbold if it is already read (not new).

8. Also, we new to display the number of "new" emails that a particular receiver has not yet read. Of course, when this email is read, the number of New emails goes down by one.

9. Emails can only be read if the user is logged in. Otherwise, they will be kicked out to the login page.

It would pretty much function like the email client on Facebook.