1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / self / root / home / earnlouq / tapnaire.live / manager /
Filename : edit-package.php
back
<?php
session_start();
error_reporting(0);
include('../../config/conn.php');
include('include/checklogin.php');
check_login();
include('include/header.php');
include('include/sidebar.php');
include('include/functions.php');

$title = "Edit Package";

// Get package ID
if (!isset($_GET['id']) || empty($_GET['id'])) {
    header("Location: edit-package.php"); // Redirect if no ID is provided
    exit;
}
$package_id = intval($_GET['id']);

// Fetch package details
$query = mysqli_query($con, "SELECT * FROM plans WHERE pid = '$package_id'");
$package = mysqli_fetch_assoc($query);

// Fetch countries
$countries = mysqli_query($con, "SELECT * FROM countries ORDER BY name ASC");

if (isset($_POST['submit'])) {
    $name = sanitize_input($_POST['name']);
    $country_id = intval($_POST['country_id']);
    $type = sanitize_input($_POST['type']);
    $registration_fee = floatval($_POST['registration_fee']);
    $welcome_bonus = floatval($_POST['welcome_bonus']);
    $affiliate_bonus = floatval($_POST['affiliate_bonus']);
    $first_indirect_bonus = floatval($_POST['first_indirect_bonus']);
    $second_indirect_bonus = floatval($_POST['second_indirect_bonus']);
    $daily_quiz = intval($_POST['daily_quiz']);
    $advert_post = intval($_POST['advert_post']);
    $spin_wheel = intval($_POST['spin_wheel']);

    // Validate inputs
    if (empty($name) || $country_id <= 0 || empty($type)) {
        $msg = "All fields are required.";
        $type = "warning";
    } else {
        // Update package in database
        $sql = "UPDATE plans SET name='$name', country_id='$country_id', type='$type', registration_fee='$registration_fee', welcome_bonus='$welcome_bonus', 
                affiliate_bonus='$affiliate_bonus', first_indirect_bonus='$first_indirect_bonus', second_indirect_bonus='$second_indirect_bonus', 
                daily_quiz='$daily_quiz', advert_post='$advert_post', spin_wheel='$spin_wheel' WHERE pid='$package_id'";
        
        $result = mysqli_query($con, $sql);

        if ($result) {
            $msg = "Package updated successfully.";
            $type = "success";
        } else {
            $msg = "Failed to update package.";
            $type = "warning";
        }
    }
}
?>

<div class="content-wrapper">
    <div class="container-xxl flex-grow-1 container-p-y">
        <h4 class="fw-bold py-3 mb-4"><span class="text-muted fw-light">Edit/</span> Package</h4>
 
        <div class="card mb-4">
            <h5 class="card-header">Edit Package</h5>
            <hr class="my-0" />
            <div class="card-body">
                <?php if(isset($msg)){ ?>
                <div class="alert alert-<?php echo $type; ?>">
                    <h6 class="alert-heading fw-bold mb-1"> <?php echo ucfirst($type); ?></h6>
                    <p class="mb-0"> <?php echo $msg; ?> </p>
                </div>
                <?php } ?>
                <form method="post" action="">
                    <div class="row">
                        <div class="mb-3 col-md-6">
                            <label class="form-label">Package Name</label>
                            <input type="text" class="form-control" name="name" value="<?php echo $package['name']; ?>" required />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label">Country</label>
                            <select class="form-control" name="country_id" required>
                                <option value="">Select Country</option>
                                <?php while ($row = mysqli_fetch_assoc($countries)) { ?>
                                    <option value="<?php echo $row['id']; ?>" <?php if ($package['country_id'] == $row['id']) echo 'selected'; ?>>
                                        <?php echo $row['name']; ?>
                                    </option>
                                <?php } ?>
                            </select>
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label">Package Type</label>
                            <select class="form-control" name="type" required>
                                <option value="Lower" <?php if ($package['type'] == 'Lower') echo 'selected'; ?>>Lower</option>
                                <option value="Higher" <?php if ($package['type'] == 'Higher') echo 'selected'; ?>>Higher</option>
                            </select>
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label">Registration Fee (₦)</label>
                            <input type="number" class="form-control" name="registration_fee" value="<?php echo $package['registration_fee']; ?>" required />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label">Welcome Bonus</label>
                            <input type="number" class="form-control" name="welcome_bonus" value="<?php echo $package['welcome_bonus']; ?>" required />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label">Affiliate Bonus</label>
                            <input type="number" class="form-control" name="affiliate_bonus" value="<?php echo $package['affiliate_bonus']; ?>" required />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label">First Indirect Bonus</label>
                            <input type="number" class="form-control" name="first_indirect_bonus" value="<?php echo $package['first_indirect_bonus']; ?>" required />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label">Second Indirect Bonus</label>
                            <input type="number" class="form-control" name="second_indirect_bonus" value="<?php echo $package['second_indirect_bonus']; ?>" required />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label">Daily Quiz</label>
                            <input type="number" class="form-control" name="daily_quiz" value="<?php echo $package['daily_quiz']; ?>" required />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label">Advert Post</label>
                            <input type="number" class="form-control" name="advert_post" value="<?php echo $package['advert_post']; ?>" required />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label">Spin Wheel</label>
                            <input type="number" class="form-control" name="spin_wheel" value="<?php echo $package['spin_wheel']; ?>" required />
                        </div>
                    </div>
                    <div class="mt-2">
                        <button type="submit" class="btn btn-primary" name="submit">Update Package</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>

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