File Manager

Editing:settings.php

<?php 
include 'header.php';

// Auto-initialize banners table if it doesn't exist
$conn->query("CREATE TABLE IF NOT EXISTS banners (
    id INT PRIMARY KEY AUTO_INCREMENT,
    image VARCHAR(255) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)");

// Auto-initialize about_image setting if missing
$conn->query("INSERT IGNORE INTO settings (setting_key, setting_value) VALUES ('about_image', 'banner.png')");

$message = "";

// Handle Settings Updates
if(isset($_POST['update_whatsapp'])) {
    if(!empty($_POST['whatsapp_number'])) {
        updateSetting('whatsapp_number', $_POST['whatsapp_number']);
        $message = "WhatsApp number updated!";
    }
}

// Handle Banner Addition
if(isset($_POST['add_banner'])) {
    if(!empty($_FILES['banner_image']['name'])) {
        $banner = "banner_" . time() . "_" . $_FILES['banner_image']['name'];
        if(move_uploaded_file($_FILES['banner_image']['tmp_name'], "../assets/img/" . $banner)) {
            $stmt = $conn->prepare("INSERT INTO banners (image) VALUES (?)");
            $stmt->bind_param("s", $banner);
            $stmt->execute();
            $message = "Banner added successfully!";
        }
    }
}

// Handle Banner Deletion
if(isset($_GET['delete_banner'])) {
    $id = intval($_GET['delete_banner']);
    $res = $conn->query("SELECT image FROM banners WHERE id = $id");
    if($row = $res->fetch_assoc()) {
        $img_path = "../assets/img/" . $row['image'];
        if(file_exists($img_path)) unlink($img_path);
        $conn->query("DELETE FROM banners WHERE id = $id");
        $message = "Banner deleted!";
    }
}

// Handle About Image Update
if(isset($_POST['update_about_image'])) {
    if(!empty($_FILES['about_image']['name'])) {
        $about_img = "about_" . time() . "_" . $_FILES['about_image']['name'];
        if(move_uploaded_file($_FILES['about_image']['tmp_name'], "../assets/img/" . $about_img)) {
            updateSetting('about_image', $about_img);
            $message = "About Us image updated!";
        }
    }
}
?>

<div class="mb-4">
    <h2>Site Settings</h2>
</div>

<?php if($message): ?>
<div class="alert alert-success alert-dismissible fade show" role="alert">
    <?php echo $message; ?>
    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
</div>
<?php endif; ?>

<div class="row">
    
    <div class="col-md-6 mb-4">
        <div class="card p-4 h-100">
            <h4><i class="fa fa-address-book me-2"></i> Contact Details</h4>
            <hr>
            <form action="settings.php" method="POST">
                <div class="mb-3">
                    <label class="form-label">WhatsApp Number (e.g., 94771234567)</label>
                    <input type="text" name="whatsapp_number" class="form-control" value="<?php echo getSetting('whatsapp_number'); ?>" required>
                </div>
                <div class="mb-3">
                    <label class="form-label">Store Address</label>
                    <textarea name="site_address" class="form-control" rows="3" required><?php echo getSetting('site_address'); ?></textarea>
                </div>
                <button type="submit" name="update_contact" class="btn btn-primary">Update Contact Info</button>
            </form>
        </div>
    </div>
<?php
// Add update logic for contact info
if(isset($_POST['update_contact'])) {
    updateSetting('whatsapp_number', $_POST['whatsapp_number']);
    updateSetting('site_address', $_POST['site_address']);
    echo "<script>window.location.href='settings.php';</script>";
}
?>

<div class="col-md-6 mb-4">
        <div class="card p-4 h-100">
            <h4><i class="fa fa-info-circle me-2"></i> About Us Image</h4>
            <hr>
            <form action="settings.php" method="POST" enctype="multipart/form-data">
                <div class="mb-3 text-center">
                    <?php 
                    $about_img = getSetting('about_image');
                    if(!$about_img) $about_img = 'banner.png'; // Fallback
                    ?>
                    <img src="../assets/img/<?php echo $about_img; ?>" class="img-fluid rounded mb-3" style="max-height: 150px;">
                </div>
                <div class="mb-3">
                    <label class="form-label">Change About Image</label>
                    <input type="file" name="about_image" class="form-control" required>
                </div>
                <button type="submit" name="update_about_image" class="btn btn-primary">Update About Image</button>
            </form>
        </div>
    </div>
    
    
    <div class="col-12">
        <div class="card p-4 mb-4">
            <h4><i class="fa fa-images me-2"></i> Homepage Banner Slider</h4>
            <hr>
            <div class="row">
                <div class="col-md-4">
                    <h5>Add New Banner</h5>
                    <form action="settings.php" method="POST" enctype="multipart/form-data">
                        <div class="mb-3">
                            <label class="form-label">Select Banner Image</label>
                            <input type="file" name="banner_image" class="form-control" required>
                            <small class="text-muted">Recommended: 1200x400 pixels</small>
                        </div>
                        <button type="submit" name="add_banner" class="btn btn-success"><i class="fa fa-plus me-1"></i> Add Banner</button>
                    </form>
                </div>
                <div class="col-md-8">
                    <h5>Existing Banners</h5>
                    <div class="table-responsive">
                        <table class="table table-bordered align-middle">
                            <thead class="table-light">
                                <tr>
                                    <th>Preview</th>
                                    <th>Action</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php
                                $banners = $conn->query("SELECT * FROM banners ORDER BY id DESC");
                                if($banners->num_rows > 0):
                                    while($b = $banners->fetch_assoc()):
                                ?>
                                <tr>
                                    <td>
                                        <img src="../assets/img/<?php echo $b['image']; ?>" style="height: 60px; width: 150px; object-fit: cover;" class="rounded">
                                    </td>
                                    <td>
                                        <a href="settings.php?delete_banner=<?php echo $b['id']; ?>" class="btn btn-danger btn-sm" onclick="return confirm('Delete this banner?')">
                                            <i class="fa fa-trash"></i> Delete
                                        </a>
                                    </td>
                                </tr>
                                <?php endwhile; else: ?>
                                <tr>
                                    <td colspan="2" class="text-center text-muted">No banners found. Please add one.</td>
                                </tr>
                                <?php endif; ?>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<?php include 'footer.php'; ?>

Cancel

🤩 File Manager - Mr.X

Editing:settings.php