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"