Jump to content


Check out our Community Blogs

swathin2

Member Since 31 Dec 2008
Offline Last Active Sep 09 2009 01:12 AM
-----

Topics I've Started

How can we know whether a file is read or not

08 September 2009 - 03:21 AM

how can we know whether a particular file is read or not using c programming.

for an example:

the file name = abcd.txt

the status of the file should be 0 if the person has not opened it and it should be changed to 1 after any one reads it

how can we do this

need help in adding a charecter to the file name

07 September 2009 - 10:46 PM

Hello,

if the account number is "abcd" then i need to have to check whether "abcd1" or "abcd2" or ...... is existing or not.

if it is not existing then i need to create it.

so how can i do this

any suggestions

how to create a discussion forum using php and my sql

31 December 2008 - 04:17 AM

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
[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...

help regarding xampp

31 December 2008 - 04:16 AM

hi need some help regarding xampp

please help me out how to execute mysql in this

how to create a new table and do some modifications in this xampp tool

discussion forum

31 December 2008 - 04:14 AM

i am planning to create a discussion forum can you suggest me which will be the easiest way to do it by means of which technologies

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download