Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.84.1.lve.el8.x86_64

PHP Version:

8.2.30

User:

u176134211

Directory:

/home/u176134211/domains/subdrop.in/public_html

Free Space:

8.3 TB

🔧 Quick Actions

✏️ Editing: submit_application.php

<?php
/**
 * Submit Application - Process Form Submission
 */

error_reporting(E_ALL);
ini_set('display_errors', 1);

session_start(); // ✅ needed because you use $_SESSION later

require_once 'includes/config.php';

if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    header('Location: index.php');
    exit;
}

$conn = getDBConnection();
if (!$conn) {
    die('Database connection failed');
}

// Generate application number
$year = date('Y');
$result = $conn->query("SELECT COUNT(*) as count FROM applications_exact WHERE YEAR(created_at) = $year");
$row = $result->fetch_assoc();
$count = $row['count'] + 1;
$application_number = 'IHM' . $year . str_pad($count, 5, '0', STR_PAD_LEFT);

// Create upload directory
$upload_dir = 'uploads/' . $application_number . '/';
if (!is_dir($upload_dir)) {
    mkdir($upload_dir, 0755, true);
}

// Handle file uploads
$photo_path = '';
$signature_path = '';

if (isset($_FILES['applicant_photo']) && $_FILES['applicant_photo']['error'] === UPLOAD_ERR_OK) {
    $photo_name = 'photo_' . time() . '.jpg';
    $photo_path = $upload_dir . $photo_name;
    move_uploaded_file($_FILES['applicant_photo']['tmp_name'], $photo_path);
}

if (isset($_FILES['applicant_signature']) && $_FILES['applicant_signature']['error'] === UPLOAD_ERR_OK) {
    $sig_name = 'signature_' . time() . '.jpg';
    $signature_path = $upload_dir . $sig_name;
    move_uploaded_file($_FILES['applicant_signature']['tmp_name'], $signature_path);
}

// Helper functions
function getVal($key, $default = '') {
    return isset($_POST[$key]) && $_POST[$key] !== '' ? $_POST[$key] : $default;
}
function getInt($key, $default = 0) {
    return isset($_POST[$key]) && $_POST[$key] !== '' ? intval($_POST[$key]) : $default;
}
function getCheck($key) {
    return isset($_POST[$key]) ? 1 : 0;
}

// Get all values
$preferred_course = getVal('preferred_course');
$test_centre = getVal('test_centre');
$title = getVal('title');
$first_name = getVal('first_name');
$middle_name = getVal('middle_name');
$last_name = getVal('last_name');
$nationality = getVal('nationality', 'India');
$date_of_birth = getVal('date_of_birth');
$mother_tongue = getVal('mother_tongue');
$height = getInt('height');
$weight = getInt('weight');
$faith = getVal('faith');
$state_of_domicile = getVal('state_of_domicile');
$email = getVal('email');
$mobile = getVal('mobile');
$phone_home = getVal('phone_home');

$address_line1 = getVal('address_line1');
$address_line2 = getVal('address_line2');
$city = getVal('city');
$pincode = getVal('pincode');
$state = getVal('state');

$father_first_name = getVal('father_first_name');
$father_middle_name = getVal('father_middle_name');
$father_last_name = getVal('father_last_name');
$father_age = getInt('father_age');
$father_occupation = getVal('father_occupation');
$father_email = getVal('father_email');
$father_phone = getVal('father_phone');
$father_working = getVal('father_working', 'No');
$father_address_line1 = getVal('father_address_line1');
$father_address_line2 = getVal('father_address_line2');
$father_pincode = getVal('father_pincode');
$father_city = getVal('father_city');
$father_state = getVal('father_state');

$mother_first_name = getVal('mother_first_name');
$mother_middle_name = getVal('mother_middle_name');
$mother_last_name = getVal('mother_last_name');
$mother_age = getInt('mother_age');
$mother_occupation = getVal('mother_occupation');
$mother_phone = getVal('mother_phone');
$mother_address_line1 = getVal('mother_address_line1');
$mother_address_line2 = getVal('mother_address_line2');
$mother_pincode = getVal('mother_pincode');
$mother_city = getVal('mother_city');
$mother_state = getVal('mother_state');

$language1_name = getVal('language1_name');
$language1_read = getCheck('language1_read');
$language1_write = getCheck('language1_write');
$language1_speak = getCheck('language1_speak');

$language2_name = getVal('language2_name');
$language2_read = getCheck('language2_read');
$language2_write = getCheck('language2_write');
$language2_speak = getCheck('language2_speak');

$language3_name = getVal('language3_name');
$language3_read = getCheck('language3_read');
$language3_write = getCheck('language3_write');
$language3_speak = getCheck('language3_speak');

$language4_name = getVal('language4_name');
$language4_read = getCheck('language4_read');
$language4_write = getCheck('language4_write');
$language4_speak = getCheck('language4_speak');

$edu_x_school = getVal('edu_x_school');
$edu_x_year = getVal('edu_x_year');
$edu_x_marks = getVal('edu_x_marks');
$edu_x_subjects = getVal('edu_x_subjects');

$edu_xii_school = getVal('edu_xii_school');
$edu_xii_year = getVal('edu_xii_year');
$edu_xii_marks = getVal('edu_xii_marks');
$edu_xii_subjects = getVal('edu_xii_subjects');

// References
$ref1_name = getVal('ref1_name');
$ref1_occupation = getVal('ref1_occupation');
$ref1_designation = getVal('ref1_designation');
$ref1_known_years = getInt('ref1_known_years');
$ref1_address = getVal('ref1_address');

$ref2_name = getVal('ref2_name');
$ref2_occupation = getVal('ref2_occupation');
$ref2_designation = getVal('ref2_designation');
$ref2_known_years = getInt('ref2_known_years');
$ref2_address = getVal('ref2_address');

$terms_accepted = getCheck('terms_accepted');

// ✅ Columns (86 columns, last one is created_at)
$columns = "application_number, preferred_course, test_centre, title, first_name, middle_name, last_name,
    nationality, date_of_birth, mother_tongue, height, weight, faith, state_of_domicile,
    email, mobile, phone_home, applicant_photo, applicant_signature,
    address_line1, address_line2, city, pincode, state,
    father_first_name, father_middle_name, father_last_name, father_age, father_occupation,
    father_email, father_phone, father_working, father_address_line1, father_address_line2,
    father_pincode, father_city, father_state,
    mother_first_name, mother_middle_name, mother_last_name, mother_age, mother_occupation, mother_phone,
    mother_address_line1, mother_address_line2, mother_pincode, mother_city, mother_state,
    language1_name, language1_read, language1_write, language1_speak,
    language2_name, language2_read, language2_write, language2_speak,
    language3_name, language3_read, language3_write, language3_speak,
    language4_name, language4_read, language4_write, language4_speak,
    edu_x_school, edu_x_year, edu_x_marks, edu_x_subjects,
    edu_xii_school, edu_xii_year, edu_xii_marks, edu_xii_subjects,
    ref1_name, ref1_occupation, ref1_designation, ref1_known_years, ref1_address,
    ref2_name, ref2_occupation, ref2_designation, ref2_known_years, ref2_address,
    terms_accepted, status, payment_status, created_at";

// ✅ Values array (everything except created_at)
$values = [
    $application_number, $preferred_course, $test_centre, $title, $first_name, $middle_name, $last_name,
    $nationality, $date_of_birth, $mother_tongue, $height, $weight, $faith, $state_of_domicile,
    $email, $mobile, $phone_home, $photo_path, $signature_path,
    $address_line1, $address_line2, $city, $pincode, $state,
    $father_first_name, $father_middle_name, $father_last_name, $father_age, $father_occupation,
    $father_email, $father_phone, $father_working, $father_address_line1, $father_address_line2,
    $father_pincode, $father_city, $father_state,
    $mother_first_name, $mother_middle_name, $mother_last_name, $mother_age, $mother_occupation, $mother_phone,
    $mother_address_line1, $mother_address_line2, $mother_pincode, $mother_city, $mother_state,
    $language1_name, $language1_read, $language1_write, $language1_speak,
    $language2_name, $language2_read, $language2_write, $language2_speak,
    $language3_name, $language3_read, $language3_write, $language3_speak,
    $language4_name, $language4_read, $language4_write, $language4_speak,
    $edu_x_school, $edu_x_year, $edu_x_marks, $edu_x_subjects,
    $edu_xii_school, $edu_xii_year, $edu_xii_marks, $edu_xii_subjects,
    $ref1_name, $ref1_occupation, $ref1_designation, $ref1_known_years, $ref1_address,
    $ref2_name, $ref2_occupation, $ref2_designation, $ref2_known_years, $ref2_address,
    $terms_accepted, 'pending', 'pending'
];

// ✅ Build placeholders dynamically based on values count + NOW() for created_at
$placeholders = rtrim(str_repeat('?,', count($values)), ',') . ',NOW()';

$sql = "INSERT INTO applications_exact ($columns) VALUES ($placeholders)";
$stmt = $conn->prepare($sql);

if (!$stmt) {
    die('Prepare failed: ' . $conn->error);
}

// ✅ Build types string safely
$types = '';
foreach ($values as $value) {
    $types .= (is_int($value) ? 'i' : 's');
}

$stmt->bind_param($types, ...$values);

if ($stmt->execute()) {
    $stmt->close();
    $conn->close();

$_SESSION['application_number'] = $application_number;

header('Location: payment_process.php?application_number=' . urlencode($application_number));
    exit;
} else {
    die('Execute failed: ' . $stmt->error);
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: submit_application.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation