set_charset('utf8'); /* set character */ /* select alumni header */ if ($stmt = $mysqli->prepare("SELECT StudentNo, Course, Point, StuName, Surname, Sex, Address, Zone, Province, Postcode, Email, Degree, CourseThai, CourseEng, StatusQuo, EdPlans, YearOfStudy, DATE_FORMAT(DateOfStudy, '%d-%m-%Y'), DATE_FORMAT(ProposalDate, '%d-%m-%Y'), DATE_FORMAT(ApproveDate, '%d-%m-%Y'), DATE_FORMAT(DefendDate, '%d-%m-%Y'), DATE_FORMAT(GraDate, '%d-%m-%Y'), GraYear, ThesisEng, ThesisThai, MainAdvisor, CoAdvisor,ExamAdvisor, ProTitle, ConferenceName, Place, TypePresent, HowTo, Authors, PubTitle, Publisher, TypePub, Language, Information, DATEDIFF(GraDate,DateOfStudy)/365, photo FROM alumni WHERE StudentNo = ?")) { /* bind parameters to '?' */ /* i = int , d = double and float, b = blob, s = all other types */ $stmt -> bind_param('s',$_SESSION['StudentNo']); /* execute the prepared statement */ $stmt -> execute(); /* bind results to variables */ $stmt-> bind_result($result1, $result2, $result3, $result4, $result5, $result6, $result7, $result8, $result9, $result10, $result11, $result12, $result13, $result14, $result15, $result16, $result17, $result18, $result19, $result20, $result21, $result22, $result23, $result24, $result25, $result26, $result27, $result28, $result29,$result30, $result31, $result32,$result33,$result34, $result35, $result36,$result37,$result38, $result39,$result40,$result41); /* fetch values */ while ($stmt->fetch()) { $_SESSION['StudentNo'] = $result1; $_SESSION['Course'] = $result2; $_SESSION['Point'] = $result3; $_SESSION['StuName'] = $result4; $_SESSION['Surname'] = $result5; $_SESSION['Sex'] = $result6; $_SESSION['Address'] = $result7; $_SESSION['Zone'] = $result8; $_SESSION['Province'] = $result9; $_SESSION['Postcode'] = $result10; $_SESSION['Email'] = $result11; $_SESSION['Degree'] = $result12; $_SESSION['CourseThai'] = $result13; $_SESSION['CourseEng'] = $result14; $_SESSION['StatusQuo'] = $result15; $_SESSION['EdPlans'] = $result16; $_SESSION['YearOfStudy'] = $result17; $_SESSION['DateOfStudy'] = $result18; $_SESSION['ProposalDate'] = $result19; $_SESSION['ApproveDate'] = $result20; $_SESSION['DefendDate'] = $result21; $_SESSION['GraDate'] = $result22; $_SESSION['GraYear'] = $result23; $_SESSION['ThesisEng'] = $result24; $_SESSION['ThesisThai'] = $result25; $_SESSION['MainAdvisor'] = $result26; $_SESSION['CoAdvisor'] = $result27; $_SESSION['ExamAdvisor'] = $result28; $_SESSION['ProTitle'] = $result29; $_SESSION['ConferenceName'] = $result30; $_SESSION['Place'] = $result31; $_SESSION['TypePresent'] = $result32; $_SESSION['HowTo'] = $result33; $_SESSION['Authors'] = $result34; $_SESSION['PubTitle'] = $result35; $_SESSION['Publisher'] = $result36; $_SESSION['TypePub'] = $result37; $_SESSION['Language'] = $result38; $_SESSION['Information'] = $result39; $_SESSION['Years'] = $result40; $_SESSION['photo'] = $result41; if(isset($_SESSION['Years'])){ $year = intval($_SESSION['Years']); $_SESSION['Months'] = (($_SESSION['Years']-$year)*365)/30; $month = intval($_SESSION['Months']); $_SESSION['Days'] = ($_SESSION['Months']-$month)*30; if($month > 11){ $_SESSION['Years'] = $_SESSION['Years'] + 1; $_SESSION['Months'] = 0; } } } } } $path = "image/"; /* $default = "profile.png"; $image = $StudentNo.".png"; $path = "image/"; $str_imgfullpath = $path . $image; if (file_exists($str_imgfullpath)) { $str_imgfullpath = $path . $image; } else { $str_imgfullpath = $path . $default; } */ ?> ยินดีต้อนรับสู่ ภาควิชาบริหารงานสาธารณสุข คณะสาธารณสุขศาสตร์ ม.มหิดล
 

 

   
       ศิษย์ปัจจุบันและศิษย์เก่า
 
   

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ปี เดือน วัน  
 
 
 

 

  

 

 

  
     
   
     

 

  
 
 
 
 
 
     
   
     
 
 
 
 
 
     
 
 
Website Hit Counters
สงวนลิขสิทธิ์© พ.ศ. 2557 คณะสาธารณสุขศาสตร์, มหาวิทยาลัยมหิดล
ภาควิชาบริหารงานสาธารณสุข, 420/1 ถนนราชวิถี เขตราชเทวี กรุงเทพฯ 10400.โทร 0-2354-8543