Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- Array
- (
- [submission_id] => 4054583910592578526
- [formID] => 81683061136454
- [ip] => 125.63.69.50
- [name] => Array
- (
- [0] => shagun
- [1] =>
- [2] => vaish
- )
- [email] => vaish.shagun@gmail.com
- [mobile258] => +915848254;
- [agegroup] => 18-25 yr.
- [gender] => Female
- [occupation] => Business;
- [selectcountrystate] => Country: Algeria (DZ)
- State: Burj Bu Arririj
- City: No city on this state.
- [address] =>
- )
- function ExtendedAddslash(&$params)
- {
- foreach ($params as &$var) {
- // check if $var is an array. If yes, it will start another ExtendedAddslash() function to loop to each key inside.
- is_array($var) ? ExtendedAddslash($var) : $var=addslashes($var);
- unset($var);
- }
- }
- ExtendedAddslash($_POST);
- $submission_id = $_POST['submission_id'];
- $formID = $_POST['formID'];
- $ip = $_POST['ip'];
- $name = $_POST['name']['0'];$_POST['name']['1'];$_POST['name']['2'];
- $email = $_POST['email'];
- $mobile258 = $_POST['mobile258'];
- $agegroup = $_POST['agegroup'];
- $gender = $_POST['gender'];
- $occupation = $_POST['occupation'];
- $selectcountrystate = $_POST['selectcountrystate'];
- $address = $_POST['address'];
- $db_host = 'localhost';
- $db_username = 'root';
- $db_password = '';
- $db_name = 'yellowponies';
- mysqli_connect( $db_host, $db_username, $db_password) or die(mysqli_error());
- mysqli_select_db($db_name);
- $query = "SELECT * FROM `donor_registration` WHERE `submission_id` = '$submission_id'";
- $sqlsearch = mysqli_query($query);
- $resultcount = mysqli_numrows($sqlsearch);
- if ($resultcount > 0) {
- mysqli_query("UPDATE `donor_registration` SET
- `name` = '$name',
- `email` = '$email',
- `mobile258` = '$mobile258',
- `agegroup` = '$agegroup',
- `gender` = '$gender'
- `occupation` = '$occupation',
- `selectcountrystate` = '$selectcountrystate',
- `address` = '$address'
- WHERE `submission_id` = '$submission_id'")
- or die(mysqli_error());
- } else {
- mysqli_query("INSERT INTO `donor_registration` (submission_id, formID, IP,
- name, email, mobile258, agegroup, gender,occupation,selectcountrystate,address)
- VALUES ('$submission_id', '$formID', '$ip',
- '$name', '$email', '$mobile258', '$agegroup', '$gender','$occupation','$selectcountrystate','$address) ")
- or die(mysqli_error());
- }
- ?>
Add Comment
Please, Sign In to add comment