Guest User

Untitled

a guest
Aug 19th, 2018
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.33 KB | None | 0 0
  1. <form id="contact-form" method="post" action="ticketSupport.php" role="form">
  2. <div class="messages"></div>
  3. <div class="controls">
  4. <div class="row">
  5. <div class="col-md-6">
  6. <div class="form-group">
  7. <label for="form_item_select" class="mbr-white text-center">Select item <span class="text-red">*</span></label>
  8. <select id="form_item_select" name="item_select" class="custom-select" required="required" data-error="Please specify your need.">
  9. <option>Select item</option>
  10. <option value="theme1">Example template (1)</option>
  11. <option value="theme2">Example 2 template (5)</option>
  12. <option value="theme3">Example 3 template (15)</option>
  13. </select>
  14. <div class="help-block with-errors"></div>
  15. </div>
  16. </div>
  17. <div class="col-md-6">
  18. <div class="form-group">
  19. <label for="form_help_select" class="mbr-white text-center">Help topic <span class="text-red">*</span></label>
  20. <select id="form_help_select" name="help_selected" class="custom-select" required="required" data-error="Please specify your need.">
  21. <option>Select help topic</option>
  22. <option value="Feedback">Feedback</option>
  23. <option value="General inquiry">General inquiry</option>
  24. <option value="Report a problem">Report a problem</option>
  25. <option value="Report a problem / Access Issue">Report a problem / Access Issue</option>
  26. </select>
  27. <div class="help-block with-errors"></div>
  28. </div>
  29. </div>
  30. </div>
  31. <div class="row">
  32. <div class="col-md-6">
  33. <div class="form-group">
  34. <label for="form_email" class="mbr-white text-center">Email <span class="text-red">*</span></label>
  35. <input id="form_email" type="email" name="email" class="form-control" readonly placeholder="Please enter your email *" required="required" data-error="Valid email is required." value="<?php echo $userData['email']; ?>">
  36. <div class="help-block with-errors"></div>
  37. </div>
  38. </div>
  39. <div class="col-md-6">
  40. <div class="form-group">
  41. <label for="form_phone" class="mbr-white text-center">Phone number</label>
  42. <input id="form_phone" type="text" name="phone" class="form-control" readonly placeholder="Please enter your phone number *" required="required" data-error="Valid phone is required." value="<?php echo $userData['phone']; ?>">
  43. <div class="help-block with-errors"></div>
  44. </div>
  45. </div>
  46. </div>
  47. <div class="row">
  48. <div class="col-md-12">
  49. <div class="form-group">
  50. <label for="form_message" class="mbr-white text-center">Ticet details <span class="text-red">*</span></label>
  51. <p class="mbr-white small">Please describe your issue</p>
  52. <textarea id="form_message" name="message" class="form-control" placeholder="Details on the reason(s) for opening the ticket. *" rows="4" required="required" data-error="Please, leave us a message."></textarea>
  53. <div class="help-block with-errors"></div>
  54. </div>
  55. </div>
  56. <div class="col-md-12">
  57. <input type="submit" class="btn btn-primary btn-block sgn" value="Create ticket">
  58. </div>
  59. </div>
  60. </div>
  61. </form>
  62.  
  63. <?php
  64. $servername = "localhost";
  65. $username = "root";
  66. $password = "";
  67. $dbname = "db_name";
  68.  
  69. try {
  70. $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username,
  71. $password);
  72. // set the PDO error mode to exception
  73. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  74.  
  75. // prepare sql and bind parameters
  76. $stmt = $conn->prepare("INSERT INTO tickets (item_selected, help_selected,
  77. email, phone, message)
  78. VALUES (:item_selected, :help_selected, :email, :phone, :message)");
  79. $stmt->bindParam(':item_selected', $item_selected);
  80. $stmt->bindParam(':help_selected', $help_selected);
  81. $stmt->bindParam(':email', $email);
  82. $stmt->bindParam(':phone', $phone);
  83. $stmt->bindParam(':message', $message);
  84.  
  85. // insert a row
  86. $item_selected = $_POST["item_selected"];
  87. $help_selected = $_POST["help_selected"];
  88. $email = $_POST["email"];
  89. $phone = $_POST["phone"];
  90. $message = $_POST["message"];
  91. $stmt->execute();
  92.  
  93.  
  94. header('Location: ticket-status');
  95. }
  96. catch(PDOException $e)
  97. {
  98. echo "Error: " . $e->getMessage();
  99. }
  100. $conn = null;
  101. ?>
  102.  
  103. $item_selected = $_POST["item_selected"];
  104. $help_selected = $_POST["help_selected"];
  105. $email = $_POST["email"];
  106. $phone = $_POST["phone"]; $message = $_POST["message"];
  107.  
  108.  
  109.  
  110. $stmt = $conn->prepare("INSERT INTO tickets (item_selected, help_selected, email, phone, message) VALUES (:item_selected, :help_selected, :email, :phone, :message)");
  111. $stmt->bindParam(':item_selected', $item_selected);
  112. $stmt->bindParam(':help_selected', $help_selected);
  113. $stmt->bindParam(':email', $email); $stmt->bindParam(':phone', $phone); $stmt->bindParam(':message', $message);
  114.  
  115. <select id="form_item_select" name="item_select" class
Add Comment
Please, Sign In to add comment