Question

0

205

Views

Output text if the SQL value is empty

I'm trying to output the text 'N/A' into my table if there is an empty value stored for it in my SQL table. Here is what I have so far:

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>
                    ";
                }

over 4 years ago · Santiago Trujillo

2 answers

Answer question

0

Try this

$value = empty($value) ? "NA" : $value;

over 4 years ago · Santiago Trujillo Report

Answer question

Find remote jobs

Accepted Answer · 2022-05-26T16:49:52.555Z

if(empty($value)){
    echo "This value is empty";
}

Or if you want to insert a value "into the table" if a field is empty

if(empty($value)){
 $value = "N/A";
 //INSERT QUERY
}

0

205

Output text if the SQL value is empty

2 answers

0

0

Find remote jobs

Andres GPT