Ellie's Custom Thank You Page

<?php
// This function will run within each post array including multi-dimensional arrays
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);
        }
}

     // Initialize ExtendedAddslash() function for every $_POST variable
    ExtendedAddslash($_POST);

?>
<?php
$submission_id=$_POST['submission_id'];
$formID=$_POST['formID'];
$ip=$_POST['ip'];
$nameof=$_POST['nameof'];
$unidf=$_POST['unidf'];
$unioi=$_POST['unioi'];
$uploadyour=$_POST['uploadyour'];
$backimg=$_POST['backimg'];
$mysterydiner=$_POST['mysterydiner'];
$dineremail=$_POST['dineremail'];
$dinerpaypal=$_POST['dinerpaypal'];
$ihave=$_POST['ihave'];
$stepcomplete288=$_POST['stepcomplete288'];
$clickto284=$_POST['clickto284'];
$dateof232=$_POST['dateof232'];
$of215=$_POST['of215'];
$clickto88=$_POST['clickto88'];
$wouldyou89=$_POST['wouldyou89'];
$wasthe90=$_POST['wasthe90'];
$werewindows=$_POST['werewindows'];
$wasthe=$_POST['wasthe'];
$wereexternal200=$_POST['wereexternal200'];
$wasthe94=$_POST['wasthe94'];
$werethe=$_POST['werethe'];
$isthere201=$_POST['isthere201'];
$weremenu202=$_POST['weremenu202'];
$isoutdoor=$_POST['isoutdoor'];
$wereexternal=$_POST['wereexternal'];
$wereoutside=$_POST['wereoutside'];
$wasyour206=$_POST['wasyour206'];
$wasthe207=$_POST['wasthe207'];
$wouldyou96=$_POST['wouldyou96'];
$plsenter23 = str_replace(",", "\n", $_POST['plsenter23']);
$usingthe35=$_POST['usingthe35'];
$isthere=$_POST['isthere'];
$didthe98=$_POST['didthe98'];
$didthe99=$_POST['didthe99'];
$didyou208=$_POST['didyou208'];
$wasyour100=$_POST['wasyour100'];
$wereyou101=$_POST['wereyou101'];
$wereyou165=$_POST['wereyou165'];
$whilewaiting=$_POST['whilewaiting'];
$isthe=$_POST['isthe'];
$isthe168=$_POST['isthe168'];
$doyou169=$_POST['doyou169'];
$canyou=$_POST['canyou'];
$wereyou170=$_POST['wereyou170'];
$onceseated=$_POST['onceseated'];
$wereyou=$_POST['wereyou'];
$didyour173=$_POST['didyour173'];
$didyour174=$_POST['didyour174'];
$pleaseorder=$_POST['pleaseorder'];
$didsomeone176=$_POST['didsomeone176'];
$werethe177=$_POST['werethe177'];
$wereyou178=$_POST['wereyou178'];
$didyour=$_POST['didyour'];
$didyour180=$_POST['didyour180'];
$pleaseenter67=$_POST['pleaseenter67']['0'] .":". $_POST['pleaseenter67']['1'] ." ". $_POST['pleaseenter67']['2'];
$pleaseenter=$_POST['pleaseenter']['0'] .":". $_POST['pleaseenter']['1'] ." ". $_POST['pleaseenter']['2'];
$doyou293=$_POST['doyou293'];
$doyou295=$_POST['doyou295'];
$doyou297=$_POST['doyou297'];
$wasthe181=$_POST['wasthe181'];
$plsexplain=$_POST['plsexplain'];
$werethe183=$_POST['werethe183'];
$didyour182=$_POST['didyour182'];
$didyou=$_POST['didyou'];
$didyour185=$_POST['didyour185'];
$whenordering123=$_POST['whenordering123'];
$didyour186=$_POST['didyour186'];
$didyou125=$_POST['didyou125'];
$hasyour=$_POST['hasyour'];
$pleaseenter83=$_POST['pleaseenter83']['0'] .":". $_POST['pleaseenter83']['1'] ." ". $_POST['pleaseenter83']['2'];
$whatis=$_POST['whatis'];
$pleaseenter84=$_POST['pleaseenter84']['0'] .":". $_POST['pleaseenter84']['1'] ." ". $_POST['pleaseenter84']['2'];
$howwould151=$_POST['howwould151'];
$wasyour=$_POST['wasyour'];
$whatwas217 = str_replace(",", "\n", $_POST['whatwas217']);
$doyou300=$_POST['doyou300'];
$doyou303=$_POST['doyou303'];
$doyou305=$_POST['doyou305'];
$didthe=$_POST['didthe'];
$didthe190=$_POST['didthe190'];
$wasthe191=$_POST['wasthe191'];
$didyour192=$_POST['didyour192'];
$uponfinishing307=$_POST['uponfinishing307'];
$hostesson223=$_POST['hostesson223'];
$didyour194=$_POST['didyour194'];
$onceyou195=$_POST['onceyou195'];
$atthe=$_POST['atthe'];
$didthe199=$_POST['didthe199'];
$manageron=$_POST['manageron'];
$barguy=$_POST['barguy'];
$didyou213=$_POST['didyou213'];
$pleasemark=$_POST['pleasemark'];
$step2complete=$_POST['step2complete'];
$didyou255=$_POST['didyou255']['0'];
$basedon=$_POST['basedon'];
$diningexperiencepositive=$_POST['diningexperiencepositive'];
$explainbadexp=$_POST['explainbadexp'];
$wasenoughservers=$_POST['wasenoughservers'];
$writeorattachfinal=$_POST['writeorattachfinal'];
$writefinal=$_POST['writefinal'];
$anynotes=$_POST['anynotes'];
$addfinalnotes=$_POST['addfinalnotes'];
$step3complete=$_POST['step3complete'];
$uploadsignaturediner=$_POST['uploadsignaturediner'];
$propext1=$_POST['propext1'];
$propext2=$_POST['propext2'];
$propext3=$_POST['propext3'];
$app1=$_POST['app1'];
$app2=$_POST['app2'];
$app3=$_POST['app3'];
$meal1=$_POST['meal1'];
$meal2=$_POST['meal2'];
$meal3=$_POST['meal3'];
$meal4=$_POST['meal4'];
$finalupsummary=$_POST['finalupsummary'];
$check1=$_POST['check1'];
$creditcard=$_POST['creditcard'];
//*THESE FIELDS BELOW ARE MY UPLOAD FIELDS - IF NO IMAGE IS UPLOADED THEN I WANT A DEFAULT IMAGE OF
// http://mywordpressurlhere.net/wp-content/uploads/2014/08/defaultnonimage.png to be there instead *//
   $uploadpictures6=$_POST['uploadpictures6'];
   $uploadaddl=$_POST['uploadaddl'];
   $uploada91=$_POST['uploada91'];
   $ifyou=$_POST['ifyou'];
   $photoapp1=$_POST['photoapp1'];
   $photoapp2=$_POST['photoapp2'];
   $photoapp296=$_POST['photoapp296'];
   $photomeal1=$_POST['photomeal1'];
   $photomeal2=$_POST['photomeal2'];
   $photomeal3=$_POST['photomeal3'];
   $photomeal4=$_POST['photomeal4'];
   $uploadfinal=$_POST['uploadfinal'];
   $picofcheck=$_POST['picofcheck'];
   $picofccreceipt=$_POST['picofccreceipt'];

?>

<?php
$db_host = 'localhost';
$db_username = 'ellie123_wrdp23';
$db_password = 'xxxxxxxxxxxxx';
$db_name = 'ellie123_wrdp23';
mysql_connect( $db_host, $db_username, $db_password) or die(mysql_error());
mysql_select_db($db_name);
?>
<?php

// search submission ID

$query = "SELECT * FROM dinerform WHERE submission_id = '$submission_id'";
$sqlsearch = mysql_query($query);
$resultcount = mysql_numrows($sqlsearch);

if ($resultcount > 0) {
    $updateStr = "UPDATE dinerform SET ";
$updateStr = $updateStr."nameof='$nameof',";
$updateStr = $updateStr."unidf='$unidf',";
$updateStr = $updateStr."unioi='$unioi',";
$updateStr = $updateStr."uploadyour='$uploadyour',";
$updateStr = $updateStr."backimg='$backimg',";
$updateStr = $updateStr."mysterydiner='$mysterydiner',";
$updateStr = $updateStr."dineremail='$dineremail',";
$updateStr = $updateStr."dinerpaypal='$dinerpaypal',";
$updateStr = $updateStr."ihave='$ihave',";
$updateStr = $updateStr."stepcomplete288='$stepcomplete288',";
$updateStr = $updateStr."clickto284='$clickto284',";
$updateStr = $updateStr."dateof232='$dateof232',";
$updateStr = $updateStr."of215='$of215',";
$updateStr = $updateStr."clickto88='$clickto88',";
$updateStr = $updateStr."wouldyou89='$wouldyou89',";
$updateStr = $updateStr."wasthe90='$wasthe90',";
$updateStr = $updateStr."werewindows='$werewindows',";
$updateStr = $updateStr."wasthe='$wasthe',";
$updateStr = $updateStr."wereexternal200='$wereexternal200',";
$updateStr = $updateStr."wasthe94='$wasthe94',";
$updateStr = $updateStr."werethe='$werethe',";
$updateStr = $updateStr."isthere201='$isthere201',";
$updateStr = $updateStr."weremenu202='$weremenu202',";
$updateStr = $updateStr."isoutdoor='$isoutdoor',";
$updateStr = $updateStr."wereexternal='$wereexternal',";
$updateStr = $updateStr."wereoutside='$wereoutside',";
$updateStr = $updateStr."wasyour206='$wasyour206',";
$updateStr = $updateStr."wasthe207='$wasthe207',";
$updateStr = $updateStr."wouldyou96='$wouldyou96',";
$updateStr = $updateStr."plsenter23='$plsenter23',";
$updateStr = $updateStr."usingthe35='$usingthe35',";
$updateStr = $updateStr."isthere='$isthere',";
$updateStr = $updateStr."didthe98='$didthe98',";
$updateStr = $updateStr."didthe99='$didthe99',";
$updateStr = $updateStr."didyou208='$didyou208',";
$updateStr = $updateStr."wasyour100='$wasyour100',";
$updateStr = $updateStr."wereyou101='$wereyou101',";
$updateStr = $updateStr."wereyou165='$wereyou165',";
$updateStr = $updateStr."whilewaiting='$whilewaiting',";
$updateStr = $updateStr."isthe='$isthe',";
$updateStr = $updateStr."isthe168='$isthe168',";
$updateStr = $updateStr."doyou169='$doyou169',";
$updateStr = $updateStr."canyou='$canyou',";
$updateStr = $updateStr."wereyou170='$wereyou170',";
$updateStr = $updateStr."onceseated='$onceseated',";
$updateStr = $updateStr."wereyou='$wereyou',";
$updateStr = $updateStr."didyour173='$didyour173',";
$updateStr = $updateStr."didyour174='$didyour174',";
$updateStr = $updateStr."pleaseorder='$pleaseorder',";
$updateStr = $updateStr."didsomeone176='$didsomeone176',";
$updateStr = $updateStr."werethe177='$werethe177',";
$updateStr = $updateStr."wereyou178='$wereyou178',";
$updateStr = $updateStr."didyour='$didyour',";
$updateStr = $updateStr."didyour180='$didyour180',";
$updateStr = $updateStr."pleaseenter67='$pleaseenter67',";
$updateStr = $updateStr."pleaseenter='$pleaseenter',";
$updateStr = $updateStr."doyou293='$doyou293',";
$updateStr = $updateStr."doyou295='$doyou295',";
$updateStr = $updateStr."doyou297='$doyou297',";
$updateStr = $updateStr."wasthe181='$wasthe181',";
$updateStr = $updateStr."plsexplain='$plsexplain',";
$updateStr = $updateStr."werethe183='$werethe183',";
$updateStr = $updateStr."didyour182='$didyour182',";
$updateStr = $updateStr."didyou='$didyou',";
$updateStr = $updateStr."didyour185='$didyour185',";
$updateStr = $updateStr."whenordering123='$whenordering123',";
$updateStr = $updateStr."didyour186='$didyour186',";
$updateStr = $updateStr."didyou125='$didyou125',";
$updateStr = $updateStr."hasyour='$hasyour',";
$updateStr = $updateStr."pleaseenter83='$pleaseenter83',";
$updateStr = $updateStr."whatis='$whatis',";
$updateStr = $updateStr."pleaseenter84='$pleaseenter84',";
$updateStr = $updateStr."howwould151='$howwould151',";
$updateStr = $updateStr."wasyour='$wasyour',";
$updateStr = $updateStr."whatwas217='$whatwas217',";
$updateStr = $updateStr."doyou300='$doyou300',";
$updateStr = $updateStr."doyou303='$doyou303',";
$updateStr = $updateStr."doyou305='$doyou305',";
$updateStr = $updateStr."didthe='$didthe',";
$updateStr = $updateStr."didthe190='$didthe190',";
$updateStr = $updateStr."wasthe191='$wasthe191',";
$updateStr = $updateStr."didyour192='$didyour192',";
$updateStr = $updateStr."uponfinishing307='$uponfinishing307',";
$updateStr = $updateStr."hostesson223='$hostesson223',";
$updateStr = $updateStr."didyour194='$didyour194',";
$updateStr = $updateStr."onceyou195='$onceyou195',";
$updateStr = $updateStr."atthe='$atthe',";
$updateStr = $updateStr."didthe199='$didthe199',";
$updateStr = $updateStr."manageron='$manageron',";
$updateStr = $updateStr."barguy='$barguy',";
$updateStr = $updateStr."didyou213='$didyou213',";
$updateStr = $updateStr."pleasemark='$pleasemark',";
$updateStr = $updateStr."step2complete='$step2complete',";
$updateStr = $updateStr."didyou255='$didyou255',";
$updateStr = $updateStr."basedon='$basedon',";
$updateStr = $updateStr."diningexperiencepositive='$diningexperiencepositive',";
$updateStr = $updateStr."explainbadexp='$explainbadexp',";
$updateStr = $updateStr."wasenoughservers='$wasenoughservers',";
$updateStr = $updateStr."writeorattachfinal='$writeorattachfinal',";
$updateStr = $updateStr."writefinal='$writefinal',";
$updateStr = $updateStr."anynotes='$anynotes',";
$updateStr = $updateStr."addfinalnotes='$addfinalnotes',";
$updateStr = $updateStr."step3complete='$step3complete',";
$updateStr = $updateStr."uploadsignaturediner='$uploadsignaturediner',";
$updateStr = $updateStr."propext1='$propext1',";
$updateStr = $updateStr."propext2='$propext2',";
$updateStr = $updateStr."propext3='$propext3',";
$updateStr = $updateStr."app1='$app1',";
$updateStr = $updateStr."app2='$app2',";
$updateStr = $updateStr."app3='$app3',";
$updateStr = $updateStr."meal1='$meal1',";
$updateStr = $updateStr."meal2='$meal2',";
$updateStr = $updateStr."meal3='$meal3',";
$updateStr = $updateStr."meal4='$meal4',";
$updateStr = $updateStr."finalupsummary='$finalupsummary',";
$updateStr = $updateStr."check1='$check1',";
$updateStr = $updateStr."creditcard='$creditcard',";
$updateStr = $updateStr."uploadpictures6='$uploadpictures6',";
$updateStr = $updateStr."uploadaddl='$uploadaddl',";
$updateStr = $updateStr."uploada91='$uploada91',";
$updateStr = $updateStr."ifyou='$ifyou',";
$updateStr = $updateStr."photoapp1='$photoapp1',";
$updateStr = $updateStr."photoapp2='$photoapp2',";
$updateStr = $updateStr."photoapp296='$photoapp296',";
$updateStr = $updateStr."photomeal1='$photomeal1',";
$updateStr = $updateStr."photomeal2='$photomeal2',";
$updateStr = $updateStr."photomeal3='$photomeal3',";
$updateStr = $updateStr."photomeal4='$photomeal4',";
$updateStr = $updateStr."uploadfinal='$uploadfinal',";
$updateStr = $updateStr."picofcheck='$picofcheck',";
$updateStr = $updateStr."picofccreceipt='$picofccreceipt' ";
    $updateStr = $updateStr."WHERE submission_id = '$submission_id'";
    mysql_query($updateStr) or die(mysql_error());

} else {

    mysql_query("INSERT INTO dinerform (submission_id,formID,ip,nameof,unidf,unioi,uploadyour,backimg,mysterydiner,dineremail,dinerpaypal,ihave,stepcomplete288,clickto284,of215,dateof232,clickto88,wouldyou89,wasthe90,werewindows,wasthe,wereexternal200,wasthe94,werethe,isthere201,weremenu202,isoutdoor,wereexternal,wereoutside,wasyour206,wasthe207,wouldyou96,plsenter23,usingthe35,isthere,didthe98,didthe99,didyou208,wasyour100,wereyou101,wereyou165,whilewaiting,isthe,canyou,isthe168,doyou169,wereyou170,onceseated,wereyou,didyour173,didyour174,pleaseorder,didsomeone176,werethe177,wereyou178,didyour,didyour180,pleaseenter67,pleaseenter,doyou293,doyou295,doyou297,wasthe181,plsexplain,werethe183,didyour182,didyou,didyour185,whenordering123,didyour186,didyou125,hasyour,pleaseenter83,whatis,pleaseenter84,howwould151,wasyour,whatwas217,doyou300,doyou303,doyou305,didthe,didthe190,wasthe191,didyour192,uponfinishing307,didyour194,onceyou195,atthe,didthe199,didyou213,uploadpictures6,uploadaddl,uploada91,photoapp1,photoapp2,photoapp296,photomeal1,photomeal2,photomeal3,photomeal4,uploadsignaturediner,ifyou,manageron,hostesson223,barguy,pleasemark,step2complete,didyou255,basedon,diningexperiencepositive,explainbadexp,wasenoughservers,writeorattachfinal,writefinal,anynotes,addfinalnotes,step3complete,uploadfinal,picofcheck,picofccreceipt,propext1,propext2,propext3,app1,app2,app3,meal1,meal2,meal3,meal4,finalupsummary,check1,creditcard)
                               VALUES ('$submission_id','$formID','$ip','$nameof','$unidf','$unioi','$uploadyour','$backimg','$mysterydiner','$dineremail','$dinerpaypal','$ihave','$stepcomplete288','$clickto284','$of215','$dateof232','$clickto88','$wouldyou89','$wasthe90','$werewindows','$wasthe','$wereexternal200','$wasthe94','$werethe','$isthere201','$weremenu202','$isoutdoor','$wereexternal','$wereoutside','$wasyour206','$wasthe207','$wouldyou96','$plsenter23','$usingthe35','$isthere','$didthe98','$didthe99','$didyou208','$wasyour100','$wereyou101','$wereyou165','$whilewaiting','$isthe','$canyou','$isthe168','$doyou169','$wereyou170','$onceseated','$wereyou','$didyour173','$didyour174','$pleaseorder','$didsomeone176','$werethe177','$wereyou178','$didyour','$didyour180','$pleaseenter67','$pleaseenter','$doyou293','$doyou295','$doyou297','$wasthe181','$plsexplain','$werethe183','$didyour182','$didyou','$didyour185','$whenordering123','$didyour186','$didyou125','$hasyour','$pleaseenter83','$whatis','$pleaseenter84','$howwould151','$wasyour','$whatwas217','$doyou300','$doyou303','$doyou305','$didthe','$didthe190','$wasthe191','$didyour192','$uponfinishing307','$didyour194','$onceyou195','$atthe','$didthe199','$didyou213','$uploadpictures6','$uploadaddl','$uploada91','$photoapp1','$photoapp2','$photoapp296','$photomeal1','$photomeal2','$photomeal3','$photomeal4','$uploadsignaturediner','$ifyou','$manageron','$hostesson223','$barguy','$pleasemark','$step2complete','$didyou255','$basedon','$diningexperiencepositive','$explainbadexp','$wasenoughservers','$writeorattachfinal','$writefinal','$anynotes','$addfinalnotes','$step3complete','$uploadfinal','$picofcheck','$picofccreceipt','$propext1','$propext2','$propext3','$app1','$app2','$app3','$meal1','$meal2','$meal3','$meal4','$finalupsummary','$check1','$creditcard') ")
    or die(mysql_error());

}
?>