针对两个日期之间的已登录用户和未登录用户的Php查询

$servername = "数据库服务器地址";
$username = "数据库用户名";
$password = "数据库密码";
$dbname = "数据库名";

$conn = mysqli_connect($servername, $username, $password, $dbname);
if (!$conn) {
    die("连接数据库失败: " . mysqli_connect_error());
}

$start_date = "起始日期";
$end_date = "结束日期";

// 查询已登录用户
$logged_in_users_query = "SELECT * FROM users WHERE login_status = 1 AND login_date BETWEEN '$start_date' AND '$end_date'";

// 查询未登录用户
$logged_out_users_query = "SELECT * FROM users WHERE login_status = 0 AND login_date BETWEEN '$start_date' AND '$end_date'";

// 执行已登录用户查询
$logged_in_users_result = mysqli_query($conn, $logged_in_users_query);
if (mysqli_num_rows($logged_in_users_result) > 0) {
    while ($row = mysqli_fetch_assoc($logged_in_users_result)) {
        // 处理已登录用户数据
        // $row['id']为用户ID
        // $row['username']为用户名
        // ...
    }
}

// 执行未登录用户查询
$logged_out_users_result = mysqli_query($conn, $logged_out_users_query);
if (mysqli_num_rows($logged_out_users_result) > 0) {
    while ($row = mysqli_fetch_assoc($logged_out_users_result)) {
        // 处理未登录用户数据
        // $row['id']为用户ID
        // $row['username']为用户名
        // ...
    }
}

mysqli_close($conn);