<?php
    $id = mysqli_real_escape_string($obj_con,$_GET['id']);

    $sql_gl = "SELECT * FROM tb_gallery WHERE g_id = $id";
    $query_gl = $obj_con->query($sql_gl);
    $row_gl = $query_gl->fetch_assoc();

    $strSQL_gl = "UPDATE tb_gallery SET g_view = g_view+1 WHERE g_id = $id ";
    $objQuery_gl = $obj_con->query($strSQL_gl);
  ?>

<div class="col-md-8" id="box_r">
  <ol class="breadcrumb">
    <li><a href="#"><i class="fas fa-home"></i> หน้าหลัก</a></li>
    <li><a href="index.php?home=gallery">อัลบั้มกิจกรรม</a></li>
    <li class="active"><?php echo mb_substr($row_gl['g_name'], 0, 40, 'UTF-8')."...";?></li>
  </ol>
  <h3 class="title-box-2"><?php echo $row_gl['g_name']?></h3>

  <div class="row">
    <?php
    $id = mysqli_real_escape_string($obj_con,$_GET['id']);

    $sqlpic = "SELECT * FROM tb_gallery WHERE g_id = $id";
    $querypic = $obj_con->query($sqlpic);
    while($rowpic = $querypic->fetch_assoc()){ ?>

    <div class="col-sm-6 col-md-4" id="box_img-m">
      <a href="#" class="a-thm" data-toggle="modal" data-target=".modal-ga-<?php echo $rowpic['ag_id'];?>">
        <div class="thumbnail_new">
         <center> <img src="img/gallery/detail/<?php echo $rowpic['g_pic'];?>" alt="..." ></center>
        </div>
      </a>
    </div>

    <div class="modal fade modal-ga-<?php echo $rowpic['ag_id'];?>" tabindex="-1" role="dialog" aria-labelledby="mySmallModalLabel">
      <div class="modal-dialog" role="document">
        <div class="modal-content">
          <div class="modal-header">
            <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
            <h4 class="modal-title" id="mySmallModalLabel"><i class="fas fa-images"></i> อัลบั้มภาพ</h4>
          </div>
          <div class="p-modal-img">
           <center>  <img src="img/gallery/detail/<?php echo $rowpic['g_pic'];?>" alt="..." style="max-width: 849px;">
          </div>
          <p class="p-modal"><?php echo $row_gl['g_name']?></p>
        </div>
      </div>
    </div>
   <?php } ?>
   <div class="col-md-12">
     <div class="p-footer-detail"><i class="far fa-calendar-alt"></i> เมื่อวันที่ : <?php echo thai_date_and_time_short(strtotime($row_gl['g_date']));?> (เข้าชม <i class="fas fa-eye"></i> <?php echo number_format($row_gl['g_view']);?>)</div>
   </div>
  </div>
</div>