Admin Control Panel v2.0

✎ Editing: announce.php ← Back

<?php include("layout/header.php")?>
<style>
.form-control {
    display: block;
    width: 100%;
    font-size: 14px !important;
    line-height: 30px;
    height: 40px;
    color: #333;
    background-color: #fff;
    background-image: none;
    border: 1px solid #CCCCCC;
    border-radius: 5px;
    -webkit-box-shadow: none;
    box-shadow: none;
    -webkit-transition: border-color ease-in-out 0.15s, -webkit-box-shadow ease-in-out 0.15s;
    -o-transition: border-color ease-in-out 0.15s, box-shadow ease-in-out 0.15s;
    transition: border-color ease-in-out 0.15s, box-shadow ease-in-out 0.15s;
}
</style>
    <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 = "announce.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-news">
            
                               <ul>
                                <?php
                                    $perpage = 20;
                                    if (isset($_GET['page'])) {
                                    $page = $_GET['page'];
                                    } else {
                                    $page = 1;
                                    }
                                    $wh = "";
                                    if($textsearch){
                                      $wh = " AND announce_title LIKE '%$textsearch%' " ;
                                    }
                                    
                                    $start = ($page - 1) * $perpage;
                                    $sql_announce = "SELECT *,DATE_FORMAT(announce_create , '%Y-%m-%d') AS date_create FROM utt_announce
                                    WHERE 1 ".$wh." ORDER BY announce_create DESC limit {$start} , {$perpage}";
                                    $q_announce = mysqli_query($con,$sql_announce);
                                    $i = 0;
                                    while($r_announce = mysqli_fetch_array($q_announce)){
                                      $i++;
                                ?>
                                  <li>
                                <div class="boxfile">
                               <img src = "<?php echo $base_url;?>images/icon-pdf.png">
                                    <div class="file-des">
                                      <a href="<?php echo $base_url;?>files/<?php echo $r_announce['announce_file'];?>" target = "_BLANK"><?php echo $r_announce['announce_title'];?></a>
                                      <div class="t-update">วันที่สร้าง <?php echo datethai($r_announce['date_create']);?></div>
                                    </div>
                                </div>
                                <hr>
                              </li>
                                 <?php } ?>
                                </ul>
                                
                              </div>
                              
                              <?php
                                $sql2 = "select * from utt_announce  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="announce.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="announce.php?page=<?php echo $i; ?>"><?php echo $i; ?></a></li>
                                <?php } ?>
                                <li>
                                <a href="announce.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");?>
<?php
		function datethai($date)
	{
		
			$explode = explode('-',$date);
			if($explode[1] ==  '01'){
				$month = "ม.ค.";
			}elseif($explode[1] ==  '02'){
				$month = "ก.พ.";
			}elseif($explode[1] ==  '03'){
				$month = "มี.ค.";
			}elseif($explode[1] ==  '04'){
				$month = "เม.ย";
			}elseif($explode[1] ==  '05'){
				$month = "พ.ค.";			
			}elseif($explode[1] ==  '06'){
				$month = "มิ.ย.";
			}elseif($explode[1] ==  '07'){
				$month = "ก.ค.";
			}elseif($explode[1] ==  '08'){
				$month = "ส.ค.";
			}elseif($explode[1] ==  '09'){
				$month = "ก.ย.";
			}elseif($explode[1] ==  '10'){
				$month = "ต.ค.";
			}elseif($explode[1] ==  '11'){
				$month = "พ.ย.";
			}elseif($explode[1] ==  '12'){
				$month = "ธ.ค.";
			}
			$year = $explode[0]+543;
 
			return  $explode[2].'  '.$month.' '.$year;
	}
?>
</body>  
</html>

Cancel