Forum Moderators: coopster
i browsed through net and i was able to get the following information which is not working for me as it is saying that it works fine only in php version but not in the latest one. i am pasting the code so that you can have a glance at it and let me know what modifications are needed.
i created a table like this with the name forum...
Field Name Data Type
code AutoNumber
parentcode Number
title Text
description Text
uname Text
email Text
Here's the code for first PHP file (forum.php):
Here's the code for the second PHP file (node.php) file:
Field Name Data Type
code AutoNumber
parentcode Number
title Text
description Text
uname Text
email Text
<?
// This is the DSN we have create for our database
$connect = odbc_connect("forum", "root", "");
?>
<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 = odbc_exec($connect,"select * from forum where parentcode = $nodecode");
echo "<UL type='disc'>";
while(odbc_fetch_row($noderesult)) // get all the rows
{
$code = odbc_result($noderesult,"code");
$title = odbc_result($noderesult,"title");
$uname = odbc_result($noderesult,"uname");
$email = odbc_result($noderesult,"email");
echo "<LI>";
echo "<A HREF='node.php?node=$code'> $title </A>";
echo "-- by ($uname) $email<BR>";
shownode($code);
}
echo "</UL>";
}
?>
</BODY>
</HTML>
Here's the code for the second PHP file (node.php) file:
<?
$connect = odbc_connect("forum", "root", "");
if(isset($submit)) // check if submitted button is clicked
{
// insert the record in the database
$resultupdate=odbc_exec($connect,"insert into forum
(parentcode,title,description,uname,email) VALUES
($_POST[node],'$_POST[title]','$_POST[description]','$_POST[postname]','$_POST
[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 = odbc_exec($connect,"select * from forum where code = $node");
$noderow=odbc_fetch_row($noderesult);
$title = odbc_result($noderesult,"title");
$description = odbc_result($noderesult,"description");
$uname = odbc_result($noderesult,"uname");
$email = odbc_result($noderesult,"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>
i was able to see everything but when i am clicking on post message then the message is neither getting added to the table or it is getting displayed in the page. can anyone explain me how can i get done better...
so only i am trying to design one
so can you help me out in this concern please
Creating a forum system from scratch is a very large (what seems to be) first project with PHP and MySQL. I would start much smaller if all it is you are doing is trying to learn. There are key levels that you have to reach in order to successfully code something like this on your own. May I suggest some tutorials on using MySQL with PHP as a place to start.
