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”].”
|
Publication
-
<?php $queryTlp=mysql_query("select * from tb_publikasi_jurnal a,tb_publikasi_jurnal_penulis b where a.id_publikasi=b.id_publikasi and b.nip='".$_GET['id']."' ");
- (“.$fieldTlp[“thn_terbit”].”) “.$fieldTlp[“judul_publikasi”].”, “.$fieldTlp[“kota”].”: “.$fieldTlp[“penerbit”].”
while($fieldTlp=mysql_fetch_array($queryTlp))
{
echo "
“;
}
?>
Research Interest
-
<?php
- “.$fieldTlp[“bidang_keahlian”].”, “.$fieldTlp[“deskripsi”].”
$queryTlp=mysql_query("select * from tb_bidang_keahlian where nip='".$_GET['id']."'");
while($fieldTlp=mysql_fetch_array($queryTlp))
{
echo "
“;
}
?>
Institutional and Professional Service
- “.$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 "
“;
}
?>
Appreciation, Award
- “.$fieldTlp[“nm_penghargaan”].”, “.$fieldTlp[“asal”].”, “.$fieldTlp[“tahun”].”
|