Admin Control Panel v2.0

✎ Editing: activity.php ← Back

<?php include("layout/header.php")?>
    <articles>
      <section>
          <div class="wrapper">
              <div class="container">
                <div class="toppic">
                  <h1>กิจกรรม</h1>
                </div>

<?php

$textsearch = @$_POST['textsearch'];

?>
          <div class="panel panel-default">
          <div style = "float:right;padding:15px;">
          <form class="form-inline" action = "activity.php" method = "POST">
          <div class="form-group mx-sm-3 mb-2">
            <input type="text" class="form-control" name = "textsearch"  value = "<?php echo $textsearch;?>" placeholder="กรอกคำที่ต้องการค้นหา">
          </div>
          <button type="submit" class="btn btn-success mb-2">ค้นหา</button>
       
        </form>
      </div>
        <br>
          <div class="panel-body" style = "font-size:15px;">
        
            <br>
                <div class="box-list-activity">
                                <ul>
                                <?php
                                $perpage = 20;
                                if (isset($_GET['page'])) {
                                $page = $_GET['page'];
                                } else {
                                $page = 1;
                                }
                                $wh = "";
                                if($textsearch){
                                  $wh = " AND act_header LIKE '%$textsearch%' " ;
                                }
                                
                                $start = ($page - 1) * $perpage;
                                      $sql_activity  = "SELECT * FROM  utt_activity ORDER BY activity_date_create DESC limit {$start} , {$perpage}";
                                      $q_activity= mysqli_query($con,$sql_activity);
                                      $i = 0;
                                      while($r_activity = mysqli_fetch_array($q_activity)){
                                      $i++;
                                ?>
                                  <li>
                                    <div class="list-activity" style = "padding:10px;margin-bottom:10px;border-bottom:2px #eee solid;">
                                        <div class="row">
                                            <div class="col-sm-4">
                                              <center> 
                                             <?php if($r_activity['activity_image_cover']){?><img src = "<?php echo $base_url;?>images/activity/<?php echo $r_activity['activity_id'];?>/<?php echo $r_activity['activity_image_cover'];?>" class = "img-responsive" style = "height:150px;"><?php } ?>
                                            </center>
                                               
                                            </div>
                                            <div class="col-sm-8">
                                              <div class="box-activity-des">
                                                  <div class="t-title">
                                                    <a href="activitydetail.php?activity_id=<?php echo $r_activity['activity_id'];?>"><?php echo $r_activity['activity_header'];?></a>
                                                  </div>
                                                  <p><?php echo $r_activity['activity_detail'];?></p>
                                              </div>
                                            </div>
                                        </div>
                                    </div>
                                  </li>
                                 <?php } ?>
                                </ul>
                              </div>
                              <?php
                                $sql2 = "select * from utt_activity  WHERE 1 ".$wh;
                                $query2 = mysqli_query($con, $sql2);
                                $total_record = mysqli_num_rows($query2);
                                $total_page = ceil($total_record / $perpage);
                                ?>
                                
                                <nav style = "float:right;">
                                <ul class="pagination">
                                <li>
                                <a href="activity.php?page=1" aria-label="Previous">
                                <span aria-hidden="true">&laquo;</span>
                                </a>
                                </li>
                                <?php for($i=1;$i<=$total_page;$i++){ ?>
                                <li><a href="activity.php?page=<?php echo $i; ?>"><?php echo $i; ?></a></li>
                                <?php } ?>
                                <li>
                                <a href="activity.php?page=<?php echo $total_page;?>" aria-label="Next">
                                <span aria-hidden="true">&raquo;</span>
                                </a>
                                </li>
                                </ul>
                                </nav>                      
               
                                </div>
                                    </div>
              </div>
          </div>
      </section>
    </articles>
<?php include("layout/footer.php")?>
</body>  
</html>

Cancel