php sql查询在月和年之间选择

SELECT * FROM table_name WHERE MONTH(date_column) = 6 AND YEAR(date_column) = 2022;

<?php
$month = 6;
$year = 2022;

// 创建数据库连接
$conn = new mysqli("localhost", "username", "password", "database_name");

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 构建SQL查询语句
$sql = "SELECT * FROM table_name WHERE MONTH(date_column) = ? AND YEAR(date_column) = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("ii", $month, $year);

// 执行查询
$stmt->execute();

// 获取查询结果
$result = $stmt->get_result();

// 处理查询结果
while ($row = $result->fetch_assoc()) {
    // 处理每一行数据
    // ...
}

// 关闭数据库连接
$stmt->close();
$conn->close();
?>