Php message board making tutorial _ PHP Tutorial

Php message board creation tutorial. This article provides php beginners with an article from database creation to the final read/write message board process. For more information, see. Create a data table this article will share with you the process from creating a database to reading and writing a message board. For more information, see.

Create a data table

The code is as follows:
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;

Database Connection file

The database connection code is relatively fixed. Create a new conn. php file and enter the following code:

The code is as follows:
$ Conn = mysql_connect ("localhost", "root", "") or die ("database link error "); Mysql_select_db ("test", $ conn ); Mysql_query ("set names 'gbk'"); // use GBK Chinese encoding; ?>

Compile the posting page File
Create an add. php file and enter the following code:

The code is as follows:
Include ("conn. php "); If ($ _ POST ['submit ']) { $ SQL = "insert into message (id, user, title, content, lastdate) values (", '$ _ POST [user]', '$ _ POST [biaoti]', '$ _ POST [content]', now ())"; Mysql_query ($ SQL ); Echo "published successfully! "; } ?>

Post message box

Compile the message list file
Create a file list. php and enter the following code:

The code is as follows:
Include ("conn. php "); ?> $ Query = mysql_query ($ SQL ); While ($ row = mysql_fetch_array ($ query) {?> $ SQL = "select * from message "; Title: User: Published content:

Note,This is just an entry-level php Tutorial. if you want to use it for the network, please do some security and SQL injection filtering. Otherwise, it will be very insecure.

Bytes. Create a data table...