Php entry-level message board program implementation code. The message board program needs to be implemented by php + Database. this tutorial mainly describes the implementation process of the message system of phpmysql, including adding, deleting, and editing changes, php + database is required to implement the message board program for php beginners. this tutorial mainly describes the implementation process of the message system for php mysql, including adding, deleting, and editing changes, it is a good material for php beginners to learn.
Project structure:
Add Page: Note: only focus on operations, and there is no time for the interface artist. I hope you can understand it ......
List page:
Modify page:
The SQL file of the message board, which can be directly imported to mysql.
The code is as follows: |
|
Create database form; use form; create table 'message' ('id' tinyint (1) not null auto_increment, 'user' varchar (25) not null, 'title' varchar (50) not null, 'content' tinytext not null, 'lastdate' date not null, primary key ('id ')) ENGINE = InnoDB default charset = gbk AUTO_INCREMENT = 1; |
Conn. php database connection file
The code is as follows: |
|
$ Conn = @ mysql_connect ("localhost", "root", "") or die ("database link error "); Mysql_select_db ("form", $ conn ); Mysql_query ("set names 'gbk '"); ?> |
Add. php stores the information submitted by the user to the database.
The code is as follows: |
|
Include 'Conn. php '; If ($ _ POST ['submit ']) { $ SQL = "INSERT INTO message (id, user, title, content, lastdate) VALUES (NULL, '$ _ POST [user]', '$ _ POST [title]', '$ _ POST [content]', now ())"; Mysql_query ($ SQL ); // Page jump, implemented in javascript $ Url = "list. php "; Echo" |