mnr PHP Code Examples

Example #1

0

Show file

File: edit_karyawan.php Project: alimustofa/DisplayPRD

<?php

cek_err();
cek_suc();
$id = anti($_GET['id']);
$q = msq($kon, "SELECT *, k.id_bagian as k_bag, b.id_bagian as b_bag, k.nama as nama_kar, b.nama as nama_bagian from t_karyawan k inner join t_bagian b on b.id_bagian=k.id_bagian where nik='{$id}'");
$d = mfa($q);
$j = mnr($q);
if ($j == 0) {
    referer();
}
echo "\r\n\t<script>\r\n\t\tdocument.title = 'Edit Karyawan | DISPLAY PRD'\r\n\t</script>\r\n\t<script>\r\n\t\t\$(document).ready(function(){\r\n\t\t\t\$('.menu9').addClass('sidebar-dash-aktif');\r\n\t\t});\r\n\t</script>\r\n\t\t<div class='title-admin'>\r\n\t\t\t<div style='padding:20px; height:142px; background:rgba(0,0,0,0.4)'>\r\n\t\t\t\t<div style='font-size:70px; margin-right:15px; margin-top:10px;' class='f-putih f-symbol'>?</div>\r\n\t\t\t\t\t<div class='f-putih f24 f-segoe' style='padding:15px; margin-top:50px;'>Edit Karyawan<br><div style='margin-top:7px;' class='f-segoe f-putih f16'><i>Form untuk mengedit karyawan...</i></div></div>\r\n\t\t\t</div>\r\n\t\t</div>\r\n\t\t<div class='title-dash'>\r\n\t\t\t<div class='f14'><a href='#' class='link-biru'>DISPLAY PRD</a> <span class='f-none f-symbol1'>&#215;</span> Form</div>\r\n\t\t</div>\r\n\t\t\r\n\t\t<div class='wrapper-tengah'>\r\n\t\t\t<div class='wrapper-form' style='width:500px;'>\r\n\t\t\t<div class='title-form'><span class='f-symbol mr10'>?</span>EDIT KARYAWAN</div>\r\n\t\t\t\t<div class='pd15'>\r\n\t\t\t\t\t<div class='psn'></div>\r\n\t\t\t\t\t<form method='POST' action='aksi_edit_karyawan' id='form_input' enctype='multipart/form-data'>\r\n\t\t\t\t\t\t<div class='form-grup'>\r\n\t\t\t\t\t\t\t<div class='label-form'>NIK KARYAWAN</div>\r\n\t\t\t\t\t\t\t<input type='text' readonly maxlength='12' class='form transi-3' value='{$d['nik']}' name='nik' autocomplete='off' required>\r\n\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t<div class='form-grup'>\r\n\t\t\t\t\t\t\t<div class='label-form'>NAMA KARYAWAN</div>\r\n\t\t\t\t\t\t\t<input type='text' class='form transi-3' name='nama' value='{$d['nama_kar']}' autocomplete='off' required>\r\n\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t<div class='form-grup'>\r\n\t\t\t\t\t\t\t<div class='label-form'>TGL LAHIR KARYAWAN</div>\r\n\t\t\t\t\t\t\t<input type='text' id='datepicker' class='form transi-3' value='{$d['tgl_lhr']}' name='tgl_lahir' maxlength='10' autocomplete='off' required>\r\n\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t\t<script>\r\n\t\t\t\t\t\t\t\tfunction ambil_mesin()\r\n\t\t\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\t\t\tvar id_bagian = \$('#id_bagian').val();\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\$.ajax({\r\n\t\t\t\t\t\t\t\t\t\ttype: 'POST',\r\n\t\t\t\t\t\t\t\t\t\turl: 'aksi_ambil_mesin',\r\n\t\t\t\t\t\t\t\t\t\tdata: {id_bagian:id_bagian},\r\n\t\t\t\t\t\t\t\t\t\tdataType: 'html',\r\n\t\t\t\t\t\t\t\t\t\tsuccess: function(msg)\r\n\t\t\t\t\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\t\t\t\t\t\$('#wr-idmesin').fadeIn();\r\n\t\t\t\t\t\t\t\t\t\t\t\$('#id_mesin').html(msg);\r\n\t\t\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t\t\t});\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\treturn false;\r\n\t\t\t\t\t\t\t\t}\r\n\r\n\t\t\t\t\t\t\t\tfunction ambil_tugas()\r\n\t\t\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\t\t\tvar id_bagian = \$('#id_bagian').val();\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\$.ajax({\r\n\t\t\t\t\t\t\t\t\t\ttype: 'POST',\r\n\t\t\t\t\t\t\t\t\t\turl: 'aksi_ambil_tugas',\r\n\t\t\t\t\t\t\t\t\t\tdata: {id_bagian:id_bagian},\r\n\t\t\t\t\t\t\t\t\t\tdataType: 'html',\r\n\t\t\t\t\t\t\t\t\t\tsuccess: function(msg)\r\n\t\t\t\t\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\t\t\t\t\t\$('#wr-idtugas').fadeIn();\r\n\t\t\t\t\t\t\t\t\t\t\t\$('#id_tugas').html(msg);\r\n\t\t\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t\t\t});\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\treturn false;\r\n\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t</script>\r\n\t\t\t\t\t\t<div class='form-grup'>\r\n\t\t\t\t\t\t\t<div class='label-form'>NAMA BAGIAN</div>\r\n\t\t\t\t\t\t\t<select class='form transi-3' id='id_bagian' name='id_bagian' onchange='ambil_mesin(); ambil_tugas();' required>\r\n\t\t\t\t\t\t\t\t";
$q_bagian = msq($kon, "SELECT * FROM t_bagian ORDER BY nama ASC");
while ($d_bagian = mfa($q_bagian)) {
    if ($d['id_bagian'] == $d_bagian['id_bagian']) {
        $slc = "selected";
    } else {
        $slc = "";
    }
    echo "<option value='{$d_bagian['id_bagian']}' {$slc}>{$d_bagian['nama']}</option>";
}
echo "\t\t\t\t\t\r\n\t\t\t\t\t\t\t</select>\r\n\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t<div class='form-grup'>\r\n\t\t\t\t\t\t\t<div class='label-form'>NAMA MESIN</div>\r\n\t\t\t\t\t\t\t<select class='form transi-3' name='id_mesin' id='id_mesin' required>\r\n\t\t\t\t\t\t\t\t";
$q_mesin = msq($kon, "SELECT * FROM t_mesin where id_bagian='{$d['id_bagian']}' ORDER BY nama ASC");
while ($d_mesin = mfa($q_mesin)) {
    if ($d['id_mesin'] == $d_mesin['id_mesin']) {
        $slc = "selected";
    } else {
        $slc = "";
    }
    echo "<option value='{$d_mesin['id_mesin']}' {$slc}>{$d_mesin['nama']}</option>";
}

Example #2

0

Show file

File: tambah_jpm_b.php Project: alimustofa/DisplayPRD

<?php

cek_err();
cek_suc();
if (!isset($_GET['id']) || empty($_GET['id'])) {
    header("Location: tambah_jpm");
} else {
    $id = $_GET['id'];
    $q_id_jpm = msq($kon, "select * from t_jpm where id_jpm='{$id}'");
    $jml = mnr($q_id_jpm);
    if ($jml == 0) {
        header("location: tambah_jpm");
    } else {
        $d_id_jpm = mfa($q_id_jpm);
    }
}
$tgl_jpm = mfa(msq($kon, "select * from t_jpm order by id_jpm desc limit 1"));
$q_cek_jpm = msq($kon, "select count(id_jpm) as jml from t_jpm where tgl_mulai='{$tgl_jpm['tgl_mulai']}' and tgl_akhir='{$tgl_jpm['tgl_akhir']}' group by tgl_mulai, tgl_akhir");
$jml_cek_jpm = mfa($q_cek_jpm);
if ($jml_cek_jpm['jml'] > 1) {
    header("Location: tambah_jpm");
}
echo "\r\n\t<script>\r\n\t\tdocument.title = 'Tambah JPM | DISPLAY PRD'\r\n\t</script>\r\n\t<script>\r\n\t\t\$(document).ready(function(){\r\n\t\t\t\$('.menu2').addClass('sidebar-dash-aktif');\r\n\t\t    \$('.table').dataTable({\r\n\t\t        'paging': false\r\n\t\t    });\r\n\t\t});\r\n\t</script>\r\n\t\t<div class='title-admin'>\r\n\t\t\t<div style='padding:20px; height:142px; background:rgba(0,0,0,0.4)'>\r\n\t\t\t\t<div style='font-size:70px; margin-right:15px; margin-top:10px;' class='f-putih f-symbol'>?</div>\r\n\t\t\t\t\t<div class='f-putih f24 f-segoe' style='padding:15px; margin-top:50px;'>Tambah JPM B<br><div style='margin-top:7px;' class='f-segoe f-putih f16'><i>Form untuk menambahkan jadwal pekerjaan mingguan...</i></div></div>\r\n\t\t\t</div>\r\n\t\t</div>\r\n\t\t<div class='title-dash'>\r\n\t\t\t<div class='f14'><a href='#' class='link-biru'>DISPLAY PRD</a> <span class='f-none f-symbol1'>&#215;</span> Form</div>\r\n\t\t</div>\r\n\t\t<script>\r\n\t\t\$(document).ready(function(){\r\n\t\t\t\$('.close-cek-penyelia').click(function(){\r\n\t\t\t\t\$('.wrapper-cek-penyelia').fadeOut();\r\n\t\t\t\tvar nik_peny = \$('#in_id').val();\r\n\t\t\t\t\$('#id_nik_'+nik_peny).prop('checked',false);\r\n\t\t\t});\r\n\r\n\t\t\t\$('.kirim-lokasi').click(function(){\r\n\t\t\t\tvar nik = \$('#in_id').val();\r\n\t\t\t\tvar id_tugas = \$('input:radio[name=lokasi]:checked').val();\r\n\t\t\t\t\r\n\t\t\t\t\$.ajax({\r\n\t\t\t\t\turl: 'aksi_simpan_lokasi',\r\n\t\t\t\t\ttype: 'POST',\r\n\t\t\t\t\tdataType: 'json',\r\n\t\t\t\t\tdata: 'nik='+nik+'&id_tugas='+id_tugas,\r\n\t\t\t\t\tsuccess:function(d){\r\n\t\t\t\t\t\tif(d['hasil']=='1')\r\n\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\t\$('.wrapper-cek-penyelia').fadeOut();\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t}\r\n\t\t\t\t\t\telse\r\n\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\talert('gagal simpan');\r\n\t\t\t\t\t\t}\r\n\t\t\t\t\t}\r\n\r\n\t\t\t\t});\r\n\t\t\t});\r\n\t\t});\r\n\t\t\t\r\n\t\t</script>\r\n\t\t<div class='wrapper-cek-penyelia overlay' style=''>\r\n\t\t\t<div class='wrapper-form' style='width:400px;'>\r\n\t\t\t\t<div class='title-form'><span class='f-symbol mr10'>?</span>LOKASI PENYELIA</div>\r\n\t\t\t\t<div class='pd15'>\r\n\t\t\t\t\t<input type='hidden' name='nik' id='in_id' value=''>";
$q_peny = msq($kon, "select * from t_tugas where id_bagian='2' order by id_tugas desc limit 2");
$no = 1;
while ($d_peny = mfa($q_peny)) {
    if ($no == 1) {
        $checked = 'checked';
    } else {
        $checked = '';
    }

Example #3

0

Show file

File: query.php Project: alimustofa/DisplayPRD

     button_cek();
     $id = anti($_POST['id']);
     $q = msq($kon, "DELETE FROM t_bagian WHERE id_bagian='{$id}'");
     if ($q) {
         $_SESSION['suc'] = "Berhasil menghapus bagian";
     } else {
         $_SESSION['err'] = "Gagal menghapus bagian";
     }
     referer();
     break;
 case "tambah_mesin":
     button_cek();
     $id_bagian = anti($_POST['id_bagian']);
     $nama_mesin = anti($_POST['nama_mesin']);
     $q_mesin = msq($kon, "SELECT * FROM t_mesin WHERE nama='{$nama_mesin}' AND id_bagian='{$id_bagian}'");
     $j_mesin = mnr($q_mesin);
     if ($j_mesin == 0) {
         $q = msq($kon, "INSERT INTO t_mesin(id_bagian,nama) VALUES ('{$id_bagian}','{$nama_mesin}')");
         if ($q) {
             $_SESSION['suc'] = "Berhasil menambahkan mesin";
         } else {
             $_SESSION['err'] = "Gagal menambahkan mesin";
         }
     } else {
         $_SESSION['err'] = "Mesin sudah ada";
     }
     referer();
     break;
 case "edit_mesin":
     button_cek();
     $id_mesin = anti($_POST['id']);

Example #4

0

Show file

File: beranda_admin.php Project: alimustofa/DisplayPRD

<?php

echo "\r\n\t<script>\r\n\t\tdocument.title = 'Beranda Admin | DISPLAY PRD'\r\n\t</script>\r\n\t<script>\r\n\t\t\t\$(document).ready(function(){\r\n\t\t\t\t\$('.menu1').addClass('sidebar-dash-aktif');\r\n\t\t\t\t\$('#table, #table2').DataTable();\r\n\t\t\t});\r\n\t</script>\r\n\t\t<div class='header-admin'>\r\n\t\t\t<div style='padding:20px; height:142px; background:rgba(0,0,0,0.4)'>\r\n\t\t\t\t<div style='font-size:70px; margin-right:15px; margin-top:10px;' class='f-putih f-symbol'>.</div>\r\n\t\t\t\t\t<div class='f-putih f24 f-segoe animated fadeInDown' style='padding:15px; margin-top:50px;'>Selamat Datang <b>Admin</b><br><div style='margin-top:7px;' class='f-segoe f-putih f16'><i>Anda terlihat mengagumkan...</i></div></div>\r\n\t\t\t</div>\r\n\t\t</div>\r\n\t\t<div class='title-dash'>\r\n\t\t\t<div class='bdr-abu-r f-left' style='padding-right:5px; margin-right:10px;'>\r\n\t\t\t\t<div class='f-symbol1 f50 mr10'>/</div>\r\n\t\t\t</div>\r\n\t\t\tDASBOR\r\n\t\t\t<div class='f14'><a href='#' class='link-biru'>JADPEL STM</a> <span class='f-none f-symbol1'>×</span> Dasbor</div>\r\n\t\t</div>\r\n\t\t\r\n\t\t<div class='wrapper-tengah'>\r\n\t\t\t<div class='pd15'>";
$j_karyawan = mnr(msq($kon, "SELECT * FROM t_karyawan"));
$j_hr = mnr(msq($kon, "SELECT * FROM t_bagian"));
$j_umum = mnr(msq($kon, "SELECT * FROM t_ik"));
$j_mesin = mnr(msq($kon, "SELECT * FROM t_mesin"));
echo "\r\n\t\t\t\t<div class='kotak-menu animated flipInY'>\r\n\t\t\t\t\t<div class='icon-kotak-menu f-symbol f-ungu'>.</div>\r\n\t\t\t\t\t<div class='f-right'>\r\n\t\t\t\t\t\t<div class='title-kotak-menu'>Karyawan</div>\r\n\t\t\t\t\t\t<div class='teks-kotak-menu'>{$j_karyawan} data</div>\r\n\t\t\t\t\t</div>\r\n\t\t\t\t\t<div class='cb'></div>\r\n\t\t\t\t</div>\r\n\t\t\t\t<div class='kotak-menu animated flipInY'>\r\n\t\t\t\t\t<div class='icon-kotak-menu f-symbol f-ungu'>u</div>\r\n\t\t\t\t\t<div class='f-right'>\r\n\t\t\t\t\t\t<div class='title-kotak-menu'>Bagian Kerja</div>\r\n\t\t\t\t\t\t<div class='teks-kotak-menu'>{$j_hr} data</div>\r\n\t\t\t\t\t</div>\r\n\t\t\t\t\t<div class='cb'></div>\r\n\t\t\t\t</div>\r\n\t\t\t\t<div class='kotak-menu animated flipInY'>\r\n\t\t\t\t\t<div class='icon-kotak-menu f-symbol f-ungu'>m</div>\r\n\t\t\t\t\t<div class='f-right'>\r\n\t\t\t\t\t\t<div class='title-kotak-menu'>Instruksi Kerja</div>\r\n\t\t\t\t\t\t<div class='teks-kotak-menu'>{$j_umum} data</div>\r\n\t\t\t\t\t</div>\r\n\t\t\t\t\t<div class='cb'></div>\r\n\t\t\t\t</div>\r\n\t\t\t\t<div class='kotak-menu animated flipInY'>\r\n\t\t\t\t\t<div class='icon-kotak-menu f-symbol f-ungu'>^</div>\r\n\t\t\t\t\t<div class='f-right'>\r\n\t\t\t\t\t\t<div class='title-kotak-menu'>Mesin</div>\r\n\t\t\t\t\t\t<div class='teks-kotak-menu'>{$j_mesin} data</div>\r\n\t\t\t\t\t</div>\r\n\t\t\t\t\t<div class='cb'></div>\r\n\t\t\t\t</div>\r\n\t\t\t\t\r\n\t\t\t\t\r\n\t\t\t\t<div class='wrapper-form f-left' style='width:650px; margin-right:15px;'>\r\n\t\t\t\t\t<div class='title-form'><span class='f-symbol mr10'>i</span>DATA KARYAWAN</div>\r\n\t\t\t\t\t<div class='pd15 ov-scr-a' style='overflow-y:scroll; height:400px;'>\r\n\t\t\t\t\t\t<table id='table' class='f-segoe' border='1' style='border:solid 1px rgba(0,0,0,0.3); border-collapse:collapse;'>\r\n\t\t\t\t\t\t\t<thead class='f12'>\r\n\t\t\t\t\t\t\t\t<tr class='title-field'>\r\n\t\t\t\t\t\t\t\t\t<th class='sorting' tabindex='0' aria-controls='example' rowspan='1' colspan='1' aria-label='Office: activate to sort column ascending' style='width: 56px;'>NO</th>\r\n\t\t\t\t\t\t\t\t\t<th class='sorting' tabindex='0' aria-controls='example' rowspan='1' colspan='1' aria-label='Office: activate to sort column ascending' style='width: 56px;'>NIK</th>\r\n\t\t\t\t\t\t\t\t\t<th class='sorting' tabindex='0' aria-controls='example' rowspan='1' colspan='1' aria-label='Office: activate to sort column ascending' style='width: 56px;'>NAMA</th>\r\n\t\t\t\t\t\t\t\t\t<th class='sorting' tabindex='0' aria-controls='example' rowspan='1' colspan='1' aria-label='Office: activate to sort column ascending' style='width: 56px;'>TANGGAL LAHIR</th>\r\n\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t</thead>\r\n\t\t\t\t\t\t\t<tbody>";
$no = 1;
$q_karyawan = msq($kon, "SELECT * FROM t_karyawan ORDER BY nama ASC");
while ($d = mfa($q_karyawan)) {
    echo "\r\n\t\t\t\t\t\t\t\t<tr style='background:rgba(255,255,255,0.4); font-size:12px;'>\r\n\t\t\t\t\t\t\t\t\t<td align='center'>{$no}</td>\r\n\t\t\t\t\t\t\t\t\t<td>{$d['nik']}</td>\r\n\t\t\t\t\t\t\t\t\t<td>{$d['nama']}</td>\r\n\t\t\t\t\t\t\t\t\t<td>{$d['tgl_lhr']}</td>\r\n\t\t\t\t\t\t\t\t</tr>";
    $no++;
}
echo "\r\n\t\t\t\t\t\t\t</tbody>\r\n\t\t\t\t\t\t</table>\r\n\t\t\t\t\t</div>\t\t\r\n\t\t\t\t</div>\r\n\t\t\t\t<div class='wrapper-form f-left' style='width:365px;'>\r\n\t\t\t\t\t<div class='title-form'><span class='f-symbol mr10'>i</span>DATA MESIN</div>\r\n\t\t\t\t\t<div class='pd15 ov-scr-a' style='overflow-y:scroll; height:400px;'>\r\n\t\t\t\t\t\t<table id='table2' class='f-segoe' border='1' style='border:solid 1px rgba(0,0,0,0.3); border-collapse:collapse;'>\r\n\t\t\t\t\t\t\t<thead class='f12'>\r\n\t\t\t\t\t\t\t\t<tr class='title-field'>\r\n\t\t\t\t\t\t\t\t\t<th class='sorting' tabindex='0' aria-controls='example' rowspan='1' colspan='1' aria-label='Office: activate to sort column ascending' style='width: 56px;'>NO</th>\r\n\t\t\t\t\t\t\t\t\t<th class='sorting' tabindex='0' aria-controls='example' rowspan='1' colspan='1' aria-label='Office: activate to sort column ascending' style='width: 56px;'>NAMA MESIN</th>\r\n\t\t\t\t\t\t\t\t\t<th class='sorting' tabindex='0' aria-controls='example' rowspan='1' colspan='1' aria-label='Office: activate to sort column ascending' style='width: 56px;'>BAGIAN</th>\r\n\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t</thead>\r\n\t\t\t\t\t\t\t<tbody>";
$no = 1;
$q_mesin = msq($kon, "SELECT *,m.nama AS nama_mesin,b.nama AS nama_bagian FROM t_mesin m\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN t_bagian b ON m.id_bagian=b.id_bagian\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tORDER BY m.nama ASC");
while ($d = mfa($q_mesin)) {
    echo "\r\n\t\t\t\t\t\t\t\t<tr style='background:rgba(255,255,255,0.4); font-size:12px;'>\r\n\t\t\t\t\t\t\t\t\t<td align='center'>{$no}</td>\r\n\t\t\t\t\t\t\t\t\t<td>{$d['nama_mesin']}</td>\r\n\t\t\t\t\t\t\t\t\t<td>{$d['nama_bagian']}</td>\r\n\t\t\t\t\t\t\t\t</tr>";
    $no++;
}
echo "\r\n\t\t\t\t\t\t\t</tbody>\r\n\t\t\t\t\t\t</table>\r\n\t\t\t\t\t</div>\t\t\r\n\t\t\t\t</div>\r\n\t\t\t</div>\r\n\t\t</div>\r\n\t\t<div class='cb'></div>\r\n\t";
?>

Example #5

0

Show file

File: beranda.php Project: alimustofa/DisplayPRD

}
echo "\r\n\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t<div class='animated fadeInRight'>\r\n\t\t\t\t\t\t";
if ($j_ultah == 0) {
    echo "<p align='center' style='padding:20px;' class='f24'>Tidak ada</p>";
} else {
    echo "\r\n\t\t\t\t\t\t\t\t<article class='grid_3  carousel-article' style='margin-top:20px;'>\r\n\r\n\t\t\t\t                    <div style='display: block; text-align: start; position: relative; top: auto; right: auto; bottom: auto; left: auto; width: 220px; height: 90px; margin: 0px; overflow: hidden;' class='caroufredsel_wrapper'>\r\n\t\t\t\t                    <ul style='text-align: left; float: none; position: absolute; top: 0px; right: auto; bottom: auto; left: 0px; margin: 0px; width: 1540px; height: 90px;' id='foo3' class='carousel-li'>\r\n\t\t\t\t                    \t";
    $q_text = msq($kon, "select *, day(tgl_lhr) as tgl, month(tgl_lhr) as bln, year(tgl_lhr) as thn from t_karyawan having tgl=day(now()) and bln=month(now())");
    while ($d_text = mfa($q_text)) {
        $umur = date('Y') - substr($d_text['tgl_lhr'], 0, 4);
        echo "\r\n\t\t\t\t\t                    \t<li>\r\n\t\t\t\t\t                            <p align='center'><span class='f24' style='color:#2bac68;'>{$d_text['nama']}</span><br><span class='f16'>{$umur} thn</span></p>\r\n\t\t\t\t\t                        </li>";
    }
    echo "\r\n\t\t\t\t                    </ul></div>\r\n\r\n\t\t\t\t                    \r\n\t\t\t\t                </article>\r\n\t\t\t\t                <script>\r\n\t\t\t\t                \$('#foo3').carouFredSel({\r\n\t\t\t\t\t                items: 1,\r\n\t\t\t\t\t                auto: true,\r\n\t\t\t\t\t                scroll: 1\r\n\t\t\t\t\t            });\r\n\t\t\t\t                </script>\r\n\t\t\t\t                ";
}
echo "\r\n\t\t\t\t        </div>\r\n\t\t\t\t\t<div class='wr-left-ribbon'>\r\n\t\t\t\t\t\t<div class='left-ribbon'></div>\r\n\t\t\t\t\t\t<div class='bg-left-ribbon'>\r\n\t\t\t\t\t\t\t<div class='wr-icon-ribbon'><div class='f-symbol f-none'>,\t</div></div>\r\n\t\t\t\t\t\t\t<div class='pd10 f-segoe f-putih' style='margin-left:60px;'>ACARA BULAN INI</div>\r\n\r\n\t\t\t\t\t\t\t<div style='margin-top:15px;' class='animated fadeInRight'>\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t";
$q_event = msq($kon, "select * from t_event where month(waktu_mulai)=month(now()) and year(waktu_mulai)=year(now()) and day(waktu_mulai)>=day(now()) order by waktu_mulai limit 2");
$j_event = mnr($q_event);
if ($j_event == 0) {
    echo "\r\n\t\t\t\t\t\t\t\t\t\t\t<p align='center'><div class='f-symbol f-none t-center' style='font-size:50px; color:#2bac68;'>;</div></p>\r\n\t\t\t\t\t\t\t\t\t\t\t<p align='center' class='f-segoe f20'>Tidak ada event bulan ini</p>\r\n\t\t\t\t\t\t\t\t\t\t\t";
} else {
    while ($d_event = mfa($q_event)) {
        $tgl1 = substr($d_event['waktu_mulai'], 8, 2);
        $bln1 = substr(no_echo_bulan(substr($d_event['waktu_mulai'], 5, 2)), 0, 3);
        $thn1 = substr($d_event['waktu_mulai'], 0, 4);
        $jam1 = substr($d_event['waktu_mulai'], 11, 5);
        $tgl2 = substr($d_event['waktu_akhir'], 8, 2);
        $bln2 = substr(no_echo_bulan(substr($d_event['waktu_akhir'], 5, 2)), 0, 3);
        $thn2 = substr($d_event['waktu_akhir'], 0, 4);
        $jam2 = substr($d_event['waktu_akhir'], 11, 5);
        echo "\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t<div style='border-bottom:solid 1px #ccc; padding:15px;' class='f-segoe'>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class='f20'>{$d_event['judul']}</span>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<div style='margin-top:5px; font-family:calibri;'>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class='f16'><span class='f-symbol f-none' style='color:#85c557;padding-right:10px;'>;</span>{$tgl1} {$bln1} {$thn1} - {$tgl2} {$bln2} {$thn2}</div>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class='f15'><span class='f-symbol f-none' style='color:#85c557;padding-right:10px;'>:</span>{$jam1} - {$jam2}</div>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class='f16'><span class='f-symbol f-none' style='color:#85c557;padding-right:20px;'>u</span>{$d_event['tempat']}</div>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t\t\t\t\t\t\t";
    }
}

PHP mnr Examples