Share php mail manager source code_php skills

This article provides you with the source code of php mail manager, I hope you like it.
1. Demand analysis
Administrators should be able to create and modify email content.
Administrators should be able to send text or HTML formatted newsletters to all subscribers on a list.
Users should be able to register to use a site and enter and modify their profile.
Users should be able to subscribe to newsletters from any of the site's lists.
Users should be able to unsubscribe from a mailing list.
Users should be able to store news letters in HTML format or plain text format, depending on personal preference.
For security reasons, users should not be able to send emails to lists or see other users' email addresses.
Users and administrators should be able to view information about the mailing list.
Users and administrators should be able to view past newsletters that have been sent to a list (archived file).

2. Solution
2.1 User Permissions Map

2.2 File List in Mailing List Manager

2.3 Possible actions in the mailing list manager

3. Implement database

CREATE DATABASE mlm; #创建mlm数据库 
 
use mlm; #使用mlm数据库 
 
CREATE TABLE lists #列表 
( 
 listid INT AUTO_INCREMENT NOT NULL PRIMARY KEY, #列表ID 
 listname CHAR(20) NOT NULL, #列表名 
 blurb VARCHAR(255) #列表主要内容 
); 
 
CREATE TABLE subscribers #订阅者 
( 
 email CHAR(100) NOT NULL PRIMARY KEY, #邮箱 
 realname CHAR(100) NOT NULL, #真实姓名 
 mimetype CHAR(1) NOT NULL, #想要接收邮件类型 
 password CHAR(40) NOT NULL, #密码 
 admin TINYINT NOT NULL #管理员标记 
); 
 
CREATE TABLE sub_lists #订阅-列表关系表 
( 
 email CHAR(100) NOT NULL, #邮件 
 listid INT NOT NULL #列表ID 
); 
 
CREATE TABLE mail #邮件表 
( 
 mailid INT AUTO_INCREMENT NOT NULL PRIMARY KEY, #邮件ID 
 email CHAR(100) NOT NULL, #发送方 
 subject CHAR(100) NOT NULL, #主题 
 listid INT NOT NULL, #列表ID 
 status CHAR(10) NOT NULL, #邮件状态，是否被发送 
 sent DATETIME, #发送时间 
 modified TIMESTAMP #最后一次修改时间戳 
); 
 
CREATE TABLE images #图像表 
( 
 mailid INT NOT NULL, #邮件ID 
 path CHAR(100) NOT NULL, #路径 
 mimetype CHAR(100) NOT NULL #图片类型 
); 
 
GRANT SELECT,INSERT,UPDATE,DELETE #创建mlm用户 
ON mlm.* 
TO mlm@localhost IDENTIFIED BY 'password'; 
 
#插入订阅者标记 
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 be helpful to everyone learning PHP programming.