Пример #1
0
            $pilihan = $datas2['id'] == $pertemuan ? "selected" : '';
            $admin .= '<option value="' . $datas2['id'] . '" ' . $pilihan . '>' . $datas2['pertemuan'] . '</option>';
        }
        $admin .= '</select></td>
	</tr>';
        $admin .= "<tr><td><label><b>Judul</b></label></td><td>";
        $admin .= '<input type="text" name="judul"  class="form-control"value="' . $judul . '"></td></tr>';
        $admin .= "<tr><td>\n<label>Isi</label></td><td><textarea name='konten' id='textarea1'>{$konten}</textarea></td></tr>";
        $admin .= "<tr><td>\n<label><b>File Materi  </b></label></td><td><input type='file' name='gambar'>&nbsp;{$mateributton}\n<input type='hidden' name='materilama' value='{$materi}'>\n</td></tr>";
        $admin .= "\n<tr><td></td><td>\n<input type='hidden' name='guru' value='{$guru}'>\n<input type='hidden' name='idmateri' value='{$idmateri}'>\n<input type='submit'class='btn btn-success' value='Update' name='submit'>\n</td>";
        $admin .= "</tr></table>\n</form>";
        $admin .= '</div>';
    }
    if ($_GET['aksi'] == "detail") {
        $id = int_filter($_GET['id']);
        $idmateri = int_filter($_GET['materi']);
        $admin .= '<div class="panel-heading"><b>Materi</b></div>';
        $hasil = $koneksi_db->sql_query("SELECT * FROM kursus_setting where id='{$id}' ");
        $data = $koneksi_db->sql_fetchrow($hasil);
        $idkursus = $data['id'];
        $guru = $data['guru'];
        $mapel = $data['mapel'];
        $tahun = $data['tahun'];
        $admin .= '
<table cellspacing="0" cellpadding="0"class="table table-striped table-hover">
	<tr>
		<td>Nama Guru</td>
		<td>:</td>
		<td>' . getnamaguru($guru) . '</td>
		<td>Tahun</td>
		<td>:</td>
Пример #2
0
      if(!isNaN(i)) {
        if(b[i].getAttribute("rel")==v) {b[i].style.backgroundColor="#fff";b[i].style.borderBottom="1px solid #fff";}
        else {b[i].style.backgroundColor="#ccc";b[i].style.borderBottom="1px solid #000";}
      }
    }
    for(i in t) {
      if(!isNaN(i)) {
        if(t[i].getAttribute("rel")==v) {t[i].style.display="";}
        else {t[i].style.display="none";}
      }
    }
  }
</script>
<?php 
$id = int_filter($_GET['id']);
$idujian = int_filter($_GET['idujian']);
?>
<form id="form" method="post" action="mod/ujiantest/admin/answer.php">
  <div style="margin:0 0 2px 5px;">
    <span class="tabbutton" onclick="settab(this);" rel="1">Page 1</span>
    <span class="tabbutton" onclick="settab(this);" rel="2">Page 2</span>
    Sisa waktu : <span id="timer"></span>
  </div>
  <div class="tab" rel="1">
    1. 1 + 1 = ...<br>
    <input type="radio" name="radio1" value="a" onclick="send(this)"> 4<br>
    <input type="radio" name="radio1" value="b" onclick="send(this)"> 7<br>
    <input type="radio" name="radio1" value="c" onclick="send(this)"> 2<br>
    <input type="radio" name="radio1" value="d" onclick="send(this)"> 1<br>
    <input type="radio" name="radio1" value="e" onclick="send(this)"> 9<br><br>
    2. 7 x 1 = ...<br>
Пример #3
0
            $nisn = $data['nisn'];
            $hasillomba = $data['hasillomba'];
            $datalomba = getlombapersiswa($replid);
            $admin .= '<tr>
<td>' . $nis . '</td>
<td>' . $nisn . '</td>
<td>' . $nama . '</td>
<td>' . $datalomba . '</td>
<td><a href="?pilih=siswalomba&amp;mod=yes&amp;aksi=add&amp;siswa=' . $data['replid'] . '" onclick="return confirm(\'Apakah Anda Yakin Ingin menambah Prestasi Siswa ?\')"><span class="btn btn-primary">Tambah</span></a>&nbsp;&nbsp;<a href="?pilih=siswalomba&amp;mod=yes&amp;aksi=cetak&amp;idsiswa=' . $data['replid'] . '"><span class="btn btn-success">Cetak</span></a></td>
</tr>';
        }
        $admin .= '</tbody></table>';
        $admin .= '</div>';
    }
    if ($_GET['aksi'] == 'cetak') {
        $idsiswa = int_filter($_GET['idsiswa']);
        if (isset($_POST['cetak'])) {
            $tgl1 = $_POST['tgl1'];
            $tgl2 = $_POST['tgl2'];
            $admin .= '<script language=javascript>
window.open("./cetaksiswalomba.php?idsiswa=' . $idsiswa . '&tgl1=' . $tgl1 . '&tgl2=' . $tgl2 . '", "_blank", "toolbar=yes, scrollbars=yes, resizable=yes, top=50, left=200, width=800, height=600");
</script>';
        }
        $admin .= '<div class="panel panel-info">
<div class="panel-heading"><h3 class="panel-title">Cari Siswa</h3></div>';
        $admin .= '
<form method="post" action="" class="form-inline"id="posts"class="form-inline">
<table class="table table-striped table-hover">
	<tr>
		<td>Siswa</td>
		<td>:</td>
Пример #4
0
<?php

if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) {
    header("HTTP/1.1 404 Not Found");
    exit;
}
$content = '<h4 class="bg">Calender Event</h4>';
$seldate = (int) int_filter($_GET['sel_date']);
$t = getdate($seldate);
$_GET['waktu_akhir'] = isset($_GET['waktu_akhir']) ? $_GET['waktu_akhir'] : null;
$u = getdate((int) int_filter($_GET['waktu_akhir']));
if (isset($_GET['sel_date'])) {
    $content .= '<div class="border">';
    $content .= '<table width="100%">';
    $JUDULCAL = array();
    $TMPpesan = array();
    $awalbulandengannol = $t['mon'] >= 10 ? $t['mon'] : '0' . $t['mon'];
    $varwaktucalender = $t['year'] . '-' . $awalbulandengannol . '-' . $t['mday'];
    $awalbulandengannol2 = $u['mon'] >= 10 ? $u['mon'] : '0' . $u['mon'];
    $varwaktucalender2 = $u['year'] . '-' . $awalbulandengannol2 . '-' . $u['mday'];
    $cekdate = mysql_query("SELECT `judul`,`waktu_mulai`,`waktu_akhir`,`isi` FROM `tbl_kalender` WHERE `waktu_mulai` = '{$varwaktucalender}' OR `waktu_akhir` = '{$varwaktucalender2}' ORDER BY `waktu_mulai`");
    while ($getdate = mysql_fetch_assoc($cekdate)) {
        // print_r($getdate);
        $WKTMULAI = $getdate['waktu_mulai'];
        $WKTAKHIR = $getdate['waktu_akhir'];
        $GTTGL = (int) substr($WKTMULAI, -2, 2);
        $TGLMULAI[$GTTGL] = $GTTGL;
        //
        $JUDULCAL[$GTTGL] = $getdate['judul'];
        $idssss = '<b>' . $getdate['judul'] . '</b><br><small>Periode Awal : ' . converttgl($WKTMULAI) . '<br>Periode Akhir : ' . converttgl($WKTAKHIR) . '</small>
                        <br>' . limitTXT($getdate['isi'], 150) . '';
Пример #5
0
		<td></td>
		<td></td>
		<td>
		<input type="submit" value="Simpan" name="submit"class="btn btn-success"></td>
	</tr>
</table>
</form></div>';
}

if($_GET['aksi']==""){
if(isset($_POST['submit'])){
$jenjang 		= $_POST['jenjang'];
$kode 		= $_POST['kode'];
$nama 		= $_POST['nama'];
$jenis 		= $_POST['jenis'];
$hargajual 		= int_filter($_POST['hargajual']);
	$error 	= '';
	if ($koneksi_db->sql_numrows($koneksi_db->sql_query("SELECT jenjang FROM pos_produkbiaya WHERE jenjang='$jenjang' and jenis='$jenis' and nama='$nama' or kode='$kode'")) > 0) $error .= "Error: Biaya sudah terdaftar , silahkan ulangi.<br />";
	if ($error){
		$admin .= '<div class="error">'.$error.'</div>';
	}else{
		$hasil  = mysql_query( "INSERT INTO `pos_produkbiaya` VALUES ('','$jenis','$jenjang','$kode','$nama','$hargajual')" );
		if($hasil){
			$admin .= '<div class="sukses"><b>Berhasil di Buat.</b></div>';
		}else{
			$admin .= '<div class="error"><b> Gagal di Buat.</b></div>';
		}
		unset($nama);
	}

}
Пример #6
0
 if ($_GET['aksi'] == 'delhistorynilai') {
     global $koneksi_db;
     $user = $_GET['user'];
     $idmapel = int_filter($_GET['idmapel']);
     $hasil = $koneksi_db->sql_query("DELETE FROM `ujiannilai` WHERE `mapel`='{$idmapel}' and `user` ='{$user}'");
     if ($hasil) {
         $admin .= '<div class="sukses">Semua Nilai History berhasil dihapus! .</div>';
         $style_include[] = '<meta http-equiv="refresh" content="1; url=admin.php?pilih=ujian&mod=yes&aksi=nilaihistoryujian" />';
     } else {
         $admin .= '<div class="error">Nilai History gagal dihapus! .</div>';
     }
 }
 if ($_GET['aksi'] == 'delhistorynilaisiswa') {
     global $koneksi_db;
     $user = $_GET['user'];
     $idmapel = int_filter($_GET['idmapel']);
     $hasil = $koneksi_db->sql_query("DELETE FROM `ujiannilai` WHERE `mapel`='{$idmapel}' and `user` ='{$user}'");
     if ($hasil) {
         $admin .= '<div class="sukses">Semua Nilai History berhasil dihapus! .</div>';
         $style_include[] = '<meta http-equiv="refresh" content="1; url=admin.php?pilih=ujian&mod=yes&aksi=nilaiujian" />';
     } else {
         $admin .= '<div class="error">Nilai History gagal dihapus! .</div>';
     }
 }
 /************************/
 if ($_GET['aksi'] == 'setting') {
     $admin .= '<div class="box">
             <div class="box-header">
               <h3 class="box-title">Setting</h3>
             </div><!-- /.box-header -->
             <div class="box-body">';
Пример #7
0
            $gambar = 'photo-default.jpg';
        }
        $admin .= '<tr><td align=center>
<img src="mod/photo/images/normal/' . $gambar . '" alt="' . $gambar . '" style="margin-right: 10px; margin-top: 5px; padding: 3px; border: 1px solid rgb(204, 204, 204); background: none repeat scroll 0% 0% rgb(255, 255, 255); float: left;" border="0">
</td></tr><tr><td>
<div  class=border>
kategori : <a href="admin.php?pilih=photo&mod=yes&aksi=photo&kid=' . $kategori . '">' . $kat2 . '</a><br>
judul : ' . $judul . '<br>
keterangan : ' . $ket . '<br>
</div><div  align=right>
<a href="admin.php?pilih=photo&mod=yes&aksi=cover_photo&id=' . $id . '&kid=' . $kategori . '"><img src="images/cover.gif">
<a href="admin.php?pilih=photo&mod=yes&aksi=edit_photo&id=' . $id . '"><img src="images/edit.gif"></a>
<a href="admin.php?pilih=photo&mod=yes&aksi=hapus_photo&id=' . $id . '"><img src="images/delete.gif"></a></div>
</td></tr>';
    }
    $admin .= '</table>';
    $admin .= '</div>';
}
if ($_GET['aksi'] == 'cover_photo') {
    $id = int_filter($_GET['id']);
    $kid = int_filter($_GET['kid']);
    $s = $koneksi_db->sql_query("SELECT * FROM photo WHERE id={$id}");
    $data = mysql_fetch_array($s);
    $gambar = $data['gambar'];
    $cek = $koneksi_db->sql_query("update kat_photo set gambar = '{$gambar}' WHERE kid = '{$kid}'");
    if ($cek) {
        $admin .= '<div class="sukses">Photo Dengan ID = ' . $id . ' Berhasil Dibuat Cover = ' . $kid . '</div>';
        $style_include[] = '<meta http-equiv="refresh" content="3; url=admin.php?pilih=photo&mod=yes" />';
    }
}
echo $admin;
Пример #8
0
}
if ($_GET['aksi'] == 'cover_photo') {
    $id = int_filter($_GET['id']);
    $kid = int_filter($_GET['kid']);
    $s = $koneksi_db->sql_query("SELECT * FROM photo WHERE id={$id}");
    $data = mysql_fetch_array($s);
    $gambar = $data['gambar'];
    $cek = $koneksi_db->sql_query("update photo_kat set gambar = '{$gambar}' WHERE kid = '{$kid}'");
    if ($cek) {
        $admin .= '<div class="sukses">Photo Dengan ID = ' . $id . ' Berhasil Dibuat Cover = ' . $kid . '</div>';
        $style_include[] = '<meta http-equiv="refresh" content="3; url=admin.php?pilih=photo&mod=yes" />';
    }
}
if ($_GET['aksi'] == "editthumb") {
    $id = int_filter($_GET['id']);
    $topik = int_filter($_GET['topik']);
    if (isset($_POST['submit'])) {
        define("GIS_GIF", 1);
        define("GIS_JPG", 2);
        define("GIS_PNG", 3);
        define("GIS_SWF", 4);
        include "includes/hft_image.php";
        $namafile_name = $_FILES['gambar']['name'];
        if (!empty($namafile_name)) {
            $files = $_FILES['gambar']['name'];
            $tmp_files = $_FILES['gambar']['tmp_name'];
            $namagambar = 'photo-default.jpg';
            $tempnews = 'mod/photo/images/temp/';
            $uploaddir = $tempnews . $namagambar;
            $uploads = move_uploaded_file($tmp_files, $uploaddir);
            if (file_exists($uploaddir)) {
Пример #9
0
<?php
if (!defined('AURACMS_admin')) {
	Header("Location: ../../../index.php");
	exit;
}

if (!cek_login ()){
   $admin .='<p class="judul">Access Denied !!!!!!</p>';
   exit;
}


if (isset ($_GET['pg'])) $pg = int_filter ($_GET['pg']); else $pg = 0;
if (isset ($_GET['stg'])) $stg = int_filter ($_GET['stg']); else $stg = 0;
if (isset ($_GET['offset'])) $offset = int_filter ($_GET['offset']); else $offset = 0;

$style_include[] = <<<style
<style type="text/css">
@import url("mod/news/css/news.css");
</style>

style;

$JS_SCRIPT = <<<js
<!-- TinyMCE -->
<script type="text/javascript" src="js/tinymce/jscripts/tiny_mce/tiny_mce.js"></script>
<script type="text/javascript" src="js/tinymce/jscripts/tiny_mce/init.js"></script>

<script type="text/javascript">
if (typeof tinyMCE == 'object') {
tinyMCE.init({
Пример #10
0
    $admin .= '</table>';
    $admin .= '<div id="responseajax"></div>';
}
######################
## Tampil Testimoni
######################
if ($_GET['aksi'] == 'tampil') {
    if ($_GET['tampil'] == 'tidak') {
        $id = int_filter($_GET['id']);
        $koneksi_db->sql_query("UPDATE testimonial SET status='tidak' WHERE pid='{$id}'");
    }
    if ($_GET['tampil'] == 'ya') {
        $id = int_filter($_GET['id']);
        $koneksi_db->sql_query("UPDATE testimonial SET status='ya' WHERE pid='{$id}'");
    }
    header("location:?pilih=testimonial&mod=yes");
}
######################
## Hapus Testimoni
######################
if ($_GET['aksi'] == 'hapus_testimonial') {
    $pid = int_filter($_GET['pid']);
    $hapus = mysql_query("DELETE FROM `testimonial` WHERE `pid`='{$pid}'");
    if ($hapus) {
        $tengah .= '<div class="sukses">Testimonial Dengan ID = ' . $pid . ' Berhasil Dihapus</div>';
        //$style_include[] ='<meta http-equiv="refresh" content="1; url=?pilih=testimonial&mod=yes" />';
    } else {
        $tengah .= '<div class="error">Testimonial Dengan ID = ' . $pid . ' Gagal dihapus</div>';
    }
}
echo $admin;
Пример #11
0
$pos = int_filter ($_GET['pos']);  
unset($_SESSION['product_id'][$pos]);             
header ("location:$url_situs/shop.html");                 
}

##########################
# EDIT ORDER
##########################
if($_GET['aksi'] == 'edit'){
$pos = int_filter ($_GET['pos']); 
if (isset ($_POST['submit'])){

if(empty($_POST['jumlah'])){
$totaled = $jumlah_iwan;
}else{
	$totaled = int_filter ($_POST['jumlah']);
}
        $total = $_POST['harga'] * $totaled;
	$_SESSION['product_id'][$pos]['jumlah'] = $totaled;    
	$_SESSION['product_id'][$pos]['total'] = $total;    
header ("location:$url_situs/shop.html");        
exit;                                                                  
} 


$new_array = Array ();        
foreach ($_SESSION['product_id'] as $key=>$val){    
	if ($pos == $key){                                                
		$id_iwan 		= $_SESSION['product_id'][$key]['product_id'];    
		$jumlah_iwan 	= $_SESSION['product_id'][$key]['jumlah']; 
		break;                                                                                            
Пример #12
0
        $jmljwb = count($PJAWABAN_TMP);
        $PJAWABAN_TMP[$pilihan]++;
        $PJAWABAN = '';
        for ($i = 0; $i < $jmljwb; $i++) {
            $PJAWABAN .= $PJAWABAN_TMP[$i] . "#";
        }
        $PJAWABAN = substr_replace($PJAWABAN, "", -1, 1);
        //-----------------------------------------------
        //---- simpan data terbaru
        $query2 = "UPDATE `polling` SET `pjawaban`='{$PJAWABAN}' WHERE `pid`='{$pid}'";
        mysql_query($query2);
        // ----------------------------------------------------------------------
    }
}
if (isset($_POST['pid'])) {
    $pid = int_filter($_POST['pid']);
    //$type_poll = 'chart';
    $data_s = mysql_fetch_array(mysql_query("SELECT * FROM polling WHERE pid='{$pid}'"));
    //tampilkan data terbaru
    $hasil = mysql_query("SELECT * FROM polling WHERE pid='{$pid}'");
    $data = mysql_fetch_array($hasil);
    $PJUDUL = $data["pjudul"];
    $PPILIHAN = explode("#", $data["ppilihan"]);
    $PJAWABAN = explode("#", $data["pjawaban"]);
    $jmlpil = count($PPILIHAN);
    $JMLVOTE = 0;
    for ($i = 0; $i < $jmlpil; $i++) {
        $JMLVOTE = $JMLVOTE + $PJAWABAN[$i];
    }
    // Jika tidak ada vote, tetapkan jumlah vote = 1 untuk menghindari pembagian dengan nol
    if ($JMLVOTE == 0) {
Пример #13
0
} );
</script>
js;
    $script_include[] = $JS_SCRIPT;
    $admin .= '<h4 class="page-header">Administrasi Siswa - Kelas</h4>';
    if ($_GET['aksi'] == 'del') {
        global $koneksi_db;
        $id = int_filter($_GET['id']);
        $hasil = $koneksi_db->sql_query("DELETE FROM `akad_siswakelas` WHERE `replid`='{$id}'");
        if ($hasil) {
            $admin .= '<div class="sukses">Siswa Kelas tersebut berhasil dihapus! .</div>';
            $style_include[] = '<meta http-equiv="refresh" content="1; url=admin.php?pilih=siswakelas&mod=yes" />';
        }
    }
    if ($_GET['aksi'] == "addsiswa") {
        $idkelas = int_filter($_GET['idkelas']);
        $query = mysql_query("SELECT * FROM `akad_kelas` WHERE `replid`='{$idkelas}'");
        $data = mysql_fetch_array($query);
        $idkelas = $data['replid'];
        $lokasi = $data['departemen'];
        $kelas = $data['kelas'];
        $tingkat = $data['subtingkat'];
        $kapasitas = $data['kapasitas'];
        $keterangan = $data['keterangan'];
        $ts = $data['ts'];
        $tahunajaran = $data['tahunajaran'];
        $walikelas = $data['walikelas'];
        $jenjang = $data['jenjang'];
        $admin .= '<div class="panel panel-info">
<div class="panel-heading"><h3 class="panel-title">Kelas</h3></div>';
        $admin .= '
Пример #14
0
 $limit = 10;
 $s1 = '';
 $query = htmlentities($query);
 $hasil = $koneksi_db->sql_query("SELECT * FROM artikel WHERE ((judul LIKE '%{$query}%' OR konten LIKE '%{$query}%' OR user LIKE '%{$query}%')AND publikasi=1)");
 $jumlah = $koneksi_db->sql_numrows($hasil);
 if ($jumlah < 1) {
     $s1 = "tidak ada";
 }
 $a = new paging($limit);
 if (!$s1) {
     $tengah .= '<div class="border">';
     $tengah .= "Yang dicari <b>\"{$query}\"</b>";
     $tengah .= '</div>';
     $offset = int_filter(@$_GET['offset']);
     $pg = int_filter(@$_GET['pg']);
     $stg = int_filter(@$_GET['stg']);
     $hasil2 = $koneksi_db->sql_query("SELECT * FROM artikel WHERE ((judul LIKE '%{$query}%' OR konten LIKE '%{$query}%' OR user LIKE '%{$query}%')AND publikasi=1) ORDER By id LIMIT {$offset},{$limit}");
     $tengah .= '<div class="border">';
     $tengah .= "Ditemukan <b>" . $jumlah . "</b> artikel mengandung kata: <b>{$query}</b>";
     $tengah .= '</div>';
     $tengah .= '<div class="border">';
     while ($data = $koneksi_db->sql_fetchrow($hasil2)) {
         $tengah .= "<p class=\"konten\"><a href=\"?pilih=news&amp;mod=yes&amp;aksi=lihat&amp;id={$data['0']}\">{$data['1']}</a><br />";
         $data[5] = datetimes($data['tgl']);
         $tengah .= "<span class=\"keterangan\">{$data['5']} - by : <a href=\"?pilih=news&amp;mod=yes&amp;aksi=pesan&amp;id={$data['0']}\">{$data['3']}</a></span></p>";
     }
     $tengah .= '</div>';
     if ($jumlah >= 10) {
         if (empty($_GET['offset']) and !isset($_GET['offset'])) {
             $offset = 0;
         }
Пример #15
0
<?php

include 'includes/config.php';
include 'includes/mysql.php';
$bulan = int_filter($_GET['bulan']);
$tahun = int_filter($_GET['tahun']);
$pbulan = getbulan($bulan);
global $koneksi_db, $url_situs;
echo "<html><head><title>Laporan Penggajian Bulanan  '.{$pbulan}.'-'.{$tahun}.'</title>";
//echo '<link rel="stylesheet" href="themes/administrator/css/print.css" type="text/css">';
//echo '<link rel="stylesheet" href="includes/bootstrap/css/bootstrap.css" type="text/css">';
echo '<style>
table {
    border-collapse: collapse;
}
.borderbawah {
border-bottom:1px solid black;
	padding			: 2px;
    margin			: 2px 0 5px 0;
}
table, td, th {
    border: 1px solid black;
	font		: 100% Arial, Helvetica, sans-serif;
}
th {
    text-align: center;
}
</style>';
$logoslip = "<img src='images/logoslip.png'>";
echo "</head><body>";
echo '<div align="left">' . $logoslip . '</div>';
Пример #16
0
 if (isset($_POST['submit'])) {
     if (isset($_POST['id'])) {
         foreach ($_POST['id'] as $K => $V) {
             if (!empty($V)) {
                 $del = mysql_query("DELETE FROM `shoutbox` WHERE `id`='{$V}'");
             }
         }
     }
 }
 $pager = mysql_query("SELECT id FROM shoutbox");
 $jumlah = mysql_num_rows($pager);
 $limit = 20;
 if (empty($_GET['offset']) and !isset($_GET['offset'])) {
     $offset = 0;
 } else {
     $offset = int_filter($_GET['offset']);
 }
 $a = new paging($limit);
 // Pembagian halaman dimulai
 if (!isset($_GET['pg'], $_GET['stg'])) {
     $_GET['pg'] = 1;
     $_GET['stg'] = 1;
 }
 $paging = $a->getPaging($jumlah, $_GET['pg'], $_GET['stg']);
 if (!empty($paging)) {
     $content .= '<br><br>';
     $content .= $paging;
     $content .= '';
 }
 $content .= '<form method="post" action="#"><table style="width:100%">';
 $perintah = "SELECT * FROM shoutbox ORDER BY id DESC LIMIT {$offset},{$limit}";
Пример #17
0
     $A = new paging($limit);
     if (empty($offset) and !isset($offset)) {
         $offset = 0;
     }
     $hasil4 = mysql_query("SELECT * FROM " . $GLOBALS['tabel']['link'] . " WHERE {$retornar} and public=1 LIMIT {$offset}, {$limit}");
 }
 $totsearch = mysql_num_rows($hasil4);
 if ($totsearch > 0) {
     $dl .= "Ditemukan <b>" . $jumlah . "</b> Links dengan kata kunci <b>" . htmlspecialchars($search) . "</b>";
 } else {
     $dl .= "Tidak Ditemukan links dengan kata kunci <b>" . htmlspecialchars($search) . "</b>";
 }
 $dl .= '<br />';
 $j = 0;
 $sc = stripslashes(htmlspecialchars(urldecode($_GET['search'])));
 $type = int_filter($_GET['type']);
 $dl .= '<form method="post" action="#" name="links" id="links">';
 while ($row = mysql_fetch_array($hasil4)) {
     ///// fungsi hightlight
     //////////////////////////////////////////////////////////////////////////////////////////////////////////
     $highlight = $search;
     if (isset($search)) {
         // Split words and phrases
         $words = explode(' ', trim(htmlspecialchars(urldecode($search))));
         $highlight_match = '';
         for ($i = 0; $i < sizeof($words); $i++) {
             if (trim($words[$i]) != '') {
                 $highlight_match .= ($highlight_match != '' ? '|' : '') . str_replace('*', '\\w*', phpbb_preg_quote($words[$i], '#'));
             }
         }
         unset($words);
Пример #18
0
     $admin .= $tengah;
 }
 if ($_GET['aksi'] == 'menueditor') {
     $tengah = '';
     if ($_GET['op'] == 'up') {
         $ID = int_filter($_GET['id']);
         $select = $koneksi_db->sql_query("SELECT MAX(ordering) as sc FROM menu_editor");
         $data = $koneksi_db->sql_fetchrow($select);
         $total = $data['sc'] + 1;
         $update = $koneksi_db->sql_query("UPDATE menu_editor SET ordering='{$total}' WHERE ordering='" . ($ID - 1) . "'");
         $update = $koneksi_db->sql_query("UPDATE menu_editor SET ordering=ordering-1 WHERE ordering='{$ID}'");
         $update = $koneksi_db->sql_query("UPDATE menu_editor SET ordering='{$ID}' WHERE ordering='{$total}'");
         header("location:admin.php?pilih=admin_menu&aksi=menueditor");
     }
     if ($_GET['op'] == 'down') {
         $ID = int_filter($_GET['id']);
         $select = $koneksi_db->sql_query("SELECT MAX(ordering) as sc FROM menu_editor");
         $data = $koneksi_db->sql_fetchrow($select);
         $total = $data['sc'] + 1;
         $update = $koneksi_db->sql_query("UPDATE menu_editor SET ordering='{$total}' WHERE ordering='" . ($ID + 1) . "'");
         $update = $koneksi_db->sql_query("UPDATE menu_editor SET ordering=ordering+1 WHERE ordering='{$ID}'");
         $update = $koneksi_db->sql_query("UPDATE menu_editor SET ordering='{$ID}' WHERE ordering='{$total}'");
         header("location:admin.php?pilih=admin_menu&aksi=menueditor");
     }
     if (isset($_POST['submit'])) {
         $menu = $_POST['menu'];
         $url = $_POST['url'];
         $ceks = mysql_query("SELECT MAX(ordering) as ordering FROM menu_editor");
         $hasil = mysql_fetch_array($ceks);
         $ordering = $hasil['ordering'] + 1;
         $error = '';
Пример #19
0
<td valign="top" style="padding:3px;text-align:center;border-top:thin solid #cccccc;">' . rupiah_format($total) . '</td>
</tr>
<tr style="background: #FFFFFF;">
<td colspan="4" valign="top" style="padding:3px;text-align:right;border-top:thin solid #cccccc; border-right:thin solid #cccccc;"><input type="submit" value="Edit" name="submit"></td>
</tr>
</tbody>
</table>
</form>';
    }
}
##########################
# LIHAT KATEGORI URUT
##########################
if ($_GET['aksi'] == 'viewcaturut') {
    $kid = int_filter($_GET['kid']);
    $uid = int_filter($_GET['uid']);
    $periksa = mysql_query("SELECT * FROM `kat_katalog` WHERE `kid`='{$kid}'");
    $dataperiksa = mysql_fetch_array($periksa);
    $cekparentid = $dataperiksa['parentid'];
    $kategori = $dataperiksa['kategori'];
    $periksaurut = mysql_query("SELECT * FROM `kat_urut` WHERE `uid`='{$uid}'");
    $dataperiksaurut = mysql_fetch_array($periksaurut);
    $orderby = $dataperiksaurut['order'];
    if ($cekparentid == '0') {
        $tengah .= '<div class="border"><strong>Kategori</strong> &raquo; ' . $dataperiksa['kategori'] . ', Urut Menurut : ' . $orderby . '</div>';
        $query2 = mysql_query("SELECT count(`id`) AS `total_files` FROM `katalog` WHERE `kategori`='{$kid}' OR `parentid`='{$kid}'");
    } else {
        $pc = mysql_query("SELECT `kategori`,`kid` FROM `kat_katalog` WHERE `kid`='{$cekparentid}'");
        $datapc = mysql_fetch_array($pc);
        $tengah .= '<div class="border"><table width="100%"><tr><td>Kategori# &raquo; <a href="' . $url_situs . '/' . get_link($dataperiksa['kid'], $dataperiksa['kategori'], "kategori-produk") . '" title="' . $datapc['kategori'] . '">' . $dataperiksa['kategori'] . '</a> , Urut Menurut : ' . $orderby . '</td>';
        ///////////////////
Пример #20
0
$admin.='</tbody>
</table>';
}

if($_GET['aksi']== 'deljenis'){    
	global $koneksi_db;    
	$id     = int_filter($_GET['id']);    
	$hasil = $koneksi_db->sql_query("DELETE FROM `po_jenisproduk` WHERE `id`='$id'");    
	if($hasil){    
		$admin.='<div class="sukses">Jenis Produk berhasil dihapus! .</div>';    
		$style_include[] ='<meta http-equiv="refresh" content="1; url=admin.php?pilih=produk&mod=yes&aksi=jenis" />';    
	}
}

if($_GET['aksi'] == 'editjenis'){
$id = int_filter ($_GET['id']);
if(isset($_POST['submit'])){
	$nama 		= $_POST['nama'];
	$error 	= '';
	if ($error){
		$tengah .= '<div class="error">'.$error.'</div>';
	}else{
		$hasil  = mysql_query( "UPDATE `po_jenisproduk` SET `nama`='$nama' WHERE `id`='$id'" );
		if($hasil){
			$admin .= '<div class="sukses"><b>Berhasil di Update.</b></div>';
			$style_include[] ='<meta http-equiv="refresh" content="1; url=admin.php?pilih=produk&amp;mod=yes&aksi=jenis" />';	
		}else{
			$admin .= '<div class="error"><b>Gagal di Update.</b></div>';
		}
	}
Пример #21
0
<?php

include 'includes/config.php';
include 'includes/mysql.php';
$idkary = int_filter($_GET['idkary']);
global $koneksi_db, $translateKal, $url_situs;
echo '<link rel="stylesheet" href="themes/administrator/css/print.css" type="text/css">';
//echo '<link rel="stylesheet" href="includes/bootstrap/css/bootstrap.css" type="text/css">';
$hasil = $koneksi_db->sql_query("SELECT * FROM hrd_karyawan WHERE id={$idkary}");
$data = $koneksi_db->sql_fetchrow($hasil);
$nip = $data['nip'];
$nama = text_filter($data['nama']);
$kotalahir = $data['kotalahir'];
$tgllahir = $data['tgllahir'];
$kelamin = $data['kelamin'];
$agama = $data['agama'];
$menikah = $data['menikah'];
$alamat = $data['alamat'];
$kota = $data['kota'];
$kodepos = $data['kodepos'];
$propinsi = $data['propinsi'];
$negara = $data['negara'];
$telepon = $data['telepon'];
$handphone = $data['handphone'];
$departemen = $data['departemen'];
$jabatan = $data['jabatan'];
$status = $data['status'];
$pendidikan_terakhir = $data['pendidikan_terakhir'];
$fotolama = $data['foto'];
$tglmelamar = $data['tglmelamar'];
$tglditerima = $data['tglditerima'];