Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/pennagaram.org/public_html/admin

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: test_banners.php

<?php
include('includes/db.php');

echo "<h2>Database Connection Test</h2>";

// Test connection
if ($conn) {
    echo "✓ Database connected successfully<br>";
    
    // Test table exists
    $result = mysqli_query($conn, "SHOW TABLES LIKE 'hero_banners'");
    if (mysqli_num_rows($result) > 0) {
        echo "✓ Table 'hero_banners' exists<br>";
        
        // Show table structure
        $structure = mysqli_query($conn, "DESCRIBE hero_banners");
        echo "<h3>Table Structure:</h3>";
        echo "<table border='1'>";
        echo "<tr><th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th></tr>";
        while ($row = mysqli_fetch_assoc($structure)) {
            echo "<tr>";
            echo "<td>{$row['Field']}</td>";
            echo "<td>{$row['Type']}</td>";
            echo "<td>{$row['Null']}</td>";
            echo "<td>{$row['Key']}</td>";
            echo "<td>{$row['Default']}</td>";
            echo "<td>{$row['Extra']}</td>";
            echo "</tr>";
        }
        echo "</table>";
        
        // Test insert
        echo "<h3>Test Insert:</h3>";
        $testSql = "INSERT INTO hero_banners (title, image_path, status, display_order) 
                   VALUES ('Test Banner', 'test.jpg', 'active', 1)";
        if (mysqli_query($conn, $testSql)) {
            echo "✓ Test insert successful<br>";
            $testId = mysqli_insert_id($conn);
            echo "✓ Last insert ID: $testId<br>";
            
            // Clean up test data
            mysqli_query($conn, "DELETE FROM hero_banners WHERE title = 'Test Banner'");
        } else {
            echo "✗ Test insert failed: " . mysqli_error($conn) . "<br>";
        }
        
    } else {
        echo "✗ Table 'hero_banners' does not exist<br>";
    }
} else {
    echo "✗ Database connection failed<br>";
}

// Check current banners
echo "<h3>Current Banners:</h3>";
$result = mysqli_query($conn, "SELECT COUNT(*) as count FROM hero_banners");
$row = mysqli_fetch_assoc($result);
echo "Total banners in database: " . $row['count'] . "<br>";

mysqli_close($conn);
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: test_banners.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation