SUNIL16 Posted July 16, 2008 Share Posted July 16, 2008 Hi all i am creating forum. I created forum_question and forum_answer table in database. i can store posted new topic values in database and retrieve from database in veiwtopic.php page but in that page i given one form to get reply. that should go and store in database and has to be retrieved but i am not getting this part, below is my code for view_topic.php(working correctly) and add_answer.php(Showing error) <?php require("connect.php"); mysql_select_db("mysite",$con)or die("cannot select DB"); $tbl_name="forum_question"; // Table name $id=$_GET['id']; echo $id; $sql="SELECT * FROM $tbl_name WHERE id='$id'"; $result=mysql_query($sql); $rows=mysql_fetch_array($result); ?> <table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC"> <tr> <td><table width="100%" border="0" cellpadding="3" cellspacing="1" bordercolor="1" bgcolor="#FFFFFF"> <tr> <td bgcolor="#F8F7F1"><strong><?php echo $rows['topic']; ?></strong></td> </tr> <tr> <td bgcolor="#F8F7F1"><?php echo $rows['detail']; ?></td> </tr> <tr> <td bgcolor="#F8F7F1"><strong>By :</strong> <?php echo $rows['name']; ?></td> </tr> <tr> <td bgcolor="#F8F7F1"><strong>Date/time : </strong><?php echo $rows['datetime']; ?></td> </tr> </table></td> </tr> </table> <BR> <?php $tbl_name2="forum_answer"; // Switch to table "forum_answer" $sql2="SELECT * FROM $tbl_name2 WHERE question_id='$id'"; $result2=mysql_query($sql2); while($rows=mysql_fetch_array($result2)){ ?> <table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC"> <tr> <td><table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF"> <tr> <td bgcolor="#F8F7F1"><strong>ID</strong></td> <td bgcolor="#F8F7F1">:</td> <td bgcolor="#F8F7F1"><?php echo $rows['a_id']; ?></td> </tr> <tr> <td width="18%" bgcolor="#F8F7F1"><strong>Name</strong></td> <td width="5%" bgcolor="#F8F7F1">:</td> <td width="77%" bgcolor="#F8F7F1"><?php echo $rows['a_name']; ?></td> </tr> <tr> <td bgcolor="#F8F7F1"><strong>Answer</strong></td> <td bgcolor="#F8F7F1">:</td> <td bgcolor="#F8F7F1"><?php echo $rows['a_answer']; ?></td> </tr> <tr> <td bgcolor="#F8F7F1"><strong>Date/Time</strong></td> <td bgcolor="#F8F7F1">:</td> <td bgcolor="#F8F7F1"><?php echo $rows['a_datetime']; ?></td> </tr> </table></td> </tr> </table><br> <?php } $sql3="SELECT view FROM $tbl_name WHERE id='$id'"; $result3=mysql_query($sql3); $rows=mysql_fetch_array($result3); $view=$rows['view']; // if have no counter value set counter = 1 if(empty($view)){ $view=1; $sql4="INSERT INTO $tbl_name(view) VALUES('$view') WHERE id='$id'"; $result4=mysql_query($sql4); } // count more value $addview=$view+1; $sql5="update $tbl_name set view='$addview' WHERE id='$id'"; $result5=mysql_query($sql5); mysql_close($con); ?> <BR> <table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC"> <tr> <form name="form1" method="post" action="add_answer.php"> <td> <table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF"> <tr> <td width="18%"><strong>Name</strong></td> <td width="3%">:</td> <td width="79%"><input name="a_name" type="text" id="a_name" size="45"></td> </tr> <tr> <td valign="top"><strong>Answer</strong></td> <td valign="top">:</td> <td><textarea name="a_answer" cols="45" rows="3" id="a_answer"></textarea></td> </tr> <tr> <td> </td> <td><input name="id" type="hidden" value="<?php echo $id; ?>"></td> <td><input type="submit" name="Submit" value="Submit"> <input type="reset" name="Submit2" value="Reset"></td> </tr> </table> </td> </form> </tr> </table> and this is my add_answer.php here in this code i am not able to get the id passed form hidden field. <?php require("connect.php"); mysql_select_db("mysite",$con)or die("cannot select DB"); $tbl_name="forum_answer"; // Table name // Get value of id that sent from hidden field $id=$_posT['id']; echo$id; // Find highest answer number. $sql="SELECT MAX(a_id) AS Maxa_id FROM $tbl_name WHERE question_id='$id'"; $result=mysql_query($sql); $rows=mysql_fetch_array($result); // add + 1 to highest answer number and keep it in variable name "$Max_id". if there no answer yet set it = 1 if ($rows) { $Max_id = $rows['Maxa_id']+1; } else { $Max_id = 1; } // get values that sent from form $a_name=$_POST['a_name']; $a_answer=$_POST['a_answer']; $datetime=date("d/m/y H:i:s"); // create date and time // Insert answer $sql2="INSERT INTO forum_answer(question_id, a_id, a_name,a_answer, a_datetime)VALUES('$id', '$Max_id', '$a_name', '$a_answer', '$datetime')"; if(mysql_query($sql2,$con)){ echo "Successful<BR>"; echo "<a href='view_topic.php?id=".$id."'>View your answer</a>"; // If added new answer, add value +1 in reply column $tbl_name2="forum_question"; $sql3="UPDATE $tbl_name2 SET reply='$Max_id' WHERE id='$id'"; $result3=mysql_query($sql3); } else { echo "ERROR"; } mysql_close($con); ?> this code is giving error. Link to comment https://forums.phpfreaks.com/topic/115027-needed-solution/ Share on other sites More sharing options...
Xurion Posted July 16, 2008 Share Posted July 16, 2008 Are you sure the value is being set in the hidden field? Is this online anywhere? Link to comment https://forums.phpfreaks.com/topic/115027-needed-solution/#findComment-591518 Share on other sites More sharing options...
SUNIL16 Posted July 16, 2008 Author Share Posted July 16, 2008 just check it out in view_topic.php code i am sending using input field<input name="id" type="hidden" value="<?php echo $id; ?>"> like this Link to comment https://forums.phpfreaks.com/topic/115027-needed-solution/#findComment-591553 Share on other sites More sharing options...
Xurion Posted July 16, 2008 Share Posted July 16, 2008 I can't tell from this server side code what the output is. Can you post it? Link to comment https://forums.phpfreaks.com/topic/115027-needed-solution/#findComment-591565 Share on other sites More sharing options...
SUNIL16 Posted July 16, 2008 Author Share Posted July 16, 2008 http://localhost/final/view_topic.php?id=1 This is address bar tell me how to get this id value 1 to next page Link to comment https://forums.phpfreaks.com/topic/115027-needed-solution/#findComment-591591 Share on other sites More sharing options...
Xurion Posted July 16, 2008 Share Posted July 16, 2008 lol... localhost is only available to you Link to comment https://forums.phpfreaks.com/topic/115027-needed-solution/#findComment-591618 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.