Advertisement
Guest User

Untitled

a guest
May 15th, 2017
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.29 KB | None | 0 0
  1.  
  2. $query = "SELECT * FROM `table_name` WHERE `submission_id` = '$submission_id'";
  3. $sqlsearch = mysql_query($query);
  4. $resultcount = mysql_numrows($sqlsearch);
  5.  
  6. if ($resultcount > 0) {
  7.  
  8. mysql_query("UPDATE `table_name` SET
  9. `name` = '$name',
  10. `email` = '$email',
  11. `phone` = '$phonenumber',
  12. `subject` = '$subject',
  13. `message` = '$message'
  14. WHERE `submission_id` = '$submission_id'")
  15. or die(mysql_error());
  16.  
  17. } else {
  18.  
  19. mysql_query("INSERT INTO `table_name` (submission_id, formID, IP,
  20. name, email, phone, subject, message)
  21. VALUES ('$submission_id', '$formID', '$ip',
  22. '$name', '$email', '$phonenumber', '$subject', '$message') ")
  23. or die(mysql_error());
  24.  
  25. }
  26. ?>
  27.  
  28. You're done. Name the script as your thank you php file and upload it to match the exact detail that you have set in your Custom Thank You URL
  29.  
  30. Here's the complete script:
  31.  
  32.  
  33. // This function will run within each post array including multi-dimensional arrays
  34. function ExtendedAddslash(&$params)
  35. {
  36. foreach ($params as &$var) {
  37. // check if $var is an array. If yes, it will start another ExtendedAddslash() function to loop to each key inside.
  38. is_array($var) ? ExtendedAddslash($var) : $var=addslashes($var);
  39. unset($var);
  40. }
  41. }
  42.  
  43. // Initialize ExtendedAddslash() function for every $_POST variable
  44. ExtendedAddslash($_POST);
  45.  
  46. $submission_id = $_POST['submission_id'];
  47. $formID = $_POST['formID'];
  48. $ip = $_POST['ip'];
  49. $name = $_POST['name'];
  50. $email = $_POST['email'];
  51. $phonenumber = $_POST['phonenumber13'][0] ."-". $_POST['phonenumber13'][1];
  52. $subject = $_POST['subject7'];
  53. $message = $_POST['message6'];
  54.  
  55. $db_host = 'db hostname here';
  56. $db_username = 'db username here';
  57. $db_password = 'db password here';
  58. $db_name = 'name of your database';
  59.  
  60. mysql_connect( $db_host, $db_username, $db_password) or die(mysql_error());
  61. mysql_select_db($db_name);
  62.  
  63. // search submission ID
  64.  
  65. $query = "SELECT * FROM `table_name` WHERE `submission_id` = '$submission_id'";
  66. $sqlsearch = mysql_query($query);
  67. $resultcount = mysql_numrows($sqlsearch);
  68.  
  69. if ($resultcount > 0) {
  70.  
  71. mysql_query("UPDATE `table_name` SET
  72. `name` = '$name',
  73. `email` = '$email',
  74. `phone` = '$phonenumber',
  75. `subject` = '$subject',
  76. `message` = '$message'
  77. WHERE `submission_id` = '$submission_id'")
  78. or die(mysql_error());
  79.  
  80. } else {
  81.  
  82. mysql_query("INSERT INTO `table_name` (submission_id, formID, IP,
  83. name, email, phone, subject, message)
  84. VALUES ('$submission_id', '$formID', '$ip',
  85. '$name', '$email', '$phonenumber', '$subject', '$message') ")
  86. or die(mysql_error());
  87.  
  88. }
  89. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement