";
echo " ";
echo "";
echo "";
// ตรวจสอบว่ามีรูปหรือไม่
mysql_connect($host,$user,$passwd);
mysql_query("SET NAMES 'utf8' COLLATE 'utf8_general_ci';");
$sql2 = "select * from tb_gallery where id_gallery='$id_gallery1'";
$result2 = mysql_db_query($dbname,$sql2);
$NRow2 = mysql_num_rows($result2);
if($NRow2==0) { echo " "; }
$row2 = mysql_fetch_array($result2);
// กำหนดค่าตัวแปร เพื่อนำไปแสดง
$id_gallery2= $row2["id_gallery"];
$title2= $row2["title"];
$photo_gallery2= $row2["photo_gallery"];
//add คนดู
if($photo_gallery2)
{
echo " $title2
";
}
{}
}
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 " ";
echo " | ";
echo " | ";
if (empty($page))
{
$page=1;
}
mysql_connect($host,$user,$passwd);
mysql_query("SET NAMES 'utf8' COLLATE 'utf8_general_ci';");
$sql3 = "select id_data from tb_data where ref_no='$No'";
$result3 = mysql_db_query($dbname,$sql3);
$NRow3 = mysql_num_rows($result3);
$sql3 = "select * from tb_data where ref_no='$No' order by ref_no DESC ";
$result3 = mysql_db_query($dbname,$sql3) or die("Faied SQL Query");
$NRow3 = mysql_num_rows($result3);
if($NRow3==0) {
echo "";
}
else {
echo"เอกสารแนบท้ายเพิ่มเติม
";
echo " \n";
$round1=1;
$c=1;
while ($row3 = mysql_fetch_array($result3)) {
$id_data= $row3["id_data"];
$title= $row3["title"];
$data_gallery= $row3["data_gallery"];
$data_size= $row3["data_size"];
$ext1 = strtolower(end(explode('.',$data_gallery)));
if($data_gallery){
if($data_size<1000*1024)
{$data_size1=$data_size/1024;$b="KB";}
else if($data_size<1000*1048576)
{$data_size1=$data_size/1048576;$b="MB";}
else if($data_size<1000*1073741824)
{$data_size1=$data_size/1073741824;$b="TB";}
if($round1%3==1)
{
echo "";
}
echo"";
if($ext1=="doc" or $ext1=="docx"){$img="iconword.gif";}else if($ext1=="xls" or $ext1=="xlsx"){$img="iconexcel.gif";}else if($ext1=="ppt" or $ext1=="pptx"){$img="iconpower.gif";}else if($ext1=="pdf"){$img="iconacrobat.gif";}else if($ext1=="rar"){$img="iconrar.gif";}else if($ext1=="jpg"){$img="iconpic.png";}else{$img="icondown.gif";}
if($title)
{
echo " ($c). $title (".number_format( $data_size1 , 2 )." $b) ";
}
else
{
echo " ($c). $data_gallery (".number_format( $data_size1 , 2 )." $b) ";
}
$c=$c+1;
if($round1%3==0)
{
echo" | ";
$round1=0;
}
$round1++;
}
}
echo " |
";
}
// ติดต่อ database เพื่ออ่านข้อมูล
$chk_date = substr(date("Y-m-d H:i:s"),-19,-9);
mysql_connect($host,$user,$passwd);
mysql_query("SET NAMES 'utf8' COLLATE 'utf8_general_ci';");
$sql = "select id_gallery from tb_gallery where ref_no='$No'";
$result = mysql_db_query($dbname,$sql);
$NRow = mysql_num_rows($result);
$rt = $NRow%27;
if($rt!=0) {
$totalpage = floor($NRow/27)+1;
}
else {
$totalpage = floor($NRow/27);
}
$goto = ($page-1)*27;
$sql = "select * from tb_gallery where ref_no='$No' order by id_gallery limit $goto,27";
$result = mysql_db_query($dbname,$sql) or die("Faied SQL Query");
$NRow = mysql_num_rows($result);
if($NRow==0) {
echo " \n";
}
else {
echo " \n";
$round=1;
while ($row = mysql_fetch_array($result)) {
$id_gallery= $row["id_gallery"];
$title= $row["title"];
$photo_gallery= $row["photo_gallery"];
if($round%3==1)
{
echo " ";
}
// echo "
";
echo"
";
if($title)
{
echo"$title";
}else{
echo"-";
}
echo " | ";
if($round%3==0)
{
echo" ";
$round=0;
}
$round++;
}
echo " ";
echo "\n";
echo "| \n";
echo "\t\t\n";
echo " หน้าที่ ";
// วนลูปแสดงเลขหน้าทั้งหมด
for($i=1 ; $i<$page ; $i++) {
echo "\t\t$i \n";
}
echo "\t\t$page \n";
for($i=$page+1 ; $i<=$totalpage ; $i++) {
echo "\t\t$i \n";
}
echo " | \n";
echo " \n";
}
?>
|
