1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / machineswift.net / admin /
Filename : edit-plan.php
back
<?php
session_start();
error_reporting(0);
include('../../config/config.php');
include('includes/checklogin.php');
check_login();
$title = "Edit Package";
include 'includes/header.php';
include 'includes/sidebar.php';
$currentTime = date('d-m-Y h:i:s A', time());

$pid=($_GET['id']);


if(isset($_POST['submit'])) {
    $name = $_POST['name'];
    $min = $_POST['min'];
    $max = $_POST['max'];
    $referralBonus = $_POST['ref'];
    $support = $_POST['support'];
    $numberOfDays = $_POST['days'];
    $profitRateDescription = $_POST['rate'];
    $profitPercentage = $_POST['profit'];

    // TODO: Update the existing package in the database using appropriate SQL query
    if(isset($_POST['submit'])) {
        $name = mysqli_real_escape_string($con, $_POST['name']);
        $min = mysqli_real_escape_string($con, $_POST['min']);
        $max = mysqli_real_escape_string($con, $_POST['max']);
        $referralBonus = mysqli_real_escape_string($con, $_POST['ref']);
        $support = mysqli_real_escape_string($con, $_POST['support']);
        $numberOfDays = mysqli_real_escape_string($con, $_POST['days']);
        $profitRateDescription = mysqli_real_escape_string($con, $_POST['rate']);
        $profitPercentage = mysqli_real_escape_string($con, $_POST['profit']);
    
        $sql = "UPDATE `investment_plans`
                SET `name` = '$name',
                    `min` = '$min',
                    `max` = '$max',
                    `referral_bonus` = '$referralBonus',
                    `support` = '$support',
                    `days` = '$numberOfDays',
                    `description` = '$profitRateDescription',
                    `profit` = '$profitPercentage'
                WHERE `id` = '$pid'";
    
        $result = mysqli_query($con, $sql);
        
        if($result) {
            $msg = "Package Updated Successfully";
            $type = "success";
        } else {
            $msg = "Something went wrong. Please try again";
            $type = "warning";
        }
    }
    
   
}

// Retrieve the existing package details from the database (Replace 'your_table_name' with the actual table name)
$sql = "SELECT * FROM `investment_plans` WHERE `id` = '$pid'";
$result = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($result);

?>

<!-- partial -->
<div class="main-panel">
    <div class="content-wrapper">
        <div class="page-header"></div>
        <div class="row">
            <div class="col-12 stretch-card">
                <div class="card">
                    <div class="card-body custom-column">
                        <h4 class="card-title">Edit Package</h4>
                        <p class="card-description"></p>
                        <div class="custom-row">
                            <div class="col-12">
                                <br>
                                <?php if(isset($msg)){ ?>
                    <div class="alert alert-<?php echo $type?>">
                          <h6 class="alert-heading fw-bold mb-1"><?php echo $type?></h6>
                          <p class="mb-0"><?php echo $msg?></p>
                        </div>
                        <?php }?>
                                <form class="" method="post" action="">
                                    <div class="mb-3 col-md-6">
                                        <label>Name</label>
                                        <input type="text" name="name" class="form-control" placeholder="eg. Pro-Stater" required value="<?php echo $row['name']; ?>">
                                    </div>
                                    <div class="mb-3 col-md-6">
                                        <label>Minimum Deposit(USDT)</label>
                                        <input type="text" name="min" class="form-control" placeholder="eg. 100" required value="<?php echo $row['min']; ?>">
                                    </div>
                                    <div class="mb-3 col-md-6">
                                        <label>Maximum Deposit(USDT)</label>
                                        <input type="text" name="max" class="form-control" placeholder="eg.500" required value="<?php echo $row['max']; ?>">
                                    </div>
                                    <div class="mb-3 col-md-6">
                                        <label>Referral Bonus(%)</label>
                                        <input type="text" name="ref" class="form-control" placeholder="e.g 5" required value="<?php echo $row['referral_bonus']; ?>">
                                    </div>
                                    <div class="mb-3 col-md-6">
                                        <label>Support</label>
                                        <input type="text" name="support" class="form-control" placeholder="e.g Full, Partial" required value="<?php echo $row['support']; ?>">
                                    </div>
                                    <div class="mb-3 col-md-6">
                                        <label>Number of Days</label>
                                        <input type="text" name="days" class="form-control" placeholder="e.g 7, 10, 30" required value="<?php echo $row['days']; ?>">
                                    </div>
                                    <div class="mb-3 col-md-6">
                                        <label>Profit Rate Description</label>
                                        <input type="text" name="rate" class="form-control" placeholder="e.g hourly, daily, weekly, for 60 days, per annum" required value="<?php echo $row['description']; ?>">
                                    </div>
                                    <div class="mb-3 col-md-6">
                                        <label>Profit (%)</label>
                                        <input type="text" name="profit" class="form-control" placeholder="e.g 2, 5, 9.5, 10" required value="<?php echo $row['profit']; ?>">
                                    </div>
                                    <button type="submit" class="btn btn-primary" name="submit">Save</button>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

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

<?php include 'includes/footer.php' ?>