-------------forum.php-----------
<?
// This is the DSN we have create for our database
$connect = mysql_connect("localhost","","") or die ("Unable To Connect To Database");
?>
<HTML>
<BODY>
Discussion Forum using PHP/Access under IIS<BR><BR>
<A HREF='node.php?node=0'>Post New Message</A>
<?
shownode(0); // display all the main threads
// This function is a recursive function which shall display all the branches
// and sub branches of the threads
function shownode($nodecode)
{
global $connect; // using the global variable for connection
// Get a list of all the sub nodes which specific parentcode
$noderesult = mysql_query("select * from forum where parentcode = $nodecode");
echo "<UL type='disc'>";
while($noderow=mysql_fetch_array($noderesult) // get all the rows
{
$code = $noderow['code'];
$title = $noderow[title];
$uname = $noderow[uname];
$email = $noderow[email];
echo "<LI>";
echo "<A HREF='node.php?node=$code'> $title </A>";
echo "-- by ($uname) $email<BR>";
shownode($code);
}
echo "</UL>";
}
?>
</BODY>
</HTML>
------------node.php----------
<?
$connect = mysql_connect("localhost","","") or die ("Unable To Connect To Database");
if(isset($submit)) // check if submitted button is clicked
{
// insert the record in the database
$resultupdate=mysql_query($connect,"insert into forum
(parentcode,title,description,uname,email) VALUES
($node,'$title','$description','$postname','$email')");
header("location:forum.php"); // open forum.php file to display the thread
exit;
}
?>
<CENTER>Post to Discussion Forum using PHP/Access under IIS</CENTER>
<?
if ( $node != 0 )
{
// Displaying the details of the thread
echo "<HR>";
$noderesult = mysql_query("select * from forum where code = $node");
$noderow=mysql_fetch_array($noderesult);
$title = $noderow[title] ;
$description = $noderow[description] ;
$uname = $noderow[uname];
$email = $noderow[email];
echo "$title by ($uname) $email<BR>";
echo "$description <BR><HR>";
}
?>
<!-- Form to enter the message -->
<FORM method='post'">
Name : <INPUT TYPE=TEXT NAME=postname> <BR>
E-Mail : <INPUT TYPE=TEXT NAME=email> <BR>
Title : <INPUT TYPE=TEXT NAME=title VALUE = '' size=50> <BR>
Description : <BR> <TEXTAREA name=description rows=10 cols=45></TEXTAREA>
<!-- we need a hidden field to store the node -->
<INPUT TYPE=hidden NAME=node value='<? echo $node;?>'> <BR>
<INPUT type=submit name=submit value='Post Message'>
</FORM>