Guest User

error in code

a guest
Jun 22nd, 2018
38
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.98 KB | None | 0 0
  1. <?php
  2. Array
  3. (
  4. [submission_id] => 4054583910592578526
  5. [formID] => 81683061136454
  6. [ip] => 125.63.69.50
  7. [name] => Array
  8. (
  9. [0] => shagun
  10. [1] =>
  11. [2] => vaish
  12. )
  13.  
  14. [email] => vaish.shagun@gmail.com
  15. [mobile258] => +915848254;
  16. [agegroup] => 18-25 yr.
  17. [gender] => Female
  18. [occupation] => Business;
  19. [selectcountrystate] => Country: Algeria (DZ)
  20. State: Burj Bu Arririj
  21. City: No city on this state.
  22. [address] =>
  23. )
  24. function ExtendedAddslash(&$params)
  25. {
  26. foreach ($params as &$var) {
  27. // check if $var is an array. If yes, it will start another ExtendedAddslash() function to loop to each key inside.
  28. is_array($var) ? ExtendedAddslash($var) : $var=addslashes($var);
  29. unset($var);
  30. }
  31. }
  32. ExtendedAddslash($_POST);
  33.  
  34.  
  35. $submission_id = $_POST['submission_id'];
  36. $formID = $_POST['formID'];
  37. $ip = $_POST['ip'];
  38. $name = $_POST['name']['0'];$_POST['name']['1'];$_POST['name']['2'];
  39. $email = $_POST['email'];
  40. $mobile258 = $_POST['mobile258'];
  41. $agegroup = $_POST['agegroup'];
  42. $gender = $_POST['gender'];
  43. $occupation = $_POST['occupation'];
  44. $selectcountrystate = $_POST['selectcountrystate'];
  45. $address = $_POST['address'];
  46.  
  47. $db_host = 'localhost';
  48. $db_username = 'root';
  49. $db_password = '';
  50. $db_name = 'yellowponies';
  51. mysqli_connect( $db_host, $db_username, $db_password) or die(mysqli_error());
  52. mysqli_select_db($db_name);
  53.  
  54.  
  55.  
  56. $query = "SELECT * FROM `donor_registration` WHERE `submission_id` = '$submission_id'";
  57. $sqlsearch = mysqli_query($query);
  58. $resultcount = mysqli_numrows($sqlsearch);
  59.  
  60. if ($resultcount > 0) {
  61.  
  62. mysqli_query("UPDATE `donor_registration` SET
  63. `name` = '$name',
  64. `email` = '$email',
  65. `mobile258` = '$mobile258',
  66. `agegroup` = '$agegroup',
  67. `gender` = '$gender'
  68. `occupation` = '$occupation',
  69. `selectcountrystate` = '$selectcountrystate',
  70. `address` = '$address'
  71. WHERE `submission_id` = '$submission_id'")
  72. or die(mysqli_error());
  73.  
  74. } else {
  75.  
  76. mysqli_query("INSERT INTO `donor_registration` (submission_id, formID, IP,
  77. name, email, mobile258, agegroup, gender,occupation,selectcountrystate,address)
  78. VALUES ('$submission_id', '$formID', '$ip',
  79. '$name', '$email', '$mobile258', '$agegroup', '$gender','$occupation','$selectcountrystate','$address) ")
  80. or die(mysqli_error());
  81.  
  82. }
  83. ?>
Add Comment
Please, Sign In to add comment