include("../connect/connectdb.php");
mysql_query("SET NAMES 'utf8' COLLATE 'utf8_general_ci';");
?>
function thaiDate($inputDate){
$m=array("ม.ค.","ก.พ.","มี.ค.","เม.ย","พ.ค.","มิ.ย.", "ก.ค.","ส.ค.","ก.ย.","ต.ค.","พ.ย.","ธ.ค.");
$d=explode("-",$inputDate);
$outputDate=$d[2]." ".$m[($d[1]-1)]." ".substr(($d[0]+543),-2);
return $outputDate;
}
?>
กองพัฒนานักศึกษาและศิษย์เก่าสัมพันธ์
เอกสารเวียน กองพัฒนานักศึกษาและศิษย์เก่าสัมพันธ์
$sdocyear=mysql_real_escape_string($sdocyear);
$sinstitute=mysql_real_escape_string($sinstitute);
$sdocid=mysql_real_escape_string($sdocid);
$sinstitutetask=mysql_real_escape_string($sinstitutetask);
$sdocname=mysql_real_escape_string($sdocname);
$sdoctype=mysql_real_escape_string($sdoctype);
$sdate=mysql_real_escape_string($sdate);
$number1=1;
//--------------------------------------------------------------------------
if(($sdocyear!='')||($sinstitute!='')||($sdocid!='')||($sinstitutetask!='')||($sdocname!='')||($sdoctype!='')||($sdate!=''))
{
$condition="";
if($sdocyear!='')
$condition =$condition."and docyear like '%$sdocyear%' ";
if($sinstitute!='')
$condition = $condition."and institute like '%$sinstitute%' ";
if($sdocid!='')
$condition = $condition."and docid like '%$sdocid%' ";
if($sinstitutetask!='')
$condition = $condition."and institutetask = '$sinstitutetask' ";
if($sdocname!='')
$condition = $condition."and docname like '%$sdocname%' ";
if($sdoctype!='')
$condition = $condition."and doctype like '%$sdoctype%' ";
if($sdate!='') {
if($edate=='')
$edate=$sdate;
$ssdate=changeDate2($sdate);
$eedate=changeDate2($edate);
$condition = $condition."and (docdate between '$ssdate' and '$eedate') ";
}
$condition = " where ".substr($condition,3);
$sql1="select * from tbdocument $condition order by docdate desc";
}else{
$sql1="select * from tbdocument order by postdate desc,posttime desc limit 20 ";
}
//--------------------------------------------------------------------------
//echo $sql1;
$result1=mysql_query($sql1) or die(mysql_error());
while($row1=mysql_fetch_array($result1))
{
$number1++;
?>
-
if ($number1 % 2 == 0 ){ ?>
} else { ?>
} ?>
if($sdate=='') {
echo htmlspecialchars($row1["docname"]).'(โพสต์ '.thaiDate($row1['postdate']).')';
}else{
echo htmlspecialchars($row1["docname"]).'(ลว. '.thaiDate($row1['docdate']).')';
}
?>
} ?>