how to create a discussion forum using php and my sql

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
swathin2
Forum Newbie
Posts: 4
Joined: Fri Jan 02, 2009 12:55 am

how to create a discussion forum using php and my sql

Post 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...
Last edited by Benjamin on Sun May 10, 2009 12:43 pm, edited 1 time in total.
Reason: Added [code=php] tags.
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

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

Post by jaoudestudios »

Just a note on your html...it is very old hat and will not validate to W3C standards. :wink:
User avatar
The_Anomaly
Forum Contributor
Posts: 196
Joined: Fri Aug 08, 2008 4:56 pm
Location: Tirana, Albania

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

Post by The_Anomaly »

Don't reinvent the wheel.

And use the little code button when you post. It make everyone a lot happier.
swathin2
Forum Newbie
Posts: 4
Joined: Fri Jan 02, 2009 12:55 am

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

Post 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
User avatar
The_Anomaly
Forum Contributor
Posts: 196
Joined: Fri Aug 08, 2008 4:56 pm
Location: Tirana, Albania

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

Post 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:
swathin2
Forum Newbie
Posts: 4
Joined: Fri Jan 02, 2009 12:55 am

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

Post by swathin2 »

hi that is no helpful for me

can you suggest me a better way of doing that
User avatar
aditya2071990
Forum Contributor
Posts: 106
Joined: Thu May 22, 2008 11:30 am
Location: Hyderabad, India
Contact:

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

Post 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...
Post Reply