select("username","tbllandformsdetails","id='$sentid'"); $esentname=$selsent_name[0][0]; /*$insert_step2 = $obj->my_insert("tbllandlord","title,forenames,surname,ukdeparturedate,address,tel,mobile,email, title1,forenames1,surname1,ukdeparturedate1,address1,tel1,mobile1,email1,bank,sortCode,accountNo,namesonAccount,hmrcapproval", "'$title66','$forenames66','$surname66','$DepartureDatep66','$address66','$Tel66','$mobile66','$email66','$title166','$forenames166', '$surname166','$DepartureDates66','$address166','$tel166','$mobile166','$email166','$bank66','$sortcode66','$accountno66', '$namesonAccount66','$value666'"); */ $address2 = $_REQUEST['address2']; //showstep2 $PostCode = $_REQUEST['PostCode']; $Property_Landline_No = $_REQUEST['Property_Landline_No']; $Example = $_REQUEST['Example']; $Example1 = $_REQUEST['Example1']; $Example2 = $_REQUEST['Example2']; $Landline_No = $_REQUEST['Landline_No']; $Property = $_REQUEST['Property']; $Media_provider = $_REQUEST['Media_provider']; $value1 = $_REQUEST['value1']; $How_Many = $_REQUEST['How_Many']; $value2 = $_REQUEST['value2']; $authorised_keyholder = $_REQUEST['authorised_keyholder']; $Alarm_Details = $_REQUEST['Alarm_Details']; $Contract_No = $_REQUEST['Contract_No']; $value3 = $_REQUEST['value3']; $value4 = $_REQUEST['value4']; $Code1 = $_REQUEST['Code1']; $Code2 = $_REQUEST['Code2']; $Masterpass = ($_REQUEST['Masterpass']); $Location = $_REQUEST['Location']; $Service_Contractor = $_REQUEST['Service_Contractor']; $Property_Landline_No1 = $_REQUEST['Property_Landline_No1']; $Property_Landline_No2 = $_REQUEST['Property_Landline_No2']; $value5 = $_REQUEST['value5']; /*insert_data = $obj->my_insert("tbllandlord","address_property,postcode,propertyland_no,example1,example2,example3,landline_no,property,mediaprovider,value1,how_many,value2,authorised_key,alarm_details,contract_no,value3,value4,code1,code2,masterpass,location,service_cont,propertyLandlineNo1,propertyLandlineNo2,value5", "'$address2','$PostCode','$Property_Landline_No','$Example','$Example1','$Example2','$Landline_No','$Property','$Media_provider' ,'$value1','$How_Many','$value2','$authorised_keyholder','$Alarm_Details','$Contract_No','$value3','$value4','$Code1','$Code2', '$Masterpass','$Location','$Service_Contractor','$Property_Landline_No1','$Property_Landline_No2','$value5'"); */ $namestep41 = $_REQUEST['namestep41']; //showstep3 $namestep42 = $_REQUEST['namestep42']; $addresstep41 = $_REQUEST['addresstep41']; $addresstep42 = $_REQUEST['addresstep42']; $postcodestep41 = $_REQUEST['postcodestep41']; $postcodestep42 = $_REQUEST['postcodestep42']; $phonestep41 = $_REQUEST['phonestep41']; $phonestep42 = $_REQUEST['phonestep42']; $emailstep1 = $_REQUEST['emailstep1']; $emailstep2 = $_REQUEST['emailstep2']; // done $interviewradiostep41 = $_REQUEST['interviewradiostep41']; $interviewradiostep42 = $_REQUEST['interviewradiostep42']; $interviewradiostep43 = $_REQUEST['interviewradiostep43']; $interviewradiostep44 = $_REQUEST['interviewradiostep44']; $interviewradiostep45 = $_REQUEST['interviewradiostep45']; $interviewradiostep46 = $_REQUEST['interviewradiostep46']; $claimsstep41 = $_REQUEST['claimsstep41']; $claimsstep42 = $_REQUEST['claimsstep42']; $interviewradiostep47 = $_REQUEST['interviewradiostep47']; $interviewradiostep48 = $_REQUEST['interviewradiostep48']; //done $Sumstep41 = $_REQUEST['Sumstep41']; $Sumstep42 = $_REQUEST['Sumstep42']; $Agestep41 = $_REQUEST['Agestep41']; $Currentstep41 = $_REQUEST['Currentstep41']; $Amountstep41 = $_REQUEST['Amountstep41']; $interviewradiostep49 = $_REQUEST['interviewradiostep49']; $interviewradiostep410 = $_REQUEST['interviewradiostep410']; /*$insert_step4 = $obj->my_insert("tbllandlord","name1,name2,addresstep41,addresstep42,postcode1,postcode2,phone_no1,phone_no2, emailstep1,emailstep2,radiostep41,radiostep42,radiostep43,radiostep44,radiostep45,radiostep46,claims1,claims2,radiostep47, radiostep48,Sumstep41,Sumstep42,Agestep41,Currentstep41,Amountstep41,radiostep49,radiostep410","'$namestep41','$namestep42','$addresstep41','$addresstep42','$postcodestep41','$postcodestep42', '$phonestep41','$phonestep42','$emailstep1','$emailstep2','$interviewradiostep41','$interviewradiostep42','$interviewradiostep43','$interviewradiostep44', '$interviewradiostep45','$interviewradiostep46','$claimsstep41','$claimsstep42','$interviewradiostep47','$interviewradiostep48', '$Sumstep41','$Sumstep42','$Agestep41','$Currentstep41','$Amountstep41','$interviewradiostep49','$interviewradiostep410'"); */ $Gasstep5 = $_REQUEST['Gasstep5']; //showstep4 $Electricstep5 = $_REQUEST['Electricstep5']; $Waterstep5 = $_REQUEST['Waterstep5']; $Meterstep51 = $_REQUEST['Meterstep51']; $Meterstep52 = $_REQUEST['Meterstep52']; $Meterstep53 = $_REQUEST['Meterstep53']; $Locationstep51 = $_REQUEST['Locationstep51']; $Heatingstep5 = $_REQUEST['Heatingstep5']; $Boilerstep51 = $_REQUEST['Boilerstep51']; $Boilerstep52 = $_REQUEST['Boilerstep52']; $Locationstep52 = $_REQUEST['Locationstep52']; $Hotstep51 = $_REQUEST['Hotstep51']; $interviewradiostep51 = $_REQUEST['interviewradiostep51']; $Locationstep53 = $_REQUEST['Locationstep53']; $Locationstep54 = $_REQUEST['Locationstep54']; $interviewradiostep52 = $_REQUEST['interviewradiostep52']; $Locationstep55 = $_REQUEST['Locationstep55']; $Annualstep51 = $_REQUEST['Annualstep51']; $Servicestep52 = $_REQUEST['Servicestep52']; $Datestep51 = $_REQUEST['Datestep51']; $Homecarestep51 = $_REQUEST['Homecarestep51']; $Homecarestep52 = $_REQUEST['Homecarestep52']; $Installationsstep51 = $_REQUEST['Installationsstep51']; $inspectionsstep51 = $_REQUEST['inspectionsstep51']; $testingstep51 = $_REQUEST['testingstep51']; $Periodicstep51 = $_REQUEST['Periodicstep51']; $interviewradiostep53 = $_REQUEST['interviewradiostep53']; $interviewradiostep54 = $_REQUEST['interviewradiostep54']; $interviewradiostep55 = $_REQUEST['interviewradiostep55']; $interviewradiostep56 = $_REQUEST['interviewradiostep56']; $plumber = $_REQUEST['plumber']; $Heating_engineer = $_REQUEST['Heating_engineer']; $Electrician = $_REQUEST['Electrician']; $Carpenter = $_REQUEST['Carpenter']; $Decorator = $_REQUEST['Decorator']; $Handyman = $_REQUEST['Handyman']; $Gardener = $_REQUEST['Gardener']; $other = $_REQUEST['other']; $contractors = $_REQUEST['contractors']; $contractors_text = $_REQUEST['contractors_text']; $company1 = $_REQUEST['company1']; $company2 = $_REQUEST['company2']; $company3 = $_REQUEST['company3']; $company4 = $_REQUEST['company4']; $company5 = $_REQUEST['company5']; $company6 = $_REQUEST['company6']; $company7 = $_REQUEST['company7']; $company8 = $_REQUEST['company8']; $email1 = $_REQUEST['email1']; $email2 = $_REQUEST['email2']; $email3 = $_REQUEST['email3']; $email4 = $_REQUEST['email4']; $email5 = $_REQUEST['email5']; $email6 = $_REQUEST['email6']; $email7 = $_REQUEST['email7']; $email8 = $_REQUEST['email8']; $mobile1 = $_REQUEST['mobile1']; $mobile2 = $_REQUEST['mobile2']; $mobile3 = $_REQUEST['mobile3']; $mobile4 = $_REQUEST['mobile4']; $mobile5 = $_REQUEST['mobile5']; $mobile6 = $_REQUEST['mobile6']; $mobile7 = $_REQUEST['mobile7']; $mobile8 = $_REQUEST['mobile8']; $tel1 = $_REQUEST['tel1']; $tel2 = $_REQUEST['tel2']; $tel3 = $_REQUEST['tel3']; $tel4 = $_REQUEST['tel4']; $tel5 = $_REQUEST['tel5']; $tel6 = $_REQUEST['tel6']; $tel7 = $_REQUEST['tel7']; $tel8 = $_REQUEST['tel8']; $electricity_supplier = $_REQUEST['electricity_supplier']; $gas_supplier = $_REQUEST['gas_supplier']; $water_supplier = $_REQUEST['water_supplier']; $council_tax = $_REQUEST['council_tax']; $sewage = $_REQUEST['sewage']; $refuse_collected = $_REQUEST['refuse_collected']; $drainage = $_REQUEST['drainage']; $saniflo_location = $_REQUEST['saniflo_location']; $account_no1 = $_REQUEST['account_no1']; $telno_no1 = $_REQUEST['telno_no1']; $provider1 = $_REQUEST['provider1']; $account_no2 = $_REQUEST['account_no2']; $telno_no2 = $_REQUEST['telno_no2']; $provider2 = $_REQUEST['provider2']; $installation_property = $_REQUEST['installation_property']; $WashingMachine = $_REQUEST['WashingMachine']; $Washingage = $_REQUEST['Washingage']; $manual1 = $_REQUEST['manual1']; $guarantee1 = $_REQUEST['guarantee1']; $Washing1 = $_REQUEST['Washing1']; $Dryer = $_REQUEST['Dryer']; $Dryerage = $_REQUEST['Dryerage']; $manual2 = $_REQUEST['manual2']; $guarantee2 = $_REQUEST['guarantee2']; $Dryer1 = $_REQUEST['Dryer1']; $Washer = $_REQUEST['Washer']; $Washerage = $_REQUEST['Washerage']; $manual3 = $_REQUEST['manual3']; $guarantee3 = $_REQUEST['guarantee3']; $Washer1 = $_REQUEST['Washer1']; $Dish = $_REQUEST['Dish']; $Dishage = $_REQUEST['Dishage']; $manual4 = $_REQUEST['manual4']; $guarantee4= $_REQUEST['guarantee4']; $Dish1 = $_REQUEST['Dish1']; $Cooker = $_REQUEST['Cooker']; $Cookerage = $_REQUEST['Cookerage']; $manual5 = $_REQUEST['manual5']; $guarantee5 = $_REQUEST['guarantee5']; $Cooker1 = $_REQUEST['Cooker1']; $Oven = $_REQUEST['Oven']; $Ovenage = $_REQUEST['Ovenage']; $manual6 = $_REQUEST['manual6']; $guarantee6 = $_REQUEST['guarantee6']; $Oven1 = $_REQUEST['Oven1']; $Hob = $_REQUEST['Hob']; $Hobage = $_REQUEST['Hobage']; $manual7 = $_REQUEST['manual7']; $guarantee7 = $_REQUEST['guarantee7']; $Hob1 = $_REQUEST['Hob1']; $MicroWave = $_REQUEST['MicroWave']; $MicroWaveage = $_REQUEST['MicroWaveage']; $manual8 = $_REQUEST['manual8']; $guarantee8 = $_REQUEST['guarantee8']; $MicroWave1 = $_REQUEST['MicroWave1']; $Fridge = $_REQUEST['Fridge']; $Fridgeage = $_REQUEST['Fridgeage']; $manual9 = $_REQUEST['manual9']; $guarantee9 = $_REQUEST['guarantee9']; $Fridge1 = $_REQUEST['Fridge1']; $Refrigderator = $_REQUEST['Refrigderator']; $Refrigderatorage = $_REQUEST['Refrigderatorage']; $manual10= $_REQUEST['manual10']; $guarantee10= $_REQUEST['guarantee10']; $Refrigderator1 = $_REQUEST['Refrigderator1']; $Freezer = $_REQUEST['Freezer']; $Freezerage = $_REQUEST['Freezerage']; $manual11 = $_REQUEST['manual11']; $guarantee11 = $_REQUEST['guarantee11']; $Freezer1 = $_REQUEST['Freezer1']; //print_r($value21); $Disposal = $_REQUEST['Disposal']; $Disposalage = $_REQUEST['Disposalage']; $manual12 = $_REQUEST['manual12']; $guarantee12 = $_REQUEST['guarantee12']; $Softener = $_REQUEST['Softener']; $Softenerage = $_REQUEST['Softenerage']; $manual13 = $_REQUEST['manual13']; $guarantee13 = $_REQUEST['guarantee13']; $pumpage = $_REQUEST['pumpage']; $pump = $_REQUEST['pump']; $manual14= $_REQUEST['manual14']; $guarantee14 = $_REQUEST['guarantee14']; $Saniflo = $_REQUEST['Saniflo']; $Sanifloage = $_REQUEST['Sanifloage']; $manual15= $_REQUEST['manual15']; $guarantee15= $_REQUEST['guarantee15']; $Heaters = $_REQUEST['Heaters']; $Heatersage = $_REQUEST['Heatersage']; $manual16 = $_REQUEST['manual16']; $guarantee16 = $_REQUEST['guarantee16']; $Extractor = $_REQUEST['Extractor']; $Extractorage = $_REQUEST['Extractorage']; $manual17 = $_REQUEST['manual17']; $guarantee17 = $_REQUEST['guarantee17']; $StorageHeatersage = $_REQUEST['StorageHeatersage']; $StorageHeaters = $_REQUEST['StorageHeaters']; $manual18 = $_REQUEST['manual18']; $guarantee18 = $_REQUEST['guarantee18']; //print_r($_REQUEST); //print_r($_FILES['input3']); print_r($_FILES['input33']); //die; $insert_step5 = $obj->my_insert("tbllandlord","linksent_id,title,forenames,surname,ukdeparturedate,address,tel,mobile,email, title1,forenames1,surname1,ukdeparturedate1,address1,tel1,mobile1,email1,bank,sortCode,accountNo,namesonAccount,hmrcapproval,address_property,postcode,propertyland_no,example1,example2,example3,landline_no,property,mediaprovider,value1,how_many,value2,authorised_key,alarm_details,contract_no,value3,value4,code1,code2,masterpass,location,service_cont,propertyLandlineNo1,propertyLandlineNo2,value5, name1,name2,addresstep41,addresstep42,postcode1,postcode2,phone_no1,phone_no2,emailstep1,emailstep2,radiostep41,radiostep42,radiostep43,radiostep44,radiostep45,radiostep46,claims1,claims2,radiostep47, radiostep48,Sumstep41,Sumstep42,Agestep41,Currentstep41,Amountstep41,radiostep49,radiostep410,Gasstep5,Electricstep5,Waterstep5,Meterstep51,Meterstep52,Meterstep53, Locationstep51,Heatingstep5,Boilerstep51,Boilerstep52,Locationstep52,Hotstep51,interviewradiostep51,Locationstep53,Locationstep54, interviewradiostep52,Locationstep55,Annualstep51,Servicestep52,Datestep51,Homecarestep51,Homecarestep52,Installationsstep51, inspectionsstep51,testingstep51,Periodicstep51,interviewradiostep53,interviewradiostep54,interviewradiostep55,interviewradiostep56,sentname,property_type,newpincode1,newpincode2","'$sentid','$title66','$forenames66','$surname66','$DepartureDatep66','$address66','$Tel66','$mobile66','$email66','$title166','$forenames166', '$surname166','$DepartureDates66','$address166','$tel166','$mobile166','$email166','$bank66','$sortcode66','$accountno66', '$namesonAccount66','$value666','$address2','$PostCode','$Property_Landline_No','$Example','$Example1','$Example2','$Landline_No','$Property','$Media_provider' ,'$value1','$How_Many','$value2','$authorised_keyholder','$Alarm_Details','$Contract_No','$value3','$value4','$Code1','$Code2', '$Masterpass','$Location','$Service_Contractor','$Property_Landline_No1','$Property_Landline_No2','$value5','$namestep41','$namestep42','$addresstep41','$addresstep42','$postcodestep41','$postcodestep42', '$phonestep41','$phonestep42','$emailstep1','$emailstep2','$interviewradiostep41','$interviewradiostep42','$interviewradiostep43','$interviewradiostep44', '$interviewradiostep45','$interviewradiostep46','$claimsstep41','$claimsstep42','$interviewradiostep47','$interviewradiostep48', '$Sumstep41','$Sumstep42','$Agestep41','$Currentstep41','$Amountstep41','$interviewradiostep49','$interviewradiostep410','$Gasstep5','$Electricstep5','$Waterstep5','$Meterstep51','$Meterstep52','$Meterstep53','$Locationstep51','$Heatingstep5','$Boilerstep51', '$Boilerstep52','$Locationstep52','$Hotstep51','$interviewradiostep51','$Locationstep53','$Locationstep54','$interviewradiostep52', '$Locationstep55','$Annualstep51','$Servicestep52','$Datestep51','$Homecarestep51','$Homecarestep52','$Installationsstep51', '$inspectionsstep51','$testingstep51','$Periodicstep51','$interviewradiostep53','$interviewradiostep54','$interviewradiostep55','$interviewradiostep56','$esentname','$property1','$newpincode1','$newpincode2'"); $insertdata1 = $obj->my_insert("tbllandlord2","Plumber,Company1,Tel1,Mobile1,Email1,Heating_Engineer,Company2,Tel2,Mobile2,Email2,Electrician, Company3,Tel3,Mobile3,Email3,Carpenter,Company4,Tel4,Mobile4,Email4,Decorator,Company5,Tel5,Mobile5, Email5,Handyman,Company6,Tel6,Mobile6,Email6,Gardener,Company7,Tel7,Mobile7,Email7,Other,Company8,Tel8, Mobile8,Email8,f_info,info_text,e_supplier,g_supplier,w_supplier,c_tax,sewage,refuseday,drainage,installation, saniflo_location,account_no_line_1,tel_no_line_1,provider1,account_no_line_2,tel_no_line_2,provider2,w_machine, dryer,washer_dryer,d_washer,cooker,oven,hob,microwave,f_freezer,refrigderator,freezer,w_dispoal,w_softener,w_pump, saniflo,w_heaters,s_heaters,extractor,age1,age2,age3,age4,age5,age6,age7,age8,age9,age10,age11,age12,age13,age14,age15, age16,age17,age18,m_provided1,m_provided2,m_provided3,m_provided4,m_provided5,m_provided6,m_provided7,m_provided8, m_provided9,m_provided10,m_provided11,m_provided12,m_provided13,m_provided14,m_provided15,m_provided16,m_provided17 ,m_provided18,g_warrranty1,g_warrranty2,g_warrranty3,g_warrranty4,g_warrranty5,g_warrranty6,g_warrranty7,g_warrranty8, g_warrranty9,g_warrranty10,g_warrranty11,g_warrranty12,g_warrranty13,g_warrranty14,g_warrranty15,g_warrranty16,g_warrranty17 ,g_warrranty18,integrated1,integrated2,integrated3,integrated4,integrated5,integrated6,integrated7,integrated8,integrated9, integrated10,integrated11,landlordformid","'$plumber','$company1','$tel1','$mobile1','$email1','$Heating_engineer','$company2','$tel2','$mobile2' ,'$email2','$Electrician','$company3','$tel3','$mobile3','$email3','$Carpenter','$company4','$tel4','$mobile4','$email4','$Decorator', '$company5','$tel5','$mobile5','$email5','$Handyman','$company6','$tel6','$mobile6','$email6','$Gardener','$company7', '$tel7','$mobile7','$email7','$other','$company8','$tel8','$mobile8','$email8','$contractors','$contractors_text', '$electricity_supplier','$gas_supplier','$water_supplier','$council_tax','$sewage','$refuse_collected','$drainage', '$installation_property','$saniflo_location','$account_no1','$telno_no1','$provider1','$account_no2','$telno_no2', '$provider2','$WashingMachine','$Dryer','$Washer','$Dish','$Cooker','$Oven','$Hob','$MicroWave','$Fridge','$Refrigderator', '$Freezer','$Disposal','$Softener','$pump','$Saniflo','$Heaters','$StorageHeaters','$Extractor','$Washingage', '$Dryerage','$Washerage','$Dishage','$Cookerage','$Ovenage','$Hobage','$MicroWaveage','$Fridgeage','$Refrigderatorage','$Freezerage', '$Disposalage','$Softenerage','$pumpage','$Sanifloage','$Heatersage','$StorageHeatersage','$Extractorage','$manual1','$manual2','$manual3', '$manual4','$manual5','$manual6','$manual7','$manual8','$manual9','$manual10','$manual11','$manual12','$manual13','$manual14', '$manual15','$manual16','$manual17','$manual18','$guarantee1','$guarantee2','$guarantee3','$guarantee4','$guarantee5','$guarantee6','$guarantee7', '$guarantee8','$guarantee9','$guarantee10','$guarantee11','$guarantee12','$guarantee13','$guarantee14','$guarantee15','$guarantee16','$guarantee17','$guarantee18', '$Washing1','$Dryer1','$Washer1','$Dish1','$Cooker1','$Oven1','$Hob1','$MicroWave1','$Fridge1','$Refrigderator1','$Freezer1','$insert_step5'"); $update_pass = $obj->update("tbllandformsdetails","status='received',received_date='$today'","id='$sentid'"); $valid_formats = array("jpg", "jpeg", "png", "gif", "bmp", "JPG", "JPEG", "PNG", "GIF"); $path = "rush/rush2017/backend/uploads/"; // Upload directory $max_file_size = 1024*2000; //100 kb //2 mb $count = 0; $valid_formatss = array("doc","PDF","pdf","DOC","DOCX"); //echo 1; if(!empty($_FILES['input3']['name'])) { foreach ($_FILES['input3']['name'] as $f => $name) { if ($_FILES['input3']['error'][$f] == 4) { continue; // Skip file if any error found } if ($_FILES['input3']['error'][$f] == 0) { // print_r($name); if ($_FILES['input3']['size'][$f] > $max_file_size) { $message[] = "$name is too large!."; //continue; // Skip large files } else if( ! in_array(pathinfo($name, PATHINFO_EXTENSION), $valid_formats) ) { $message[] = "$name is not a valid format"; //continue; // Skip invalid file formats } else { // o error found! Move uploaded files $name = str_replace(' ', '_', $name); $pname2 = time().$name; if(move_uploaded_file($_FILES["input3"]["tmp_name"][$f],$path.$pname2)) { $count++; // Number of successfully uploaded files $insertgallery = $obj->my_insert("tbllandlordimages","tbllandlord_id,images","'$sentid','$pname2'"); } } // print_r($message); } } //echo 1; } if(!empty($_FILES['input33']['name'])) { foreach ($_FILES['input33']['name'] as $f => $name) { if ($_FILES['input33']['error'][$f] == 4) { continue; // Skip file if any error found } if ($_FILES['input33']['error'][$f] == 0) { // print_r($name); if ($_FILES['input33']['size'][$f] > $max_file_size) { $message[] = "$name is too large!."; //continue; // Skip large files } else if( ! in_array(pathinfo($name, PATHINFO_EXTENSION), $valid_formatss) ) { $message[] = "$name is not a valid format"; //continue; // Skip invalid file formats } else { // o error found! Move uploaded files $name = str_replace(' ', '_', $name); $pname2 = time().$name; if(move_uploaded_file($_FILES["input33"]["tmp_name"][$f],$path.$pname2)) { $count++; // Number of successfully uploaded files $insertgallery = $obj->my_insert("tbllandlordimages","tbllandlord_id,images","'$sentid','$pname2'"); } } // print_r($message); } } } echo 1; ?>