Guest User

Untitled

a guest
Oct 15th, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.46 KB | None | 0 0
  1. <form action="/data/insert.php" method="POST" id="guest-form" name="reg">
  2. <input id="username" type="text" name="name" placeholder="Username">
  3. <input id="email" type="text" name="email" placeholder="E-mail">
  4. <textarea id="message" type="text" name="text" placeholder="Your message"></textarea>
  5. <img src="data/captcha.php" alt="Картинка" /><br />
  6. <input id ="captcha" type="text" name="captcha" placeholder="Verify code" /><br />
  7.  
  8. <input id="submit" class="btn btn-default" type="button" value="Submit">
  9.  
  10. </form>
  11.  
  12. $(document).ready(function() {
  13. $('#submit').click(function() {
  14. var username = $('#username').val();
  15. var email = $('#email').val();
  16. var message = $('#message').val();
  17. var captcha = $('#captcha').val();
  18. if(username === ''){
  19. alert('Please input data in all fields');
  20. }
  21. else {
  22. $.ajax({
  23. type: "POST",
  24. cache: false,
  25. url: '/data/insert.php',
  26. data: {username: username, email: email, message: message, captcha: captcha},
  27. success: function(data) {
  28. }
  29. });
  30. }
  31. });
  32. });
  33.  
  34. require_once 'db.php';
  35. session_start();
  36. if (isset($_SESSION["captcha"]) && $_SESSION["captcha"]===$_POST["captcha"]){
  37. dataInsert();
  38. }
  39. else {
  40. echo 'error captcha';
  41. }
  42. unset($_SESSION["captcha"]);
  43. function dataInsert(){
  44. if (isset($_POST['username']) && isset($_POST['email']) && isset($_POST['message'])){
  45.  
  46. $username = $_POST['username'];
  47. $email = $_POST['email'];
  48. $message = $_POST['message'];
  49.  
  50. $db_host = "localhost";
  51. $db_user = "alekspvn"; // Логин БД
  52. $db_password = "123"; // Пароль БД
  53. $db_table = "book"; // Имя Таблицы БД
  54.  
  55. $connect_db=mysql_connect(HOST, MYSQL_USER, MYSQL_PASS)
  56. or die("No connection with SQL");
  57.  
  58. mysql_select_db("guests_db",$connect_db);
  59.  
  60. mysql_query("SET NAMES 'utf8'",$connect_db);
  61.  
  62. $result = mysql_query ("INSERT INTO ".$db_table." (username,email,message) VALUES ('$username','$email','$message')");
  63.  
  64. if ($result = 'true'){
  65. echo "Информация занесена в базу данных";
  66. }else{
  67. echo "Информация не занесена в базу данных";
  68. }
  69. }
  70. }
  71. print_r ($_SESSION["captcha"]);
Add Comment
Please, Sign In to add comment