Source code My forum source code 1

In fact, it only took me three days to write these codes. There was no detailed thinking or planning beforehand (it can be said that there was no plan at all). That day I thought of trying to make a forum, so I started to do it, and I just got in touch with it. I have been using PHP for nearly a month, and I have never really written anything like a program before. During the two and a half days of writing this code, I encountered difficulties several times and wanted to give up, but I still wrote it. And I didn't expect it to work, so there may be many hidden dangers that I can't explain, even though it is said to be usable.
In two days, I will go to work, and I won’t have time to carefully check these codes from beginning to end. This is one of the reasons why I put it up. Another reason is because I want everyone to look at it together. Look at these characters. I am just a novice. There may be many shortcuts that I have not taken, and there may be many things that are wrong. In the past two days, I have changed the code of some pages, but other related codes have not been removed, so some places are a bit heavy. cover. But it can run normally, that's for sure (at least it looks normal on the surface. I have no problem using it under WIN98/APACHE/PHP/MYSQL, and it has no problem when testing online. I don't know about other environments. I just hope it will work with me. What can newbies like me, or novices who are better than me, get from it, and if veterans and seniors can write or leave messages to point out the shortcomings or shortcomings, I will be more happy, because in that case, I will also be happy. I can learn a lot from it. My email address is: hllinyu@netease.com, OICQ: 2289230, and the homepage address is: http://lfox.oso.com.cn
Okay, I’ve said too much nonsense. I hope that everyone can devote themselves to modifying the source code of this forum, so that it can become a free forum developed by the Chinese themselves, and that the forum code can be used by many friends like me who are very interested in PHP but feel they have no idea where to start. Reference materials are enough. Let’s take a look at my forum!
First of all, I will introduce the two tables to be used: foxbbs to store post information and useinfo to store user information. Because the data space was not very large, I chose MYSQL. +TXT method, all topics except the content are stored in MYSQL, and the topic content and reply content with relatively large data volume are stored separately in TXT format files with extensions of .FOX and .BBS. Just add a field to store the file name in the table. In order to avoid duplication of file names, use the current system time as the file name. For example, if a post was posted at 11:20:30 on January 2, 2001, the file name would be 20010102112030.txt I think this can meet most of the requirements, because there may not be many forums that are so popular that two or more new posts appear every second! Haha...
The specific situation of this forum. You can see http://lfox.oso.com.cn/foxbbs/foxbbs.php. In addition, the source code package download is provided on the main page http://lfox.oso.com.cn/index.php. Don’t come here after reading the source code. Make trouble.
useinfo user information table
0 usename varchar(8) not null Username
1 usepass varchar(8) Password
2 useni varchar(30) not null Nickname
3 useoicq varchar(12) not null
4 usesex int( 1) Not null User gender
5 useage int(2) Not null User age
6 varchar(4) not null Occupation
7 useaddr varchar(20) not null Address
8 usemail varchar(40) not null email
9 useweb varchar(50) not null Home page
10 useqm varchar(240) not null Signature
11 useattr int(1) not null Attribute 1 user 2 moderator 3 administrator 4 webmaster
12 useinf int(1) not null Is the information public? 1 no 2 yes
13 useid int(5) not auto_increment primary key User ID number
14 usebq int(1) expression
15 regdate datetime; registration Time
16 enddate varchar(22) not null Last arrival time
17 ftnum int(4) not null Number of posts
18 usety char(1) not null
foxbbs forum topic table
0 id int(5) not auto_increment primary key
1 usename varchar(20) NOT Posting user name
2 ftbq int (1) not expression
3 title varchar(40) not theme
4 ftdate varchar(22) not posting time
5 mesname varchar(15) not content file name 20010102055635 I left one extra digit to prevent accidents, actually fourteen bit is enough.
6 djnum int(4) not Number of clicks
7 hfnum int(3) not Number of replies
8 hfdate varchar(24) not Last reply time
9 hfname varchar(20) not Reply file name
10 hfusename varchar(20) not Last reply person name
11 ip varchar(15)
12 lockes int 1
linkfox.inc.php is used to connect to the database

$dbhostname = "lfox";
$dbusername = "root";
$dbpassword = "root ";
$dbName = "flyfox";
MYSQL_CONNECT($dbhostname, $dbusername, $dbpassword) OR DIE("Unable to connect to database");
@mysql_select_db( "$dbName") or die( "Unable to select database");
?>

The above introduces the source code. My forum source code 1 includes source code content. I hope it will be helpful to friends who are interested in PHP tutorials.