Module introduc...LOGIN

Module introduction to the website backend - Classification management (1) Table creation

This section will introduce a very important link, classification management, which is the core of writing a website.

What is classification management? Classification management refers to classifying things into categories, and applying different or similar management methods to different categories.

First we create a cate table to store classification information.

The code is as follows

<?php
CREATE TABLE IF NOT EXISTS `cate` (
 `cid` int(11) NOT NULL AUTO_INCREMENT,
 `pid` varchar(32) NOT NULL,
 `cate_name` varchar(32) NOT NULL,
 `rank` varchar(32) NOT NULL,
 PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;
?>

As shown in the picture:

微信截图_20170714172932.png

Insert fields inside:

微信截图_20170714173016.png

In this way, a basic classification table is built

Next Section
<?php CREATE TABLE IF NOT EXISTS `cate` ( `cid` int(11) NOT NULL AUTO_INCREMENT, `pid` varchar(32) NOT NULL, `cate_name` varchar(32) NOT NULL, `rank` varchar(32) NOT NULL, PRIMARY KEY (`cid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ; ?>
submitReset Code
ChapterCourseware