如果DateTime对象为空 [英] If DateTime Object Is Null

问题描述

提交表单后，我将返回一些搜索结果.一切正常，直到我到达一个名为SMALLDATETIME并允许为NULL的字段.返回的行中至少有一个字段为NULL.正如您在下面的代码中看到的那样，当它不为NULL时，我会将其从Date转换为String没问题，但是对于包含NULL的行，我会收到一条错误消息.

I am returning some search results after form submit. All is working fine, until I get to a field that is SMALLDATETIME and allows NULL. At least one of the returned rows has the field as NULL. As you can see in the code below, when it is not NULL I am converting it from Date to String no problem, but i get an error Message for the rows with NULL.

有什么想法吗?

代码:

$search_results = sqlsrv_query($database_connection, $search_results_sql, array(), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));

if($search_results){
    $returned_rows = sqlsrv_has_rows($search_results);
    if($returned_rows === true){
        getAssetSearchData($search_results);
    }
}
function getAssetSearchData($search_results){

while($search_results_option = sqlsrv_fetch_object($search_results)){
    echo "
<tr>
        <td class='col45'>".date_format($search_results_option->HardwareAssetLastUpdateTime,"d/m/Y H:i")."</td>
        <td class='col46'>".$search_results_option->HardwareAssetLastUpdatedByName."</td>
        <td class='col47'>".date_format($search_results_option->HardwareAssetLastDiscoveryScanDate,"d/m/Y H:i")."</td></tr>";
    }
}

错误消息:

警告:date_format()期望参数1为DateTimeInterface， 在

Warning: date_format() expects parameter 1 to be DateTimeInterface, null given in

推荐答案

<td>".(
   is_null($search_results_option->HardwareAssetLastDiscoveryScanDate) ? '' : 
       date_format($search_results_option->HardwareAssetLastDiscoveryScanDate,
        "d/m/Y H:i")
    )
 ."</td>";

这篇关于如果DateTime对象为空的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！