I am going to use PHP for a small Forum project to terminate the in-depth study of PHP. Ready to switch to. net

Introduction: this is an attempt to use PHP for a small Forum project to terminate in-depth PHP research. Prepare to go to the. NET detailed page and introduce the related knowledge, skills, experience, and some PHP source code.

Class = 'pingjiaf' frameborder = '0' src = 'HTTP: // biancheng.dnbc?info/pingjia.php? Id = 361155 'rolling = 'no'>
Database Structure

User simple table [bbs_user]

Field	Type	Remarks
Userid	Int	Automatic user ID Growth
Username	Varchar (50)	User Name
Password	Varchar (50)	User Password

User Details table [bbs_userinfo]

Field	Type	Remarks
Userid	Int	User ID
Username	Varchar (50)	User Name
Password	Varchar (50)	User Password
Email	Varchar (50)	User email
Age	Int	User age
Createtime	Date	User Registration Date
Ismoderator	Int	Whether it is a moderator. The default value is not (0 ).

Forum topic table [bbs_title]

Field	Type	Remarks
Titleid	Int	Subject ID increases automatically
Boardid	Int	Forum ID
Userid	Int	User ID
Title	Varchar (100)	Post Title content
Replycount	Int	Reply times
Replyuserid	Int	Reply topic user ID
Createtime	Date	Topic posting time
Lastreplytime	Date	Last reply time of topic
IP	Varchar (30)	Post IP Address

Topic content table [bbs_content]

Field	Type	Remarks
Titleid	Int	Topic ID
Content	Varchar (5000)	Subject content

Topic reply content table [bbs_repley]

Field	Type	Remarks
Reply	Int	Reply post ID
Titleid	Int	Topic ID
Boarded	Int	Forum ID
Userid	Int	User ID
Replycontent	Varchar (5000)	Reply content
IP	Varchar (30)	Reply IP Address

Forum table [bbs_board]

Field	Type	Remarks
Boardid	Int	Forum ID, automatic Growth
Boardname	Varchar (50)	Forum name
Moderatorid	Int	Moderator ID
Boardcount	Int	Number of senders

Love J2EE follow Java Michael Jackson video station JSON online tools

Http://biancheng.dnbcw.info/php/361155.html pageno: 1.