| Server IP : 182.53.201.61 / Your IP : 216.73.217.175 Web Server : Apache/2.2.15 (Fedora) System : Linux km10.dyndns.org 2.6.31.5-127.fc12.i686.PAE #1 SMP Sat Nov 7 21:25:57 EST 2009 i686 User : apache ( 48) PHP Version : 5.3.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/Menu กลุ่มงานเภสัช/ |
Upload File : |
<?php
function dCon($code){
switch ($code) {
case '01':
return "ทันตแพทย์";
case '05':
return "เจ้าพนักงานเวชสถิติ";
case '06':
return "นักวิชาการคอมพิวเตอร์";
default :
return '';
}
}
function dLev($code){
switch ($code) {
case '9':
return "เชี่่ยวชาญ";
case '8':
return "ชำนาญการพิเศษ";
case '7':
return "ชำนาญการ";
case '6':
return "ปฎิบัติการ";
case '5':
return "ชำนาญงาน";
case '4':
return "ปฏิบัติงาน";
default :
return '';
}
}
function dPos($code){
switch ($code) {
case '1':
return "หัวหน้างาน";
default :
return '';
}
}
$numall =0;
//ตั้งค่าการเชื่อมต่อฐานข้อมูล
$database_host = '192.168.1.39';
$database_port = '3306';
$database_username = 'root';
$database_password = '090407';
$database_name = 'mit';
$mysqli = new mysqli($database_host, $database_username, $database_password, $database_name, $database_port);
$mysqli->set_charset("utf8");
if ($mysqli->connect_error) {
die('Error : ('. $mysqli->connect_errno .') '. $mysqli->connect_error);
}
?>
<!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>โครงสร้างบุคลากรทางการแพทย์</title>
</head>
<body>
<?php
$numall=0;
$rec0 = 1;
$get_sub = $mysqli->query('SELECT empimage.EmpID,empimage.EmpTitle,empimage.EmpName,empimage.Empsurname ,
empimage.no ,empimage.EmpPicture ,empimage.deptcode ,empimage.con,empimage.lev
FROM empimage WHERE no IS NOT NULL AND no != " "AND deptcode = "03001" ');
echo "<ul>";
while($sub1 = $get_sub->fetch_array()){
$numall+=1;
echo "<li>";
$uDept = $sub1['deptcode'];
echo '<a href="JD/'.trim($sub1['EmpName']).' '.$sub1['Empsurname'].'.pdf" target="_blank">
<img src="data:image/jpeg;base64,'.base64_encode( $sub1['EmpPicture'] ).'" width="80" height="100"><br>';
echo trim($sub1['EmpTitle']).trim($sub1['EmpName']).' '.$sub1['Empsurname'].'<br>';
echo dCon($sub1['con']).dLev($sub1['lev']).'<br>';
echo dPos(substr($uDept,4,1)).'<br></a>';
}
mysqli_free_result($get_sub);
$get_sub2 = $mysqli->query('SELECT empimage.EmpID,empimage.EmpTitle,empimage.EmpName,empimage.Empsurname ,
empimage.no ,empimage.EmpPicture ,empimage.deptcode ,empimage.con,empimage.lev
FROM empimage WHERE no IS NOT NULL AND no != " " AND substr(empimage.DeptCode,1,2) = "09" ');
echo "<ul>" ;
while($sub2 = $get_sub2->fetch_array()){
echo "<li>" ;
$numall+=1;
if ($rec0 <= 3) {
$uDept = $sub1['deptcode'];
echo '<a href="JD/'.trim($sub2['EmpName']).' '.$sub2['Empsurname'].'.pdf" target="_blank">
<img src="data:image/jpeg;base64,'.base64_encode( $sub2['EmpPicture'] ).'" width="80" height="100"><br>';
echo trim($sub2['EmpTitle']).trim($sub2['EmpName']).' '.$sub2['Empsurname'].'<br>';
echo dCon($sub2['con']).dLev($sub2['lev']).'<br>';
echo dPos(substr($uDept,4,1)).'<br></a>';
echo "</li>" ;
}
$rec0 +=1;
}
echo "</li>" ;
echo "</ul>" ;
echo "</ul>" ;
mysqli_free_result($get_sub2);
?>
</body>
</html>