<?php

$sql_s = 'status = 1';
$max_rows = 8; // แสดงจำนวนแถวต่อหน้า
$page_number = 0;
if(isset($_GET['page_number']))
{
	 $page_number = $_GET['page_number'];
}
$all_array =  array('table'=>'article','where'=>$sql_s);
$start_row = $page_number * $max_rows;
$all_sql = $view_db->view($all_array);
$all_result = $view_db->q_re($all_sql);
$total_rows = $view_db->q_nr($all_result);
$total_rows_num = $view_db->q_nr($all_result);
$total_pages = ceil($total_rows/$max_rows)-1;
////////////////////////////////////////
$list = array('table'=>'article','where'=>$sql_s, 'limit'=> "$start_row,$max_rows",'order'=> "ORDER BY id DESC");
$view = $view_db->view($list);
$result = $view_db->q_re($view);
$num_tr = 1;
$num = 1+($page_number*$max_rows);
 ?>
 <div class="container">
   <div class="row">
     <div class="col-md-12">
       <div style="margin-top:30px;">
         <div class="row text-light">
           <div class="col-md-12" style="margin-bottom:5px;">
             <p class="HeadTextL">บทความ</p>
           </div>
         </div>

         <div class="row text-light">
           <div class="col-md-6" style="margin-bottom:5px;">
             <p style="font-size:22px;">พบทั้งหมด <?php echo number_format($total_rows_num);?> บทความ</p>
           </div>
         </div>
         <?php  while($row = $view_db->q_ro($result))  {   ?>
           <div class="col-md-12" style="margin-top:15px;">
             <div class="row">
               <div class="col-md-12">
                 <div class="DivprofileR-Head"> หัวข้อ : <?php echo $row['title'];?> </div>
                 <div class="DivprofileR-Detail">
                 	<p style="font-size:22px;"></p>
                   <span>
                   	<?php echo $util_class->sub_str($row['detail'],200);?>
                       <br>
                   </span>
                   <div style="border-top:1px solid #c8ac52;margin:20px 5px 0px 5px;font-size:12px;">
                     	<div class="row">
                         <div class="col-md-5" align="left" style="padding-top:15px;">
                         	<img src="../images/icon_eye.png" width="40" height="25" /> &nbsp; 50 view &nbsp; &nbsp;
                         	<img src="../images/icon_time.png" width="29" height="25" />&nbsp; <?php echo  $util_class->timedmy_th($row['up_date']); ?>
                         </div>
                         <?php
                           $list_sh = array('table'=>'shop','where'=>'id = "'.$row['id_shop'].'"');
 													$view_sh = $view_db->view($list_sh);
 													$row_sh = $view_db->q($view_sh);

 													$img =  imgprofile_shop($row_sh['image_profile'],'34');
 													$txt_phonenumber =  $Phone_class->phonecomma($row_sh['phone']);
 												  ?>
                         <div class="col-md-7">
                         	<div class="row">
                             <div class="col-xs-12 col-md-8"  style="padding:0px;padding-top:5px;">
                               <div class="col-xs-10" align="right">
                                   <div style="font-size:20px;"><?php echo $row_sh['nameShop']?> </div>
                                   <div>สั่งซื้อเบอร์ติดต่อ <?php echo $txt_phonenumber; ?> </div>
                               </div>
                               <div class="col-xs-2" style="text-align:left;padding:0px;padding-top:5px;" align="left">
                                   <?php echo $img; ?>
                               </div>
                              </div>
                              <div class="col-xs-12 col-md-4" align="right"  style="padding:0px;padding-top:10px;padding-right:15px;">
                               <a href="detail.php?id=<?php echo $row['id']?>" class="btn btn-primary btn_read">Read More</a>
                              </div>
                            </div>
                         </div>
                       </div>

                 		</div>
               	</div>
               </div>
             </div>
           </div>
         <?php  }    ?>
         <br>
         <div class="row" align="right" style="padding-top:25px;">
         	<div class="col-md-12">
             <div class="BerDedToday-page" style="margin-top:20px;">
               <?php
 							if($total_rows_num > 0)
 							{
 								page_news2($page_number,$total_pages,'index.php','');
 							}
 							?>
             </div>
           </div>
         </div>
       </div>
     </div>
   </div><!--/row-->
 </div><!--/.container-->