require("left.php");
?>
|
|
include("config.inc.php");
$chk_date = substr(date("Y-m-d H:i:s"),-19,-9);
if (empty($page)){
$page=1;
}
// ติดต่อ database เพื่ออ่านข้อมูล
// หาจำนวนหน้าทั้งหมด
mysql_connect($host,$user,$passwd);
mysql_query("SET NAMES 'utf8' COLLATE 'utf8_general_ci';");
$sql = "select No from know_data where Category Like'$Category'";
$result = mysql_db_query($dbname,$sql);
$NRow = mysql_num_rows($result);
$rt = $NRow%$list_page;
if($rt!=0) {
$totalpage = floor($NRow/$list_page)+1;
}
else {
$totalpage = floor($NRow/$list_page);
}
$goto = ($page-1)*$list_page;
// Query ข้อมูลตามจำนวนที่กำหนด
mysql_query("SET NAMES 'utf8' COLLATE 'utf8_general_ci';");
$sql = "select * from know_data where Category Like'$Category' order by No DESC limit $goto,$list_page";
$result = mysql_db_query($dbname,$sql);
$NRow = mysql_num_rows($result);
if($NRow==0) {
echo "";
echo " ";
echo "ยังไม่มีข้อมูลเลย
\n";
echo "";
}
else {
echo "\n";
$round=1;
while ($row = mysql_fetch_array($result)) {
$No = $row["No"];
$Title = $row["Question"];
$Detail = $row["Note"];
$shortnote= $row["shortnote"];
$Date1 = trim(substr($row["Date"],0,11));
$nphoto = $row["nphoto"];
$ndata = $row["ndata"];
$ndata = $row["ndata"];
$ndata_size = $row["ndata_size"];
$pageviewdata = $row["pageview"];
$ext = strtolower(end(explode('.',$ndata)));
$pageviewdata = $row["pageview"];
$pcate1 = $row["Category"];
if($pcate1=="center")
{
$showcate1="เจ้าหน้าที่ทั่วไป";
}
elseif ($pcate1=="sapa")
{
$showcate1="สภา อบต. ";
}
elseif ($pcate1=="syota")
{
$showcate1="ส่วนโยธา ";
}
elseif ($pcate1=="splud")
{
$showcate1="สนง.ปลัด";
}
elseif ($pcate1=="smoney")
{
$showcate1="ส่วนการคลัง ";
}
elseif ($pcate1=="sedu")
{
$showcate1="ส่วนการศึกษา";
}
elseif($pcate1=="admin")
{
$showcate1="admin";
}
$sql2= "select * from tb_gallery where ref_no='$No'";
$result2 = mysql_db_query($dbname,$sql2) or die("");
$NRow2= mysql_num_rows($result2);
if($round%3==1)
{
echo " ";
}
if($nphoto)
{
echo"
";
if($ndata){
if($ndata_size<1000*1024)
{$data_size1=$ndata_size/1024;$b="KB";}
else if($ndata_size<1000*1048576)
{$data_size1=$ndata_size/1048576;$b="MB";}
else if($ndata_size<1000*1073741824)
{$data_size1=$ndata_size/1073741824;$b="TB";}
if($ext=="doc" or $ext=="docx"){$img="iconword.gif";}else if($ext=="xls" or $ext=="xlsx"){$img="iconexcel.gif";}else if($ext=="ppt" or $ext=="pptx"){$img="iconpower.gif";}else if($ext=="pdf"){$img="iconacrobat.gif";}else if($ext=="rar"){$img="iconrar.gif";}else if($ext=="apk"){$img="iconapk.png";}else if($ext=="zip"){$img="iconzip.png";}else if($ext=="jpg"){$img="iconpic.png";}else{$img="icondown.gif";}
echo "";
}
echo" | ";
}
else
{
echo"
";
if($ndata){
if($ndata_size<1000*1024)
{$data_size1=$ndata_size/1024;$b="KB";}
else if($ndata_size<1000*1048576)
{$data_size1=$ndata_size/1048576;$b="MB";}
else if($ndata_size<1000*1073741824)
{$data_size1=$ndata_size/1073741824;$b="TB";}
if($ext=="doc" or $ext=="docx"){$img="iconword.gif";}else if($ext=="xls" or $ext=="xlsx"){$img="iconexcel.gif";}else if($ext=="ppt" or $ext=="pptx"){$img="iconpower.gif";}else if($ext=="pdf"){$img="iconacrobat.gif";}else if($ext=="rar"){$img="iconrar.gif";}else if($ext=="apk"){$img="iconapk.png";}else if($ext=="zip"){$img="iconzip.png";}else if($ext=="jpg"){$img="iconpic.png";}else{$img="icondown.gif";}
echo "";
}
echo" | ";
}
if($round%3==0)
{
echo" | ";
$round=0;
}
$round++;
}
echo " \n\n";
// table แสดงเลขหน้า
echo "\n";
echo "\n";
echo "\t\n";
echo " หน้าที่ ";
// วนลูปแสดงเลขหน้าทั้งหมด
for($i=1 ; $i<$page ; $i++) {
echo "\t$i \n";
}
echo "\t$page \n";
for($i=$page+1 ; $i<=$totalpage ; $i++) {
echo "\t$i \n";
}
echo " | \n";
echo " \n";
}
mysql_close();
?> |
|
|
|
|
require("foot.php");
?>
|
|