<?php include("common/conn.php"); ?>

<?php
function make_query($conn)
{
 $query = "SELECT * FROM banner_slider ORDER BY id ASC";
 $result = mysqli_query($conn, $query);
 return $result;
}

function make_slide_indicators($conn)
{
 $output = ''; 
 $count = 0;
 $result = make_query($conn);
 while($row = mysqli_fetch_array($result))
 {
  if($count == 0)
  {
   $output .= '
   <li data-target="#banners" data-slide-to="'.$count.'" class="active"></li>
   ';
  }
  else
  {
   $output .= '
   <li data-target="#banners" data-slide-to="'.$count.'"></li>
   ';
  }
  $count = $count + 1;
 }
 return $output;
}

function make_slides($conn)
{
 $output = '';
 $count = 0;
 $result = make_query($conn);
 while($row = mysqli_fetch_array($result))
 {
  if($count == 0)
  {
   $output .= '<div class="carousel-item active">';
  }
  else
  {
   $output .= '<div class="carousel-item">';
  }
  $output .= '
  <img src="'. str_replace("../assets", "assets", $row[2]).'" alt="'. $row[1] .'" class="w-100" />
  </div>
  ';
  $count = $count + 1;
 }
 return $output;
}

?>
<section class="banner-section text-center">
    <div id="banners" class="carousel slide" data-ride="carousel">
        <ol class="carousel-indicators">
        <?php echo make_slide_indicators($conn); ?>
        </ol>
        <div class="carousel-inner">
        <?php echo make_slides($conn); ?>
        </div>
        <?php 
            if($rowcount == 0){
                echo '<style>section.banner-section{display:none}</style>';
            } 
        ?>
        <a class="left carousel-control" href="#banners" data-slide="prev">
            <span class="glyphicon glyphicon-chevron-left"></span>
            <span class="sr-only">Previous</span>
        </a>
        <a class="right carousel-control" href="#banners" data-slide="next">
            <span class="glyphicon glyphicon-chevron-right"></span>
            <span class="sr-only">Next</span>
        </a>
    </div>
</section>