<?php 
// Include the database config file 
include_once 'config.php'; 
 

    // Fetch state data based on the specific country 
	$valid_extensions = array('jpeg', 'jpg', 'png','pdf'); // valid extensions
$path = 'files/'; // upload directory
$path2 = 'files/'; // upload directory
if(!empty($_POST['category']))
{
$img = $_FILES['upload_proof']['name'];
$tmp = $_FILES['upload_proof']['tmp_name'];


$img2 = $_FILES['upload_id']['name'];
$tmp2 = $_FILES['upload_id']['tmp_name'];
// get uploaded file's extension
$ext = strtolower(pathinfo($img, PATHINFO_EXTENSION));
$ext2 = strtolower(pathinfo($img2, PATHINFO_EXTENSION));
// can upload same image using rand function
$final_image = rand(1000,1000000).$img;
$final_image2 = rand(1000,1000000).$img2;
// check's valid format
if(in_array($ext, $valid_extensions) AND in_array($ext2, $valid_extensions)) 
{ 
$path = $path.strtolower($final_image); 
$path2 = $path2.strtolower($final_image2); 
if((move_uploaded_file($tmp,"../".$path)) AND (move_uploaded_file($tmp2,"../".$path2)))
{

if($_REQUEST['loan_date']==""){
   	$query = "INSERT INTO tb_data (category,brand,model,downpayment,terms,area,branch,firstname,middlename,lastname,gender,maritalstatus,nationality,contact_no1,contact_no2,birthdate,comaker_firstname,comaker_middlename,comaker_lastname,comaker_contactno,comaker_relationship,comaker_address,comaker_residence,comaker_source_of_income,spouse_fullname,spouse_source_of_income,spouse_company,source_of_income,loan_storebank,loan_amount,loan_term,loan_date,address_line1,province,municipality,barangay,typeofresidence,proof_attachment,valid_id,repeated)
	                      values('".$_REQUEST['category']."','".$_REQUEST['brand']."','".$_REQUEST['model']."','".$_REQUEST['downpayment']."','".$_REQUEST['term']."','".$_REQUEST['area']."','".$_REQUEST['branch']."','".$_REQUEST['firstname']."','".$_REQUEST['middlename']."','".$_REQUEST['lastname']."','".$_REQUEST['gender']."','".$_REQUEST['maritalstatus']."','".$_REQUEST['nationality']."','".$_REQUEST['contact_no1']."','".$_REQUEST['contact_no2']."','".$_REQUEST['birthdate']."','".$_REQUEST['comaker_firstname']."','".$_REQUEST['comaker_middlename']."','".$_REQUEST['comaker_lastname']."','".$_REQUEST['comaker_contactno']."','".$_REQUEST['comaker_relationship']."','".$_REQUEST['comaker_address']."','".$_REQUEST['comaker_residence']."','".$_REQUEST['comaker_source_of_income']."','".$_REQUEST['spouse_fullname']."','".$_REQUEST['spouse_source_of_income']."','".$_REQUEST['spouse_company']."','".$_REQUEST['source_of_income']."','".$_REQUEST['loan_storebank']."','".$_REQUEST['loan_amount']."','".$_REQUEST['loan_term']."',null,'".$_REQUEST['address1']."','".$_REQUEST['province']."','".$_REQUEST['municipality']."','".$_REQUEST['barangay']."','".$_REQUEST['typeofresidence']."','".$path."','".$path2."','".$_REQUEST['repeated']."')"; 
  
}else{
    	$query = "INSERT INTO tb_data (category,brand,model,downpayment,terms,area,branch,firstname,middlename,lastname,gender,maritalstatus,nationality,contact_no1,contact_no2,birthdate,comaker_firstname,comaker_middlename,comaker_lastname,comaker_contactno,comaker_relationship,comaker_address,comaker_residence,comaker_source_of_income,spouse_fullname,spouse_source_of_income,spouse_company,source_of_income,loan_storebank,loan_amount,loan_term,loan_date,address_line1,province,municipality,barangay,typeofresidence,proof_attachment,valid_id,repeated)
	                      values('".$_REQUEST['category']."','".$_REQUEST['brand']."','".$_REQUEST['model']."','".$_REQUEST['downpayment']."','".$_REQUEST['term']."','".$_REQUEST['area']."','".$_REQUEST['branch']."','".$_REQUEST['firstname']."','".$_REQUEST['middlename']."','".$_REQUEST['lastname']."','".$_REQUEST['gender']."','".$_REQUEST['maritalstatus']."','".$_REQUEST['nationality']."','".$_REQUEST['contact_no1']."','".$_REQUEST['contact_no2']."','".$_REQUEST['birthdate']."','".$_REQUEST['comaker_firstname']."','".$_REQUEST['comaker_middlename']."','".$_REQUEST['comaker_lastname']."','".$_REQUEST['comaker_contactno']."','".$_REQUEST['comaker_relationship']."','".$_REQUEST['comaker_address']."','".$_REQUEST['comaker_residence']."','".$_REQUEST['comaker_source_of_income']."','".$_REQUEST['spouse_fullname']."','".$_REQUEST['spouse_source_of_income']."','".$_REQUEST['spouse_company']."','".$_REQUEST['source_of_income']."','".$_REQUEST['loan_storebank']."','".$_REQUEST['loan_amount']."','".$_REQUEST['loan_term']."','".$_REQUEST['loan_date']."','".$_REQUEST['address1']."','".$_REQUEST['province']."','".$_REQUEST['municipality']."','".$_REQUEST['barangay']."','".$_REQUEST['typeofresidence']."','".$path."','".$path2."','".$_REQUEST['repeated']."')"; 

}

    $result = $con->query($query); 
     echo "ok";

}
} 
else 
{
echo 'invalid';
}
}


		

    // Generate HTML of state options list 
   


?>