forumReply.php
[PHP]<?php
$_GET[forumID];
$conn = mysql_connect("localhost", "root", "")
or die (mysql_error());
mysql_select_db("ums e-job portal",$conn) or die ("Cannot connect");
//verity the topic exists
$verify_topic = "select * from forumtopic where
forumID = '$_GET[forumID]'";
$verify_topic_res = mysql_query($verify_topic, $conn)
or die ("Cannot connect to server");
while ($forumIS = mysql_fetch_array($verify_topic_res)){
?>
<h2 align="center">Reply to <? echo $forumIS['forumTopic']; ?> </h2>
<? } ?>[/PHP]
[HTML]<form method=post action="forumReply_act.php?forumID=<? echo $_GET[forumID];?>">
<p align="center">
<p align="center"><br/>
<p align="center"><strong>Reply :</strong><br/>
<textarea name="reply" rows="8" cols="40" wrap=virtual></textarea>
<p>
<center><input type="submit" name="submit" value="Reply">
</center>
</p>
</form>[/HTML]
forumReply_act.php
[PHP]<?php
ob_start();
session_start();
//check for required fields from the form
$_GET[forumID];
//connect to server and select database
$conn = mysql_connect("localhost", "root", "")
or die (mysql_error());
mysql_select_db("ums e-job portal",$conn) or die(mysql_error());
//create and issue the first query
$add_topic = "insert into forumpost values ('', '$_GET[forumID]', '$_SESSION[username]', now(), '$_POST[reply]')";
mysql_query($add_topic,$conn) or die(mysql_error());
//get the id of the last query
$ID = mysql_insert_id();
//create messege for user indicate bulletin adding success
$msg = ("Your reply has being posted!");
?>
<? echo $msg; ?>
<? include("forum.php")
?>[/PHP]
forumTopic.php
[PHP]<?php
//check for required info from the query string
$_GET[forumID];
$conn = mysql_connect("localhost", "root", "")
or die (mysql_error());
mysql_select_db("ums e-job portal",$conn) or die ("Cannot connect");
//verity the topic exists
$verify_topic = "select * from forumtopic where
forumID = '$_GET[forumID]'";
$verify_topic_res = mysql_query($verify_topic, $conn)
or die ("Cannot connect to server");
?>
<?
while ($forumIS = mysql_fetch_array($verify_topic_res)){
?>
<h2><font face="Arial, Helvetica, sans-serif">Forum title : <? echo $forumIS['forumTopic']; ?></font></h2>
<p><font face="Arial, Helvetica, sans-serif">By : </font><? echo $forumIS['username']; ?><br>
<font face="Arial, Helvetica, sans-serif">On :</font> <? echo $forumIS['forumTime']; ?></p>
<p><font face="Arial, Helvetica, sans-serif">Comment :</font><br>
<? echo $forumIS['forumComment']; ?></p>
<? } ?>
<p><a href="forumReply.php?forumID=<? echo $_GET[forumID];?>"><font face="Arial, Helvetica, sans-serif">Reply
a Post</font></a></p>
<?
$get_totalPosts = "select * from forumpost where forumID = '$_GET[forumID]' ORDER BY postID desc";
$get_totalPosts_res = mysql_query($get_totalPosts,$conn) or die (mysql_error());
$num=mysql_num_rows($get_totalPosts_res);
$get_posts = "select * from forumpost where forumID = '$_GET[forumID]' ORDER BY postID desc";
$get_posts_res = mysql_query($get_posts,$conn) or die (mysql_error());
?>
<font face="Arial, Helvetica, sans-serif"> Total reply(s) :</font> <? echo $num;?><br>
<br>
<table border="1"><tr>
<td width="400"><strong><font face="Arial, Helvetica, sans-serif">Reply</font></strong></td>
<td width="50"><font face="Arial, Helvetica, sans-serif">By</font></td>
<td width="50"><font face="Arial, Helvetica, sans-serif">On</font></td>
</tr>
<?
while ($posts_info = mysql_fetch_array($get_posts_res)) {
?>
<tr>
<td><? echo $posts_info['postContent'];?></td>
<td><? echo $posts_info['username'];?></td>
<td><? echo $posts_info['postTime'];?></td>
</tr>
<? } ?>
[/PHP]
127
