Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-611.41.1.el9_7.x86_64

PHP Version:

8.3.30

User:

u838833262

Directory:

/home/u838833262/domains/fsmc.co.in/public_html

Free Space:

10.04 TB

🔧 Quick Actions

✏️ Editing: setup_db.php

<?php
$servername = "localhost";
$username = "u838833262_fsmc";
$password = "Marv@123456";   
$dbname = "u838833262_fsmc";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$queries = [];

// Admin Users
$queries[] = "CREATE TABLE IF NOT EXISTS admin_users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";

// Partners
$queries[] = "CREATE TABLE IF NOT EXISTS partners (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    image_path VARCHAR(255),
    display_order INT DEFAULT 0,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";

// Impact Stats
$queries[] = "CREATE TABLE IF NOT EXISTS impact_stats (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(100),
    value VARCHAR(50),
    subtitle VARCHAR(255),
    icon VARCHAR(50),
    section VARCHAR(50), -- 'circular_economy' or 'stakeholder'
    display_order INT DEFAULT 0,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";

// Annual Reports
$queries[] = "CREATE TABLE IF NOT EXISTS annual_reports (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255),
    year VARCHAR(10),
    file_path VARCHAR(255),
    cover_image VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";

// Newsletters
$queries[] = "CREATE TABLE IF NOT EXISTS newsletters (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255),
    publish_date DATE,
    file_path VARCHAR(255),
    cover_image VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";

// Blogs
$queries[] = "CREATE TABLE IF NOT EXISTS blogs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255),
    slug VARCHAR(255) UNIQUE,
    content TEXT,
    author VARCHAR(100),
    image_path VARCHAR(255),
    publish_date DATE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";

// Publications
$queries[] = "CREATE TABLE IF NOT EXISTS publications (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255),
    category VARCHAR(100),
    file_path VARCHAR(255),
    cover_image VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";

// Impact Stories
$queries[] = "CREATE TABLE IF NOT EXISTS impact_stories (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255),
    image_path VARCHAR(255),
    description TEXT,
    link VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";

// Media Categories
$queries[] = "CREATE TABLE IF NOT EXISTS media_categories (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL
)";

// Media Gallery
$queries[] = "CREATE TABLE IF NOT EXISTS media_gallery (
    id INT AUTO_INCREMENT PRIMARY KEY,
    category_id INT,
    file_path VARCHAR(255),
    title VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (category_id) REFERENCES media_categories(id) ON DELETE SET NULL
)";

// Contact Enquiries
$queries[] = "CREATE TABLE IF NOT EXISTS contact_enquiries (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100),
    phone VARCHAR(20),
    subject VARCHAR(200),
    message TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";

// Partner With Us Enquiries
$queries[] = "CREATE TABLE IF NOT EXISTS partner_enquiries (
    id INT AUTO_INCREMENT PRIMARY KEY,
    organization_name VARCHAR(150),
    contact_person VARCHAR(100),
    email VARCHAR(100),
    phone VARCHAR(20),
    sector VARCHAR(100),
    message TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";

// Volunteer Enquiries
$queries[] = "CREATE TABLE IF NOT EXISTS volunteer_enquiries (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100),
    phone VARCHAR(20),
    address TEXT,
    message TEXT,
    cv_path VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";

// Work With Us Enquiries
$queries[] = "CREATE TABLE IF NOT EXISTS work_enquiries (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100),
    phone VARCHAR(20),
    position_applied VARCHAR(100),
    message TEXT,
    cv_path VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";

// Site Settings (for Volunteer Guide, etc.)
$queries[] = "CREATE TABLE IF NOT EXISTS site_settings (
    id INT AUTO_INCREMENT PRIMARY KEY,
    setting_key VARCHAR(100) UNIQUE,
    setting_value TEXT
)";

// About Content (General Sections)
$queries[] = "CREATE TABLE IF NOT EXISTS about_content (
    id INT AUTO_INCREMENT PRIMARY KEY,
    section_name VARCHAR(100) UNIQUE,
    title VARCHAR(255),
    content TEXT,
    image_path VARCHAR(255),
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)";

// About Timeline
$queries[] = "CREATE TABLE IF NOT EXISTS about_timeline (
    id INT AUTO_INCREMENT PRIMARY KEY,
    year VARCHAR(20),
    title VARCHAR(255),
    description TEXT,
    image_path VARCHAR(255),
    display_order INT DEFAULT 0,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";

foreach ($queries as $sql) {
    if ($conn->query($sql) === TRUE) {
        // echo "Table created successfully\n";
    } else {
        echo "Error creating table: " . $conn->error . "\n";
    }
}

// Seed default admin (password: admin123)
$admin_check = $conn->query("SELECT * FROM admin_users WHERE username='admin'");
if ($admin_check->num_rows == 0) {
    // Using MD5 for simplicity as requested by similar legacy setups, but password_hash is better. 
    // Given the environment, I'll use password_hash.
    $pass = password_hash("admin123", PASSWORD_DEFAULT);
    $conn->query("INSERT INTO admin_users (username, password) VALUES ('admin', '$pass')");
    echo "Default admin created.\n";
}

// Seed Media Categories
$cats = ['Events', 'Press Release', 'Field Visits', 'Workshops'];
foreach ($cats as $cat) {
    $conn->query("INSERT IGNORE INTO media_categories (name) VALUES ('$cat')"); // Assuming id auto-inc handles uniqueness effectively or check first.
    // simpler:
    $check = $conn->query("SELECT id FROM media_categories WHERE name='$cat'");
    if ($check->num_rows == 0) {
        $conn->query("INSERT INTO media_categories (name) VALUES ('$cat')");
    }
}

// Seed Settings
$conn->query("INSERT IGNORE INTO site_settings (setting_key, setting_value) VALUES ('volunteer_guide', '')");
// checking manually to avoid error if unique constraint hits on generic insert ignore if not supported fully or effectively
$check_set = $conn->query("SELECT id FROM site_settings WHERE setting_key='volunteer_guide'");
if ($check_set->num_rows == 0) {
    $conn->query("INSERT INTO site_settings (setting_key, setting_value) VALUES ('volunteer_guide', '')");
}

echo "Database setup completed.";
$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: setup_db.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation