1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / jeffautomobileinc.com / admin /
Filename : edit-card-link.php
back
<?php
session_start();
error_reporting(0);
include('../../config/jaconfig.php');
include('include/checklogin.php');
check_login();
include('include/header.php');
include('include/sidebar.php');
$title = "Edit Credit Card Link";

// Check if id is provided and fetch current data
if (isset($_GET['id'])) {
    $id = intval($_GET['id']);
    $query = "SELECT * FROM card_link 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'];
        $instruction = $row['instruction'];
        $link = $row['funding_link'];
        $is_visible = $row['is_visible'];
    }
}

// Update record on form submission
if (isset($_POST['submit'])) {
    $currency = $_POST['currency'];
    $link = $_POST['link'];
    $instruction = $_POST['instruction'];
    $is_visible = $_POST['is_visible'];

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

        // Update query
        $updateQuery = "UPDATE card_link SET currency = '$currency', funding_link = '$link', is_visible = '$is_visible', `instruction`='$instruction' WHERE id = $id";

        if (mysqli_query($con, $updateQuery)) {
            $msg = "Credit Card 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> Credit Card 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="link">Link</label>
                            <input type="text" class="form-control" name="link" value="<?php echo htmlentities($link); ?>" required />
                        </div>
                        <div class="mb-3 col-md-6">
							<label class="form-label" for="basicinput">Instruction</label>
							<textarea name="instruction" id="instruction" class="form-control"><?php echo htmlspecialchars($instruction); ?></textarea>
						</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-card-links.php" class="btn btn-secondary">Cancel</a>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>
<!-- / Content -->


<!-- Include CKEditor 4 -->
<script src="https://cdn.ckeditor.com/4.21.0/standard/ckeditor.js"></script>

<!-- Initialize CKEditor -->
<script>
    CKEDITOR.replace('instruction', {
        height: 300,
        removePlugins: 'elementspath',
        resize_enabled: true,
        toolbar: [
            { name: 'document', items: ['Source', '-', 'Preview'] },
            { name: 'basicstyles', items: ['Bold', 'Italic', 'Underline', 'Strike'] },
            { name: 'paragraph', items: ['NumberedList', 'BulletedList', '-', 'Outdent', 'Indent', '-', 'Blockquote'] },
            { name: 'links', items: ['Link', 'Unlink'] },
            { name: 'insert', items: ['Image', 'Table', 'HorizontalRule'] },
            { name: 'styles', items: ['Format', 'Font', 'FontSize'] },
            { name: 'colors', items: ['TextColor', 'BGColor'] }
        ]
    });
</script>
<?php include('include/footer.php'); ?>