<?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="news-box">

<div class="title">
<h3>ข่าว สพม.ราชบุรี</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?id=<?php echo $storypoprow['id'];?>"><?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-->


<div class="news-box">

<div class="title">
<h3>ข่าวโรงเรียนในสังกัด สพม.ราชบุรี</h3>
</div><!--title-->

<?php
$storypop = $mysqli->query("SELECT * FROM posts where uid BETWEEN 1 AND 26 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?id=<?php echo $storypoprow['id'];?>"><?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-->
<?php }?>

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


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