Page 1 of 1

how to create a discussion forum using php and my sql

Posted: Fri Jan 02, 2009 12:58 am
by swathin2
hi i am trying to make a new discussion forum by means of these two services,(php and mysql).

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

Code: Select all

 
<?
// 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:

Code: Select all

 
<?
$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...

Re: how to create a discussion forum using php and my sql

Posted: Fri Jan 02, 2009 2:09 am
by jaoudestudios
Just a note on your html...it is very old hat and will not validate to W3C standards. :wink:

Re: how to create a discussion forum using php and my sql

Posted: Fri Jan 02, 2009 3:22 am
by The_Anomaly
Don't reinvent the wheel.

And use the little code button when you post. It make everyone a lot happier.

Re: how to create a discussion forum using php and my sql

Posted: Fri Jan 02, 2009 5:05 am
by swathin2
The_Anomaly wrote:Don't reinvent the wheel.

And use the little code button when you post. It make everyone a lot happier.
i did not get what you were trying to say by means of this
can you be more specific so that i can understand it in a better manner

Re: how to create a discussion forum using php and my sql

Posted: Fri Jan 02, 2009 5:10 am
by The_Anomaly
There are a bunch of PHP and MySQL discussion boards out there, OS and commercial. Google around.


And I meant to use the following tags when posting code:

Re: how to create a discussion forum using php and my sql

Posted: Tue Jan 06, 2009 1:42 am
by swathin2
hi that is no helpful for me

can you suggest me a better way of doing that

Re: how to create a discussion forum using php and my sql

Posted: Sun May 10, 2009 11:02 am
by aditya2071990
http://www.google.com/#hl=en&q=free+for ... y0_Tod3DXA

That's a load of free PHP discussion boards, Swathi, they will eradicate the need for you to code a new discussion board all over again...