1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / self / root / home / earnlouq / ashtokenrewards.com / manager /
Filename : add-bonus.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="Add Country";
$current_date = date("Y-m-d");

if (isset($_POST['submit'])) {
    $name = sanitize_input($_POST['name']);
    $symbol = sanitize_input($_POST['symbol']);
    $registration_fee = sanitize_input($_POST['registration_fee']);
    $welcome_bonus = sanitize_input($_POST['welcome_bonus']);
    $affiliate_bonus = sanitize_input($_POST['affiliate_bonus']);
    $first_indirect_bonus = sanitize_input($_POST['first_indirect_bonus']);
    $second_indirect_bonus = sanitize_input($_POST['second_indirect_bonus']);
    $daily_visit = sanitize_input($_POST['daily_visit']);
    $sponsored_post = sanitize_input($_POST['sponsored_post']);
    $surveys = sanitize_input($_POST['surveys']);
    $task = sanitize_input($_POST['task']);

    // Validate form data
    if (empty($name) || empty($symbol)) {
        $msg = "Country name and symbol are required.";
        $type = "warning";
    } else {
        // Insert the new country into the database
        $sql = "INSERT INTO `countries` (`name`, `symbol`, `registration_fee`, `welcome_bonus`, `affiliate_bonus`, `first_indirect_bonus`, `second_indirect_bonus`, `daily_visit`, `sponsored_post`, `surveys`, `task`)
                VALUES ('$name', '$symbol', '$registration_fee', '$welcome_bonus', '$affiliate_bonus', '$first_indirect_bonus', '$second_indirect_bonus', '$daily_visit', '$sponsored_post', '$surveys', '$task')";
        
        $result = mysqli_query($con, $sql);

        if ($result) {
            $msg = "Country added successfully.";
            $type = "success";
        } else {
            $msg = "Failed to add country.";
            $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">New/</span> Add Country</h4>
 
        <div class="card mb-4">
            <h5 class="card-header">Add New Country</h5>
            <!-- Account -->
            <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="name">Country Name</label>
                            <input type="text" class="form-control" name="name" value="<?php if(isset($_POST['name'])) echo $_POST['name']; ?>" required />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="symbol">Country Symbol</label>
                            <input type="text" class="form-control" name="symbol" value="<?php if(isset($_POST['symbol'])) echo $_POST['symbol']; ?>" required />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="registration_fee">Registration Fee</label>
                            <input type="text" class="form-control" name="registration_fee" value="<?php if(isset($_POST['registration_fee'])) echo $_POST['registration_fee']; ?>" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="welcome_bonus">Welcome Bonus</label>
                            <input type="text" class="form-control" name="welcome_bonus" value="<?php if(isset($_POST['welcome_bonus'])) echo $_POST['welcome_bonus']; ?>" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="affiliate_bonus">Affiliate Bonus</label>
                            <input type="text" class="form-control" name="affiliate_bonus" value="<?php if(isset($_POST['affiliate_bonus'])) echo $_POST['affiliate_bonus']; ?>" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="first_indirect_bonus">First Indirect Bonus</label>
                            <input type="text" class="form-control" name="first_indirect_bonus" value="<?php if(isset($_POST['first_indirect_bonus'])) echo $_POST['first_indirect_bonus']; ?>" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="second_indirect_bonus">Second Indirect Bonus</label>
                            <input type="text" class="form-control" name="second_indirect_bonus" value="<?php if(isset($_POST['second_indirect_bonus'])) echo $_POST['second_indirect_bonus']; ?>" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="daily_visit">Daily Visit</label>
                            <input type="text" class="form-control" name="daily_visit" value="<?php if(isset($_POST['daily_visit'])) echo $_POST['daily_visit']; ?>" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="sponsored_post">Sponsored Post</label>
                            <input type="text" class="form-control" name="sponsored_post" value="<?php if(isset($_POST['sponsored_post'])) echo $_POST['sponsored_post']; ?>" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="surveys">Surveys</label>
                            <input type="text" class="form-control" name="surveys" value="<?php if(isset($_POST['surveys'])) echo $_POST['surveys']; ?>" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="task">Task</label>
                            <input type="text" class="form-control" name="task" value="<?php if(isset($_POST['task'])) echo $_POST['task']; ?>" />
                        </div>
                    </div>
                    <div class="mt-2">
                        <button type="submit" class="btn btn-primary" name="submit">Add Country</button>
                    </div>
                </form>
            </div>
            <!-- /Account -->
        </div>
    </div>
</div>
<!-- / Content -->

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