| Server IP : 172.67.187.206 / Your IP : 172.71.28.155 Web Server : Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/5.6.30 System : Windows NT WIN-ECQAAA40806 6.2 build 9200 (Windows Server 2012 Standard Edition) i586 User : SYSTEM ( 0) PHP Version : 5.6.30 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /Inetpub/www/news/ |
Upload File : |
<?php
session_start();
include("db.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);
}
$sitesettings = $mysqli->query("SELECT * FROM settings WHERE id='1'");
$settingsrow = mysqli_fetch_array($sitesettings);
?>
<html xmlns="https://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
<link href="https://program.sesaorb.go.th/news/csr/admin/assets/css/style.css" rel="stylesheet" type="text/css" />
<meta name="author" content="">
<!-- Bootstrap core CSS -->
<link href="https://program.sesaorb.go.th/news/csr/main/assets/css/bootstrap.min.css" rel="stylesheet">
<!-- Font Awesome CSS -->
<link href="https://program.sesaorb.go.th/news/csr/main/assets/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css" />
<!-- Custom styles for this template -->
<link href="https://program.sesaorb.go.th/news/csr/main/assets/css/custom.css" rel="stylesheet">
<!-- Core Scripts -->
<script src="https://program.sesaorb.go.th/news/csr/main/assets/js/jquery.min.js"></script>
<script src="https://program.sesaorb.go.th/news/csr/main/assets/js/bootstrap.bundle.min.js"></script>
<link href="https://fonts.googleapis.com/css?family=Prompt" rel="stylesheet">
<style>
body {
margin-top: -50px;
margin-left: 5px;
margin-right: 5px;
font-family: 'Prompt', sans-serif;
}
h1, h2, h3, h4, h5, h6, .h1, .h2, .h3, .h4, .h5, .h6 {
font-family: 'Prompt', sans-serif;
}
bx {
color: #ffffff;
text-shadow: -2px 0 #330033, 0 2px #330033, 3px 0 #330033, 0 -2px #330033;
}
.cardx1 {
position: absolute;
margin-top: 43% !important;
margin-left: 5% !important;
margin-right: 0% !important;
padding: 0;
}
.cardx2 {
position: absolute;
margin-top: 3% !important;
margin-left: 5% !important;
margin-right: 0% !important;
padding: 0;
color: #ffffff;
}
.ex1{
width : 100%;
}
</style>
</head>
<body>
<?php
$sql= $mysqli->query("select * from sc_news where cat_id between 70 and 85 order by id desc limit 5");
echo "<table border='0' align='center' width='100%'>";
$i=0;
while($r=mysqli_fetch_array($sql)) {
$i++
?>
<?php
if($i==1){
$color="secondary";
}elseif($i==2){
$color="success";
}elseif($i==3){
$color="primary";
}elseif($i==4){
$color="warning";
}elseif($i==5){
$color="info";
}
$today=date("d-m-Y");
$date_news=$r['date_news'];
$rest2 = substr("$date_news", 0,-9);
$news_day=(strtotime($today)-strtotime($rest2))/(60*60*24);
if($news_day <= 2) { $hot="<img src='images/update_news.gif'>";} else { $hot="";}
//$rest2 = substr("$date_news", 0,-9);
$userid=$r['uid'];
$user2 = $mysqli->query("SELECT * FROM users WHERE id='$userid' LIMIT 1");
$userrow2 = mysqli_fetch_array($user2);
$school=$userrow2['school'];
$ti_news = iconv_substr("$r[title]", 0,130,"UTF-8")."..";
echo "<tr><td valign='middle' style='BORDER-BOTTOM: #CCC 1px dotted'>
<div><font size='2'><span class='badge badge-pill badge-$color'> $i </span> <a href='view.php?id=$r[id]' target='_blank'>$ti_news</a></font><br>
<font size='1'>$school $date_news อ่าน <span class='badge badge-pill badge-$color'><i>$r[views]</i></span> ครั้ง</font> $hot</div></td></tr>";
?>
<?php }
echo "</table>";
echo "<div align='right'><a href='https://program.sesaorb.go.th/news/se_postall.php' target='_blank'><img src='images/more_r.png' border='0' /></a> </div>";
?>
</body>
</html>