Listing Program. index.php. kanan.php

Listing Program. index.php

kanan.php "; // Tampilkan 3 berita terbaru echo ""; $terkini= mysql_query("SELECT * FROM berita,user WHERE user.id_user=berita.id_user ORDER BY id_berita DESC LIMIT 3"); while($t=mysql_fetch_array($terkini)){ $tgl = tgl_indo($t[tanggal]); echo ""; echo ""; echo ""; echo ""; } // Tampilkan 5 berita sebelumnya echo ""; $sebelum=mysql_query("SELECT * FROM berita ORDER BY id_berita DESC LIMIT 3,5");

while($s=mysql_fetch_array($sebelum)){ echo "";} echo ""; // Tampilkan 3 agenda dan 3 pengumuman echo ""; } // Detail Berita elseif ($_GET[module]=='detailberita'){ $detail=mysql_query("SELECT * FROM berita,user WHERE user.id_user=berita.id_user AND id_berita='$_GET[id]'"); $d = mysql_fetch_array($detail); $tgl = tgl_indo($d[tanggal]); echo ""; echo ""; echo ""; echo ""; echo ""; // Apabila berita dibuka, maka tambahkan counternya mysql_query("UPDATE berita SET counter=$d[counter]+1 WHERE id_berita='$_GET[id]'"); } // Bagian Berita elseif ($_GET[module]=='berita'){ echo ""; $p = new Paging; $batas = 8; $posisi = $p->cariPosisi($batas); $sql = "SELECT * FROM berita,user WHERE user.id_user=berita.id_user ORDER BY id_berita DESC LIMIT $posisi,$batas"; $hasil = mysql_query($sql); while($r=mysql_fetch_array($hasil)){ $tgl = tgl_indo($r[tanggal]); echo ""; echo ""; echo ""; } $jmldata = mysql_num_rows(mysql_query("SELECT * FROM berita")); $jmlhalaman = $p->jumlahHalaman($jmldata, $batas); $linkHalaman = $p->navHalaman($_GET[halaman], $jmlhalaman); echo ""; } // Bagian Agenda elseif ($_GET[module]=='agenda'){ echo ""; $p = new Paging; $batas = 10; $posisi = $p->cariPosisi($batas); $sql = "SELECT * FROM agenda,user WHERE user.id_user=agenda.id_user ORDER BY id_agenda DESC LIMIT $posisi,$batas"; $hasil = mysql_query($sql); while($r=mysql_fetch_array($hasil)){ $tgl_mulai = tgl_indo($r[tgl_mulai]); $tgl_selesai = tgl_indo($r[tgl_selesai]); $isi_agenda=nl2br($r[isi_agenda]);

echo ""; echo ""; echo ""; echo ""; echo ""; } $jmldata = mysql_num_rows(mysql_query("SELECT * FROM agenda")); $jmlhalaman = $p->jumlahHalaman($jmldata, $batas); $linkHalaman = $p->navHalaman($_GET[halaman], $jmlhalaman); echo ""; } // Detail Agenda elseif ($_GET[module]=='detailagenda'){ $detail=mysql_query("SELECT * FROM agenda,user WHERE user.id_user=agenda.id_user AND id_agenda='$_GET[id]'"); $d = mysql_fetch_array($detail); $tgl_mulai = tgl_indo($d[tgl_mulai]); $tgl_selesai = tgl_indo($d[tgl_selesai]); $isi_agenda=nl2br($d[isi_agenda]); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } // Bagian Pengumuman elseif ($_GET[module]=='pengumuman'){ echo ""; $p = new Paging; $batas = 10; $posisi = $p->cariPosisi($batas); $sql = "SELECT * FROM pengumuman,user WHERE user.id_user=pengumuman.id_user ORDER BY id_pengumuman DESC LIMIT $posisi,$batas"; $hasil = mysql_query($sql); while($r=mysql_fetch_array($hasil)){ $tgl = tgl_indo($r[tanggal]); $isi = nl2br($r[isi]); echo ""; echo ""; echo ""; echo ""; } $jmldata = mysql_num_rows(mysql_query("SELECT * FROM pengumuman")); $jmlhalaman = $p->jumlahHalaman($jmldata, $batas); $linkHalaman = $p->navHalaman($_GET[halaman], $jmlhalaman); echo "";

} // Detail Pengumuman elseif ($_GET[module]=='detailpengumuman'){ $detail=mysql_query("SELECT * FROM pengumuman,user WHERE user.id_user=pengumuman.id_user AND id_pengumuman='$_GET[id]'"); $d = mysql_fetch_array($detail); $tgl = tgl_indo($d[tanggal]); $isi = nl2br($d[isi]); echo ""; echo ""; echo ""; echo ""; echo ""; } // Bagian Renungan elseif ($_GET[module]=='renungan'){ echo ""; $p = new Paging; $batas = 10; $posisi = $p->cariPosisi($batas); $sql = "SELECT * FROM renungan,user WHERE user.id_user=Renungan.id_user ORDER BY id_renungan DESC LIMIT $posisi,$batas"; $hasil = mysql_query($sql); while($r=mysql_fetch_array($hasil)){ $tgl = tgl_indo($r[tanggal]); $isi = nl2br($r[isi]); echo ""; echo ""; echo ""; echo ""; echo ""; } $jmldata = mysql_num_rows(mysql_query("SELECT * FROM renungan")); $jmlhalaman = $p->jumlahHalaman($jmldata, $batas); $linkHalaman = $p->navHalaman($_GET[halaman], $jmlhalaman); echo ""; } // Detail Renungan elseif ($_GET[module]=='detailrenungan'){ $detail=mysql_query("SELECT * FROM renungan,user WHERE user.id_user=renungan.id_user AND id_renungan='$_GET[id]'"); $d = mysql_fetch_array($detail); $tgl = tgl_indo($d[tanggal]); $isi = nl2br($d[isi]); echo ""; echo ""; echo "";

echo ""; echo ""; echo ""; } // Bagian Khotbah elseif ($_GET[module]=='khotbah'){ echo ""; $p = new Paging; $batas = 10; $posisi = $p->cariPosisi($batas); $sql = "SELECT * FROM khotbah,user WHERE user.id_user=khotbah.id_user ORDER BY id_khotbah DESC LIMIT $posisi,$batas"; $hasil = mysql_query($sql); while($r=mysql_fetch_array($hasil)){ $tgl = tgl_indo($r[tanggal]); $isi = nl2br($r[isi]); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } $jmldata = mysql_num_rows(mysql_query("SELECT * FROM khotbah")); $jmlhalaman = $p->jumlahHalaman($jmldata, $batas); $linkHalaman = $p->navHalaman($_GET[halaman], $jmlhalaman); echo ""; } // Detail Khotbah elseif ($_GET[module]=='detailkhotbah'){ $detail=mysql_query("SELECT * FROM khotbah,user WHERE user.id_user=khotbah.id_user AND id_khotbah='$_GET[id]'"); $d = mysql_fetch_array($detail); $tgl = tgl_indo($d[tanggal]); $isi = nl2br($d[isi]); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } // Bagian Hubungi Kami

elseif ($_GET[module]=='hubungi'){ echo ""; echo ""; echo ""; echo ""; } // Bagian Kirim Email elseif ($_GET[module]=='kirimemail'){ mysql_query("INSERT INTO hubungi(nama,email,subjek,pesan,tanggal) VALUES('$_POST[nama]','$_POST[email]','$_POST[subjek]','$_POST[pesan]',' $tgl_sekarang')"); echo ""; } // Bagian Profil elseif ($_GET[module]=='profil'){ echo ""; $profil = mysql_query("SELECT * FROM modul WHERE id_modul='11'"); $r = mysql_fetch_array($profil); echo ""; echo ""; } // Bagian Susunan Kepengurusan Pusat GBKP elseif ($_GET[module]=='pengurus'){ echo ""; $pengurus = mysql_query("SELECT * FROM modul WHERE id_modul='12'"); $r = mysql_fetch_array($pengurus); echo ""; echo ""; } // Bagian Hasil Pencarian elseif ($_GET[module]=='hasilcari'){ echo ""; // Hanya mencari berita, apabila diperlukan bisa ditambahkan utk mencari agenda, pengumuman, dll $cari = mysql_query("SELECT * FROM berita WHERE isi_berita LIKE '%$_POST[kata]%' OR judul LIKE '%$_POST[kata]%'"); $jumlah = mysql_num_rows($cari); if ($jumlah > 0){ echo ""; } else{ echo ""; } echo ""; } ?>

» Berita Terkini

$t[hari], $tgl

$t[judul]

Ditulis Oleh : $t[nama_lengkap]

"; if ($t[gambar]!=''){ echo ""; } // Tampilkan hanya sebagian isi berita $isi_berita = nl2br($t[isi_berita]); $isi = substr($isi_berita,0,410); // ambil sebanyak 410 karakter $isi = substr($isi_berita,0,strrpos($isi," ")); // spasi antar kalimat echo "$isi ... Selengkapnya

•     $s[judul]

"; $agenda=mysql_query("SELECT * FROM agenda ORDER BY id_agenda DESC LIMIT 3"); while($a=mysql_fetch_array($agenda)){ $mulai =tgl_indo($a[tgl_mulai]); $selesai=tgl_indo($a[tgl_selesai]); echo " $mulai - $selesai $a[tema] "; } echo " "; $umum=mysql_query("SELECT * FROM pengumuman ORDER BY id_pengumuman DESC LIMIT 3"); while($u=mysql_fetch_array($umum)){ $tgl=tgl_indo($u[tanggal]); echo " $tgl $u[judul] "; } echo "

$d[hari], $tgl

$d[judul]

Ditulis Oleh : $d[nama_lengkap]

"; if ($d[gambar]!=''){ echo ""; } $isi_berita=nl2br($d[isi_berita]); echo "$isi_berita

[ Kembali ]

» Berita

$r[hari], $tgl

$r[judul]

"; // Tampilkan hanya sebagian isi berita $isi_berita = nl2br($r[isi_berita]); $isi = substr($isi_berita,0,380); // ambil sebanyak 410 karakter $isi = substr($isi_berita,0,strrpos($isi," ")); // spasi antar kalimat echo "$isi ... Selengkapnya

$linkHalaman

» Agenda

$tgl_mulai s/d $tgl_selesai

$r[tema]

Topik:$isi_agenda

Tempat:$r[tempat]

Pengirim : $r[nama_lengkap]

$linkHalaman

$tgl_mulai s/d $tgl_selesai

$d[tema]

Topik : $isi_agenda

Tempat : $d[tempat]

Pengirim : $d[nama_lengkap]

[ Kembali ]

» Pengumuman

$tgl

$r[judul]

$isi

Pengirim : $r[nama_lengkap]

$linkHalaman

$tgl

$d[judul]

$isi

Pengirim : $d[nama_lengkap]

[ Kembali ]

» Renungan Harian

$tgl

$r[judul]

$r[bahan_khotbah]

$isi

Pengirim : $r[nama_lengkap]

$linkHalaman

$tgl

$d[judul]

$d[bahan_khotbah]

$isi

Pengirim : $d[nama_lengkap]

[ Kembali ]

» Bimbingan Khotbah

$tgl

$r[introitus]

$r[ogen]

$r[khotbah]

$r[thema]

$isi

Pengirim : $r[nama_lengkap]

$linkHalaman

$tgl

$d[introitus]

$d[ogen]

$d[khotbah]

$d[thema]

$isi

Pengirim : $d[nama_lengkap]

[ Kembali ]

» Hubungi Kami

Silahkan hubungi kami secara online:

Nama :

E-mail :

Subjek:

Pesan :

[ Kembali ]

» Status Email

Email telah sukses terkirim dan segera akan kami balas

[ Kembali ]

» Profil Moderamen GBKP

"; if ($r[gambar]!=''){ echo ""; } $isi_profil=nl2br($r[static_content]); echo "$isi_profil

[ Kembali ]

» Susunan Kepengurusan Pusat GBKP

"; if ($r[gambar]!=''){ echo ""; } $isi_pengurus=nl2br($r[static_content]); echo "$isi_pengurus

[ Kembali ]

» Hasil Pencarian

Ditemukan $jumlah berita dengan kata kunci $_POST[kata] : "; while($r=mysql_fetch_array($cari)){ echo " $r[judul] "; } echo "

Tidak ditemukan berita dengan kata $_POST[kata]

[ Kembali ]

kiri.php "; // Menu Utama echo ""; $menu=mysql_query("SELECT * FROM modul WHERE publish='Y' and aktif='Y' ORDER BY urutan");

echo ""; while($r=mysql_fetch_array($menu)){ echo ""; } echo ""; // Berita Terpopuler echo ""; $populer=mysql_query("SELECT * FROM berita ORDER BY counter DESC LIMIT 10"); while($p=mysql_fetch_array($populer)){ echo ""; } echo ""; // Tampilkan banner dalam bentuk gambar $banner=mysql_query("SELECT * FROM banner ORDER BY id_banner DESC"); while($b=mysql_fetch_array($banner)){ echo ""; } ?>

•	Beranda
•	$r[nama_modul]
•	$p[judul] ($p[counter])

media.php <style type="text/css">



mod_agenda.php Agenda "; if ($_SESSION[leveluser]=='admin'){ $tampil=mysql_query("SELECT * FROM agenda ORDER BY id_agenda DESC"); } else{ $tampil=mysql_query("SELECT * FROM agenda WHERE id_user='$_SESSION[namauser]' ORDER BY id_agenda DESC"); } $no=1; while ($r=mysql_fetch_array($tampil)){ $tgl_mulai = tgl_indo($r[tgl_mulai]); $tgl_selesai = tgl_indo($r[tgl_selesai]); echo ""; $no++; } echo "

no	tema	tgl. mulai	tgl. selesai	aksi
$no	$r[tema]	$tgl_mulai	$tgl_selesai	Edit | Hapus

"; break; case "tambahagenda": echo "

Tambah Agenda

Tema	:
Isi Agenda	:
Tempat	:
Tgl Mulai	: "; combotgl(1,31,'tgl_mulai',Tgl); combobln(1,12,'bln_mulai',Bulan); combotgl($thn_sekarang-2,$thn_sekarang+2,'thn_mulai',Tahun); echo "
Tgl Selesai	: "; combotgl(1,31,'tgl_selesai',Tgl); combobln(1,12,'bln_selesai',Bulan); combotgl($thn_sekarang-2,$thn_sekarang+2,'thn_selesai',Tahun); echo "

"; break; case "editagenda": $edit = mysql_query("SELECT * FROM agenda WHERE id_agenda='$_GET[id]'"); $r = mysql_fetch_array($edit); echo "

Edit Agenda

Tema	:
Isi Agenda	: $r[isi_agenda]
Tempat	:
Tgl Mulai	: "; $get_tgl=substr("$r[tgl_mulai]",8,2); combotgl2(1,31,'tgl_mulai',$get_tgl); $get_bln=substr("$r[tgl_mulai]",5,2); combobln2(1,12,'bln_mulai',$get_bln); $get_thn=substr("$r[tgl_mulai]",0,4); $thn_skrg=date("Y"); combotgl2($thn_sekarang2,$thn_sekarang+2,'thn_mulai',$get_thn); echo "
Tgl Selesai	: "; $get_tgl2=substr("$r[tgl_selesai]",8,2); combotgl2(1,31,'tgl_selesai',$get_tgl2); $get_bln2=substr("$r[tgl_selesai]",5,2); combobln2(1,12,'bln_selesai',$get_bln2); $get_thn2=substr("$r[tgl_selesai]",0,4); combotgl2($thn_sekarang-2,$thn_sekarang+2,'thn_selesai',$get_thn2); echo "

"; break; } ?>

mod_banner.php Banner "; $tampil=mysql_query("SELECT * FROM banner ORDER BY id_banner DESC"); $no=1; while ($r=mysql_fetch_array($tampil)){ $tgl=tgl_indo($r[tgl_posting]); echo ""; $no++; } echo "

no	judul	link	tgl. posting	aksi
$no	$r[judul]	$r[url]	$tgl	Edit | Hapus

"; break; case "tambahbanner": echo "

Tambah Banner

Judul	:
Link	:
Gambar	:

"; break; case "editbanner": $edit = mysql_query("SELECT * FROM banner WHERE id_banner='$_GET[id]'"); $r = mysql_fetch_array($edit); echo "

Edit Banner

Judul	:
Link	:
Gambar	:
Ganti Gbr	: *)
*) Apabila gambar tidak diubah, dikosongkan saja.

"; break; } ?>

mod_berita.php Berita "; $p = new Paging; $batas = 10; $posisi = $p->cariPosisi($batas); if ($_SESSION[leveluser]=='admin'){ $tampil = mysql_query("SELECT * FROM berita ORDER BY id_berita DESC limit $posisi,$batas"); } else{ $tampil=mysql_query("SELECT * FROM berita WHERE id_user='$_SESSION[namauser]' ORDER BY id_berita DESC"); } $no = $posisi+1; while($r=mysql_fetch_array($tampil)){ $tgl_posting=tgl_indo($r[tanggal]);

echo ""; $no++; } echo "

no	judul	tgl. posting	aksi
$no	$r[judul]	$tgl_posting	Edit | Hapus

"; if ($_SESSION[leveluser]=='admin'){ $jmldata = mysql_num_rows(mysql_query("SELECT * FROM berita")); } else{ $jmldata = mysql_num_rows(mysql_query("SELECT * FROM berita WHERE id_user='$_SESSION[namauser]'")); } $jmlhalaman = $p->jumlahHalaman($jmldata, $batas); $linkHalaman = $p->navHalaman($_GET[halaman], $jmlhalaman); echo "
"; break; case "tambahberita": echo "

Tambah Berita

Judul	:
Kategori	: <select name='kategori'> - Pilih Kategori -"; $tampil=mysql_query("SELECT * FROM kategori ORDER BY nama_kategori"); while($r=mysql_fetch_array($tampil)){ echo "$r[nama_kategori]"; } echo "
Isi Berita	:
Gambar	:

"; break; case "editberita": $edit = mysql_query("SELECT * FROM berita WHERE id_berita='$_GET[id]'"); $r = mysql_fetch_array($edit); echo "

Edit Berita

Judul	:
Kategori	: <select name='kategori'>"; $tampil=mysql_query("SELECT * FROM kategori ORDER BY nama_kategori"); while($w=mysql_fetch_array($tampil)){ if ($r[id_kategori]==$w[id_kategori]){ echo "$w[nama_kategori]"; } else{ echo "$w[nama_kategori]"; } } echo "
Isi Berita	: $r[isi_berita]
Gambar	:
Ganti Gbr	: *)
*) Apabila gambar tidak diubah, dikosongkan saja.

"; break; } ?>

mod_hubungi.php Hubungi Kami "; $no=1; $tampil=mysql_query("SELECT * FROM hubungi ORDER BY id_hubungi desc"); while ($r=mysql_fetch_array($tampil)){ $tgl=tgl_indo($r[tanggal]); echo ""; $no++; } echo "

no	nama	email	subjek	tanggal	aksi
$no	$r[nama]	$r[email]	$r[subjek]	$tgl	Hapus

";

break; case "balasemail": $tampil = mysql_query("SELECT * FROM hubungi WHERE id_hubungi='$_GET[id]'"); $r = mysql_fetch_array($tampil); echo "

Reply Email

Kepada	:
Subjek	:
Pesan	: ----------------------------------------------------------------------------------------$r[pesan]

"; break; case "kirimemail": mail($_POST[email],$_POST[subjek],$_POST[pesan],"From: [email protected]"); echo "

Status Email

Email telah sukses terkirim ke tujuan

[ Kembali ]

"; break; } ?>

mod_khotbah.php Bimbingan Khotbah "; if ($_SESSION[leveluser]=='admin'){ $tampil=mysql_query("SELECT * FROM khotbah ORDER BY id_khotbah DESC"); } else{ $tampil=mysql_query("SELECT * FROM khotbah WHERE id_user='$_SESSION[namauser]' ORDER BY id_khotbah DESC"); } $no=1; while ($r=mysql_fetch_array($tampil)){ $tanggal=tgl_indo($r[tanggal]); echo "

"; $no++; } echo "

no	introitus	tanggal	aksi
$no	$r[introitus]	$r[ogen]	$r[khotbah]	$r[thema]	$tanggal	Edit | Hapus

"; break; case "tambahkhotbah": echo "

Tambah Bimbingan Khotbah

Introitus	:
Ogen	:
Khotbah	:
Thema	:
Isi Bimbingan Khotbah	:
Tanggal	: "; combotgl(1,31,'tgl',Tgl); combobln(1,12,'bln',Bulan); combotgl($thn_sekarang-2,$thn_sekarang+2,'thn',Tahun); echo "

"; break; case "editkhotbah": $edit = mysql_query("SELECT * FROM khotbah WHERE id_khotbah='$_GET[id]'"); $r = mysql_fetch_array($edit); echo "

Edit Bimbingan Khotbah

Introitus	:
Ogen	:
Khotbah	:
Thema	:
Isi Bimbingan Khotbah	: $r[isi]
Tanggal	: "; $get_tgl=substr("$r[tanggal]",8,2); combotgl2(1,31,'tgl',$get_tgl); $get_bln=substr("$r[tanggal]",5,2); combobln2(1,12,'bln',$get_bln); $get_thn=substr("$r[tanggal]",0,4); $thn_skrg=date("Y"); combotgl2($thn_sekarang-2,$thn_sekarang+2,'thn',$get_thn); echo "

"; break; } ?>

mod_modul.php Modul "; $tampil=mysql_query("SELECT * FROM modul ORDER BY urutan"); while ($r=mysql_fetch_array($tampil)){ echo ""; } echo "

no	nama modul	link	publish	aktif	status	aksi
$r[urutan]	$r[nama_modul]	$r[link]	$r[publish]	$r[aktif]	$r[status]	Edit | Hapus

"; break; case "tambahmodul": echo "

Tambah Modul

Nama Modul	:
Link	:
Publish	: YN
Aktif	: YN
Status	: user admin
Urutan	:

"; break; case "editmodul": $edit = mysql_query("SELECT * FROM modul WHERE id_modul='$_GET[id]'"); $r = mysql_fetch_array($edit); echo "

Edit Modul

"; if ($r[publish]=='Y'){ echo ""; } else{ echo ""; } if ($r[aktif]=='Y'){ echo ""; } else{ echo ""; } if ($r[status]=='user'){ echo ""; } else{ echo ""; }

echo "

Nama Modul	:
Link	:
Publish	: Y N
Publish	: YN
Aktif	: Y N
Aktif	: YN
Status	: user admin
Status	: useradmin
Urutan	:

"; break; } ?>

mod_pengumuman.php Pengumuman "; if ($_SESSION[leveluser]=='admin'){ $tampil=mysql_query("SELECT * FROM pengumuman ORDER BY id_pengumuman DESC"); } else{ $tampil=mysql_query("SELECT * FROM pengumuman WHERE id_user='$_SESSION[namauser]' ORDER BY id_pengumuman DESC"); } $no=1; while ($r=mysql_fetch_array($tampil)){ $tanggal=tgl_indo($r[tanggal]); echo ""; $no++; } echo "

no	judul	tanggal	aksi
$no	$r[judul]	$tanggal	Ed it | Hapus

"; break; case "tambahpengumuman": echo "

Tambah Pengumuman

Judul	:
Isi Pengumuman	:
Tanggal	: "; combotgl(1,31,'tgl',Tgl); combobln(1,12,'bln',Bulan); combotgl($thn_sekarang-2,$thn_sekarang+2,'thn',Tahun); echo "

"; break; case "editpengumuman": $edit = mysql_query("SELECT * FROM pengumuman WHERE id_pengumuman='$_GET[id]'"); $r = mysql_fetch_array($edit); echo "

Edit Pengumuman

Judul	:
Isi Pengumuman	: $r[isi]
Tanggal	: "; $get_tgl=substr("$r[tanggal]",8,2); combotgl2(1,31,'tgl',$get_tgl); $get_bln=substr("$r[tanggal]",5,2); combobln2(1,12,'bln',$get_bln); $get_thn=substr("$r[tanggal]",0,4); $thn_skrg=date("Y"); combotgl2($thn_sekarang-2,$thn_sekarang+2,'thn',$get_thn); echo "

"; break; } ?>

mod_renungan.php Renungan "; if ($_SESSION[leveluser]=='admin'){ $tampil=mysql_query("SELECT * FROM renungan ORDER BY id_renungan DESC"); } else{ $tampil=mysql_query("SELECT * FROM renungan

WHERE id_user='$_SESSION[namauser]' ORDER BY id_renungan DESC"); } $no=1; while ($r=mysql_fetch_array($tampil)){ $tanggal=tgl_indo($r[tanggal]); echo ""; $no++; } echo "

no	judul	tanggal	aksi
$no	$r[judul]	$tanggal	Edit | Hapus

"; break; case "tambahrenungan": echo "

Tambah Renungan

Judul	:
Bahan Khotbah	:
Isi Renungan	:
Tanggal	: "; combotgl(1,31,'tgl',Tgl); combobln(1,12,'bln',Bulan); combotgl($thn_sekarang-2,$thn_sekarang+2,'thn',Tahun); echo "

"; break; case "editrenungan": $edit = mysql_query("SELECT * FROM renungan WHERE id_renungan='$_GET[id]'"); $r = mysql_fetch_array($edit); echo "

Edit Renungan

Judul	:
Bahan Khotbah	:
Isi Renungan	: $r[isi]
Tanggal	: "; $get_tgl=substr("$r[tanggal]",8,2); combotgl2(1,31,'tgl',$get_tgl); $get_bln=substr("$r[tanggal]",5,2); combobln2(1,12,'bln',$get_bln); $get_thn=substr("$r[tanggal]",0,4); $thn_skrg=date("Y"); combotgl2($thn_sekarang-2,$thn_sekarang+2,'thn',$get_thn); echo "

"; break; } ?>

mod_user.php User "; $tampil=mysql_query("SELECT * FROM user ORDER BY id_user"); $no=1; while ($r=mysql_fetch_array($tampil)){ echo ""; $no++; } echo "

no	username	nama lengkap	email	aksi
$no	$r[id_user]	$r[nama_lengkap]	$r[email]	Edit | Hapus

"; break; case "tambahuser": echo "

Tambah User

Username	:
Password	:
Nama Lengkap	:
E-mail	:

"; break; case "edituser": $edit=mysql_query("SELECT * FROM user WHERE id_user='$_GET[id]'"); $r=mysql_fetch_array($edit); echo "

Edit User

Username	:
Password	: *)
Nama Lengkap	:
E-mail	:
*) Apabila password tidak diubah, dikosongkan saja.

"; break; } ?>

aksi.php
elseif ($module=='user' AND $act=='update'){

// Apabila password tidak diubah if (empty($_POST[password])) { mysql_query("UPDATE user SET id_user = '$_POST[id_user]', nama_lengkap = '$_POST[nama_lengkap]',email = '$_POST[email]' WHERE id_user = '$_POST[id]'"); } // Apabila password diubah else{ $pass=md5($_POST[password]); mysql_query("UPDATE user SET id_user = '$_POST[id_user]', password = '$pass',nama_lengkap = '$_POST[nama_lengkap]', email = '$_POST[email]'WHERE id_user = '$_POST[id]'"); } header('location:media.php?module='.$module); } // Input modul elseif ($module=='modul' AND $act=='input'){ mysql_query("INSERT INTO modul(nama_modul,link,publish,aktif, status,urutan) VALUES('$_POST[nama_modul]','$_POST[link]', '$_POST[publish]','$_POST[aktif]','$_POST[status]','$_POST[urutan]')"); header('location:media.php?module='.$module); } // Update modul elseif ($module=='modul' AND $act=='update'){ mysql_query("UPDATE modul SET nama_modul = '$_POST[nama_modul]', link = '$_POST[link]',publish = '$_POST[publish]', aktif = '$_POST[aktif]',status = '$_POST[status]', urutan = '$_POST[urutan]'WHERE id_modul = '$_POST[id]'"); header('location:media.php?module='.$module); } // Input agenda elseif ($module=='agenda' AND $act=='input'){ $mulai=sprintf("%02d%02d%02d",$_POST[thn_mulai],$_POST[bln_mulai],$_POST [tgl_mulai]); $selesai=sprintf("%02d%02d%02d",$_POST[thn_selesai],$_POST[bln_selesai], $_POST[tgl_selesai]); mysql_query("INSERT INTO agenda(tema,isi_agenda,tempat,tgl_mulai,tgl_selesai,tgl_posting,id_user) VALUES('$_POST[tema]','$_POST[isi_agenda]','$_POST[tempat]','$mulai','$s elesai','$tgl_sekarang','$_SESSION[namauser]')"); header('location:media.php?module='.$module); } // Update agenda elseif ($module=='agenda' AND $act=='update'){ $mulai=sprintf("%02d%02d%02d",$_POST[thn_mulai],$_POST[bln_mulai],$_POST [tgl_mulai]);

$selesai=sprintf("%02d%02d%02d",$_POST[thn_selesai],$_POST[bln_selesai], $_POST[tgl_selesai]); mysql_query("UPDATE agenda SET tema = '$_POST[tema]', isi_agenda = '$_POST[isi_agenda]',tgl_mulai = '$mulai',tgl_selesai = '$selesai',tempat = '$_POST[tempat]'WHERE id_agenda = '$_POST[id]'"); header('location:media.php?module='.$module); } // Input pengumuman elseif ($module=='pengumuman' AND $act=='input'){ $tanggal=sprintf("%02d%02d%02d",$_POST[thn],$_POST[bln],$_POST[tgl]); mysql_query("INSERT INTO pengumuman(judul,isi,tanggal,tgl_posting, id_user) VALUES('$_POST[judul]','$_POST[isi_pengumuman]','$tanggal','$tgl_sekaran g','$_SESSION[namauser]')"); header('location:media.php?module='.$module); } // Update pengumuman elseif ($module=='pengumuman' AND $act=='update'){ $tanggal=sprintf("%02d%02d%02d",$_POST[thn],$_POST[bln],$_POST[tgl]); mysql_query("UPDATE pengumuman SET judul = '$_POST[judul]', isi = '$_POST[isi_pengumuman]',tanggal = '$tanggal'WHERE id_pengumuman = '$_POST[id]'"); header('location:media.php?module='.$module); } // Input Renungan elseif ($module=='renungan' AND $act=='input'){ $tanggal=sprintf("%02d%02d%02d",$_POST[thn],$_POST[bln],$_POST[tgl]); mysql_query("INSERT INTO renungan(judul,bahan_khotbah,isi,tanggal, tgl_posting,id_user) VALUES('$_POST[judul]','$_POST[bahan_khotbah]', '$_POST[isi_renungan]','$tanggal','$tgl_sekarang','$_SESSION[namauser]') "); header('location:media.php?module='.$module); } // Update Renungan elseif ($module=='renungan' AND $act=='update'){ $tanggal=sprintf("%02d%02d%02d",$_POST[thn],$_POST[bln],$_POST[tgl]); mysql_query("UPDATE renungan SET judul = '$_POST[judul]', bahan_khotbah = '$_POST[bahan_khotbah]',isi = '$_POST[isi_renungan]', tanggal = '$tanggal'WHERE id_renungan = '$_POST[id]'"); header('location:media.php?module='.$module); } // Input Khotbah elseif ($module=='khotbah' AND $act=='input'){ $tanggal=sprintf("%02d%02d%02d",$_POST[thn],$_POST[bln],$_POST[tgl]); mysql_query("INSERT INTO khotbah(introitus,ogen,khotbah,thema,isi, tanggal,tgl_posting,id_user) VALUES('$_POST[introitus]','$_POST[ogen]','$_POST[khotbah]', '$_POST[thema]','$_POST[isi_khotbah]','$tanggal','$tgl_sekarang','$_SESS ION[namauser]')"); header('location:media.php?module='.$module); }

// Update Khotbah elseif ($module=='khotbah' AND $act=='update'){ $tanggal=sprintf("%02d%02d%02d",$_POST[thn],$_POST[bln],$_POST[tgl]); mysql_query("UPDATE khotbah SET introitus = '$_POST[introitus]', ogen = '$_POST[ogen]',khotbah = '$_POST[khotbah]',thema = '$_POST[thema]',isi = '$_POST[isi_khotbah]',tanggal = '$tanggal'WHERE id_khotbah = '$_POST[id]'"); header('location:media.php?module='.$module); }

// Input berita elseif ($module=='berita' AND $act=='input'){ $lokasi_file = $_FILES['fupload']['tmp_name']; $tipe_file = $_FILES['fupload']['type']; $nama_file = $_FILES['fupload']['name']; $acak = rand(000000,999999); $nama_file_unik = $acak.$nama_file; // Apabila ada gambar yang diupload if (!empty($lokasi_file)){ // Apabila tipe gambar bukan jpeg akan tampil peringatan if ($tipe_file != "image/jpeg" AND $tipe_file != "image/pjpeg"){ echo "Gagal menyimpan data !!!
Tipe file $nama_file : $tipe_file
Tipe file yang diperbolehkan adalah : JPG/JPEG.
"; echo "Ulangi Lagi"; } else{ move_uploaded_file($lokasi_file,"foto_berita/$nama_file_unik"); mysql_query("INSERT INTO berita(judul,id_kategori,isi_berita, id_user,jam,tanggal,hari,gambar) VALUES('$_POST[judul]', '$_POST[kategori]','$_POST[isi_berita]','$_SESSION[namauser]','$jam_seka rang','$tgl_sekarang','$hari_ini','$nama_file_unik')"); header('location:media.php?module='.$module); } } else{ mysql_query("INSERT INTO berita(judul,id_kategori,isi_berita, id_user,jam,tanggal,hari) VALUES('$_POST[judul]','$_POST[kategori]', '$_POST[isi_berita]','$_SESSION[namauser]','$jam_sekarang','$tgl_sekaran g','$hari_ini')"); header('location:media.php?module='.$module); } } // Update berita elseif ($module=='berita' AND $act=='update'){ $lokasi_file = $_FILES['fupload']['tmp_name']; $nama_file = $_FILES['fupload']['name']; // Apabila gambar tidak diganti if (empty($lokasi_file)){ mysql_query("UPDATE berita SET judul = '$_POST[judul]', id_kategori = '$_POST[kategori]',isi_berita = '$_POST[isi_berita]'

WHERE id_berita = '$_POST[id]'"); } else{ move_uploaded_file($lokasi_file,"foto_berita/$nama_file"); mysql_query("UPDATE berita SET judul = '$_POST[judul]', id_kategori = '$_POST[kategori]',isi_berita = '$_POST[isi_berita]', gambar = '$nama_file'WHERE id_berita = '$_POST[id]'"); } header('location:media.php?module='.$module); } // Input banner elseif ($module=='banner' AND $act=='input'){ $lokasi_file = $_FILES['fupload']['tmp_name']; $nama_file = $_FILES['fupload']['name']; // Apabila ada gambar yang diupload if (!empty($lokasi_file)){ move_uploaded_file($lokasi_file,"foto_berita/$nama_file"); mysql_query("INSERT INTO banner(judul,url,tgl_posting,gambar) VALUES('$_POST[judul]','$_POST[link]','$tgl_sekarang','$nama_file')"); } else{ mysql_query("INSERT INTO banner(judul,tgl_posting,url) VALUES('$_POST[judul]','$tgl_sekarang','$_POST[link]')"); } header('location:media.php?module='.$module); } // Update banner elseif ($module=='banner' AND $act=='update'){ $lokasi_file = $_FILES['fupload']['tmp_name']; $nama_file = $_FILES['fupload']['name']; // Apabila gambar tidak diganti if (empty($lokasi_file)){ mysql_query("UPDATE banner SET judul = '$_POST[judul]', url = '$_POST[link]'WHERE id_banner = '$_POST[id]'"); } else{ move_uploaded_file($lokasi_file,"foto_berita/$nama_file"); mysql_query("UPDATE banner SET judul = '$_POST[judul]', url = '$_POST[link]',gambar = '$nama_file'WHERE id_banner = '$_POST[id]'"); } header('location:media.php?module='.$module); } // Update profil elseif ($module=='profil' AND $act=='update'){ $lokasi_file = $_FILES['fupload']['tmp_name']; $nama_file = $_FILES['fupload']['name']; // Apabila gambar tidak diganti if (empty($lokasi_file)){ mysql_query("UPDATE modul SET static_content = '$_POST[isi]'WHERE id_modul = '$_POST[id]'"); }

else{ move_uploaded_file($lokasi_file,"foto_berita/$nama_file"); mysql_query("UPDATE modul SET static_content = '$_POST[isi]', gambar = '$nama_file'WHERE id_modul = '$_POST[id]'"); } header('location:media.php?module='.$module); } // Update Susunan Kepengurusan Pusat GBKP elseif ($module=='pengurus' AND $act=='update'){ $lokasi_file = $_FILES['fupload']['tmp_name']; $nama_file = $_FILES['fupload']['name']; // Apabila gambar tidak diganti if (empty($lokasi_file)){ mysql_query("UPDATE modul SET static_content = '$_POST[isi]' WHERE id_modul = '$_POST[id]'"); } else{ move_uploaded_file($lokasi_file,"foto_berita/$nama_file"); mysql_query("UPDATE modul SET static_content = '$_POST[isi]', gambar = '$nama_file' WHERE id_modul = '$_POST[id]'"); } header('location:media.php?module='.$module); } ?>

cek_login.php 0){ session_start(); session_register("namauser"); session_register("passuser"); session_register("leveluser"); $_SESSION[namauser] = $r[id_user]; $_SESSION[passuser] = $r[password]; $_SESSION[leveluser]= $r[level]; header('location:media.php?module=home'); } else{ echo ""; echo "Login gagal! username & password tidak benar
"; echo "ULANGI LAGI"; }

?>

content.php
"../config/koneksi.php"; "../config/library.php"; "../config/fungsi_indotgl.php"; "../config/fungsi_combobox.php"; "../config/class_paging.php";

// Bagian Beranda if ($_GET[module]=='beranda'){ echo "

Selamat Datang

Hai $_SESSION[namauser], silahkan klik menu pilihan yang berada di sebelah kiri untuk mengelola content website.

 

 

 

 

Login Hari ini: "; echo tgl_indo(date("Y m d")); echo " | "; echo date("H:i:s"); echo "

"; } // Bagian Profil Lembaga elseif ($_GET[module]=='profil'){ $sql = mysql_query("SELECT * FROM modul WHERE id_modul='11'"); $r = mysql_fetch_array($sql); echo "

Profil Lembaga

Ganti Foto :

$r[static_content]

"; } // Bagian Susunan Kepengurusan Pusat GBKP elseif ($_GET[module]=='pengurus'){ $sql = mysql_query("SELECT * FROM modul WHERE id_modul='12'"); $r = mysql_fetch_array($sql); echo "

Susunan Kepengurusan Pusat GBKP

Ganti Foto :

$r[static_content]

"; } // Bagian User elseif ($_GET[module]=='user'){ include "modul/mod_user.php"; } // Bagian Modul elseif ($_GET[module]=='modul'){ include "modul/mod_modul.php"; } // Bagian Agenda elseif ($_GET[module]=='agenda'){ include "modul/mod_agenda.php"; } // Bagian Berita elseif ($_GET[module]=='berita'){ include "modul/mod_berita.php"; } // Bagian Pengumuman elseif ($_GET[module]=='pengumuman'){ include "modul/mod_pengumuman.php"; } // Bagian Renungan elseif ($_GET[module]=='renungan'){ include "modul/mod_renungan.php"; } // Bagian Khotbah elseif ($_GET[module]=='khotbah'){ include "modul/mod_khotbah.php"; } // Bagian Banner elseif ($_GET[module]=='banner'){ include "modul/mod_banner.php"; } // Bagian Hubungi Kami elseif ($_GET[module]=='hubungi'){ include "modul/mod_hubungi.php"; } // Apabila modul tidak ditemukan else{ echo "

MODUL BELUM ADA

";

} ?>

index.php

Login

Username	:
Password	:

 

Copyright © 2012 by irvan mart tarigan

logout.php Anda telah sukses keluar sistem [LOGOUT]"; // Apabila setelah logout langsung menuju halaman utama website, aktifkan baris di bawah ini: // header('location:http://www.alamatwebsite.com'); ?>

media.php
echo " Untuk mengakses modul, Anda harus login
"; echo "LOGIN"; } else{ ?>

• » Home
• » Logout

 

Copyright © 2012 by irvan mart tarigan

menu.php » $data[nama_modul]"; } ?>

adminstyle.css body{ font-family: Tahoma;

text-align: center; } #header { position: relative; background-image: url(../admin/images/header.jpg); background-repeat: no-repeat; margin-right: auto; margin-left: auto; width: 780px; border: 2px solid #265180; padding-top: 70px; text-align: left; } #content { margin-left: 230px; padding: 20px 10px 0 0; } #content p { font-size: 75%; line-height: 1.8em; padding-left: 2em; } #menu { position: absolute; top: 90px; left: 0; width: 180px; } #menu ul { list-style: none; margin: 0; padding: 0; border: none; } #menu li { width: 180px; border-bottom: 1px solid #969BA5; margin: 0; padding: 0; font-size: 80%; vertical-align: bottom; } #menu a:link, #menu a:visited { display: block; padding: 5px 5px 5px 0.5em; border-left: 12px solid #265180; border-right: 1px solid #265180; background-color: #CAD6EC; color: #265180; text-decoration: none; } #menu a:hover { background-color: #265180; color: #FFFFFF; } a:link,a:visited {

color:#265180; } a:hover { color: #FF6600; text-decoration:none; } h2 { font: normal 120% Georgia; color: #265180; background-color: transparent; border-bottom: 1px dotted #265180; } table { font-family: Tahoma; font-size: 8pt; border-width: 1px; border-style: solid; border-color: #999999; border-collapse: collapse; margin: 10px 0px; } th{ color: #FFFFFF; font-size: 7pt; text-transform: uppercase; text-align: center; padding: 0.5em; border-width: 1px; border-style: solid; border-color: #969BA5; border-collapse: collapse; background-color: #265180; } td{ padding: 0.5em; vertical-align: top; border-width: 1px; border-style: solid; border-color: #969BA5; border-collapse: collapse; } input,textarea,select{ font-family: Tahoma; font-size: 8pt; } #paging{ font-family: Tahoma; font-size: 8pt; } #footer{ padding: 20px 0 10px 255px; font-size: 70%; color: #FFFFFF; background-color: #265180; }

class_paging.php 1) { $link_halaman .= " << First | "; } if (($halaman_aktif-1) > 0) { $previous = $halaman_aktif-1; $link_halaman .= "< Previous | "; } // Link halaman 1,2,3, ... for ($i=1; $i<=$jmlhalaman; $i++) { if ($i == $halaman_aktif) { $link_halaman .= "$i | "; } else { $link_halaman .= "$i | ";

} $link_halaman .= " "; } // Link Next dan Last if ($halaman_aktif < $jmlhalaman) { $next=$halaman_aktif+1; $link_halaman .= " Next > "; } if (($halaman_aktif != $jmlhalaman) && ($jmlhalaman != 0)) { $link_halaman .= " | Last >> "; } return $link_halaman; } } ?>

fungsi_combobox.php "; echo "$default"; for ($i=$awal; $i<=$akhir; $i++){ echo "$i"; } echo " "; } function combobln($awal, $akhir, $var, $default){ include "../config/library.php"; echo "<select name=$var>"; echo "$default"; for ($bln=$awal; $bln<=$akhir; $bln++){ echo "$nama_bln[$bln]"; } echo " "; } function combotgl2($awal, $akhir, $var, $terpilih){ echo "<select name=$var>"; for ($i=$awal; $i<=$akhir; $i++){ if ($i==$terpilih) echo "$i"; else echo "$i"; } echo " "; } function combobln2($awal, $akhir, $var, $terpilih){ include "../config/library.php"; echo "<select name=$var>";

for ($bln=$awal; $bln<=$akhir; $bln++){ if ($bln==$terpilih) echo "$nama_bln[$bln]"; else echo "$nama_bln[$bln]"; } echo " "; } ?>

fungsi_indotgl.php
return "Desember"; break; } } ?>

koneksi.php
"localhost"; = "root"; = ""; = "dbmedia";

// Koneksi dan memilih database di server mysql_connect($server,$username,$password) or die("Koneksi gagal"); mysql_select_db($database) or die("Database tidak bisa dibuka"); ?>

library.php "Januari", "Februari", "Maret", "April", "Mei", "Juni", "Juli", "Agustus", "September", "Oktober", "November", "Desember"); ?>

style.php a:link, a:visited { color:#007495; font-weight:bold; text-decoration:none; } a:hover { color:#FF9900; font-weight:bold; } input, select{ background-color: #EEEEEE; font-size: 10px; } textarea{ background-color: #EEEEEE; font-size: 12px; }

hr { border-bottom: 1px dashed #9d9d9d; } #menu{ font-family:Tahoma; font-size:12px; color:#ffffff; } #menu a:link, #menu a:visited { color: #ffff00; } #menu a:hover { color:#ffffff; } #kiri{ font-family:Tahoma; font-size:11px; color:#ffffff; } #kiri a:link, #kiri a:visited { color: #ffff00; } #kiri a:hover { color:#ffffff; } .isi { font-family:Tahoma; font-size:11px; padding-left:4px; text-align:justify; line-height: 18px; } .bullet{ font-family:Tahoma; font-size:14px; padding-left:4px; color:#ffffff; text-align:justify; line-height: 18px; } .isi_kecil{ font-family:Tahoma; font-size:11px; padding-left:4px; color:#FF6600; } .judul { font-family:Tahoma; font-size:12px; font-weight:bold; color:#265180; padding-left:4px; } .judul_head { font-family:Georgia;

font-size:12px; font-weight:bold; background-color: #B7BCC2; color:#333333; padding-left:4px; } .kembali { font-family:Tahoma; font-size:11px; padding-left:4px; text-align:center;}