Php development of the message board CRUD (add, delete, modify, query) operations _ PHP Tutorial

Php develops the CRUD (add, delete, modify, and query) operation on the message board. Project structure: add page: Note: only focus on operations here, and there is no time for the interface artist. I hope you can understand it ...... list page: modify page: SQL required by the project: 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:

SQL required in the project:

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

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

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"