How to design and implement mysql social platform-Mysql Tutorial-php.cn

4. Design and implementation of CMS suite

A.CMS article

1. The article module mainly consists of publishing, review, article It consists of several parts such as management and classification management.

2. Design ideas

There are three main options for article publishing: platform publishing, platform publishing combined with user publishing, and complete user publishing.
Article status: Draft box, pending review, published.
# Product binding: The bound products can be from self-built malls or other platforms.
##Image upload method: FileUpload, Flash, XMLHttpRequest2, etc.

B.CMS Pictorial

1. A media form based on pictures. The content of the pictures can be the same product or the same theme.

2. The pictorial module is similar to the article.

3. Design idea:

Functional design idea: An article type that uses slides as the presentation form and is entirely composed of pictures.
Delayed loading of images

C.CMS special topic

1. Module composition: image hot spots, banner images, product modules, etc.

2. After the topic page is published, a static html file is directly generated and loaded directly when displayed in the front desk.

3. Design ideas:

Background design ideas: Added the function of setting multiple background parameters such as background images, alignment, margins, etc. for the topic page. These parameters can create rich page background effects.
Picture Hotspot Design
Loading method of the topic: Generate static page
The overall style of the topic: separation of mall and CMS

D.CMS home page editing

1. Module Composition: standard modules and custom modules

2. Design idea:

Overall structural design idea: use building blocks to combine standard modules and custom modules
Standard module design ideas: fixed layout and content format, including comprehensive module, article module, banner picture module, etc.

E. Other functions

1. Comments: Forum building mode, only logged-in users can post

2. Mood

3. Sharing

4. Navigation management

5. Design and implementation of social platform

A.SNS module

1. Module composition:

B. Circle (discussion group) suite

1. Circle features: Create your own circle (category, name, LOGO , introduction content and announcements, etc.); independent front-end management center; multi-form display of theme lists;

2. Design ideas:

Member design: super administrator; circle leader; administrator; Members; visitors;

Topic design: divided into two types, ordinary topics and voting topics; simple editing functions are required; protection (preventing XSS from injecting UBB, preventing watering, keyword filtering, platform control)

6. Design and implementation of IM suite

A. Module composition

Real-time, message push

B. Design ideas

1. Socket.IO of Node.js

2. The message table records unread messages, and the message record table saves all conversations permanently

7. Design and implementation of mobile application suite

A. Design ideas

1. Product design: convenience, Timeliness, number of users

2. Design principles:

##Use environment: to kill boredom, busy at work, in a different place
Universal design specifications: three types of mobile applications: practical, efficient, and immersive. In design, focus on responsiveness, detail, thumb-friendliness, click target size, layout relationships of adjacent elements, and presentation of content. Satisfy intuitive mode as much as possible within a "direct manipulation" framework: control layout and scrolling
First impression: application icon, first launch

B. Introduction to related tools and third-party frameworks

Axure, AndroidAnnotations, lightweight ORM framework ActiveAndroid

8. Design and implementation of O2O suite

A. Product design ideas

8 main modules: merchant module, group purchase module, coupon module, settlement module, reservation module, membership card module, community module, member center module

B. Merchant Design and implementation of the module

1. Module composition: store setting, order management, group purchase management, product management, review management, coupon management, event management and settlement management, membership card management and appointment management

2. Design ideas

Regional attributes need to be divided into three levels: cities, districts and counties, and commercial areas
The store homepage needs to display basic merchant information, geographical location, group buying discount information, store products, user reviews, etc.

C. Group buying module design

1. Module composition: Merchant group purchase management (publish and edit group purchases), platform group purchase management (group purchase management, group purchase orders), member order management, group purchase front-end display (group purchase list module, group purchase details module, select group purchase quantity module , group purchase payment module)

2. Design ideas:

Group purchase data table design ideas:

Group purchase information data table: including group purchase name, group purchase Introduction, group buying start and end time, store ID, store name, original price, group buying price, group buying quantity, purchase online, number of buyers, group buying introduction, group buying pictures, release time, etc.
Group purchase order data table: including order number, member ID, member name, mobile phone number, store ID, store name, order time, group purchase index ID, group purchase name, group purchase quantity, group purchase price, group purchase status, etc.
Group buying coupon data table: including index order ID, group buying coupon status, group buying code, usage time

##D .Coupon module design

1. Module composition: coupon management in the merchant backend (add, delete, check), coupon management in the platform backend (review, deletion, recommendation, etc.), coupon front-end display (display and Provide functions such as printing and downloading)

2. Design ideas:

Data table: main table of coupon information (coupon name, picture, start and end time, text message content, etc. ), coupon download record table (download coupon name, download time, download method, etc.)
Coupon page design ideas: basic information of merchants, basic information of coupons , Coupon details

E. Settlement module design

1. Module composition: Settlement management module of the platform background (generate settlement Bill, review payment and view details), settlement management module of the merchant backend (view the issued settlement document and confirm or collect payment)

2. Design idea:

Data table: stores settlement order number, store ID, store name, start settlement time, end settlement time, total amount, final payment amount, settlement status and settlement date, etc.
Process: 5 statuses (outgoing, reviewed, confirmed, paid, completed)

9. E-commerce platform interface design And user experience

A. Things about web design

1. Web design is divided into visual design (GUI), interaction design (UCD) and Front-end development (Web Font-End Development)

2. Add readability comments to the code: area comments, single-line comments, comment levels, assistance comments

B. Mall homepage

1. B2B2C mall homepage design elements: Topbar, Header, Navigation and Category menu (Nav & Category), Focus Layout, Information area (Information) , promotion recommendation (Sales), page main body (Main), advertising insertion point (AD), user help (Member FAQ), page foot (Footer)

The above is the detailed content of How to design and implement mysql social platform. For more information, please follow other related articles on the PHP Chinese website!