Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-687.39.1.el9_8.x86_64

PHP Version:

8.2.33

User:

flightbo

Directory:

/home2/flightbo/public_html/ibvte.com

Free Space:

130.46 GB

🔧 Quick Actions

✏️ Editing: create_tables2.php

<?php
$dsn = "mysql:host=127.0.0.1;dbname=ibvte;charset=utf8mb4";
$pdo = new PDO($dsn, 'root', '', [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);

$pdo->exec("CREATE TABLE IF NOT EXISTS notifications (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    content TEXT,
    image_path VARCHAR(255),
    pdf_path VARCHAR(255),
    is_marquee TINYINT(1) DEFAULT 0,
    status ENUM('active', 'inactive') DEFAULT 'active',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)");

$pdo->exec("CREATE TABLE IF NOT EXISTS sliders (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255),
    description TEXT,
    image_path VARCHAR(255) NOT NULL,
    button_text VARCHAR(100),
    button_link VARCHAR(255),
    status ENUM('active', 'inactive') DEFAULT 'active',
    display_order INT DEFAULT 0,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)");

try { $pdo->exec("ALTER TABLE student_results ADD COLUMN semester INT DEFAULT 1"); } catch(Exception $e) {}
try { $pdo->exec("ALTER TABLE students ADD COLUMN current_semester INT DEFAULT 1"); } catch(Exception $e) {}
try { $pdo->exec("ALTER TABLE students ADD COLUMN course_duration_years INT DEFAULT 1"); } catch(Exception $e) {}

echo "Done.\n";

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: create_tables2.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation