Admin Control Panel v2.0

✎ Editing: news.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 = "news.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 news_header LIKE '%$textsearch%' " ;
                                }
                                
                                $start = ($page - 1) * $perpage;
                                      $sql_news  = "SELECT * FROM  utt_news ORDER BY news_datecreate DESC limit {$start} , {$perpage}";
                                      $q_news= mysqli_query($con,$sql_news);
                                      $i = 0;
                                      while($r_news = mysqli_fetch_array($q_news)){
                                      $i++;
                                ?>
                                  <li>
                                    <div class="list-news">
                                        <div class="row">
                                            <div class="col-sm-4">
                                                <div class="box-thumbnail">
                                                    <a href="newsdetail.php?news_id=<?php echo $r_news['news_id'];?>">
                                                      <?php if($r_news['news_img_cover']){?><img src = "<?php echo $base_url;?>images/news/<?php echo $r_news['news_img_cover'];?>"><?php } ?>
                                                    </a>
                                                </div>
                                            </div>
                                            <div class="col-sm-8">
                                              <div class="box-news-des">
                                                  <div class="t-title">
                                                    <a href="newsdetail.php?news_id=<?php echo $r_news['news_id'];?>"><?php echo $r_news['news_header'];?></a>
                                                  </div>
                                                  <p><?php echo $r_news['news_detail'];?></p>
                                              </div>
                                            </div>
                                        </div>
                                    </div>
                                  </li>
                                 <?php } ?>
                                </ul>
                              </div>
                              <?php
                                $sql2 = "select * from utt_news  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="news.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="news.php?page=<?php echo $i; ?>"><?php echo $i; ?></a></li>
                                <?php } ?>
                                <li>
                                <a href="news.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