Advertisement
Guest User

Untitled

a guest
Oct 31st, 2016
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.13 KB | None | 0 0
  1. <html>
  2. <head>
  3. </head>
  4. <body>
  5. <table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
  6. <tr>
  7. <form id="form" name="form" method="POST" action="add_new_topic.php">
  8. <td>
  9. <table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
  10. <tr>
  11. <td colspan="3" bgcolor="#E6E6E6"><strong>Create New Topic</strong> </td>
  12. </tr>
  13. <tr>
  14. <td width="14%"><strong>Topic</strong></td>
  15. <td width="2%">:</td>
  16. <td width="84%"><input name="topic" type="text" id="topic" size="50" /></td>
  17. </tr>
  18. <tr>
  19. <td valign="top"><strong>Detail</strong></td>
  20. <td valign="top">:</td>
  21. <td><textarea name="detail" cols="50" rows="3" id="detail"></textarea></td>
  22. </tr>
  23. <tr>
  24. <td><strong>Name</strong></td>
  25. <td>:</td>
  26. <td><input name="name" type="text" id="name" size="50" /></td>
  27. </tr>
  28. <tr>
  29. <td><strong>Email</strong></td>
  30. <td>:</td>
  31. <td><input name="email" type="text" id="email" size="50" /></td>
  32. </tr>
  33. <tr>
  34. <td>&nbsp;</td>
  35. <td>&nbsp;</td>
  36. <td><input type="submit" name="Submit" value="Submit" />
  37. <input type="reset" name="Submit2" value="Reset" /></td>
  38. </tr>
  39. </table>
  40. </td>
  41. </form>
  42. </tr>
  43. </table>
  44. </body>
  45. </html>
  46.  
  47. <?php
  48.  
  49. $host="localhost"; // Host name
  50. $username="root"; // Mysql username
  51. $password=""; // Mysql password
  52. $db_name="myforum"; // Database name
  53. $tbl_name="fquestions"; // Table name
  54.  
  55. // Connect to server and select database.
  56. $con = mysqli_connect("$host", "$username", "$password" , "$db_name");
  57. if (mysqli_connect_errno())
  58. {
  59. echo "Failed to connect to MySQL: " . mysqli_connect_error();
  60. }
  61. mysqli_select_db($con,"$db_name")or die("cannot select DB");
  62.  
  63. // get data that sent from form
  64. $topic=$_POST['topic'];
  65. $detail=$_POST['detail'];
  66. $name=$_POST['name'];
  67. $email=$_POST['email'];
  68.  
  69. $datetime=date("d/m/y h:i:s"); //create date time
  70.  
  71. $sql="INSERT INTO '$tbl_name'('topic',' detail', 'name', 'email', 'datetime')VALUES('topic', 'detail', 'name', 'email', 'datetime')";
  72. $result=mysqli_query($con,$sql);
  73.  
  74. if($result){
  75. echo "Successful<BR>";
  76. echo "<a href=main_forum.php>View your topic</a>";
  77. }
  78. else {
  79. echo "ERROR";
  80. }
  81. mysqli_close($con);
  82. ?>
  83.  
  84. $topic=$_POST['topic'];
  85. $detail=$_POST['detail'];
  86. $name=$_POST['name'];
  87. $email=$_POST['email'];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement