An example of a php message board

The message board can be said to be a small WEB application that all php beginners will practice. below I will share an example of a php message board I have written with you.

The message board can be said to be a small WEB application that all php beginners will practice. below I will share an example of a php message board I wrote with you, for more information, see references.

1. create a folder named "msgboard" under the root directory of your PHP. create a "msglist. php" file under "msgboard". you can directly import the data table structure.

The instance code is as follows:

1. Create table 'msgboard '(
2. 'Id' int (10) not null AUTO_INCREMENT,
3. 'Username' varchar (50) character set latin1 not null,
4. 'Sex' tinyint (1) not null default '1 ',
5. 'MSG 'text character set latin1 not null,
6. Primary key ('id ')
7. ) ENGINE = MyISAM AUTO_INCREMENT = 1 default charset = utf8;

Msglist. php file, including adding, deleting, and modifying messages

The instance code is as follows:

1.  
2.  
4. My message board 
5.  
6.  
8. $ Username = isset ($ _ REQUEST ['username'])? $ _ REQUEST ['username']: ''; // name
9. $ Sex = isset ($ _ REQUEST ['Sex '])? Intval ($ _ REQUEST ['sex']): 1; // gender
10. $ Msg = isset ($ _ REQUEST ['MSG '])? $ _ REQUEST ['MSG ']: ''; // Leave a message
11.  
12.  
13. Mysql_connect ("127.0.0.1", "root", "lzy"); // link
14. Mysql_select_db ("test"); // select a database
15.  
16. If (! Emptyempty ($ username )&&! Emptyempty ($ msg ))
17. {
18. Mysql_query ("insert into msgboard (username, sex, msg) VALUES ('$ username',' $ sex', '$ msg ')");
19. }
20. Else
21. {
22. Echo "incorrect input
    ";
23. }
24.  
25. $ Source = mysql_query ("SELECT * FROM msgboard order by id DESC ");
26. $ Result = array ();
27.  
28. ?>
29.  
31. Name 
32. Gender 
33. Message content 
35.  
37. While ($ row = mysql_fetch_array ($ source ))
38. {
39. Echo''. $ Row ['username'].'';
40. Echo''. ($ Row ['sex'] = 1? 'Male': 'Female ').'';
41. Echo''. $ Row ['MSG'].'';
42. }
43. ?>
44.  
45.  
     
46.  
48.  
49.