Advertisement
Guest User

Untitled

a guest
Jul 30th, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.02 KB | None | 0 0
  1. <?php
  2. $host="localhost"; // Host name
  3. $username=""; // Mysql username
  4. $password=""; // Mysql password
  5. $db_name="test"; // Database name
  6. $tbl_name="forum_question"; // Table name
  7.  
  8. // Connect to server and select database.
  9. mysql_connect($host, $username, $password)or die("cannot connect");
  10. mysql_select_db($db_name)or die("cannot select DB");
  11.  
  12. // get data that sent from form
  13. $topic = htmlspecialchars(mysql_real_escape_string($_POST['topic']));
  14. $detail = htmlspecialchars(mysql_real_escape_string($_POST['detail']));
  15. $name = htmlspecialchars(mysql_real_escape_string($_POST['name']));
  16. $email = htmlspecialchars(mysql_real_escape_string($_POST['email']));
  17. $datetime = date("d/m/y h:i:s"); //create date time
  18. $sql = "INSERT INTO $tbl_name(topic, detail, name, email, datetime)VALUES('$topic', '$detail', '$name', '$email', '$datetime')";
  19. $result = mysql_query($sql);
  20. if($result)
  21. {
  22. print <<<HTML
  23. Successful<BR>
  24. <a href=main_forum.php>View your topic</a>
  25. HTML;
  26. }
  27. elseif(!$result)
  28. {
  29. print "Error ";
  30. }
  31. mysql_close();
  32. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement