Add php if else to html code

Question

I need help with how to add an "if else" statement to my php script, I need the new_license_issued_date field to be null if null and not 01/01/1970 like it's currently pulling through.... please help! thanks

 <table cellpadding='0' cellspacing='0' border='0' class='display' id='table' width='100%'>
    <thead>
    <tr>
        <th>Emp Code</th>   
        <th width='130'>Emp Name</th>
        <th width=100>Manager</th>
        <th width=150>Business Unit</th>
        <th width=240>Training Course Name</th>     
        <th width=65>Issued Date</th>
        <th width=65>Expiry Date</th>
        <th width=100>Cert Number</th>

    </tr>
    </thead>
    <tbody>
    <?php
    //display the results 
    while($row = mssql_fetch_array($result))
    {
    echo "<tr>
        <td width=40>" . $row['Emp Code'] . "</td>
        <td>". $row['new_EmployeeName']  . "</td>
        <td>". $row['Manager'] . "</td>     
        <td>". $row['BusinessUnit'] . "</td>
        <td>". $row['new_TrainingCourseLookName'] . "</td>
        <td>". date('d-M-Y', strtotime($row['new_license_issued_date'])) . "</td>
        <td>". date('d-M-Y', strtotime($row['new_license_expiry_date'])) . "</td>
        <td>". $row['new_license_no'] . "</td>
    </tr>";
    }

    echo "</tbody>
    </table>
    <br>
        <p><a href='index.php'><< Back to Portal</p>
    </div>";
    //close the connection
    mssql_close();
    ?>  
    <!-- Le javascript
    ================================================== -->
    <!-- Placed at the end of the document so the pages load faster -->
    <script type="text/javascript" language="javascript" src="assets/js/jquery.js"></script>
    <script type="text/javascript" language="javascript" src="assets/js/jquery.dataTables.js">                        </script>

    <script type='text/javascript' charset='utf-8'>
            $(document).ready(function() {
                $('table').dataTable();
            } );
    </script>
  </body>
</html>

ʰᵈˑ · Accepted Answer · 2014-09-30 10:17:12Z

1

Use the ternary operator.

<td>". (is_null($row['new_license_issued_date']) 
               ? "NULL" 
               : date('d-M-Y', strtotime($row['new_license_issued_date']))) ."</td>

answered Sep 30, 2014 at 10:17

ʰᵈˑ

11.4k3 gold badges31 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Krisztián Dudás · Accepted Answer · 2014-09-30 10:20:03Z

0

Have you tried:

($row['new_license_issue_date'] ? date('d-M-Y', strtotime($row['new_license_issue_date'])) : '&nbsp');

?

answered Sep 30, 2014 at 10:20

Krisztián Dudás

1,0461 gold badge12 silver badges25 bronze badges

Comments

Petar Kolev · Accepted Answer · 2014-09-30 18:11:36Z

0

Or if it's more easy for you use this:

echo "<td>";

   if($row['new_license_issued_date'] !== NULL){
      echo date('d-M-Y', strtotime($row['new_license_issued_date']));
   } else {
      echo "&nbsp;";
   }

echo "</td>";

edited Sep 30, 2014 at 18:11

answered Sep 30, 2014 at 10:21

Petar Kolev

394 bronze badges

2 Comments

Rápli András Over a year ago

use !== instead of !=

Petar Kolev Over a year ago

You're right ... I have not seen ... thanks for the correction!

Collectives™ on Stack Overflow

Add php if else to html code

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related