Web Management System One

Always want to write a Web management system, but caught in the technology trap, always in the research technology, in fact, now think of simple things should be simple to do.

Step by step to modify, gradually revised.

Now write down the goals and processes, please make progress with me.

Objective: To create a simple news system with a news product message.

System Analysis

First, the function

User

User Add Delete Modify find all user user name find ordinal lookup

Role table

News (list, detail) attachment (Zip,doc,rar)

Add edit delete Find all ordinal ordinal categories find pagination Lookup audit

News Category

Adding and deleting sqlds realization

Product (list, detail) picture (img,jpg,gif,png)

Add edit delete Find all ordinal find category find page search review

About (single page) administrators to add

Add edit delete Find all ordinal find category find

Front desk only message and check function

Background for administrative permissions to access the directory under Admin

Second, the database design

ID is marked int cannot be null default all fields cannot be null NULL for NULL

Other IDs are foreign keys

Guest User Table

Ordinal ID

User name UserName

Password Userpass

Email useremail

Nickname Usernick

Avatar Userimg

Role sequence RID

Role roles table (default role is User admin admin)/* The user name is stored in the configuration file, only administrator privileges can be assigned */

Ordinal ID

Character RoleName

Newsclass

Ordinal ID

Category name ClassName

News list

Ordinal ID

User ID UID

Class Number Ncid

Title Newstitle

Content Newscontent

Annex Newsaffix

News Time Newsdate

Productclass Product Categories

Ordinal ID

Product Type Productclass

Product Products Table

Ordinal ID

User ID UID

Class Number Pcid

Product Name ProductName

Product Picture Productimg

Product Introduction Productcontent

Product Price Productpice

Page single page

Ordinal ID

Titles Title

Content contents

Attachment Affix for download forms

Guestbook Message Board

Ordinal ID

Name Author

Email email

Message Content Message

Reply Replay null

Message Date Messagedate

Audit Ischeck Audit before the first page display

Web Management System One