本文整理汇总了PHP中tglindonesia函数的典型用法代码示例。如果您正苦于以下问题：PHP tglindonesia函数的具体用法？PHP tglindonesia怎么用？PHP tglindonesia使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了tglindonesia函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: tglindonesia
?>
</b></td>
</tr>
<tr>
<td width='20%'>Tanggal Terima</td>
<td width='10px'>:</td>
<td><b><?php
echo tglindonesia($ds_sm["tgl_terima"]);
?>
</b></td>
</tr>
<tr>
<td width='20%'>Tanggal Selesai</td>
<td width='10px'>:</td>
<td><b><?php
echo tglindonesia($ds_sm["harus_selesai"]);
?>
</b></td>
</tr>
<tr>
<td width='20%'>Perihal</td>
<td width='10px'>:</td>
<td><b><?php
echo $ds_sm["perihal_surat"];
?>
</td>
</tr>
<tr>
<td width='20%'>Deskripsi</td>
<td width='10px'>:</td>
<td><b><?php 示例2: array
<!-- CONTROLLER -->
<script type="text/javascript">
<?php
$data = array();
$sql_data = "SELECT\n \ta.*, b.pangkat, b.gol_ruang\n FROM\n \ttbl_usulan_pi a\n \tLEFT JOIN ref_pangkat b ON a.id_pangkat_ttd_usulan = b.id_pangkat\n WHERE\n \ta.kode_skpd LIKE '" . $_SESSION["simpeg_kode_skpd"] . "%'\n ORDER BY\n \ta.id_usulan DESC";
$res_data = mysql_query($sql_data);
while ($ds_data = mysql_fetch_array($res_data)) {
$row_data["id_usulan"] = $ds_data["id_usulan"];
$row_data["no_usulan"] = $ds_data["no_usulan"];
$row_data["tgl_usulan"] = tglindonesia($ds_data["tgl_usulan"]);
$row_data["jabatan_ttd_usulan"] = $ds_data["jabatan_ttd_usulan"];
$row_data["nama_ttd_usulan"] = $ds_data["nama_ttd_usulan"];
$row_data["nip_ttd_usulan"] = $ds_data["nip_ttd_usulan"];
$row_data["status"] = $ds_data["status"];
$row_data["stats"] = status_supervisi($ds_data["status"]);
$row_data["pangkat"] = $ds_data["pangkat"];
$row_data["gol_ruang"] = $ds_data["gol_ruang"];
array_push($data, $row_data);
}
echo "var data = " . json_encode($data) . ";\n";
?>
</script>
<!-- END OF CONTROLLER -->
<!-- JAVASCRIPT PAGE -->
<script type="text/javascript">
function edit(id_usulan){
document.location.href = "?mod=pi_daftar_usulan_edit&id_usulan=" + id_usulan;
}
示例3: mysql_query
<div class="bodypanel">
<table border="0px" cellspacing='0' cellpadding='0' width='100%' class="listingtable">
<thead>
<tr class="headertable">
<th width='40px'>No.</th>
<th>Periode</th>
<th width='450px'>Pejabat Penilai</th>
<th width='450px'>Atasan Pejabat Penilai</th>
<th width='20px'> </th>
</tr>
</thead>
<tbody>
<?php
$res = mysql_query("SELECT\n \ta.*, b.nama_pegawai AS nama_pegawai_penilai, b.nip AS nip_penilai, \n\t c.nama_pegawai AS nama_pegawai_atasan_penilai, c.nip AS nip_atasan_penilai\n FROM\n \ttbl_skp a\n \tLEFT JOIN tbl_pegawai b ON a.id_pegawai_penilai = b.id_pegawai\n \tLEFT JOIN tbl_pegawai c ON a.id_atasan_pegawai_penilai = c.id_pegawai\n LEFT JOIN tbl_skp_perilaku d ON a.id_skp = d.id_skp\n WHERE\n \ta.id_pegawai = '" . $_GET["id_pegawai"] . "' AND (d.status_supervisi = 1 OR d.id_skp IS NULL)\n ORDER BY\n \ta.dari ASC\n ");
$no = 0;
while ($ds = mysql_fetch_array($res)) {
$no++;
echo "<tr>";
echo "<td align='center'>" . $no . "</td>";
//echo("<td align='center'>" . $ds["dari"] . "<br/>S/D<br/>" . $ds["dari"] . "</td>");
echo "<td align='center'>" . tglindonesia($ds["dari"]) . " S/D " . tglindonesia($ds["sampai"]) . "</td>";
echo "<td align='center'>" . $ds["nama_pegawai_penilai"] . " (NIP : " . $ds["nip_penilai"] . ")</td>";
echo "<td align='center'>" . $ds["nama_pegawai_atasan_penilai"] . " (NIP : " . $ds["nip_atasan_penilai"] . ")</td>";
echo "<td>\n <img src='image/Text-Signature-32.png' width='18px' class='linkimage' title='Lanjut Untuk Mengisikan Data Hasil Penilaian Perilaku' onclick='lanjut(" . $ds["id_skp"] . ")' />\n </td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>示例4: strtoupper
echo strtoupper(detail_pegawai($_SESSION["simpeg_id_pegawai"], "nama_pegawai"));
?>
(NIP : <?php
echo strtoupper(detail_pegawai($_SESSION["simpeg_id_pegawai"], "nip"));
?>
)</h3>
<div class="bodypanel bodyfilter" id="bodyfilter">
<?php
$ds = mysql_fetch_array(mysql_query("SELECT\n\t\t\t\t\t\t\t\t\t\t\t\t\ta.*, b.nama_pegawai AS nama_pegawai_penilai, b.nip AS nip_penilai, \n\t\t\t\t\t\t\t\t\t\t\t\t\tc.nama_pegawai AS nama_pegawai_atasan_penilai, c.nip AS nip_atasan_penilai,\n\t\t\t\t\t\t\t\t\t\t\t\t\td.pangkat AS pangkat_penilai, d.gol_ruang AS gol_ruang_penilai,\n\t\t\t\t\t\t\t\t\t\t\t\t\te.pangkat AS pangkat_atasan_penilai, e.gol_ruang AS gol_ruang_atasan_penilai,\n\t\t\t\t\t\t\t\t\t\t\t\t\tf.skpd AS skpd_penilai, g.skpd AS skpd_atasan_penilai,\n\t\t\t\t\t\t\t\t\t\t\t\t\th.jabatan AS jabatan_penilai, i.jabatan AS jabatan_atasan_penilai\n\t\t\t\t\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\t\t\t\t\ttbl_skp a\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN tbl_pegawai b ON a.id_pegawai_penilai = b.id_pegawai\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN tbl_pegawai c ON a.id_atasan_pegawai_penilai = c.id_pegawai\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN ref_pangkat d ON b.id_pangkat = d.id_pangkat\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN ref_pangkat e ON c.id_pangkat = e.id_pangkat\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN ref_skpd f ON b.id_satuan_organisasi = f.id_skpd\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN ref_skpd g ON c.id_satuan_organisasi = g.id_skpd\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN ref_jabatan h ON b.id_jabatan = h.id_jabatan\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN ref_jabatan i ON c.id_jabatan = i.id_jabatan\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t\t\t\ta.id_skp='" . $_GET["id"] . "'\n\t\t\t\t\t\t\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\t\t\t\t\t\t\t\ta.dari ASC\n\t\t\t\t\t\t\t\t\t\t\t\t"));
?>
<table border="0px" cellspacing='0' cellpadding='0' width='100%'>
<tr>
<td width='150px'>Periode</td>
<td width='5px'>:</td>
<td style="text-transform: uppercase;"><b><?php
echo tglindonesia($ds["dari"]) . " S/D " . tglindonesia($ds["sampai"]);
?>
</b></td>
<td width='150px'> </td>
<td width='5px'> </td>
<td> </td>
</tr>
<tr>
<td>Pejabat Penilai</td>
<td>:</td>
<td style="text-transform: uppercase;">
<b>
<?php
echo $ds["nama_pegawai_penilai"];
?>
<br />示例5: mysql_fetch_array
$rnmpri = mysql_fetch_array($nmpri);
$dari_nama = $rnmpri["nama"];
$dari_lev = $d1["dari_level"];
$nmpri = mysql_query("select nama_level from tbl_ket_level where id_level='" . $dari_lev . "'");
$rnmpri = mysql_fetch_array($nmpri);
$dari_level = $rnmpri["nama_level"];
$tujuan = $d1["tujuan"];
$nmpri = mysql_query("select nama from user where id_user='" . $tujuan . "'");
$rnmpri = mysql_fetch_array($nmpri);
$tujuan_nama = $rnmpri["nama"];
$tujuan_lev = $d1["tujuan_level"];
$nmpri = mysql_query("select nama_level from tbl_ket_level where id_level='" . $tujuan_lev . "'");
$rnmpri = mysql_fetch_array($nmpri);
$tujuan_level = $rnmpri["nama_level"];
//$nmpri=mysql_query("select level from user where id_user='$tujuan'");
//$rnmpri = mysql_fetch_array($nmpri);
//$tujuan_level=$rnmpri["level"];
$pesan = $d1["pesan"];
$atas .= " \n\t\t\t<tr>\n\t\t\t\t<td>" . $i . "</td> \n\t\t\t\t<td>" . tglindonesia($d1["tgl"]) . "</td> \n\t\t\t\t<td>" . $dari_nama . "</td> \n\t\t\t\t<td>" . $tujuan_nama . "</td> \n\t\t\t\t<td>" . $pesan . "</td> \n\t\t\t</tr><br/>\t\n\t\t";
$i++;
}
$atas .= "</table>";
$html = $atas;
// output the HTML content
$tes = '<b>hai</b>';
$pdf->writeHTML($html, true, false, true, false, '');
// reset pointer to the last page
$pdf->lastPage();
// ---------------------------------------------------------
//Close and output PDF document
$pdf->Output('print_lembar_disposisi.pdf', 'I');示例6: array
$("#lihat").click(function(){
jAlert("TEST");
});
});
</script>
<!-- CONTROLLER -->
<script type="text/javascript">
<?php
$data = array();
$sql_data = "SELECT\n \ta.*, b.pangkat, b.gol_ruang\n FROM\n \ttbl_sk_kenpang a\n \tLEFT JOIN ref_pangkat b ON a.id_pangkat_ttd_sk = b.id_pangkat\n\t\t\t\tWHERE \n\t\t\t\t\ta.status_supervisi = '3'\n ORDER BY\n \ta.id_data DESC";
$res_data = mysql_query($sql_data);
while ($ds_data = mysql_fetch_array($res_data)) {
$row_data["id_sk"] = $ds_data["id_data"];
$row_data["no_sk"] = $ds_data["no_sk"];
$row_data["tgl_sk"] = tglindonesia($ds_data["tgl_sk"]);
$row_data["jabatan_ttd_sk"] = $ds_data["jabatan_ttd_sk"];
$row_data["nama_ttd_sk"] = $ds_data["nama_ttd_sk"];
$row_data["nip_ttd_sk"] = $ds_data["nip_ttd_sk"];
$row_data["status"] = $ds_data["status_supervisi"];
$row_data["stats"] = status_supervisi($ds_data["status_supervisi"]);
$row_data["no_usul"] = $ds_data["no_usulan_naik_pangkat"];
$row_data["pangkat"] = $ds_data["pangkat"];
$row_data["gol_ruang"] = $ds_data["gol_ruang"];
$row_data["scan_sk"] = $ds_data["scan_sk"];
array_push($data, $row_data);
}
echo "var data = " . json_encode($data) . ";\n";
?>
</script>
<!-- END OF CONTROLLER -->示例7: tglindonesia
</td>
</tr>
</table>
<table border="0px" cellspacing='0' cellpadding='0' width='100%'>
<tr>
<td>
<label>Nomor SK. :</label>
<div class="label_caption"><?php
echo $ds["no_sk"];
?>
</div>
</td>
<td width='300px'>
<label>Tgl SK. :</label>
<div class="label_caption"><?php
echo tglindonesia($ds["tgl_sk"]);
?>
</div>
</td>
</tr>
</table>
<table border="0px" cellspacing='0' cellpadding='0' width='100%'>
<tr>
<td>
<label>Pejabat Penetapan :</label>
<div class="label_caption"><?php
echo $ds["pejabat_penetapan"];
?>
</div>
</td>
</tr>示例8: while
<th colspan="2">AKTIFITAS</th>
</tr>
<?php
if (mysql_num_rows($query) == '') {
echo "<tr >\n\t\t\t\t\t\t\t<td colspan='9'>DATA TIDAK DITEMUKAN</td>\n\t\t\t\t\t\t </tr>";
}
$i = 1;
while ($set = mysql_fetch_array($query)) {
$onc = "tampil('" . $set['no_resi'] . "','" . $_SESSION["id_user"] . "')";
$onc1 = "simpan('" . $set['no_resi'] . "','" . $_SESSION["id_user"] . "')";
$no = 0;
if ($halaman > 1) {
$no = ($halaman - 1) * 20;
}
echo "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>", $no + $i, "</td>\n\t\t\t\t\t\t\t\t<td> " . $set['no_resi'] . "</td>";
echo "<td>" . tglindonesia($set['tgl_masuk']) . "</td>";
echo "<td>" . $set['jenis'] . "</td>";
echo "<td>" . $set['nama'] . "</td>";
echo "<td>" . $set['pemohon'] . "</td>";
echo "<td>" . $set['alamat_usaha'] . "</td>";
echo "<td>" . $set['alamat_pemohon'] . "</td>";
echo "\n\t\t\t\t\t\t\t\t<td width='35px'> <input type='button' value='SURAT TUGAS' onClick={$onc1}></td>\n\t\t\t\t\t\t\t\t<td> <input type='button' value='PROSES' onClick={$onc}></td>\n\t\t\t\t\t\t\t\t</tr>";
$i++;
echo "\n\t\t\t\t\t<tr id='div_if'>\n\t\t\t\t\t\t<td colspan='10'> <div id='div_cek_" . $set['no_resi'] . "'></div>\n\t\t\t\t\t</tr>\n\t\t\t\t\t";
}
?>
</table>
</fieldset></div>
</td>
</tr>
示例9: array
<!-- CONTROLLER -->
<?php
/* Hasil filter data pegawai */
$pegawai = array();
$sql_pegawai = "SELECT\n \taa.id_lhkpn, aa.no_nhk, aa.tgl_lapor, aa.jenis_form, a.id_pegawai, a.nama_pegawai, a.nip,\n \tb.pangkat, b.gol_ruang,\n \tc.jabatan, d.skpd\n FROM\n \ttbl_pegawai a\n \tLEFT JOIN tbl_lhkpn aa ON a.id_pegawai = aa.id_pegawai\n \tLEFT JOIN ref_pangkat b ON aa.id_pangkat = b.id_pangkat\n \tLEFT JOIN ref_jabatan c ON aa.id_jabatan = c.id_jabatan\n \tLEFT JOIN ref_skpd d ON aa.id_skpd = d.id_skpd\n WHERE\n \taa.id_pegawai = '" . $_GET["id_pegawai"] . "'\n ORDER BY\n \t\taa.id_lhkpn ASC";
//echo($sql_pegawai);
$res_pegawai = mysql_query($sql_pegawai) or die(mysql_error());
$no_pegawai = 0;
while ($ds_pegawai = mysql_fetch_array($res_pegawai)) {
$no_pegawai++;
$row_pegawai["no"] = $no_pegawai;
$row_pegawai["id_lhkpn"] = $ds_pegawai["id_lhkpn"];
$row_pegawai["no_nhk"] = $ds_pegawai["no_nhk"];
$row_pegawai["tgl_lapor"] = tglindonesia($ds_pegawai["tgl_lapor"]);
$row_pegawai["jenis_form"] = $ds_pegawai["jenis_form"];
$row_pegawai["id_pegawai"] = $ds_pegawai["id_pegawai"];
$row_pegawai["nama_pegawai"] = $ds_pegawai["nama_pegawai"];
$row_pegawai["nip"] = $ds_pegawai["nip"];
$row_pegawai["pangkat"] = $ds_pegawai["pangkat"];
$row_pegawai["gol_ruang"] = $ds_pegawai["gol_ruang"];
$row_pegawai["jabatan"] = $ds_pegawai["jabatan"];
$row_pegawai["skpd"] = $ds_pegawai["skpd"];
array_push($pegawai, $row_pegawai);
}
?>
<script type="text/javascript">
var pegawai = <?php
echo json_encode($pegawai);
?>示例10: tglindonesia
<tr>
<td>JENIS KELAMIN</td>
<td> : </td>
<td>
<span><b><?php
echo $ds["jenis_kelamin"] == "" ? "-" : $ds["jenis_kelamin"];
?>
</b></span>
</td>
</tr>
<tr>
<td>TEMPAT / TANGGAL LAHIR</td>
<td> : </td>
<td>
<span><b><?php
echo $ds["tempat_lahir"] . ", " . tglindonesia($ds["tanggal_lahir"]);
?>
</b></span>
</td>
</tr><br/>
<tr>
<td colspan="3"><center><span>|<a href="?mod=ganti_password"> GANTI PASSWORD AKUN </a>|</span></center></td>
</tr>
</table>
</div>
</div>
</div>
</td>
</tr>
<tr>示例11: ob_start
ob_start();
session_start();
require_once "../php/dompdf_config.inc.php";
require_once "../php/koneksi.php";
require_once "../php/fungsi.php";
date_default_timezone_set("America/New_York");
?>
<?php
$html = "";
$html .= "<html>";
$html .= "<head>";
$html .= "</head>";
$html .= "<body>";
$html .= "<h3 style='text-align: center;'>REKAP KEGIATAN VERIFIKASI UPLOAD PER TANGGAL " . tglindonesia($_POST["dari"]) . " SAMPAI " . tglindonesia($_POST["sampai"]) . "</h3>";
$html .= "<table width='100%' border='1px' cellspacing='0' cellpadding='5' style='border-collapse: collapse; font-family: sans-serif; font-size: 9pt;'>";
$html .= "<thead>";
$html .= "<tr>";
$html .= "<th width='40px'>NO.</th>";
$html .= "<th>NAMA PENGGUNA</th>";
$html .= "<th width='20%'>TOTAL</th>";
$html .= "</tr>";
$html .= "</thead>";
$html .= "<tbody>";
$no = 0;
$sql = "SELECT\n \ta.nama, a.id_user,\n \tCASE\n \t\tWHEN rekap.jumlah IS NOT NULL THEN rekap.jumlah\n \t\tELSE 0\n \tEND AS jumlah\n FROM\n \ttbl_pengguna a\n \tLEFT JOIN (\n \t\tSELECT\n \t\t\tid_pemeriksa, COUNT(*) AS jumlah\n \t\tFROM\n \t\t\ttbl_skp_dp3_upload_pemeriksaan\n \t\tWHERE\n \t\t\ttgl_periksa BETWEEN '" . $_POST["dari"] . " 00:00:00' AND '" . $_POST["sampai"] . " 23:59:59'\n \t\tGROUP BY\n \t\t\tid_pemeriksa\n \t) rekap ON a.id_user = rekap.id_pemeriksa\n WHERE\n \ta.modul = 12 OR a.modul = 14";
$res = mysql_query($sql);
while ($ds = mysql_fetch_array($res)) {
$no++;
$html .= "<tr>";示例12: tglindonesia
* $html .= "</tr>";
* $html .= "<tr>";
* $html .= "<td style='border: solid 1px #CCC;'>Unit Kerja</td>";
* $html .= "<td style='border: solid 1px #CCC;'>:</td>";
* $html .= "<td style='border: solid 1px #CCC;'>" . $ds_header["skpd_penilai"] . "</td>";
*
* $html .= "<td style='border: solid 1px #CCC;'>Unit Kerja</td>";
* $html .= "<td style='border: solid 1px #CCC;'>:</td>";
* $html .= "<td style='border: solid 1px #CCC;'>" . $ds_header["skpd_atasan_penilai"] . "</td>";
* $html .= "</tr>";
* $html .= "</table>";
*/
$html .= "<div style='height: 10px;'></div>";
$html .= "<table width='100%' cellspacing='0' cellpadding='5' border='0px' style='font-family: sans-serif; font-size: 10pt;'>";
$html .= "<tr>";
$html .= "<td><b>Periode Penilaian : " . tglindonesia($ds_header["dari"]) . " S/D " . tglindonesia($ds_header["sampai"]) . "</b></td>";
$html .= "</tr>";
$html .= "</table>";
$html .= "<table width='100%' cellspacing='0' cellpadding='5' border='0px' style='font-family: sans-serif; font-size: 9.5pt;'>";
$html .= "<thead>";
$html .= "<tr>";
$html .= "<td rowspan='2' width='3%' style='text-align: center; border: solid 1px #000000;'>NO.</td>";
$html .= "<td rowspan='2' width='20%' style='text-align: center; border: solid 1px #000000;'>I. KEGIATAN TUGAS JABATAN</td>";
$html .= "<td rowspan='2' width='5%' style='text-align: center; border: solid 1px #000000;'>AK</td>";
$html .= "<td colspan='4' style='text-align: center; border: solid 1px #000000;'>TARGET</td>";
$html .= "<td rowspan='2' width='5%' style='text-align: center; border: solid 1px #000000;'>AK</td>";
$html .= "<td colspan='4' style='text-align: center; border: solid 1px #000000;'>REALISASI</td>";
$html .= "<td rowspan='2' width='7%' style='text-align: center; border: solid 1px #000000;'>PENG<br/>HITUNGAN</td>";
$html .= "<td rowspan='2' width='8%' style='text-align: center; border: solid 1px #000000;'>CAPAIAN</td>";
$html .= "</tr>";
$html .= "<tr>";示例13: mysql_real_escape_string
<?php
include "../php/koneksi.php";
include "../php/fungsi.php";
$id_usulan = mysql_real_escape_string($_GET['id_usulan']);
$no_usul = getNoUsulFromUsulanCuti($id_usulan);
$sql = "SELECT * FROM tbl_usulan_cuti WHERE id_usulan = '" . $id_usulan . "'";
$query = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($query);
echo "<table border='0' cellspacing='4' cellpadding='4' style='font-size:12px;'>\t\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>NO USULAN </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . $no_usul . "</td>\t\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>TGL USULAN </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . tglindonesia($row['tgl_usulan']) . "</td>\t\n\t\t\t</tr>\t\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>PEJABATAN PENANDATANGAN USULAN </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . $row['pejabat_usulan'] . "</td>\t\n\t\t\t</tr>\n\t\t</table><br/>\t\t\n\t";
echo "<center><span style='font-size:14px; font-weight:bold;' >DAFTAR NAMA PEGAWAI YANG DIUSULKAN</span></center>";
echo "<center><table border='1' cellspacing='4' cellpadding='4' style='font-size:12px;'>";
echo "\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'><center>No</center></td>\n\t\t\t\t<td style='font-weight:bold;'><center>NIP Pegawai</center></td>\n\t\t\t\t<td style='font-weight:bold; width='100px;'><center>Nama Pegawai</center></td>\n\t\t\t\t<td style='font-weight:bold;' width='120px;'><center>Pangkat (Gol.Ruang)</center></td>\n\t\t\t\t<td style='font-weight:bold;' width='100px;'><center>Unit Kerja/SKPD</center></td>\n\t\t\t\t<td style='font-weight:bold;' width='80px;'><center>Lama Cuti (hari)</center></td>\n\t\t\t\t<td style='font-weight:bold;' width='100px;'><center>Jenis Cuti</center></td>\n\t\t\t</tr>\n\t";
$no = 1;
echo "<tbody>";
// hardcode cuy untuk string sql kedua
$ql = "SELECT \n\t\t\t\ta.*, b.nip, b.nama_pegawai, c.skpd, d.pangkat, d.gol_ruang, e.jenis_cuti\n\t\t\tFROM\n\t\t\t\ttbl_usulan_cuti a\n\t\t\t\tLEFT JOIN tbl_pegawai b ON a.id_pegawai = b.id_pegawai\n\t\t\t\tLEFT JOIN ref_skpd c ON b.id_satuan_organisasi = c.id_skpd\n\t\t\t\tLEFT JOIN ref_pangkat d ON b.id_pangkat = d.id_pangkat\n\t\t\t\tLEFT JOIN ref_jenis_cuti e ON a.id_jenis_cuti = e.id_jenis_cuti\n\t\t\tWHERE\n\t\t\t\ta.no_usulan = '" . $no_usul . "' AND a.diproses = '0' \n\t\t\tORDER BY\n\t\t\t b.nama_pegawai ASC\n\t\t ";
$qr = mysql_query($ql) or die(mysql_error());
while ($data = mysql_fetch_array($qr)) {
// normalisasi data
$skpd = $data['skpd'] == '' ? '-' : $data['skpd'];
$panggol = $data['pangkat'] == '' && $data['gol_ruang'] == '' ? '-' : $data['pangkat'] . " (" . $data['gol_ruang'] . ") ";
$nnip = $data['nip'] == '' ? 'NIHIL' : $data['nip'];
$fullname = $data['nama_pegawai'] == '' ? 'NIHIL' : $data['nama_pegawai'];
echo "<tr>\n\t\t\t<td><center>" . $no . "</center></td>\n\t\t\t<td><center>" . $nnip . "</center></td>\n\t\t\t<td><center>" . $fullname . "</center></td>\n\t\t\t<td><center>" . $panggol . "</center></td>\n\t\t\t<td><center>" . $skpd . "</center></td>\n\t\t\t<td><center>" . $data['lama'] . "</center></td>\n\t\t\t<td><center>" . $data['jenis_cuti'] . "</center></td>\n\t\t</tr>";
$no++;
}
echo "</tbody>";
echo "</table></center>";
// tutup koneksi
mysql_close();示例14: while
$res = $con->query($sql);
$ctr = 0;
$res->data_seek(0);
while ($ds = $res->fetch_assoc()) {
$nosur = explode("/", $ds["no_surat"]);
$ctr++;
echo "<tr>";
$kondisi = "belumdibaca";
if ($ds["kondisi"] == 2) {
$kondisi = "telahdibaca";
}
echo "<td align='center'>" . $ctr . "</td>";
echo "<td align='center'>" . no_register($ds["id"]) . "</td>";
echo "<td>" . $ds["no_surat"] . "</td>";
echo "<td>" . tglindonesia($ds["tgl_surat"]) . "</td>";
echo "<td>" . tglindonesia($ds["tgl_kirim"]) . "</td>";
echo "<td>" . $ds["perihal_surat"] . "</td>";
echo "<td>" . $ds["unit_kerja"] . "</td>";
echo "<td>" . $ds["asal"] . "</td>";
echo "<td>" . konversiKeadaanSK($ds["keadaan"]) . "</td>";
echo "<td align='center'>";
echo "<img src='image/Info-32.png' width='18px' class='linkimage' title='Detail Surat Keluar' onclick='lihat_detail_sk(" . $ds["id"] . ", " . $ds["id_disposisi"] . ");'>";
echo "</td>";
echo "<td align='center'>";
echo "<img src='image/icon-disposisi.png' width='18px' class='linkimage' title='Daftar catatan disposisi' onclick='lihat_cadis_sk(" . $ds["id"] . ", " . $ds["id_disposisi"] . ");'>";
echo "</td>";
echo "<td align='center'>";
echo "<a href='./?mod=file_final_surat_keluar&id=" . $ds["id"] . "' id='uploadBerkas_" . $ds["id"] . "'>\n\t\t\t\t\t\t\t<img src='image/upload.png' width='18px' class='linkimage' title='Upload File Final' ></a>";
echo "</td>";
echo "<td align='center'>";
echo "<img src='image/Attachment-32.png' width='18px' class='linkimage' title='File yang dilampirkan' onclick='lihat_file_sk(" . $ds["id"] . ", " . $ds["id_disposisi"] . ");'>";示例15: mysql_real_escape_string
<?php
include "../php/koneksi.php";
include "../php/fungsi.php";
$id_usulan = mysql_real_escape_string($_GET['id_usulan']);
//$no_usulan = get_no_usulan_pangkat($id_usulan);
$sql = "SELECT \n\t\t\t\ta.*,d.pangkat, d.gol_ruang\n\t\t\tFROM\n\t\t\t\ttbl_usulan_pangkat a\n\t\t\t\tLEFT JOIN ref_pangkat d ON a.id_pangkat_ttd = d.id_pangkat\n\t\t\tWHERE\n\t\t\t\ta.id_usulan = '" . $id_usulan . "'\n\t\t ";
$query = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($query);
$tgl_usul = $row['tgl_usulan'] == "" ? "-" : $row['tgl_usulan'];
echo "<table border='0' cellspacing='4' cellpadding='4' style='font-size:12px;'>\t\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>NO USULAN </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . $row['no_usulan'] . "</td>\t\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>TGL USULAN </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . tglindonesia($tgl_usul) . "</td>\t\n\t\t\t</tr>\t\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>NAMA PEJABAT PENGUSUL </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . $row['nama_pejabat_ttd'] . "</td>\t\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>NIP PEJABAT PENGUSUL </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . $row['nip_pejabat_ttd'] . "</td>\t\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>PANGKAT PEJABAT PENGUSUL </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . $row['pangkat'] . " ( " . $row['gol_ruang'] . " )</td>\t\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>JABATAN PEJABAT PENGUSUL </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . $row['jabatan_ttd'] . "</td>\t\n\t\t\t</tr>\n\t\t</table><br/>\t\t\n\t";
echo "<center><span style='font-size:14px; font-weight:bold;' >DAFTAR NAMA PEGAWAI YANG DIUSULKAN</span></center>";
echo "<table border='1' cellspacing='4' cellpadding='4' style='font-size:12px;'>";
echo "\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'><center>No</center></td>\n\t\t\t\t<td style='font-weight:bold;'><center>NIP Pegawai</center></td>\n\t\t\t\t<td style='font-weight:bold;'><center>Nama Pegawai</center></td>\n\t\t\t\t<td style='font-weight:bold;'><center>Unit Kerja/SKPD</center></td>\n\t\t\t\t<td style='font-weight:bold;'><center>Pangkat Lama</center></td>\n\t\t\t\t<td style='font-weight:bold;'><center>Pangkat Baru</center></td>\n\t\t\t</tr>\n\t";
$no = 1;
echo "<tbody>";
// hardcode cuy untuk string sql kedua
$ql = "SELECT \n\t\t\t\ta.id_pegawai, b.nip, b.nama_pegawai, c.skpd, d.pangkat, d.gol_ruang ,\n\t\t\t\te.pangkat as 'PANGKAT_BARU', e.gol_ruang as 'GOLBAR'\n\t\t\tFROM\n\t\t\t\ttbl_detail_usulan_pangkat a\n\t\t\t\tLEFT JOIN tbl_pegawai b ON a.id_pegawai = b.id_pegawai\n\t\t\t\tLEFT JOIN ref_skpd c ON b.id_satuan_organisasi = c.id_skpd\n\t\t\t\tLEFT JOIN ref_pangkat d ON b.id_pangkat = d.id_pangkat\n\t\t\t\tLEFT JOIN ref_pangkat e ON a.id_pangkat_baru = e.id_pangkat\n\t\t\tWHERE\n\t\t\t\ta.id_usulan = '" . $id_usulan . "'\n\t\t\tORDER BY\n\t\t\t b.nama_pegawai ASC\n\t\t ";
$qr = mysql_query($ql);
while ($data = mysql_fetch_array($qr)) {
// normalisasi data
$skpd = $data['skpd'] == '' ? '-' : $data['skpd'];
$panggol = $data['pangkat'] == '' && $data['gol_ruang'] == '' ? '-' : $data['pangkat'] . " (" . $data['gol_ruang'] . ") ";
$nnip = $data['nip'] == '' ? 'NIHIL' : $data['nip'];
$fullname = $data['nama_pegawai'] == '' ? 'NIHIL' : $data['nama_pegawai'];
$p_baru = $data['PANGKAT_BARU'] == '' && $data['GOLBAR'] == '' ? '-' : $data['PANGKAT_BARU'] . " (" . $data['GOLBAR'] . ") ";
echo "<tr>\n\t\t\t<td><center> " . $no . " </center></td>\n\t\t\t<td><center> " . $nnip . " </center></td>\n\t\t\t<td><center> " . $fullname . " </center></td>\n\t\t\t<td><center> " . $skpd . " </center></td>\n\t\t\t<td><center> " . $panggol . " </center></td>\n\t\t\t<td><center> " . $p_baru . " </center></td>\n\t\t</tr>";
$no++;
}
echo "</tbody>";
echo "</table>";