Open())
{
echo “Error occure on openning connection or database. Period.”;
}
else
{
echo “”;
}
}
// Open database server connection
function Open ()
{
if (!($ServerConn = @mysql_pconnect($this->DBHost, $this->DBUser, $this->DBPass)))
{
return 0;
} else {
if (!($this->Connection = @mysql_select_db($this->DBName, $ServerConn)))
return 0;
else
return 1;
}
}
}
function dates_time($date_format1, $date_format2, $date_str)
{
$base_struc = split(‘[:/.\ \-]’, $date_format1);
$date_str_parts = split(‘[:/.\ \-]’, $date_str );
// print_r( $base_struc ); echo “\n”; // for testing
// print_r( $date_str_parts ); echo “\n”; // for testing
$date_elements = array();
$p_keys = array_keys( $base_struc );
foreach ( $p_keys as $p_key )
{
if ( !empty( $date_str_parts[$p_key] ))
{
$date_elements[$base_struc[$p_key]] = $date_str_parts[$p_key];
}
else
return false;
}
// print_r($date_elements); // for testing
if (array_key_exists(‘M’, $date_elements)) {
$Mtom=array(
“Jan”=>”01”,
“Feb”=>”02”,
“Maret”=>”03”,
“Apr”=>”04”,
“Mei”=>”05”,
“Jun”=>”06”,
“Jul”=>”07”,
“Aug”=>”08”,
“Sep”=>”09”,
“Oct”=>”10”,
“Nov”=>”11”,
“Dec”=>”12”,
);
$date_elements[‘m’]=$Mtom[$date_elements[‘M’]];
}
// print_r($date_elements); // for testing
$dummy_ts = mktime(
$date_elements[‘H’],
$date_elements[‘i’],
$date_elements[‘s’],
$date_elements[‘m’],
$date_elements[‘d’],
$date_elements[‘Y’]
);
return date( $date_format2, $dummy_ts );
}
$database=new clsDbConn();
$database->Conn();
$query=mysql_query(“select *,year(tgl_lahir) as tahun,month(tgl_lahir) as bulan,day(tgl_lahir) as hari from tb_pegawai where nip='”.$_GET[“id”].”‘”);
$field=mysql_fetch_array($query);
$tempCondition=$field[“status_jns”];
$nip1=$field[“nip”];
$nip2=$field[“nip_baru”];
?>
<img alt="" src="http://sis.fttm.itb.ac.id/sdm/fileFoto/” class=”img_profile” width=”200″/>
–
Education
- “.$fieldTlp[“jenjang_pendidikan”].”, “.$fieldTlp[“nm_pendidikan”].”, “.$fieldTlp[“negara”].”, “.$fieldTlp[“tahun_lulus”].”
|
-
<?php
- “.$fieldTlp[“email”].”
$queryTlp=mysql_query("select * from tb_email where nip='".$_GET['id']."'");
while($fieldTlp=mysql_fetch_array($queryTlp))
{
echo "
“;
}
?>
Unit
-
<?php
- “.$fieldTlp[“nm_unit”].”, “.$fieldTlp[“deskripsi”].”
$queryTlp=mysql_query("select * from tb_ambil_unit a,tb_pegawai b,tb_unit c where a.nip=b.nip and a.kd_unit=c.kd_unit and b.nip='".$_GET['id']."'");
while($fieldTlp=mysql_fetch_array($queryTlp))
{
echo "
“;
}
?>
Penugasan
-
<?php
- “.$fieldJabatan[“nm_jabatan”].”
//$queryTlp=mysql_query("select * from tb_bidang_keahlian where nip='".$_GET['id']."'");
//echo "select * from tb_ambil_jabatan a,tb_pegawai b,tb_struktur_jabatan c where a.nip=b.nip and a.id=c.id and b.nip='".$_GET["id"]."'";
$queryJabatan=mysql_query("select * from tb_ambil_jabatan a,tb_pegawai b,tb_struktur_jabatan c where a.nip=b.nip and a.id=c.id and b.nip='".$_GET["id"]."'");
while($fieldJabatan=mysql_fetch_array($queryJabatan))
{
echo "
“;
}
?>
Job Desc
- “.$fieldTlp[“bentuk”].”, “.$fieldTlp[“nm_kegiatan”].”, “.$fieldTlp[“tempat”].”
<?php
$queryTlp=mysql_query("select * from tb_pengabdian where nip='".$_GET['id']."'");
while($fieldTlp=mysql_fetch_array($queryTlp))
{
$queryUang=mysql_query("select * from tb_mata_uang where kd_mata_uang='".$fieldTlp["kd_mata_uang"]."'");
$fieldUang=mysql_fetch_array($queryUang);
echo "
“;
}
?>
Status Kepegawaian