This article mainly shares the php Mail Manager source code, a simple PHP mail manager with detailed comments and development documents, you are welcome to download the php Mail Manager source code.
1. requirement analysis
The administrator should be able to create and modify the Mail content.
The administrator should be able to send text or HTML-format news messages to all subscribers in a list.
Users should be able to use a website through registration and access and modify their personal data.
The user should be able to subscribe to any list of news mails on the site.
The user should be able to cancel the subscription of a mail list.
Users should be able to store News and mails in HTML or plain text format according to their personal preferences.
For security reasons, you should not be able to send emails to the list or to see the email addresses of other users.
Users and administrators should be able to view information about the email list.
The user and administrator should be able to view the news mails that have been sent to a list (archive file) in the past.
2. solutions
2.1 User permission diagram
2.2 List of files in the mail list manager
2.3 possible operations in the mail list manager
3. implement databases
Create database mlm; # CREATE a mlm DATABASE use mlm; # use the mlm database create table lists # List (listid INT AUTO_INCREMENT not null primary key, # List ID listname CHAR (20) not null, # List name blurb VARCHAR (255) # List main content); create table subscribers # subscriber (email CHAR (100) not null primary key, # mailbox realname CHAR (100) not null, # Real name mimetype CHAR (1) not null, # password CHAR (40) not null, # password admin tinyint not null # administrator flag ); create table sub_lists # subscribe-list relational TABLE (email CHAR (100) not null, # email listid int not null # List ID ); create table mail # mail TABLE (mailid INT AUTO_INCREMENT not null primary key, # mail ID email CHAR (100) not null, # sender subject CHAR (100) not null, # topic listid int not null, # List ID status CHAR (10) not null, # Mail status, whether sent DATETIME, # sending time modified TIMESTAMP # Last modification TIMESTAMP); create table images # Image TABLE (mailid int not null, # mail ID path CHAR (100) not null, # path mimetype CHAR (100) not null # Image type); grant select, INSERT, UPDATE, DELETE # Create a mlm user ON mlm. * TO mlm @ localhost identified by 'password'; # INSERT the subscriber tag insert into subscribers VALUES ('admin @ localhost', 'administrative user', 'H ', SHA1 ('admin'), 1); insert into subscribers VALUES ('switch _ 1@switch.com ', 'administrative user', 'H', SHA1 ('admin'), 1 );
I hope this article will help you learn php programming.