Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-611.26.1.el9_7.x86_64

PHP Version:

8.4.15

User:

u892747680

Directory:

/home/u892747680/domains/sisteminformasic.com/public_html/freshfruty

Free Space:

9.68 TB

🔧 Quick Actions

✏️ Editing: install_va_table.php

<?php
// install_va_table.php
// Jalankan file ini di browser: http://localhost/freshfruty/install_va_table.php

require_once 'config/database.php';

try {
    $database = new Database();
    $db = $database->getConnection();

$sql = "CREATE TABLE IF NOT EXISTS `virtual_accounts` (
        `id` INT(11) PRIMARY KEY AUTO_INCREMENT,
        `order_id` INT(11) NOT NULL,
        `customer_id` INT(11) NOT NULL,
        `payment_method` VARCHAR(100) NOT NULL,
        `virtual_account_number` VARCHAR(100) UNIQUE NOT NULL,
        `amount` BIGINT(20) NOT NULL,
        `status` ENUM('active', 'expired', 'paid') DEFAULT 'active',
        `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        `expires_at` TIMESTAMP NULL DEFAULT NULL,
        `paid_at` TIMESTAMP NULL,
        FOREIGN KEY (order_id) REFERENCES orders(id) ON DELETE CASCADE,
        FOREIGN KEY (customer_id) REFERENCES customers(id) ON DELETE CASCADE,
        INDEX idx_order_id (order_id),
        INDEX idx_customer_id (customer_id),
        INDEX idx_virtual_account_number (virtual_account_number),
        INDEX idx_status (status)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;";

$db->exec($sql);
    echo "<h1>Berhasil!</h1><p>Tabel 'virtual_accounts' berhasil dibuat. Silakan refresh halaman admin.</p>";
} catch(PDOException $e) {
    echo "<h1>Error</h1><p>" . $e->getMessage() . "</p>";
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: install_va_table.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation