File "form-api.php"

Full path: /home/fsibplc/public_html/fsib/remittance/form-api.php
File size: 4.12 B (4.12 KB bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Edit   Advanced Editor   Back

<?php

include 'dbconnect.php';


// $nid = "";
// $cus_photo = "";
// $nominee_nid = "";

if(isset($_POST["ac_open_form_submit"])){
       
    
    $ac_open_br = $conn->real_escape_string(trim($_POST["ac_open_br"]));
    $ac_type = $conn->real_escape_string(trim($_POST["ac_type"]));
    $cus_name = $conn->real_escape_string(trim($_POST["cus_name"]));
    $gender = $conn->real_escape_string(trim($_POST["gender"]));
    $father_name = $conn->real_escape_string(trim($_POST["father_name"]));
    $mother_name = $conn->real_escape_string(trim($_POST["mother_name"]));
    $dob = $conn->real_escape_string(trim($_POST["dob"]));
    $occupation = $conn->real_escape_string(trim($_POST["occupation"]));

    $country_code = $conn->real_escape_string(trim($_POST["cc"]));
    $mob = $conn->real_escape_string(trim($_POST["mobile"]));
    
    $mobile = $country_code.$mob;
    
    $email = $conn->real_escape_string(trim($_POST["email"]));
    $nationality = $conn->real_escape_string(trim($_POST["nationality"]));
    $pr_ad = $conn->real_escape_string(trim($_POST["pr_ad"]));
    $per_ad = $conn->real_escape_string(trim($_POST["per_ad"]));
    // $nid = $conn->real_escape_string(trim($_POST["nid"]));
    // $cus_photo = $conn->real_escape_string(trim($_POST["cus_photo"]));
    $nominee_name = $conn->real_escape_string(trim($_POST["nominee_name"]));
    $nominee_relation = $conn->real_escape_string(trim($_POST["nominee_relation"]));
    $nominee_share = $conn->real_escape_string(trim($_POST["nominee_share"]));
    // $nominee_nid = $conn->real_escape_string(trim($_POST["nominee_nid"]));
    
    // echo $pr_ad." ".$per_ad." ".$country_code." ".$mob." ".$mobile;
    // die();
    
     
    

    // File upload directory
    $targetDir = "uploads/";


    // Handle file uploads
    $nid = $_FILES['nid']['name'];
    $cus_photo = $_FILES['cus_photo']['name'];
    $nominee_nid = $_FILES['nominee_nid']['name'];

    // Handle file uploads
    $nid_b = $_FILES['nid_b']['name'];
    $cus_sign = $_FILES['cus_sign']['name'];
    $nominee_nid_b = $_FILES['nominee_nid_b']['name'];

    // Set the target file paths
    $photoIDTarget = $targetDir . basename($nid);
    $userPhotoTarget = $targetDir . basename($cus_photo);
    $nomineePhotoIDTarget = $targetDir . basename($nominee_nid);

    $photoIDTarget_b = $targetDir . basename($nid_b);
    $userSignTarget= $targetDir . basename($cus_sign);
    $nomineePhotoIDTarget_b = $targetDir . basename($nominee_nid_b);

    // Upload files
    if (move_uploaded_file($_FILES['nid']['tmp_name'], $photoIDTarget) &&
        move_uploaded_file($_FILES['cus_photo']['tmp_name'], $userPhotoTarget) &&
        move_uploaded_file($_FILES['nominee_nid']['tmp_name'], $nomineePhotoIDTarget) &&
        move_uploaded_file($_FILES['nid_b']['tmp_name'], $photoIDTarget_b) &&
        move_uploaded_file($_FILES['cus_sign']['tmp_name'], $userSignTarget) &&
        move_uploaded_file($_FILES['nominee_nid_b']['tmp_name'], $nomineePhotoIDTarget_b)) {

        // Prepare SQL query
        $sql = "INSERT INTO `account_info`(`branch`, `ac_type`, `name`, `father_name`, `mother_name`, `dob`, `occupation`, `mobile`, `email`, `nationality`, `present_address`, `permanent_address`, `gender`, `nominee_name`, `relation`, `share`, `picture`, `user_front`, `user_back`, `nominee_front`, `nominee_back`,`sign`)
                VALUES
                ('$ac_open_br', '$ac_type', '$cus_name', '$father_name', '$mother_name', '$dob', '$occupation', '$mobile', '$email','$nationality', '$pr_ad', '$per_ad', '$gender', '$nominee_name','$nominee_relation', '$nominee_share','$cus_photo','$nid', '$nid_b',  '$nominee_nid',  '$nominee_nid_b','$cus_sign')";


        if ($conn->query($sql) === TRUE) {
            echo "<script>alert('Form submitted successfully!');</script>";
            echo '<script>window.top.location="account_open_form.php";</script>';
        } else {
            echo "Error: " . $sql . "<br>" . $conn->error;
        }

    } else {
        echo "Sorry, there was an error uploading your files.";
    }

} else {
    echo "No form data submitted.";
}

$conn->close();
?>