在php和sql server中根据日期和时间从表中查找活动记录。

<?php
// 连接到 SQL Server 数据库
$serverName = "your_server_name";
$connectionOptions = array(
    "Database" => "your_database_name",
    "Uid" => "your_username",
    "PWD" => "your_password"
);
$conn = sqlsrv_connect($serverName, $connectionOptions);

if ($conn === false) {
    die(print_r(sqlsrv_errors(), true));
}

// 获取当前日期和时间
$currentDateTime = date("Y-m-d H:i:s");

// 构建 SQL 查询语句
$sql = "SELECT * FROM your_table_name WHERE event_date >= '$currentDateTime'";

// 执行查询
$stmt = sqlsrv_query($conn, $sql);
if ($stmt === false) {
    die(print_r(sqlsrv_errors(), true));
}

// 处理查询结果
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
    // 处理每一行记录
    echo "Event: " . $row['event_name'] . "<br>";
    echo "Date: " . $row['event_date']->format('Y-m-d') . "<br>";
    echo "Time: " . $row['event_date']->format('H:i:s') . "<br>";
    echo "<br>";
}

// 关闭连接
sqlsrv_free_stmt($stmt);
sqlsrv_close($conn);
?>