swathin2 Posted January 2, 2009 Share Posted January 2, 2009 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 <? // 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 ')"); 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... Quote Link to comment https://forums.phpfreaks.com/topic/139170-how-to-create-a-discussion-forum-using-php-and-my-sql/ Share on other sites More sharing options...
dezkit Posted January 2, 2009 Share Posted January 2, 2009 USE CODE TAGS PLZ Quote Link to comment https://forums.phpfreaks.com/topic/139170-how-to-create-a-discussion-forum-using-php-and-my-sql/#findComment-727915 Share on other sites More sharing options...
swathin2 Posted January 2, 2009 Author Share Posted January 2, 2009 USE CODE TAGS please i did not get what you are asking me to do i posted the same code which i am using for making the posting into the discussion forum can you explain me in details what might be the error Quote Link to comment https://forums.phpfreaks.com/topic/139170-how-to-create-a-discussion-forum-using-php-and-my-sql/#findComment-727979 Share on other sites More sharing options...
Prismatic Posted January 2, 2009 Share Posted January 2, 2009 USE CODE TAGS please i did not get what you are asking me to do i posted the same code which i am using for making the posting into the discussion forum can you explain me in details what might be the error Code tags, when you post code on these forums it's polite to encase them within [code][/code] to preserve proper code formatting and/or code highlighting. Example: <?php function myFunction($str) { return $str; } echo myFunction("Hello world!"); ?> vs <?php function myFunction($str) { return $str; } echo myFunction("Hello world!"); ?> Quote Link to comment https://forums.phpfreaks.com/topic/139170-how-to-create-a-discussion-forum-using-php-and-my-sql/#findComment-728065 Share on other sites More sharing options...
swathin2 Posted January 6, 2009 Author Share Posted January 6, 2009 ok i will do that from my next post can you suggest me a better way of doing the coding to build a discussion forum Quote Link to comment https://forums.phpfreaks.com/topic/139170-how-to-create-a-discussion-forum-using-php-and-my-sql/#findComment-730658 Share on other sites More sharing options...
redarrow Posted January 6, 2009 Share Posted January 6, 2009 create a forum here one for u. http://www.phpeasystep.com/workshopview.php?id=12 Quote Link to comment https://forums.phpfreaks.com/topic/139170-how-to-create-a-discussion-forum-using-php-and-my-sql/#findComment-730661 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.