Software: Apache/2.2.3 (CentOS). PHP/5.1.6 

uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44
EDT 2010 i686 

uid=48(apache) gid=48(apache) groups=48(apache) 

Safe-mode: OFF (not secure)

/var/www/html/reportEregis111/   drwxr-xr-x
Free 40.47 GB of 127.8 GB (31.67%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     detailData.php (3.87 KB)      -rw-r--r--

<meta name="viewport" content="width=device-width, initial-scale=1" charset="x-windows-874">

<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
<link rel="stylesheet"
          href="https://fonts.googleapis.com/css?family=Tangerine">
    <style>
      body {
        font-family: 'Kanit', sans-serif;
        font-size: 15px;
      }
	</style>
	
<script>
	$( function() {
		$( "#datepicker1" ).datepicker();
		$( "#datepicker2" ).datepicker();
	} );
</script>
<style type="text/css">
	@font-face {
		font-family: cha;
		src: url(/font/THSarabunNew.ttf);
	}
	html, body {
		padding:0px;
		margin:0px;
		height:100%;
		font-family: cha;
	}
</style>
<?php
include_once("classes/Crud.php");
$crud = new Crud();
$id=$_GET['id'];
$prodate1=$_GET['prodate1'];
$prodate2=$_GET['prodate2'];
$no=1;
$query = "SELECT * FROM Officer WHERE officerCode='$id' ";
$result = $crud->getData($query);
foreach($result as $key => $res){
		$officerName=$res['officerName']." ".$res['officerSurname'];
}
?>
<table class="table table-striped">
		  <thead class="thead-dark">
			<tr>
				<th colspan="7"><center>ўйНБЩЕЎТГгЛй¤У»ГЦЎЙТўН§ Н. <?=$officerName?> <br>ГРЛЗиТ§ ЗС№·Хи <?=DateThai($prodate1)?> ¶Ц§ <?=DateThai($prodate2)?> </center></th>
			</tr>
			<tr>
			  <th class="text-center">ЕУґСє</th>
			  <th class="text-center">»Х</th>
			  <th class="text-center">¤ГСй§</th>
			  <th class="text-center">а·НБ</th>
			  <th class="text-left">ГТВЄЧиН№СЎИЦЎЙТ·ХиаўйТГиЗБ</th>
			  <th class="text-left">јЕЎТГгЛй¤У»ГЦЎЙТ</th>
			  <th class="text-left">ЗС№·Хи</th>
			  </tr>
		  </thead>
		  <?php
		  $queryData = "SELECT * FROM v_detailData WHERE userID='$id' AND proDate BETWEEN '$prodate1' AND '$prodate2' ";
		  $resultData = $crud->getData($queryData);
		  ?>
		  <tbody>
			  <?php
			  foreach($resultData as $key => $resData){

			  ?>
			  <tr>
		 	  <td class="text-center"><?=$no?></td>
			  <td class="text-center"><?=$resData['academic_year']?></td>
			  <td class="text-center"><?=$resData['round']?></td>
			  <td class="text-center"><?=$resData['term']?></td>
			  <td class="text-left"><?=nl2br(convertName($resData['per1']).",".convertName($resData['per2']).",".convertName($resData['per3']).",".convertName($resData['per4']).",".convertName($resData['per5']).",".convertName($resData['per6']).",".convertName($resData['per7']).",".convertName($resData['per8']).",".convertName($resData['per9']).",".convertName($resData['per10']).",".convertName($resData['per11']).",".convertName($resData['per12']).",".convertName($resData['per13']).",".convertName($resData['per14']).",".convertName($resData['per15']).",".convertName($resData['per16']).",".convertName($resData['per17']).",".convertName($resData['per18']).",".convertName($resData['per19']).",".convertName($resData['per20']))?></td>
			  <td class="text-left"><?=nl2br($resData['result'])?></td>
			  <td class="text-left"><?=DateThai($resData['proDate'])?></td>
			  </tr>
			  <?php
			  $no++;
			  }
			  ?>
		  </tbody>
</table>
<?php
function DateThai($strDate)
{
	$strYear = date("Y",strtotime($strDate))+543;
	$strMonth= date("n",strtotime($strDate));
	$strDay= date("j",strtotime($strDate));
	$strHour= date("H",strtotime($strDate));
	$strMinute= date("i",strtotime($strDate));
	$strSeconds= date("s",strtotime($strDate));
	$strMonthCut = Array("","Б.¤.","Ў.ѕ.","БХ.¤.","аБ.В.","ѕ.¤.","БФ.В.","Ў.¤.","К.¤.","Ў.В.","µ.¤.","ѕ.В.","ё.¤.");
	$strMonthThai=$strMonthCut[$strMonth];
	return "$strDay $strMonthThai $strYear $strHour:$strMinute:$strSeconds";
}
function convertName($id)
{
	$crud = new Crud();
	$query = "SELECT * FROM Student WHERE studentId='$id' ";
	$result = $crud->getData($query);
	foreach($result as $key => $res){
	$studentName=$res['prefixName'].$res['studentName']." ".$res['studentSurname'];
	}
	return $studentName;
}
?>