Page 1 of 1

Facebook Inbox

Posted: Fri Jan 30, 2009 10:00 am
by vikas_ercse
i want to implement the mails functionality for my website. same as that of facebook/inbox.
like users can talk on a single topic. what should i need to do with database. ie. which kind of our database should be for that functionality.
i am very new to php . please tell .

Re: Facebook Inbox

Posted: Fri Jan 30, 2009 10:04 am
by papa
If you are on a PC I would download Wamp and work with MySQL.

Re: Facebook Inbox

Posted: Fri Jan 30, 2009 10:39 am
by Attero
For development purposes, install a automated installation for a WAMP (Windows, Apache, MySQL, PHP) system.
I find the best one is EasyPHP because it's very lightweight.

You will probably want to create 2 tables.

Tables:
  • tblMessageHeaders
  • tblMessages
In the tblMessageHeaders table you want fields such as the message header ID, title, creator, recipient, time created.
In the tblMessages table you want fields such as message ID, message header ID, message, creator, time created.

And then you can just add the messages in tblMessages and headers into tblMessageHeaders and join them together using LEFT JOIN or something similar when fetching them from the database.