Простой форум на PHP для начинающих за 3 шага

Сегодня я собираюсь показать вам как легко и быстро реализовать скрипт форума для ваших нужд.

Шаг 1: Файлы Создадим 5 файлов

new_topic.php
add_new_topic.php
main_forum.php
view_topic.php
add_answer.php

Шаг 2: База данных

Создадим базу данных с именем «myforum» и поместим туда 2 таблицы «fquestions» и “fanswer”

forum-1

1
CREATE DATABASE /*!32312 IF NOT EXISTS*/`myforum` /*!40100 DEFAULT CHARACTER SET latin1 */;
2

3
USE `myforum`;
4

5
/*Table structure for table `fanswer` */
6

7
DROP TABLE IF EXISTS `fanswer`;
8

9
CREATE TABLE `fanswer` (
10
  `question_id` int(4) NOT NULL DEFAULT '0',
11
  `a_id` int(4) NOT NULL DEFAULT '0',
12
  `a_name` varchar(65) NOT NULL DEFAULT '',
13
  `a_email` varchar(65) NOT NULL DEFAULT '',
14
  `a_answer` longtext NOT NULL,
15
  `a_datetime` varchar(25) NOT NULL DEFAULT '',
16
  KEY `a_id` (`a_id`)
17
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
18

19
/*Table structure for table `fquestions` */
20

21
DROP TABLE IF EXISTS `fquestions`;
22

23
CREATE TABLE `fquestions` (
24
  `id` int(4) NOT NULL AUTO_INCREMENT,
25
  `topic` varchar(255) NOT NULL DEFAULT '',
26
  `detail` longtext NOT NULL,
27
  `name` varchar(65) NOT NULL DEFAULT '',
28
  `email` varchar(65) NOT NULL DEFAULT '',
29
  `datetime` varchar(25) NOT NULL DEFAULT '',
30
  `view` int(4) NOT NULL DEFAULT '0',
31
  `reply` int(4) NOT NULL DEFAULT '0',
32
  PRIMARY KEY (`id`)
33
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

Шаг 3: КОД ФАЙЛОВ

файл new_topic.php

forum-2

1
<!DOCTYPE html>
2
<html>
3
<head>
4
</head>
5
<body>
6
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
7
<tr>
8
<form id="form1" name="form1" method="post" action="add_new_topic.php">
9
<td>
10
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
11
<tr>
12
<td colspan="3" bgcolor="#E6E6E6"><strong>Create New Topic</strong> </td>
13
</tr>
14
<tr>
15
<td width="14%"><strong>Topic</strong></td>
16
<td width="2%">:</td>
17
<td width="84%"><input name="topic" type="text" id="topic" size="50" /></td>
18
</tr>
19
<tr>
20
<td valign="top"><strong>Detail</strong></td>
21
<td valign="top">:</td>
22
<td><textarea name="detail" cols="50" rows="3" id="detail"></textarea></td>
23
</tr>
24
<tr>
25
<td><strong>Name</strong></td>
26
<td>:</td>
27
<td><input name="name" type="text" id="name" size="50" /></td>
28
</tr>
29
<tr>
30
<td><strong>Email</strong></td>
31
<td>:</td>
32
<td><input name="email" type="text" id="email" size="50" /></td>
33
</tr>
34
<tr>
35
<td>&nbsp;</td>
36
<td>&nbsp;</td>
37
<td><input type="submit" name="Submit" value="Submit" />
38
<input type="reset" name="Submit2" value="Reset" /></td>
39
</tr>
40
</table>
41
</td>
42
</form>
43
</tr>
44
</table>
45
</body>
46
</html>

Файл add_new_topic.php

1
<?php
2

3
$host="localhost"; // Host name
4
$username="root"; // Mysql username
5
$password=""; // Mysql password
6
$db_name="myforum"; // Database name
7
$tbl_name="fquestions"; // Table name
8

9
// Connect to server and select database.
10
mysql_connect("$host", "$username", "$password")or die("cannot connect");
11
mysql_select_db("$db_name")or die("cannot select DB");
12

13
// get data that sent from form
14
$topic=$_POST['topic'];
15
$detail=$_POST['detail'];
16
$name=$_POST['name'];
17
$email=$_POST['email'];
18

19
$datetime=date("d/m/y h:i:s"); //create date time
20

21
$sql="INSERT INTO $tbl_name(topic, detail, name, email, datetime)VALUES('$topic', '$detail', '$name', '$email', '$datetime')";
22
$result=mysql_query($sql);
23

24
if($result){
25
echo "Successful<BR>";
26
echo "<a href=main_forum.php>View your topic</a>";
27
}
28
else {
29
echo "ERROR";
30
}
31
mysql_close();
32
?>

Файл main_forum.php

forum-3

1
<?php
2

3
$host="localhost"; // Host name
4
$username="root"; // Mysql username
5
$password=""; // Mysql password
6
$db_name="myforum"; // Database name
7
$tbl_name="fquestions"; // Table name
8

9
// Connect to server and select databse.
10
mysql_connect("$host", "$username", "$password")or die("cannot connect");
11
mysql_select_db("$db_name")or die("cannot select DB");
12

13
$sql="SELECT * FROM $tbl_name ORDER BY id DESC";
14
// OREDER BY id DESC is order result by descending
15

16
$result=mysql_query($sql);
17
?>
18

19
<table width="90%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
20
<tr>
21
<td width="6%" align="center" bgcolor="#E6E6E6"><strong>#</strong></td>
22
<td width="53%" align="center" bgcolor="#E6E6E6"><strong>Topic</strong></td>
23
<td width="15%" align="center" bgcolor="#E6E6E6"><strong>Views</strong></td>
24
<td width="13%" align="center" bgcolor="#E6E6E6"><strong>Replies</strong></td>
25
<td width="13%" align="center" bgcolor="#E6E6E6"><strong>Date/Time</strong></td>
26
</tr>
27

28
<?php
29

30
// Start looping table row
31
while($rows = mysql_fetch_array($result)){
32
?>
33
<tr>
34
<td bgcolor="#FFFFFF"><?php echo $rows['id']; ?></td>
35
<td bgcolor="#FFFFFF"><a href="view_topic.php?id=<?php echo $rows['id']; ?>"><?php echo $rows['topic']; ?></a><BR></td>
36
<td align="center" bgcolor="#FFFFFF"><?php echo $rows['view']; ?></td>
37
<td align="center" bgcolor="#FFFFFF"><?php echo $rows['reply']; ?></td>
38
<td align="center" bgcolor="#FFFFFF"><?php echo $rows['datetime']; ?></td>
39
</tr>
40

41
<?php
42
// Exit looping and close connection
43
}
44
mysql_close();
45
?>
46

47
<tr>
48
<td colspan="5" align="right" bgcolor="#E6E6E6"><a href="new_topic.php"><strong>Create New Topic</strong> </a></td>
49
</tr>
50
</table>

Файл view_topic.php

forum-4

1
<?php
2

3
$host="localhost"; // Host name
4
$username="root"; // Mysql username
5
$password=""; // Mysql password
6
$db_name="myforum"; // Database name
7
$tbl_name="fquestions"; // Table name
8

9
// Connect to server and select databse.
10
mysql_connect("$host", "$username", "$password")or die("cannot connect");
11
mysql_select_db("$db_name")or die("cannot select DB");
12

13
// get value of id that sent from address bar
14
$id=$_GET['id'];
15
$sql="SELECT * FROM $tbl_name WHERE id='$id'";
16
$result=mysql_query($sql);
17
$rows=mysql_fetch_array($result);
18
?>
19

20
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
21
<tr>
22
<td><table width="100%" border="0" cellpadding="3" cellspacing="1" bordercolor="1" bgcolor="#FFFFFF">
23
<tr>
24
<td bgcolor="#F8F7F1"><strong><?php echo $rows['topic']; ?></strong></td>
25
</tr>
26

27
<tr>
28
<td bgcolor="#F8F7F1"><?php echo $rows['detail']; ?></td>
29
</tr>
30

31
<tr>
32
<td bgcolor="#F8F7F1"><strong>By :</strong> <?php echo $rows['name']; ?> <strong>Email : </strong><?php echo $rows['email'];?></td>
33
</tr>
34

35
<tr>
36
<td bgcolor="#F8F7F1"><strong>Date/time : </strong><?php echo $rows['datetime']; ?></td>
37
</tr>
38
</table></td>
39
</tr>
40
</table>
41
<BR>
42

43
<?php
44

45
$tbl_name2="fanswer"; // Switch to table "forum_answer"
46
$sql2="SELECT * FROM $tbl_name2 WHERE question_id='$id'";
47
$result2=mysql_query($sql2);
48
while($rows=mysql_fetch_array($result2)){
49
?>
50

51
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
52
<tr>
53
<td><table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
54
<tr>
55
<td bgcolor="#F8F7F1"><strong>ID</strong></td>
56
<td bgcolor="#F8F7F1">:</td>
57
<td bgcolor="#F8F7F1"><?php echo $rows['a_id']; ?></td>
58
</tr>
59
<tr>
60
<td width="18%" bgcolor="#F8F7F1"><strong>Name</strong></td>
61
<td width="5%" bgcolor="#F8F7F1">:</td>
62
<td width="77%" bgcolor="#F8F7F1"><?php echo $rows['a_name']; ?></td>
63
</tr>
64
<tr>
65
<td bgcolor="#F8F7F1"><strong>Email</strong></td>
66
<td bgcolor="#F8F7F1">:</td>
67
<td bgcolor="#F8F7F1"><?php echo $rows['a_email']; ?></td>
68
</tr>
69
<tr>
70
<td bgcolor="#F8F7F1"><strong>Answer</strong></td>
71
<td bgcolor="#F8F7F1">:</td>
72
<td bgcolor="#F8F7F1"><?php echo $rows['a_answer']; ?></td>
73
</tr>
74
<tr>
75
<td bgcolor="#F8F7F1"><strong>Date/Time</strong></td>
76
<td bgcolor="#F8F7F1">:</td>
77
<td bgcolor="#F8F7F1"><?php echo $rows['a_datetime']; ?></td>
78
</tr>
79
</table></td>
80
</tr>
81
</table><br>
82

83
<?php
84
}
85

86
$sql3="SELECT view FROM $tbl_name WHERE id='$id'";
87
$result3=mysql_query($sql3);
88
$rows=mysql_fetch_array($result3);
89
$view=$rows['view'];
90

91
// if have no counter value set counter = 1
92
if(empty($view)){
93
$view=1;
94
$sql4="INSERT INTO $tbl_name(view) VALUES('$view') WHERE id='$id'";
95
$result4=mysql_query($sql4);
96
}
97

98
// count more value
99
$addview=$view+1;
100
$sql5="update $tbl_name set view='$addview' WHERE id='$id'";
101
$result5=mysql_query($sql5);
102
mysql_close();
103
?>
104

105
<BR>
106
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
107
<tr>
108
<form name="form1" method="post" action="add_answer.php">
109
<td>
110
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
111
<tr>
112
<td width="18%"><strong>Name</strong></td>
113
<td width="3%">:</td>
114
<td width="79%"><input name="a_name" type="text" id="a_name" size="45"></td>
115
</tr>
116
<tr>
117
<td><strong>Email</strong></td>
118
<td>:</td>
119
<td><input name="a_email" type="text" id="a_email" size="45"></td>
120
</tr>
121
<tr>
122
<td valign="top"><strong>Answer</strong></td>
123
<td valign="top">:</td>
124
<td><textarea name="a_answer" cols="45" rows="3" id="a_answer"></textarea></td>
125
</tr>
126
<tr>
127
<td>&nbsp;</td>
128
<td><input name="id" type="hidden" value="<?php echo $id; ?>"></td>
129
<td><input type="submit" name="Submit" value="Submit"> <input type="reset" name="Submit2" value="Reset"></td>
130
</tr>
131
</table>
132
</td>
133
</form>
134
</tr>
135
</table>

Файл add_answer.php

1
<?php
2

3
$host="localhost"; // Host name
4
$username="root"; // Mysql username
5
$password=""; // Mysql password
6
$db_name="myforum"; // Database name
7
$tbl_name="fanswer"; // Table name
8

9
// Connect to server and select databse.
10
mysql_connect("$host", "$username", "$password")or die("cannot connect");
11
mysql_select_db("$db_name")or die("cannot select DB");
12

13
// Get value of id that sent from hidden field
14
$id=$_POST['id'];
15

16
// Find highest answer number.
17
$sql="SELECT MAX(a_id) AS Maxa_id FROM $tbl_name WHERE question_id='$id'";
18
$result=mysql_query($sql);
19
$rows=mysql_fetch_array($result);
20

21
// add + 1 to highest answer number and keep it in variable name "$Max_id". if there no answer yet set it = 1
22
if ($rows) {
23
$Max_id = $rows['Maxa_id']+1;
24
}
25
else {
26
$Max_id = 1;
27
}
28

29
// get values that sent from form
30
$a_name=$_POST['a_name'];
31
$a_email=$_POST['a_email'];
32
$a_answer=$_POST['a_answer'];
33

34
$datetime=date("d/m/y H:i:s"); // create date and time
35

36
// Insert answer
37
$sql2="INSERT INTO $tbl_name(question_id, a_id, a_name, a_email, a_answer, a_datetime)VALUES('$id', '$Max_id', '$a_name', '$a_email', '$a_answer', '$datetime')";
38
$result2=mysql_query($sql2);
39

40
if($result2){
41
echo "Successful<BR>";
42
echo "<a href='view_topic.php?id=".$id."'>View your answer</a>";
43

44
// If added new answer, add value +1 in reply column
45
$tbl_name2="fquestions";
46
$sql3="UPDATE $tbl_name2 SET reply='$Max_id' WHERE id='$id'";
47
$result3=mysql_query($sql3);
48
}
49
else {
50
echo "ERROR";
51
}
52

53
// Close connection
54
mysql_close();
55
?>