1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / ashtokenrewards.com / control /
Filename : email-list.php
back
<?php
session_start();
error_reporting(0);
include('../../config/aconn.php');
include('include/checklogin.php');
check_login();
include('include/header.php');
include('include/sidebar.php');
include('include/functions.php');
include('include/settings.php');

// Enable error reporting for debugging
error_reporting(E_ALL);
ini_set('display_errors', 1);

$current_date = date("Y-m-d");

if (isset($_POST['submit'])) {
    $email_category = sanitize_input($_POST['email_category']);

    // Prepare the SQL query based on the selected category
    switch ($email_category) {
        case 'all_users':
            $query = "SELECT * FROM `users`";
            break;
        case 'og_users':
            $query = "SELECT * FROM `users` WHERE `og_status` = '1' ";
            break;
        case 'verified_users':
            $query = "SELECT * FROM `users` WHERE `verification_status` = '1' ";
            break;
        case 'inactive':
            $query = "SELECT * FROM `users` WHERE `lastLogin` < DATE_SUB(NOW(), INTERVAL 1 WEEK)";
            break;
        default:
            $query = "SELECT * FROM `users`";
            break;
    }

    $result = mysqli_query($con, $query);

    if (mysqli_num_rows($result) > 0) {
        // Initialize an empty string to hold formatted data
        $email_list = "";
        
        // Fetch each row and build the formatted list
        while ($user = mysqli_fetch_assoc($result)) {
            $email = $user['email'];
            $email_list .=  $email . ","; // Each row in new line
        }
        // Display the email addresses in a styled container
        ?>
        <!-- Content wrapper -->
            <!-- Content -->
            <div class="container-xxl flex-grow-1 container-p-y">
                <div class="card mb-4">
                    <h5 class="card-header">Email Addresses for Category: <?php echo $email_category; ?></h5>
                    <hr class="my-0" />
                    <div class="card-body">
                        <textarea rows="10" class="form-control"><?php echo $email_list; ?></textarea>
                    </div>
                </div>
            </div>
        <!-- / Content -->
        <?php
    } else {
        echo "No users found for the selected category.";
    }
}
?>

<!-- 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> Email List</h4>
        <div class="card mb-4">
            <h5 class="card-header">Select Email Category</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 $type ?></h6>
                    <p class="mb-0"><?php echo $msg ?></p>
                </div>
                <?php } ?>
                <form method="post" action="">
                    <div class="mb-3 col-md-12">
                        <label class="form-label" for="email_category">Email Category</label>
                        <select class="form-select" name="email_category">
                            <option value="all_users">All Users</option>
                            <option value="og_users">OGs</option>
                            <option value="verified_users">Verified Users</option>
                            <option value="inactive">Inactive</option>
                        </select>
                    </div>
                    <div class="mt-2">
                        <button type="submit" class="btn btn-primary me-2" name="submit">Submit</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>
<!-- / Content -->
<?php include('include/footer.php'); ?>