PHP MySQLi 编程风格解析：从面向对象到过程化及最佳实践

function build_calendar_oo($month, $year){
    $mysqli = new mysqli('localhost', 'root', '', 'ems');
    $stmt = $mysqli->prepare("SELECT * FROM bookings WHERE MONTH(event_date) = ? AND YEAR(event_date)=?");
    $stmt->bind_param('ss', $month, $year);
    $bookings = array();
    if($stmt->execute()){
        $result = $stmt->get_result();
        if($result->num_rows > 0){
            while($row = $result->fetch_assoc()){
                $bookings[] = $row['event_date'];
            }
            $stmt->close();
        }
    }
    return $bookings;
}

function build_calendar_procedural($month, $year)
{
    // 建立数据库连接
    $mysqli = mysqli_connect('localhost', 'root', '', 'ems');
    if (mysqli_connect_errno()) {
        die("数据库连接失败: " . mysqli_connect_error());
    }

    // 准备语句
    $stmt = mysqli_prepare($mysqli, "SELECT * FROM bookings WHERE MONTH(event_date) = ? AND YEAR(event_date)=?");
    if (!$stmt) {
        die("语句准备失败: " . mysqli_error($mysqli));
    }

    // 绑定参数
    mysqli_stmt_bind_param($stmt, 'ss', $month, $year);

    $bookings = array();
    // 执行语句
    if (mysqli_stmt_execute($stmt)) {
        // 获取结果集
        $result = mysqli_stmt_get_result($stmt);
        if ($result && mysqli_num_rows($result) > 0) {
            // 遍历结果
            while ($row = mysqli_fetch_assoc($result)) {
                $bookings[] = $row['event_date'];
            }
            // 释放结果集
            mysqli_free_result($result);
        }
    } else {
        die("语句执行失败: " . mysqli_stmt_error($stmt));
    }

    // 关闭语句和连接
    mysqli_stmt_close($stmt);
    mysqli_close($mysqli);

    return $bookings;
}

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

// 启用错误报告
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

// 建立数据库连接
$mysqli = new mysqli('localhost', 'root', '', 'ems');

/**
 * 构建日历预订日期数组
 *
 * @param mysqli $mysqli 数据库连接对象
 * @param int $month 月份
 * @param int $year 年份
 * @return array 预订日期数组
 */
function build_calendar_simplified(mysqli $mysqli, int $month, int $year): array
{
    $stmt = $mysqli->prepare("SELECT event_date FROM bookings WHERE MONTH(event_date) = ? AND YEAR(event_date)=?");
    $stmt->bind_param('ii', $month, $year); // 注意：如果月份和年份是整数，应使用 'ii'
    $stmt->execute();

    // 获取所有结果并以关联数组形式返回
    $result = $stmt->get_result();
    return $result->fetch_all(MYSQLI_ASSOC);
}

// 示例调用
$bookings = build_calendar_simplified($mysqli, 1, 2020);
print_r($bookings);

// 关闭连接
$mysqli->close();