Techno World Inc - The Best Technical Encyclopedia Online!

THE TECHNO CLUB [ TECHNOWORLDINC.COM ] => PHP => Topic started by: Hellraiser on August 29, 2007, 10:22:07 AM



Title: PHP mailbox - dynamic website
Post by: Hellraiser on August 29, 2007, 10:22:07 AM
PHP mailbox - dynamic website

�Assuming you have the basic understanding of PHP and MySQL and both are installed and running on your PC.

   1. The first step is to make the database: Create database called PHPmail and two tables mail, member
      Mail:
Code:
      CREATE TABLE `mail` ( `mailid` int(25) NOT NULL, `from` int(25) default NULL, `to` int(25) default NULL, `subject` varchar(255) default NULL, `mail` text, `date` datetime default NULL, `status` varchar(10) NOT NULL default 'not read', `file` varchar(255) default NULL, PRIMARY KEY (`mailid`) )
      Member:
Code:
      CREATE TABLE `employee` ( `memberid` int(25) NOT NULL default '0', `name` varchar(50) default NULL, PRIMARY KEY (`mailid`) )