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/gadadhari.in/public_html

Free Space:

8.3 TB

🔧 Quick Actions

✏️ Editing: fix_database.php

<?php
// fix_database.php
ini_set('display_errors', 1); error_reporting(E_ALL);
$host = 'localhost'; $db = 'u176134211_ihm123'; $user = 'u176134211_ihm123'; $pass = 'Ayushi@0337##';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$db;charset=utf8mb4", $user, $pass);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    echo "<h3>Starting Database Repair...</h3>";

// 1. Update APPLICATIONS table
    $sql_app = "ALTER TABLE applications 
    ADD COLUMN IF NOT EXISTS salutation VARCHAR(10),
    ADD COLUMN IF NOT EXISTS middle_name VARCHAR(50),
    ADD COLUMN IF NOT EXISTS dob DATE,
    ADD COLUMN IF NOT EXISTS nationality VARCHAR(50),
    ADD COLUMN IF NOT EXISTS domicile_state VARCHAR(50),
    ADD COLUMN IF NOT EXISTS mother_tongue VARCHAR(50),
    ADD COLUMN IF NOT EXISTS faith VARCHAR(50),
    ADD COLUMN IF NOT EXISTS address_line1 TEXT,
    ADD COLUMN IF NOT EXISTS city VARCHAR(50),
    ADD COLUMN IF NOT EXISTS state VARCHAR(50),
    ADD COLUMN IF NOT EXISTS pincode VARCHAR(20),
    ADD COLUMN IF NOT EXISTS phone_home VARCHAR(20),
    ADD COLUMN IF NOT EXISTS photo_path VARCHAR(255),
    ADD COLUMN IF NOT EXISTS signature_path VARCHAR(255),
    ADD COLUMN IF NOT EXISTS place VARCHAR(50),
    ADD COLUMN IF NOT EXISTS submitted_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    ADD COLUMN IF NOT EXISTS status VARCHAR(20) DEFAULT 'submitted';";
    $pdo->exec($sql_app);
    echo "✅ 'applications' table updated.<br>";

// 2. Create/Update FAMILY table
    $pdo->exec("CREATE TABLE IF NOT EXISTS application_family (
        id INT AUTO_INCREMENT PRIMARY KEY,
        application_id INT,
        type VARCHAR(20),
        name VARCHAR(100),
        age INT,
        occupation VARCHAR(100),
        email VARCHAR(100),
        mobile VARCHAR(20),
        office_address TEXT
    )");
    echo "✅ 'application_family' table ready.<br>";

// 3. Create/Update EDUCATION table
    $pdo->exec("CREATE TABLE IF NOT EXISTS application_education (
        id INT AUTO_INCREMENT PRIMARY KEY,
        application_id INT,
        level VARCHAR(20),
        institution_name VARCHAR(100),
        year_of_passing VARCHAR(20),
        marks_percent VARCHAR(10),
        subjects TEXT
    )");
    echo "✅ 'application_education' table ready.<br>";

// 4. Create/Update REFERENCES table
    $pdo->exec("CREATE TABLE IF NOT EXISTS application_references (
        id INT AUTO_INCREMENT PRIMARY KEY,
        application_id INT,
        name VARCHAR(100),
        occupation VARCHAR(100),
        phone VARCHAR(20)
    )");
    echo "✅ 'application_references' table ready.<br>";

// 5. Ensure Uploads Folder Exists
    if (!is_dir('uploads')) {
        mkdir('uploads', 0755, true);
        echo "✅ 'uploads' folder created.<br>";
    } else {
        echo "✅ 'uploads' folder exists.<br>";
    }

echo "<h2 style='color:green'>Database Fixed Successfully! Now try submitting the form.</h2>";

} catch (PDOException $e) {
    die("<h2 style='color:red'>Error: " . $e->getMessage() . "</h2>");
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: fix_database.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation