解决 PHP sqlsrv_query 长查询无结果无错误问题的指南

<?php
// 数据库连接信息
$connInfo = array(
    "Database" => "xxx",
    "UID" => "xxx",
    "PWD" => "xxx",
    "CharacterSet" => "UTF-8"
);

// 建立数据库连接
$conn = sqlsrv_connect('SQL2008', $connInfo);

if ($conn) {
    // 假设 $dateDebut 和 $dateFin 是 DateTime 对象
    // 实际应用中需要确保这些变量已正确初始化
    $dateDebut = new DateTime('2023-01-01 00:00:00');
    $dateFin = new DateTime('2023-12-31 23:59:59');

    // 1. 使用参数化查询，避免字符串拼接和SQL注入
    // 2. 日期时间参数使用占位符 "?"
    $sql_q = "
        SELECT 
            TblOrder.FldJobNb, 
            TblOrder.FldOrdCre AS DateReception, 
            TblOrder.FldReclamerDate AS DateDebutPORev, 
            TblOrder.FldPOReviewApprovedDate AS DateFinPORev,
            TblOrder.FldPrinted, 
            capsule_order.temps_reception_planification AS DateReceptionPLANIF, 
            TblOrder.FldPriced,
            CASE
                WHEN ISNULL(TblOrder.FldContractReviewCompletedDate, 0) = 0 THEN capsule_order.temps_reception_planification
                ELSE TblOrder.FldContractReviewCompletedDate
            END AS TempsFinRevue,
            (
                SELECT TOP 1 TblOrderXFeredNotifications.FldDate 
                FROM [TCS].[dbo].[TblOrderXFeredNotifications] 
                WHERE TblOrderXFeredNotifications.FldOrdID = TblOrder.FldOrdID 
                ORDER BY TblOrderXFeredNotifications.FldNoLigne
            ) AS DatePlanification,
            TblOrder.FldXfer2Sched, 
            TblOrder.FldOrdMod AS DateDernierMod, 
            TblOrder.FldOrdStatusDate AS DateDernierStatut, 
            TblOrder.FldOrdReq AS DateBesoin
        FROM [TCS].[dbo].[TblOrder] 
        RIGHT JOIN [TCS].[dbo].[capsule_order] ON TblOrder.FldJobNB = capsule_order.FldJobNB
        WHERE ? <= TblOrder.FldOrdCre AND TblOrder.FldOrdCre <= ?
    ";

    // 3. 将日期时间值格式化为明确的 ISO 8601 格式 (yyyy-mm-ddThh:mm:ss.zzz)
    // 注意：`DateTime::format` 中的 'T' 会输出 'T' 字母，`.000` 是手动添加的毫秒部分
    $params = array(
        $dateDebut->format('Y-m-d\TH:i:s') . '.000',
        $dateFin->format('Y-m-d\TH:i:s') . '.000'
    );

    // 执行参数化查询
    $query = sqlsrv_query($conn, $sql_q, $params);

    if ($query) {
        // 4. 使用 sqlsrv_has_rows() 检查结果集是否存在行，效率更高
        if (sqlsrv_has_rows($query)) {
            echo "查询返回了数据。<br>";
            while ($result = sqlsrv_fetch_array($query, SQLSRV_FETCH_ASSOC)) {
                // 处理每一行数据
                // print_r($result); // 调试用
            }
            echo "数据处理完成。<br>";
        } else {
            echo "查询未返回任何行。<br>";
            // 调试时可以输出 sqlsrv_num_rows，但通常不建议在生产环境使用
            // die(var_dump(sqlsrv_num_rows($query)));
        }
    } else {
        // 查询执行失败，输出详细错误信息
        echo "查询执行失败！<br>";
        echo "SQL 语句: " . htmlspecialchars($sql_q) . "<br>";
        print_r(sqlsrv_errors(), true);
        die();
    }
} else {
    // 数据库连接失败
    echo "数据库连接失败！<br>";
    print_r(sqlsrv_errors(), true);
    die();
}
?>