如果在我的 SQL 表中存储了一个空值,我试图将文本“N/A”输出到我的表中。这是我到目前为止所拥有的:
while($rowObj = $queryResult->fetch_object())
{
$eventTitle = $rowObj->eventTitle;
$catDesc = $rowObj->catDesc;
$catID = $rowObj->catID;
$eventDescription = $rowObj->eventDescription;
$venueName = $rowObj->venueName;
$venueID = $rowObj->venueID;
$eventStartDate = $rowObj->eventStartDate;
$eventEndDate = $rowObj->eventEndDate;
$eventPrice = $rowObj->eventPrice;
echo "
<tr>
<td> $eventTitle </td>
<td> " . (empty($catID)) ? 'N/A' : '$catDesc'. "</td>
<td> " . (empty($eventDescription)) ? 'N/A' : '$eventDescription'. "</td>
<td> " . (empty($venueID)) ? 'N/A' : '$venueName'. "</td>
<td> $eventStartDate </td>
<td> $eventEndDate </td>
<td> $eventPrice </td>
</tr>
";
}
if(empty($value)){
echo "This value is empty";
}
或者,如果您想在字段为空时将值“插入表中”
if(empty($value)){
$value = "N/A";
//INSERT QUERY
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句