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

Free Space:

10.31 TB

🔧 Quick Actions

✏️ Editing: get-villages.php

<?php
require_once 'includes/db.php';

header('Content-Type: text/html');

if (isset($_GET['panchayat_id'])) {
    $panchayat_id = intval($_GET['panchayat_id']);
    
    // Get panchayat name
    $panchayatQuery = "SELECT name FROM panchayats WHERE id = ?";
    $stmt = mysqli_prepare($conn, $panchayatQuery);
    mysqli_stmt_bind_param($stmt, "i", $panchayat_id);
    mysqli_stmt_execute($stmt);
    $panchayatResult = mysqli_stmt_get_result($stmt);
    $panchayat = mysqli_fetch_assoc($panchayatResult);
    
    // Get villages for this panchayat
    $query = "
        SELECT v.id, v.name, v.pincode 
        FROM villages v 
        WHERE v.panchayat_id = ? AND v.status = 'active'
        ORDER BY v.name ASC
    ";
    
    $stmt = mysqli_prepare($conn, $query);
    mysqli_stmt_bind_param($stmt, "i", $panchayat_id);
    mysqli_stmt_execute($stmt);
    $result = mysqli_stmt_get_result($stmt);
    
    if (mysqli_num_rows($result) == 0) {
        echo '
        <div class="bg-white rounded-lg shadow p-6 max-w-4xl mx-auto">
            <h2 class="text-lg md:text-xl font-semibold text-secondary mb-6 pb-3 border-b border-gray-200">
                Villages in ' . htmlspecialchars($panchayat['name']) . '
            </h2>
            <div class="text-center py-8">
                <i class="fas fa-map text-4xl text-neutral mb-3"></i>
                <h3 class="text-lg font-semibold text-dark mb-1">No Villages Available</h3>
                <p class="text-neutral text-sm">There are no villages listed for this panchayat yet.</p>
            </div>
        </div>';
    } else {
        echo '
        <div class="bg-white rounded-lg shadow p-6 max-w-4xl mx-auto">
            <h2 class="text-lg md:text-xl font-semibold text-secondary mb-6 pb-3 border-b border-gray-200">
                Villages in ' . htmlspecialchars($panchayat['name']) . '
            </h2>
            <div class="space-y-2">';
        
        while ($village = mysqli_fetch_assoc($result)) {
            echo '
            <div class="village-item p-4 rounded-lg border border-gray-100 bg-highlight/30">
                <div class="flex items-center">
                    <i class="fas fa-map-marker-alt text-primary mr-3 text-lg"></i>
                    <div>
                        <h3 class="text-dark font-semibold text-base md:text-lg">' . htmlspecialchars($village['name']) . '</h3>
                        ' . ($village['pincode'] ? '<p class="text-neutral text-sm mt-1">Pincode: ' . htmlspecialchars($village['pincode']) . '</p>' : '') . '
                    </div>
                </div>
            </div>';
        }
        
        echo '</div></div>';
    }
} else {
    echo '<div class="text-center text-red-500">Invalid request</div>';
}

if (isset($conn)) {
    mysqli_close($conn);
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: get-villages.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation