Profiles | Data Diri

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

    <?php
    $queryTlp=mysql_query("select * from tb_pendidikan where nip='".$_GET['id']."' order by tahun_masuk desc");
    while($fieldTlp=mysql_fetch_array($queryTlp))
    {
    echo "

    “;
    }
    ?>

  • “.$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']."' ");
    while($fieldTlp=mysql_fetch_array($queryTlp))
    {
    echo "

  • (“.$fieldTlp[“thn_terbit”].”) “.$fieldTlp[“judul_publikasi”].”, “.$fieldTlp[“kota”].”: “.$fieldTlp[“penerbit”].”
  • “;
    }
    ?>

Research Interest

    <?php
    $queryTlp=mysql_query("select * from tb_bidang_keahlian where nip='".$_GET['id']."'");
    while($fieldTlp=mysql_fetch_array($queryTlp))
    {
    echo "

  • “.$fieldTlp[“bidang_keahlian”].”, “.$fieldTlp[“deskripsi”].”
  • “;
    }

    ?>

Institutional and Professional Service

    <?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 "

  • “.$fieldTlp[“bentuk”].”, “.$fieldTlp[“nm_kegiatan”].”, “.$fieldTlp[“tempat”].”
  • “;
    }

    ?>

Appreciation, Award

    <?php
    $queryTlp=mysql_query("select * from tb_penghargaan where nip='".$_GET['id']."' order by tahun desc");
    while($fieldTlp=mysql_fetch_array($queryTlp))
    {
    echo "

    “;
    }
    ?>

  • “.$fieldTlp[“nm_penghargaan”].”, “.$fieldTlp[“asal”].”, “.$fieldTlp[“tahun”].”