示例#1
0
    <td align=left><span class="style9 style2">Sebutan Profesi 2</span></td>
    <td align=left><span class="style9 style2">Sejak</span></td>
    <td align=left><span class="style9 style2">Hingga</span></td>   
  </tr>


<?
/* Data Riwayat Profesi 2 */
$urut = 1;
$sql1 = "select no_urut, nm_profesi, sb_profesi, tgl_mulai, tgl_akhir
         from $tbl_profesi where nipeg='$nipeg' and jenis='2' order by tgl_mulai ASC";
$q1 = mysql_query($sql1);
while(list($no_urut, $nm_profesi, $sb_profesi, $tgl_mulai, $tgl_akhir) = mysql_fetch_row($q1)) {
  
  $tgl_mulai = tgl2ind($tgl_mulai);
  $tgl_akhir = tgl2ind($tgl_akhir);

  print "
  <tr bgcolor= white>
    <td align=left>$no_urut</td>
    <td>$nm_profesi</td>
    <td>$sb_profesi</td>
    <td align=left>$tgl_mulai</td>
    <td align=left>$tgl_akhir</td>     
  </tr>
  ";
  $urut++;
}
?>
	
	</table>	
示例#2
0
  </tr>
";

/* dozir */
$urut = 1;
if($urut%2) $warna = 'LIGHTGREY' ;
  else $warna = 'WHITE';
$sql1 = "select keterangan, no_sk, namafile, tgl_sk,time,id
         from $tbl_dozir where nipeg='$nipeg1'&& id_dozir='$id_dozir' order by tgl_SK ASC" ;
$q1 = mysql_query($sql1);
while(list($keterangan, $no_sk, $namafile, $tgl_sk,$time,$id) = mysql_fetch_row($q1)) {
  $sql2 = "select nama_dozir from jenis_dozir where id_dozir='$id_dozir'";
  $q2 = mysql_query($sql2);
  list($nama_dozir) = mysql_fetch_row($q2);
  $tgl_sk = tgl2ind($tgl_sk);  
  print "
  <tr bgcolor= $warna>
    <td align=left valign=top>$urut</td>
    <td align=left valign=top>$nama_dozir</td>
    <td align=left valign=top>$keterangan</td>
    <td align=left valign=top>$no_sk</td>
    <td align=left valign=top>$tgl_sk</td>
     <td align=left valign=top>$namafile</td>
	  <td valign =top>
	 <a href='carinama2.php?session=$session && namafile=".$namafile." && nip = ".$nipeg." && time=".$time." && id_dozir=".$id_dozir." && no_sk=".$no_sk." && keterangan=".$keterangan." && id=".$id."'>Edit</a>
	
	 <a href='hapus.php?session=$session && namafile=".$namafile." && nip = ".$nipeg." && time=".$time." '>Delete</a> 
	 </td>
	 
  </tr>
示例#3
0
$tgl_sekarang = date("Y-m-d");
$tgl_sekarang=substr($tgl_sekarang,5);

$urut = 1;
$sql1 = "select nipeg,nama, jabatan,tgl_lahir
         from $tbl_bio01 ";
$q1 = mysql_query($sql1);
while(list($nipeg,$nama, $jabatan, $tgl_lahir) = mysql_fetch_row($q1)) {
 if($urut%2) $warna = "LIGHTGREY" ;
  else $warna = "WHITE";
 $tgl_lahir= substr($tgl_lahir,5);
if ($tgl_lahir == $tgl_sekarang) {
 $nipeg = trim($nipeg, " ");
  $foto = $fotodir.$nipeg.".jpg";
  /* rapihkan tampilan */
   $tgl_lahir = tgl2ind($tgl_lahir);
   print "
  <tr bgcolor=$warna>
    <td align=left valign=top>$urut</td>
    <td align=left valign=top>$nama</td>
    <td align=left valign=top>$jabatan</td>
	  ";

  /* trap nama file foto pegawai */
  if(file_exists($foto)) print "
    <td valign=top><img src=$foto width=50 height=70> </td>
	
  ";
  else print "
    <td align=center>&nbsp;</td>
  ";