// ติดต่อ database เพื่ออ่านข้อมูล
$No=$_GET['No'];
mysql_connect($host,$user,$passwd);
mysql_query("SET NAMES 'utf8' COLLATE 'utf8_general_ci';");
$sql = "select * from know_data where No='$No'";
$result = mysql_db_query($dbname,$sql);
$NRow = mysql_num_rows($result);
if($NRow==0) { echo "รอการบันทึกข้อมูล";}
$row = mysql_fetch_array($result);
// กำหนดค่าตัวแปร เพื่อนำไปแสดง
$Question = $row["Question"];
$Title5 = $row["Question"];
$Note = $row["Note"];
$Name = $row["Name"];
$Namer = $row["Namer"];
$Member = $row["Member"];
$Email = $row["Email"];
$Date1 = trim(substr($row["Date"],0,11));
$date=displaydate($Date1);
$Image = $row["Image"];
$nphoto = $row["nphoto"];
$showpic= $row["showphoto"];
$ndata = $row["ndata"];
$ndata_size = $row["ndata_size"];
$pageviewdata = $row["pageview"];
$ext = strtolower(end(explode('.',$ndata)));
if($round1%1==1)
//add คนดู
mysql_query("SET NAMES 'utf8' COLLATE 'utf8_general_ci';");
mysql_query("update know_data set pageview=pageview+1 where No=$No");
// ตรวจสอบรูปแบบการแสดง IP Address
switch ($showIP) {
case "ALL" : $IP = "(".$row["IP"].")"; break;
case "BAN" : $IP = "(".substr($row["IP"],0,strrpos($row["IP"],".")).".*)"; break;
case "NONE": $IP = ""; break;
default : $IP = $row["IP"];
}
if($Member) {
$sql = "select * from know_member where User='$Name'";
$result = mysql_db_query($dbname,$sql);
$NRow = mysql_num_rows($result);
if($NRow==0) { echo "Error3"; exit(); }
$row = mysql_fetch_array($result);
// กำหนดค่าตัวแปร เพื่อนำไปแสดง
$ICQ = $row["ICQ"];
$WebName = $row["WebName"];
$URL = $row["URL"];
}
echo "";
echo "";
echo "";
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{$img="icondown.gif";}
echo "กรณีเว็บไม่สามารถแสดงไฟล์ได้ [ คลิกไฟล์แนบ (".number_format( $data_size1,1 )." $b) ] ";
if($ext=="pdf")
{
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 ";
}
else{
if($nphoto)
{
if($showpic==1)
{
echo " ";
}
}
}
echo " $Note ";
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";
}
?> |