Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/demo.sigmacomputers.in/public_html/avatar_coupon/admin

Free Space:

4.08 TB

🔧 Quick Actions

✏️ Editing: editcoupon.php

<?php 
include ('header.php');
if (!isset($_GET['id']) || empty($_GET['id'])) {
    echo "<script>alert('Invalid request.'); window.location.href='couponlist.php';</script>";
    exit;
}

$coupon_id = intval($_GET['id']);

// if ($coupon_id <= 0) {
//     echo "<script>alert('Invalid Coupon ID'); window.location.href='couponlist.php';</script>";
//     exit;
// }

// Fetch existing coupon data
$sql_fetch = "SELECT * FROM coupon WHERE coupon_id = $coupon_id";
$result_fetch = mysqli_query($con, $sql_fetch);

if (!$result_fetch || mysqli_num_rows($result_fetch) == 0) {
    echo "<script>alert('Coupon not found'); window.location.href='couponlist.php';</script>";
    exit;
}

$coupon_data = mysqli_fetch_assoc($result_fetch);

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $coupon_amount = $_POST['coupon_amount'];
    $coupon_name = $_POST['coupon_name'];
    $member_type = $_POST['member_type'];
    $no_of_coupons = $_POST['no_of_coupons'];
    $ref_status_id = $_POST['ref_status_id'];

$sql_update = "UPDATE coupon SET 
        coupon_amount = '$coupon_amount',
        coupon_name = '$coupon_name',
        member_type = '$member_type',
        no_of_coupons = '$no_of_coupons',
        ref_status_id = '$ref_status_id'
        WHERE coupon_id = $coupon_id";

if (mysqli_query($con, $sql_update)) {
        echo "<script>
            alert('Coupon updated successfully!');
            window.location.href = 'couponlist.php';
        </script>";
        exit;
    } else {
        echo "<script>alert('Error updating coupon.');</script>";
    }
}
?>

<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-sm-flex align-items-center justify-content-between">
                        <h4 class="mb-sm-0">Edit Coupon</h4>
                        <div class="page-title-right">
                            <ol class="breadcrumb m-0">
                                <li class="breadcrumb-item"><a href="javascript:void(0);">Home</a></li>
                                <li class="breadcrumb-item active">Edit Coupon</li>
                            </ol>
                        </div>
                    </div>
                </div>
            </div>

<div class="row">
                <div class="col-xl">
                    <div class="card mb-4">
                        <div class="card-header text-center">
                            <h3 style="color: #20478a;" class="mb-0">Edit Coupon</h3>
                        </div>
                        <div class="card-body">
                            <form action="" method="post" enctype="multipart/form-data">
                                <div class="card-body">
                                    <div class="row">

<div class="col-md-3">
                                            <label><b>Member Type</b></label>
                                            <select class="form-control" name="member_type" required>
                                                <option value="">Choose...</option>
                                                <?php
                                                    $mem_sql = "SELECT * FROM member_type ORDER BY member_type_id ASC";
                                                    $mem_result = mysqli_query($con, $mem_sql);
                                                    if ($mem_result) {
                                                        while ($row = mysqli_fetch_assoc($mem_result)) {
                                                            $selected = $coupon_data['member_type'] == $row['member_type_id'] ? 'selected' : '';
                                                            echo "<option value='{$row['member_type_id']}' $selected>{$row['member_type_name']}</option>";
                                                        }
                                                    }
                                                ?>
                                            </select>    
                                        </div>

<div class="col-md-3">
                                            <label><b>Coupon Name</b></label>
                                            <input type="text" name="coupon_name" class="form-control" required value="<?= htmlspecialchars($coupon_data['coupon_name']) ?>">
                                        </div>

<div class="col-md-2">
                                            <label><b>Coupon Amount</b></label>
                                            <input type="text" name="coupon_amount" class="form-control" required value="<?= htmlspecialchars($coupon_data['coupon_amount']) ?>">
                                        </div>

<div class="col-md-2">
                                            <label><b>No of Coupons</b></label>
                                            <input type="number" name="no_of_coupons" class="form-control" required value="<?= htmlspecialchars($coupon_data['no_of_coupons']) ?>">
                                        </div>

<div class="col-md-2">
                                            <label><b>Status</b></label>
                                            <select name="ref_status_id" class="form-control" required>
                                                <option value="">-- Select --</option>
                                                <?php
                                                    $status_sql = "SELECT status_id, status_name FROM status ORDER BY status_id ASC";
                                                    $status_result = mysqli_query($con, $status_sql);
                                                    if ($status_result) {
                                                        while ($row = mysqli_fetch_assoc($status_result)) {
                                                            $selected = ($row['status_id'] == $coupon_data['ref_status_id']) ? 'selected' : '';
                                                            echo "<option value='{$row['status_id']}' $selected>{$row['status_name']}</option>";
                                                        }
                                                    }
                                                ?>
                                            </select>
                                        </div>

<div class="row">
                                            <div class="col-md-4"><br>
                                                <input type="submit" class="me-3 btn btn-primary" name="submit" value="Update">
                                                <a href="couponlist.php" class="btn btn-secondary">Cancel</a>
                                            </div>
                                        </div>

</div>
                                </div>
                            </form>
                        </div> 
                    </div> 
                </div>
            </div>
        </div>
    </div>
</div>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: editcoupon.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation