<?php
// 連接數(shù)據(jù)庫
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("連接失敗: " . $conn->connect_error);
}
// 獲取當(dāng)前月份
$currentMonth = date('Y-m');
// 構(gòu)造 SQL 查詢語句
$sql = "SELECT * FROM my_table WHERE DATE_FORMAT(date_column, '%Y-%m') = '$currentMonth'";
// 執(zhí)行查詢
$result = $conn->query($sql);
// 處理查詢結(jié)果
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        // 在這里處理每條記錄
        echo "ID: " . $row["id"] . " - Name: " . $row["name"] . " - Date: " . $row["date_column"] . "<br>";
    }
} else {
    echo "當(dāng)前月份沒有數(shù)據(jù)。";
}
// 關(guān)閉數(shù)據(jù)庫連接
$conn->close();
?>

use think\Db;
// 獲取當(dāng)前月份
$currentMonth = date('Y-m');
// 查詢當(dāng)前月份的數(shù)據(jù)
$data = Db::name('my_table')
    ->whereTime('date_column', '>=', $currentMonth . '-01 00:00:00')
    ->whereTime('date_column', '<=', $currentMonth . '-31 23:59:59')
    ->select();
// 處理查詢結(jié)果
if (!empty($data)) {
        // 在這里處理每條記錄
} else {
    echo "當(dāng)前月份沒有數(shù)據(jù)。";
}

use app\common\model\MyModel;
// 獲取當(dāng)前月份
$currentMonth = date('Y-m');
// 查詢當(dāng)前月份的數(shù)據(jù)
$data = MyModel::whereTime('date_column', '>=', $currentMonth . '-01 00:00:00')
    ->whereTime('date_column', '<=', $currentMonth . '-31 23:59:59')
    ->select();
// 處理查詢結(jié)果
if (!empty($data)) {
        // 在這里處理每條記錄
} else {
    echo "當(dāng)前月份沒有數(shù)據(jù)。";
}