用于显示结果的简化php代码

Question

Sorry if this have been asked before but I couldn't find what I wanted and I am not strong in PHP.

Right now I have this code, which is supposed to return result for different levels:

<div class="swiper-slide">
        <img src="img/B1.jpg" alt="" />
        <div class="content_container">
            <?php
                $result = mysqli_query($con,"SELECT * FROM floor_directory WHERE level='B1'");
                while($row = mysqli_fetch_array($result))
                {
            ?>
            <h1><?php echo $row['categories']; ?></h1>
            <ul class="shop_listing clearfix">
                <li class="float_left"><?php echo $row['name']; ?></li>
                <li class="float_right"><?php echo $row['unit_number']; ?></li>
            </ul>
            <?php
                }
            ?>
        </div>
      </div>
      <div class="swiper-slide">
        <img src="img/L1.jpg" alt="" />
        <div class="content_container">
            <?php
                $result = mysqli_query($con,"SELECT * FROM floor_directory WHERE level='L1'");
                while($row = mysqli_fetch_array($result))
                {
            ?>
            <h1><?php echo $row['categories']; ?></h1>
            <ul class="shop_listing clearfix">
                <li class="float_left"><?php echo $row['name']; ?></li>
                <li class="float_right"><?php echo $row['unit_number']; ?></li>
            </ul>
            <?php
                }
            ?>
        </div>
      </div> and so on...

Right now I can only duplicate it in order to fulfil the displaying of result for each individual levels. If let's say the building have 10 levels, is there a way to simplified the coding?

Hope you guys understand. Thanks in advance! =)

Answer 1

Try this:

    <?php
    $levelArray=array('L1','B1','L2','B2');
        foreach ($levelArray as $i=>$level) {
             $data='';
            $img = "img/".$levelArray[$i];
           $result = mysqli_query($con,"SELECT * FROM floor_directory WHERE level='$levelArray[$i]'");
           while($row = mysqli_fetch_array($result)){
            $data .= '<h1>'.$row['categories'].'</h1>
                        <ul class="shop_listing clearfix">
                            <li class="float_left">'.$row['name'].'</li>
                            <li class="float_right">'.$row['unit_number'].'</li>
                        </ul>';
        }
        echo '<div class="swiper-slide">
            <img src="'.$img.'" alt="" />
                <div class="content_container">'.$data.'</div>
          </div>'

        }

     ?>