Shulou(Shulou.com)05/31 Report--

Most people do not understand the knowledge points of this article "how to achieve a personal blog site based on PHP", so the editor summarizes the following content, detailed content, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this "how to achieve a personal blog site based on PHP" article.

First, the operation display

II. Function description

Unlogged-in user:

You can only browse the content of all blogs.

Logged in user:

Browse the content of all blogs

Publish a blog

Delete your own blog

Modify your own blog

Comment on any blog

Change nicknames and passwords.

Administrator:

It can perform all the functions of ordinary users.

Modify the content of any blog

Delete any blog

Delete any user.

Supplementary notes on the functions of the website platform

Dynamically display blog information (such as the current number of all blogs, the number of users' personal blogs, and blog content information)

Blogs and comments are published in accordance with Beijing time

When logging in, as long as you enter the account password, the backend will automatically determine whether the account is an ordinary user or an administrator, and then push it to the corresponding web page.

3. Core code explanation 1. Create database drop database if exists grblog;CREATE DATABASE `grblog` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;USE grblog;-- personnel information CREATE TABLE admin (adminMail varchar (25) primary key, adminName varchar (10) not null, passWord varchar (15) not null, level enum ('user',' super')) Blog information CREATE TABLE blog (blogNo int primary key AUTO_INCREMENT, blogTopic varchar (50) not null, blogContent varchar (5000) not null, adminMail varchar (25) not null, importDate date not null, foreign key (adminMail) references admin (adminMail)) -- comment information CREATE TABLE comment (commentNo int primary key AUTO_INCREMENT, commentContent varchar (500) not null, adminMail varchar (25) not null, blogNo int, commentDate datetime not null, foreign key (adminMail) references admin (adminMail), foreign key (blogNo) references blog (blogNo)) 2. Initialize the data INSERT INTO `admin` (`adminMail`, `adminName`, `passWord`, `level`) VALUES ('2015100mm 126.compositions,' programmers without hair loss', 'pwdpwd',' user'), ('2015333' 163.compositions, 'Tao GE is still', 'pwdpwd',' user'), ('2015222popular qq.compositions,' ThinkWon', 'pwdpwd',' user'), ('2015111qq.compositions,' SAP swordsmen', 'pwdpwd',' user') ('20152012126.compositions,' ao C', 'pwdpwd',' user'), ('2015202126.compositions,' > = FreeMan=

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.