<?php include("header.php");

 ?>
 <title>ศูนย์ข่าว สพม.ราชบุรี</title>
<style type="text/css">
<!--
#Layer1 {
	position:absolute;
	left:25px;
	top:10px;
	width:100px;
	height:99px;
	z-index:1;
}
-->
</style>
<?php
// Create the function, so you can use it
function isMobile() {
    return preg_match("/(android|avantgo|blackberry|bolt|boost|cricket|docomo|fone|hiptop|mini|mobi|palm|phone|pie|tablet|up\.browser|up\.link|webos|wos)/i", $_SERVER["HTTP_USER_AGENT"]);
}
// If the user is on a mobile device, redirect them
if(isMobile()) {} else {
echo "<div id='Layer1'><a href='index.php'><img src='images/logo.png'></a></div>";
}
?>

<div id="left-top">
<div class="title">
<h3>ข่าวหน้า 1</h3>
</div><!--tab-base-->
<?php
if(!isset($_SESSION['username'])){
}else{ 
$username1 = $_SESSION['username'];
$user1 = $mysqli->query("SELECT * FROM users WHERE username='$username1' LIMIT 1");
$userrow1 = mysqli_fetch_array($user1);
}

$hot = $mysqli->query("SELECT * FROM posts WHERE hot='1' ORDER BY id DESC LIMIT 1");
$hotrow = mysqli_fetch_array($hot);
	
	$hotdescription = stripslashes($hotrow['description']);
	$hotdesc = strlen ($hotdescription);
	if ($hotdesc > 140) {
	$hotsdec = substr($hotdescription,0,631).'..';
	$title1=substr($hotrow['title'],0,233).'';
	}else{
	$hotsdec = $hotdescription;}
	$title1=substr($hotrow['title'],0,233).'';


?>

<div id="thumb-box">

<div class="thumb"><iframe src="slide/test.php" width="655" height="410" frameborder="0" scrolling="no"></iframe></div>
</div><!--thumb-box-->

</div><!--left-top-->

<?php include("right_all.php");?>

<div class="news-box">

<div class="title">
<h3> <a href="rss.php" target="_blank"><img src="images/m_rss.gif" align="absmiddle"></a>RSS :: ข่าวด่วนล่าสุด </h3>
</div><!--title-->

<?php
$story = $mysqli->query("SELECT * FROM posts where uid between '1' and '65' ORDER BY id DESC LIMIT 5");
while($storyrow = mysqli_fetch_array($story)){
	
	$description = stripslashes($storyrow['description']);
	$desc = strlen ($description);
	if ($desc > 140) {
	$sdec = substr($description,0,500).'...';
	}else{
	$sdec = $description;}
?>
<div class="story">
<div class="small-thumb">
<a href="story-<?php echo $storyrow['id'];?>.php">
	<?php 
	if ($storyrow['id'] > 4430){
	?>
<img src="uploads/<?php echo $storyrow['image'];?>" height="90" width="120" alt="<?php echo $storyrow['title'];?>"/>
<?php }else{ ?>
<img src="<?php echo $storyrow['image'];?>" height="90" width="120" alt="<?php echo $storyrow['title'];?>"/>
<?php } ?>	
</a>
</div><!--small-thumb-->
<h2><a href="story-<?php echo $storyrow['id'];?>.php"><?php echo stripslashes($storyrow['title']);?></a></h2>
<p><?php echo strip_tags($sdec);?></p>

<?php
$userid = $storyrow['uid'];
$user = $mysqli->query("SELECT * FROM users WHERE id='$userid' LIMIT 1");
$userrow = mysqli_fetch_array($user);
?>
<div class="look-up-story">
<?php if(!isset($_SESSION['username'])){?>
<?php }elseif
($userrow['id']=="$userrow1[id]") {
?>
<a href="edit_news.php?id=<?php echo $storyrow['id'];?>">แก้ไข</a>&nbsp;&nbsp;
<a class="red-button" href="delete_news.php?id=<?php echo $storyrow['id'];?>">ลบ</a> 
<?php } ?>

<p>เขียนโดย <?php echo $userrow['school'];?> เปิดอ่าน <?php echo $storyrow['views'];?> ครั้ง  เขียนเมื่อ <?php echo $storyrow['date'];?></p>
</div><!--look-up-->
</div><!--story-->
<?php }?>

</div>

<table width="667" border="0">
  <tr>
    <td>
<?php 
$rbr = $mysqli->query("SELECT * FROM posts WHERE uid between '27' and '55' ORDER BY RAND() LIMIT 1");
$row_rbr = mysqli_fetch_array($rbr);
?>	
<div id="thumb-box1">
<a href="section.php?uid=<?php echo $row_rbr['uid'];?>">
<div class="thumb1">
	<?php 
	if ($row_rbr['id'] > 4430){
	?>
<img src="uploads/<?php echo $row_rbr['image'];?>" height="200" width="318" alt="<?php echo $row_rbr['title'];?>"/>
<?php }else{ ?>
<img src="<?php echo $row_rbr['image'];?>" height="200" width="318" alt="<?php echo $row_rbr['title'];?>"/>
<?php } ?>
<div id="hot-des"><h1><center>ข่าวโรงเรียนในจังหวัดกาญจนบุรี</center></h1></div></div>
</a>
</div>

</td>
    <td>
<?php 
$kri = $mysqli->query("SELECT * FROM posts WHERE uid <= 26 ORDER BY RAND() LIMIT 1");
$row_kri = mysqli_fetch_array($kri);
?>	
<div id="thumb-box1">
<a href="section.php?uid=<?php echo $row_kri['uid'];?>">
<div class="thumb1">
	<?php 
if ($row_kri['id'] > 4430){
	?>
<img src="uploads/<?php echo $row_kri['image'];?>" height="200" width="318"  alt="<?php echo $row_kri['title'];?>"/>
<?php }else{ ?>
<img src="<?php echo $row_kri['image'];?>"  height="200" width="318" alt="<?php echo $row_kri['title'];?>"/>
<?php } ?>
<div id="hot-des1"><h1><center>ข่าวโรงเรียนในจังหวัดราชบุรี</center></h1></div></div>
</a>
</div>	
	</td>
  </tr>
</table>


<div class="news-box">

<div class="title">
<h3>ข่าว สพม.8</h3>
</div><!--title-->

<?php
$storypop = $mysqli->query("SELECT * FROM posts where uid BETWEEN 70 AND 85 ORDER BY id DESC LIMIT 5");
while($storypoprow = mysqli_fetch_array($storypop)){
	
	$popdescription = stripslashes($storypoprow['description']);
	$popdesc = strlen ($popdescription);
	if ($popdesc > 140) {
	$popsdec = substr($popdescription,0,500).'..';
	}else{
	$popsdec = $popdescription;}
	
?>
<?php
$userid1 = $storypoprow['uid'];
$user1 = $mysqli->query("SELECT * FROM users WHERE id='$userid1' LIMIT 1");
$userrow1 = mysqli_fetch_array($user1);
?>
<div class="story">
<div class="small-thumb">
		<?php 
// ตรวจสอบ id ใหม่ในการแสดงผลรูป
if($storypoprow["id"] > 4430) { ?>
<img src="uploads/<?php echo $storypoprow['image'];?>"  height="90" width="120" alt="<?php echo $storypoprow['title'];?>"/>
<?php }else{ ?>
<img src="<?php echo $storypoprow['image'];?>"  height="90" width="120" alt="<?php echo $storypoprow['title'];?>"/>
<?php } ?>
</div><!--small-thumb-->
<h2><a href="story-<?php echo $storypoprow['id'];?>.php"><?php echo stripslashes($storypoprow['title']);?></a></h2>
<p><?php echo strip_tags($popsdec);?></p>

<div class="look-up-story">
<p>เขียนโดย:<?php echo $userrow1['school'];?> เปิดอ่าน<?php echo $storypoprow['views'];?>ครั้ง เขียนเมื่อ<?php echo $storypoprow['date'];?></p>
</div><!--look-up-->
</div><!--story-->
<?php }?>

</div><!--news-box-->

<?php include("footer.php"); ?>