1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / self / root / home / earnlouq / qarkt.com / admin /
Filename : edit-paypal-link.php
back
<?php
session_start();
error_reporting(0);
include('../../config/qaconfig.php');
include('include/checklogin.php');
check_login();
include('include/header.php');
include('include/sidebar.php');
$title = "Edit PayPal Link";

// Check if id is provided and fetch current data
if (isset($_GET['id'])) {
    $id = intval($_GET['id']);
    $query = "SELECT * FROM paypal_links WHERE id = $id";
    $result = mysqli_query($con, $query);
    $row = mysqli_fetch_array($result);

    if (!$row) {
        $msg = "Record not found!";
        $type = "warning";
    } else {
        // Populate existing data into variables
        $currency = $row['currency'];
        $address_name = $row['address_name'];
        $transfer_option = $row['transfer_option'];
        $available_time = $row['available_time'];
        $amount = $row['amount'];
        $is_visible = $row['is_visible'];
    }
}

// Update record on form submission
if (isset($_POST['submit'])) {
    $currency = $_POST['currency'];
    $address_name = $_POST['address_name'];
    $transfer_option = $_POST['transfer_option'];
    $available_time = $_POST['available_time'];
    $amount = $_POST['amount'];
    $is_visible = $_POST['is_visible'];

    if (empty($currency) || empty($address_name) || empty($transfer_option) || empty($amount)) {
        $msg = "All fields are required";
        $type = "warning";
    } else {
        // Sanitize inputs
        $currency = mysqli_real_escape_string($con, $currency);
        $address_name = mysqli_real_escape_string($con, $address_name);
        $transfer_option = mysqli_real_escape_string($con, $transfer_option);
        $available_time = mysqli_real_escape_string($con, $available_time);
        $amount = mysqli_real_escape_string($con, $amount);
        $is_visible = mysqli_real_escape_string($con, $is_visible);

        // Update query
        $updateQuery = "UPDATE paypal_links SET 
                        currency = '$currency', 
                        address_name = '$address_name', 
                        transfer_option = '$transfer_option', 
                        available_time = '$available_time', 
                        amount = '$amount', 
                        is_visible = '$is_visible', 
                        updated_at = NOW() 
                        WHERE id = $id";

        if (mysqli_query($con, $updateQuery)) {
            $msg = "PayPal link updated successfully!";
            $type = "success";
        } else {
            $msg = "Something went wrong, please try again.";
            $type = "warning";
        }
    }
}
?>

<!-- Content wrapper -->
<div class="content-wrapper">
    <!-- Content -->
    <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> PayPal Link</h4>
        
        <div class="card mb-4">
            <h5 class="card-header">Edit PayPal Link</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" for="currency">Currency</label>
                            <input type="text" class="form-control" name="currency" value="<?php echo htmlentities($currency); ?>" required />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="address_name">Address Name</label>
                            <input type="text" class="form-control" name="address_name" value="<?php echo htmlentities($address_name); ?>" required />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="transfer_option">Transfer Option</label>
                            <input type="text" class="form-control" name="transfer_option" value="<?php echo htmlentities($transfer_option); ?>" required />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="available_time">Available Time</label>
                            <input type="text" class="form-control" name="available_time" value="<?php echo htmlentities($available_time); ?>" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="amount">Amount</label>
                            <input type="number" step="0.01" class="form-control" name="amount" value="<?php echo htmlentities($amount); ?>" required />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="is_visible">Active</label>
                            <select class="form-control" name="is_visible" required>
                                <option value="1" <?php if ($is_visible == 1) echo 'selected'; ?>>Yes</option>
                                <option value="0" <?php if ($is_visible == 0) echo 'selected'; ?>>No</option>
                            </select>
                        </div>
                    </div>
                    <div class="mt-2">
                        <button type="submit" class="btn btn-primary me-2" name="submit">Save Changes</button>
                        <a href="list-paypal-links.php" class="btn btn-secondary">Cancel</a>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>
<!-- / Content -->

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