01.<?
02.$objConnect = mysql_connect("localhost","root","armarm014") or die("Error Connect to Database");
03.$objDB = mysql_select_db("webboard");
04.
05.if($_GET["Action"] == "Save")
06.{
07.
08. $strSQL = "INSERT INTO reply ";
09. $strSQL .="(QuestionID,CreateDate,Details,Name) ";
10. $strSQL .="VALUES ";
11. $strSQL .="('".$_GET["QuestionID"]."','".date("Y-m-d H:i:s")."','".$_POST["txtDetails"]."','".$_POST["txtName"]."') ";
12. $objQuery = mysql_query($strSQL);
13.
14.
15. $strSQL = "UPDATE webboard ";
16. $strSQL .="SET Reply = Reply + 1 WHERE QuestionID = '".$_GET["QuestionID"]."' ";
17. $objQuery = mysql_query($strSQL);
18.}
19.?>
20.<html>
21.<head>
22.<title>Webb</title>
23.</head>
24.<body>
25.<?
26.
27.$strSQL = "SELECT * FROM webboard WHERE QuestionID = '".$_GET["QuestionID"]."' ";
28.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
29.$objResult = mysql_fetch_array($objQuery);
30.
31.
32.$strSQL = "UPDATE webboard ";
33.$strSQL .="SET View = View + 1 WHERE QuestionID = '".$_GET["QuestionID"]."' ";
34.$objQuery = mysql_query($strSQL);
35.?>
36.<table width="738" border="1" cellpadding="1" cellspacing="1">
37. <tr>
38. <td colspan="2"><center><h1><?=$objResult["Question"];?></h1></center></td>
39. </tr>
40. <tr>
41. <td height="53" colspan="2"><?=nl2br($objResult["Details"]);?></td>
42. </tr>
43. <tr>
44. <td width="397">Name : <?=$objResult["Name"];?> Create Date : <?=$objResult["CreateDate"];?></td>
45. <td width="253">View : <?=$objResult["View"];?> Reply : <?=$objResult["Reply"];?></td>
46. </tr>
47.</table>
48.<br>
49.<br>
50.<?
51.$intRows = 0;
52.$strSQL2 = "SELECT * FROM reply WHERE QuestionID = '".$_GET["QuestionID"]."' ";
53.$objQuery2 = mysql_query($strSQL2) or die ("Error Query [".$strSQL."]");
54.while($objResult2 = mysql_fetch_array($objQuery2))
55.{
56. $intRows++;
57.?> No : <?=$intRows;?>
58.<table width="738" border="1" cellpadding="1" cellspacing="1">
59. <tr>
60. <td height="53" colspan="2"><?=nl2br($objResult2["Details"]);?></td>
61. </tr>
62. <tr>
63. <td width="397">Name :
64. <?=$objResult2["Name"];?> </td>
65. <td width="253">Create Date :
66. <?=$objResult2["CreateDate"];?></td>
67. </tr>
68.</table><br>
69.<?
70.}
71.?>
72.<br>
73.<a href="Webboard.php">Back to Webboard</a> <br>
74.<br>
75.<form action="ViewWebboard.php?QuestionID=<?=$_GET["QuestionID"];?>&Action=Save" method="post" name="frmMain" id="frmMain">
76. <table width="738" border="1" cellpadding="1" cellspacing="1">
77. <tr>
78. <td width="78">Details</td>
79. <td><textarea name="txtDetails" cols="50" rows="5" id="txtDetails"></textarea></td>
80. </tr>
81. <tr>
82. <td width="78">Name</td>
83. <td width="647"><input name="txtName" type="text" id="txtName" value="" size="50"></td>
84. </tr>
85. </table>
86.
87. <input name="btnSave" type="submit" id="btnSave" value="Submit">
88.</form>
89.</body>
90.</html>
91.<?
92.mysql_close($objConnect);
93.?>
Quote:
