PHP development simple post bar database construction

Database Analysis

The main functions implemented by this project are user registration and login, publishing posts, and replying to posts. Based on this judgment, user tables and posts need to be designed. The two tables of content table

The user table user contains the following fields:

Field name	Field type	Field length	Field description
id	int	30	Number, primary key, auto-increment
username	varchar	30	Username
password	varchar	40	Password

The post table tiezi contains the following fields:

## Content of the posttimestampvarchar30Post timenumint20Post views

Database creation

We run mysql in the command prompt window (specifically how to use the command prompt To connect to the database in the character window, you can refer to Section 2.2 in our previous course "PHP Development Login Registration Tutorial")

After successfully connecting to the database, copy the complete statement to create the database below into the window , press the Enter key to prompt that the creation is successful, as shown below

Creation The complete statement of the database is as follows

DROP DATABASE IF EXISTS tieba;
CREATE DATABASE tieba DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE tieba;
CREATE TABLE IF NOT EXISTS `user` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL,
  `password` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
INSERT INTO `user` (`username`, `password`) VALUES
('admin', '21232f297a57a5a743894a0e4a801fc3');

CREATE TABLE IF NOT EXISTS `tiezi` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `userId` int(30) NOT NULL,
  `fId` int(30) NOT NULL,
  `title` varchar(50) NOT NULL,
  `content` text NOT NULL,
  `timestamp` varchar(30) NOT NULL,
  `num` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;

Next Section

new file

DROP DATABASE IF EXISTS tieba;
CREATE DATABASE tieba DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE tieba;
CREATE TABLE IF NOT EXISTS `user` (
 `id` int(30) NOT NULL AUTO_INCREMENT,
 `username` varchar(30) NOT NULL,
 `password` varchar(40) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
INSERT INTO `user` (`username`, `password`) VALUES
('admin', '21232f297a57a5a743894a0e4a801fc3');

CREATE TABLE IF NOT EXISTS `tiezi` (
 `id` int(30) NOT NULL AUTO_INCREMENT,
 `userId` int(30) NOT NULL,
 `fId` int(30) NOT NULL,
 `title` varchar(50) NOT NULL,
 `content` text NOT NULL,
 `timestamp` varchar(30) NOT NULL,
 `num` int(20) NOT NULL DEFAULT '0',
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;

submit Reset Code

Automatic operation

Full Screen

None

Field name	Field type	Field length	Field Description
id	int	30	Number, primary key, auto-increment
userId	int	30	User id of the user table
fId	int	30	Indicates the affiliation of the post
title	varchar	50	Post Title
content	text