Utiliser des fonctions vides avec des boucles Foreach

Question

Je souhaite afficher un message lorsqu'il n'y a aucun élément dans la base de données. ce Le code n'imprime pas les instructions lorsque la base de données ne contient aucune donnée.

This is my code,
<?php foreach($latest_tenders as $tenders):
if(!empty($tenders)){ 
$time = strtotime($tenders['post_date']);
                      $month=date('m', $time);
                                switch($month){
                                   case 1:
                                    echo "January "; break;
                                      .
                                      .
                                      .
                                    case 12:
                                     echo "December "; break;
                                   default:
                                    echo "January ";
                            }
echo date('d', $time).', ';
echo date('Y', $time).'&nbsp';
echo date('h', $time).':'; echo date('i',     $time).' |&nbsp';?>
     <i class="fas fa-user"></i> <?php echo $tenders['author'];?></p> 
       </div><br/>
     <?php 
         }
            else{?>
      <p style=" font-size:13px; word-spacing: 5px;color:tomato;">
          Tender Name: No advertised Tenders, Check again later.
      </p>
        <?php
            }
            endforeach;
            ?>

Answer 1

Et si$latest_tenders是您的数据库结果，首先检查$latest_tenders数组是否不为空。如果不为空：循环遍历 $latest_tenders 并打印其 $tenders. Sinon (vide) : imprimez votre message d'erreur.

<?php if(!empty($latest_tenders)) : ?>
    <?php foreach($latest_tenders as $tenders):
        $time = strtotime($tenders['post_date']);
        $month=date('m', $time);
        switch($month){
            case 1:
                echo "January "; break;
                    .
                    .
                    .
            default:
                echo "January ";
        }
        echo date('d', $time).', ';
        echo date('Y', $time).'&nbsp';
        echo date('h', $time).':';
        echo date('i',     $time).' |&nbsp';
    ?>
        <i class="fas fa-user"></i> <?php echo $tenders['author'];?></p></div><br/>
    <?php endforeach; ?>
<?php else : ?>
    <p style=" font-size:13px; word-spacing: 5px;color:tomato;">
        Tender Name : No advertised Tenders for No, Check again later.
    </p>
<?php endif; ?>