File manager

File manager - Edit - /home/custbahd/cornerstoneassetmanagers.com/application-forms/submit/index.php

Back
<?php include_once('../../admin/db/saucerer.php'); if(!isset($_POST["submit"])) { $code = 'utf_'.date("HisdmY",time()).''; $surname1 = mysqli_real_escape_string($mysqli, $_POST['surname1']); $surname2 = mysqli_real_escape_string($mysqli, $_POST['surname2']); $surname3 = mysqli_real_escape_string($mysqli, $_POST['surname3']); $othername1 = mysqli_real_escape_string($mysqli, $_POST['othername1']); $othername2 = mysqli_real_escape_string($mysqli, $_POST['othername2']); $othername3 = mysqli_real_escape_string($mysqli, $_POST['othername3']); $dob1 = mysqli_real_escape_string($mysqli, $_POST['dob1']); $dob2 = mysqli_real_escape_string($mysqli, $_POST['dob2']); $dob3 = mysqli_real_escape_string($mysqli, $_POST['dob3']); $passport1 = mysqli_real_escape_string($mysqli, $_POST['passport1']); $passport2 = mysqli_real_escape_string($mysqli, $_POST['passport2']); $passport3 = mysqli_real_escape_string($mysqli, $_POST['passport3']); $nin1 = mysqli_real_escape_string($mysqli, $_POST['nin1']); $nin2 = mysqli_real_escape_string($mysqli, $_POST['nin2']); $nin3 = mysqli_real_escape_string($mysqli, $_POST['nin3']); $nationality1 = mysqli_real_escape_string($mysqli, $_POST['nationality1']); $nationality2 = mysqli_real_escape_string($mysqli, $_POST['nationality2']); $nationality3 = mysqli_real_escape_string($mysqli, $_POST['nationality3']); $residence1 = mysqli_real_escape_string($mysqli, $_POST['residence1']); $residence2 = mysqli_real_escape_string($mysqli, $_POST['residence2']); $residence3 = mysqli_real_escape_string($mysqli, $_POST['residence3']); $email1 = mysqli_real_escape_string($mysqli, $_POST['email1']); $email2 = mysqli_real_escape_string($mysqli, $_POST['email2']); $email3 = mysqli_real_escape_string($mysqli, $_POST['email3']); $po_box1 = mysqli_real_escape_string($mysqli, $_POST['po_box1']); $po_box2 = mysqli_real_escape_string($mysqli, $_POST['po_box2']); $po_box3 = mysqli_real_escape_string($mysqli, $_POST['po_box3']); $emp_status1 = mysqli_real_escape_string($mysqli, $_POST['emp_status1']); $emp_status2 = mysqli_real_escape_string($mysqli, $_POST['emp_status2']); $emp_status3 = mysqli_real_escape_string($mysqli, $_POST['emp_status3']); $employer1 = mysqli_real_escape_string($mysqli, $_POST['employer1']); $employer2 = mysqli_real_escape_string($mysqli, $_POST['employer2']); $employer3 = mysqli_real_escape_string($mysqli, $_POST['employer3']); $occupation1 = mysqli_real_escape_string($mysqli, $_POST['occupation1']); $occupation2 = mysqli_real_escape_string($mysqli, $_POST['occupation2']); $occupation3 = mysqli_real_escape_string($mysqli, $_POST['occupation3']); $industry1 = mysqli_real_escape_string($mysqli, $_POST['industry1']); $industry2 = mysqli_real_escape_string($mysqli, $_POST['industry2']); $industry3 = mysqli_real_escape_string($mysqli, $_POST['industry3']); $tin1 = mysqli_real_escape_string($mysqli, $_POST['tin1']); $tin2 = mysqli_real_escape_string($mysqli, $_POST['tin2']); $tin3 = mysqli_real_escape_string($mysqli, $_POST['tin3']); $phone1 = mysqli_real_escape_string($mysqli, $_POST['phone1']); $phone2 = mysqli_real_escape_string($mysqli, $_POST['phone2']); $phone3 = mysqli_real_escape_string($mysqli, $_POST['phone3']); $house1 = mysqli_real_escape_string($mysqli, $_POST['house1']); $house2 = mysqli_real_escape_string($mysqli, $_POST['house2']); $house3 = mysqli_real_escape_string($mysqli, $_POST['house3']); $road1 = mysqli_real_escape_string($mysqli, $_POST['road1']); $road2 = mysqli_real_escape_string($mysqli, $_POST['road2']); $road3 = mysqli_real_escape_string($mysqli, $_POST['road3']); $city1 = mysqli_real_escape_string($mysqli, $_POST['city1']); $city2 = mysqli_real_escape_string($mysqli, $_POST['city2']); $city3 = mysqli_real_escape_string($mysqli, $_POST['city3']); $auth_sign = mysqli_real_escape_string($mysqli, $_POST['auth_sign']); $e_name = mysqli_real_escape_string($mysqli, $_POST['e_name']); $e_phone = mysqli_real_escape_string($mysqli, $_POST['e_phone']); $e_relations = mysqli_real_escape_string($mysqli, $_POST['e_relations']); $source_funds = mysqli_real_escape_string($mysqli, $_POST['source_funds']); $source_funds_specify = mysqli_real_escape_string($mysqli, $_POST['source_funds_specify']); $bank_name = mysqli_real_escape_string($mysqli, $_POST['bank_name']); $bank_branch = mysqli_real_escape_string($mysqli, $_POST['bank_branch']); $ac_name = mysqli_real_escape_string($mysqli, $_POST['ac_name']); $ac_number = mysqli_real_escape_string($mysqli, $_POST['ac_number']); $auth_sign1 = mysqli_real_escape_string($mysqli, $_POST['auth_sign1']); $auth_sign2 = mysqli_real_escape_string($mysqli, $_POST['auth_sign2']); $auth_sign3 = mysqli_real_escape_string($mysqli, $_POST['auth_sign3']); $ug_fund = mysqli_real_escape_string($mysqli, $_POST['ug_fund']); $us_fund = mysqli_real_escape_string($mysqli, $_POST['us_fund']); $org_name = mysqli_real_escape_string($mysqli, $_POST['org_name']); $org_reg_no = mysqli_real_escape_string($mysqli, $_POST['org_reg_no']); $org_tin_no = mysqli_real_escape_string($mysqli, $_POST['org_tin_no']); $org_inc_date = mysqli_real_escape_string($mysqli, $_POST['org_inc_date']); $org_reg_country = mysqli_real_escape_string($mysqli, $_POST['org_reg_country']); $org_business_nature = mysqli_real_escape_string($mysqli, $_POST['org_business_nature']); $org_email = mysqli_real_escape_string($mysqli, $_POST['org_email']); $org_po_box = mysqli_real_escape_string($mysqli, $_POST['org_po_box']); $org_industry = mysqli_real_escape_string($mysqli, $_POST['org_industry']); $org_building_floor = mysqli_real_escape_string($mysqli, $_POST['org_building_floor']); $org_city = mysqli_real_escape_string($mysqli, $_POST['org_city']); $org_road = mysqli_real_escape_string($mysqli, $_POST['org_road']); $org_contact_person = mysqli_real_escape_string($mysqli, $_POST['org_contact_person']); $org_mobile = mysqli_real_escape_string($mysqli, $_POST['org_mobile']); $risk1 = mysqli_real_escape_string($mysqli, $_POST['risk1']); $risk2 = mysqli_real_escape_string($mysqli, $_POST['risk2']); $risk3 = mysqli_real_escape_string($mysqli, $_POST['risk3']); $risk4 = mysqli_real_escape_string($mysqli, $_POST['risk4']); $risk5 = mysqli_real_escape_string($mysqli, $_POST['risk5']); $risk6 = mysqli_real_escape_string($mysqli, $_POST['risk6']); $risk6 = mysqli_real_escape_string($mysqli, $_POST['risk6']); $confirm_name = mysqli_real_escape_string($mysqli, $_POST['confirm_name']); $confirm_signature = mysqli_real_escape_string($mysqli, $_POST['confirm_signature']); $final_name1 = mysqli_real_escape_string($mysqli, $_POST['final_name1']); $final_name2 = mysqli_real_escape_string($mysqli, $_POST['final_name2']); $final_name3 = mysqli_real_escape_string($mysqli, $_POST['final_name3']); $final_signature1 = mysqli_real_escape_string($mysqli, $_POST['final_signature1']); $final_signature2 = mysqli_real_escape_string($mysqli, $_POST['final_signature2']); $final_signature3 = mysqli_real_escape_string($mysqli, $_POST['final_signature3']); $sql = "INSERT INTO fund_investment (code, surname1, surname2, surname3, othername1, othername2, othername3, dob1, dob2, dob3, passport1, passport2, passport3, nin1, nin2, nin3, nationality1, nationality2, nationality3, residence1, residence2, residence3, email1, email2, email3, po_box1, po_box2, po_box3, emp_status1, emp_status2, emp_status3, employer1, employer2, employer3, occupation1, occupation2, occupation3, industry1, industry2, industry3, tin1, tin2, tin3, phone1, phone2, phone3, house1, house2, house3, road1, road2, road3, city1, city2, city3, auth_sign, e_name, e_phone, e_relations, source_funds, source_funds_specify, bank_name, bank_branch, ac_name, ac_number, auth_sign1, auth_sign2, auth_sign3, ug_fund, us_fund, org_name, org_reg_no, org_tin_no, org_inc_date, org_reg_country, org_business_nature, org_email, org_po_box, org_industry, org_building_floor, org_city, org_road, org_contact_person, org_mobile, risk1, risk2, risk3, risk4, risk5, risk6, risk7, confirm_name, confirm_signature, final_name1, final_name2, final_name3, final_signature1, final_signature2, final_signature3) VALUES ('$code', '$surname1', '$surname2', '$surname3', '$othername1', '$othername2', '$othername3', '$dob1', '$dob2', '$dob3', '$passport1', '$passport2', '$passport3', '$nin1', '$nin2', '$nin3', '$nationality1', '$nationality2', '$nationality3', '$residence1', '$residence2', '$residence3', '$email1', '$email2', '$email3', '$po_box1', '$po_box2', '$po_box3', '$emp_status1', '$emp_status2', '$emp_status3', '$employer1', '$employer2', '$employer3', '$occupation1', '$occupation2', '$occupation3', '$industry1', '$industry2', '$industry3', '$tin1', '$tin2', '$tin3', '$phone1', '$phone2', '$phone3', '$house1', '$house2', '$house3', '$road1', '$road2', '$road3', '$city1', '$city2', '$city3', '$auth_sign', '$e_name', '$e_phone', '$e_relations', '$source_funds', '$source_funds_specify', '$bank_name', '$bank_branch', '$ac_name', '$ac_number', '$auth_sign1', '$auth_sign2', '$auth_sign3', '$ug_fund', '$us_fund', '$org_name', '$org_reg_no', '$org_tin_no', '$org_inc_date', '$org_reg_country', '$org_business_nature', '$org_email', '$org_po_box', '$org_industry', '$org_building_floor', '$org_city', '$org_road', '$org_contact_person', '$org_mobile', '$risk1', '$risk2', '$risk3', '$risk4', '$risk5', '$risk6', '$risk7', '$confirm_name', '$confirm_signature', '$final_name1', '$final_name2', '$final_name3', '$final_signature1', '$final_signature2', '$final_signature3')"; //use for MySQLi OOP if(mysqli_query($mysqli, $sql)){ $_SESSION['success'] = 'Investment form sent successfully'; } else{ $_SESSION['error'] = 'Something went wrong while sending the investment form!'; } } header('location: ../'); ?>

| ver. 1.4 | Github | . | PHP 8.1.33 | Generation time: 2.6 | proxy | phpinfo | Settings