Facebook Inbox

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
vikas_ercse
Forum Newbie
Posts: 1
Joined: Fri Jan 30, 2009 9:56 am

Facebook Inbox

Post 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 .
User avatar
papa
Forum Regular
Posts: 958
Joined: Wed Aug 27, 2008 3:36 am
Location: Sweden/Sthlm

Re: Facebook Inbox

Post by papa »

If you are on a PC I would download Wamp and work with MySQL.
User avatar
Attero
Forum Newbie
Posts: 18
Joined: Thu Jan 29, 2009 9:35 am
Location: Farnborough, UK

Re: Facebook Inbox

Post 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.
Post Reply