LAPORAN PRAKTEK KERJA NYATA ( MAGANG ) PERANCANGAN SISTEM INFORMASI BERBASIS WEBSITE DI SMK BINAWIYATA KARANGMALANG SRAGEN

...
Author:  Dian Setiawan
7740 downloads 9075 Views 3MB Size
Report
DOWNLOAD .PDF

Recommend Documents

Laporan Praktek Kerja Lapangan Sistem Informasi
praktek industri ini dilakukan di rochmad bengkel banyuanyar
LAPORAN TAHUNAN (ANNUAL REPORT) BERBASIS WEB PADA
metpen
sistem pengelasan pada konstruksi kapal
laporan kerja praktekFull description
Full description
SIM - Sistem Informasi ManajemenFull description
fdhg
Skripsi Teknik InformatikaDeskripsi lengkap
LAPORAN KERJA PRAKTEK
ffFull description
Laporan Perancangan Sistem Kerja Dan Ergonomi Penginderaan Dan InformasiDeskripsi lengkap
hanya bab I saja next akan di upload lagi 2- 5 terimakasihDeskripsi lengkap
Full description
Perancangan Sistem Kerja ErgonomisFull description
polibatamFull description
Program Kerja Tim Pengembang Sekolah
Program Kerja Tim Pengembang SekolahFull description


23. isi

22. index <meta http-equiv="contenttype" content="text/html" /> 54

$id=$_GET['id']; if(empty($id)){ echo "Halaman tidak

24. isi_agenda
ditemukan"; }else{ $a="select * from tblcms,tblkategori where tblcms.idkategori=tblkategori.idkategor i and id='$id'"; $b=mysql_query($a);

$b=mysql_query($a); $c=mysql_fetch_array($b) ?>

$c[judul]

"; ?> Dikirim oleh : - Kategori:
   & nbsp;  $c[content]



Download"; }

$c=mysql_fetch_array($b) ?>

$c[judul]

"; ?> Dikirim oleh :
   & nbsp;  $c[content]

"; }else{ echo "

   & nbsp;  $c[content]

"; } } ?>

elseif(empty($c['file'])){ echo "

$c[content]


"; }

25. isi_artikel
$mulai = (($halaman * $hal_maksimum) $hal_maksimum);

else{ echo "



?>



      $c[content]


Download"; } } ?> 26.


kaldik

Kalender Akademik Sekolah SMK Binawiyata Karangmalang Sragen



$hasil = mysql_query($query) or die("Gagal melakukan query.");



echo "";


echo "";

while ($buff = mysql_fetch_array($hasil)) {

//Ambil file koneksi

echo "";

include "koneksi.php";

echo "";

$hal = $_GET[hal];

echo ""; echo "";

if(!isset($_GET['hal'])){

echo "";

$halaman = 1;

echo "";

} else {

}

$halaman = $_GET['hal'];

?>

}

Tanggal Acara Keterangan
$buff[tanggal] $buff[acara] $buff[keterangan]


//tentukan jumlah data setiap halaman


$hal_maksimum = 9;

56

$total= mysql_result(mysql_query("SELECT COUNT(*) as jumlah FROM

echo " Selanjutnya->";

kalender"),0);

}

$jumlah_halaman = ceil($total / $hal_maksimum);

echo ""; ?>

// bangun jumlah hiperlink halaman echo "

";

27. kirim_guestbook
// bangun Previous link if($hal > 1){

include "koneksi.php";

$sebelum = ($halaman - 1); $nama = $_POST["nama"]; $email = $_POST["email"]; $website = $_POST["website"]; $alamat = $_POST["alamat"]; $pesan = $_POST["pesan"]; $tanggal = date("Y-m-d"); /*if(empty($nama) || empty($email) || empty($alamat)){ }*/

echo " "; } if ($jumlah_halaman == 1){ echo ""; } else {

$simpan = mysql_query("insert into guestbook (id, tanggal, nama, email, website, alamat, pesan) value ('','$tanggal','$nama','$email','$website','$ alamat','$pesan')"); if(!$simpan){ echo "<script>alert('Gagal terkirim, silahkan coba beberapa saat lagi...');window.history.go(-1);"; } else { echo "<script>alert('Pesan, berhasil di dikirim...');window.history.go(1);"; echo "<meta http-equiv='refresh' content='0; url=home.php?page=buku_tamu'>"; } exit(); ?>

for($i = 1; $i <= $jumlah_halaman; $i++){ if(($hal) == $i){ echo "$i "; } else { echo "".$i." "; } } } // bangun Next link if($hal < $jumlah_halaman){ $selanjutnya = ($halaman + 1);

57

 


28. koneksi 29. kosong
maaf, halaman yang anda cari tidak dapat di temukan.  atau anda tidak memiliki izin untuk melihat halaman tersebut.

31.

lihat_artikel

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> SMK Binawiyata Karangmalang Sragen | Beranda <script language="javascript" src="js/menu.js">
 
 


30. lihat_agenda <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> SMK Binawiyata Karangmalang Sragen <script language="javascript" src="js/menu.js">
 


58

32.

profil_guru

Data Staff dan Guru SMK Binawiyata Karangmalang Sragen




$hal = $_GET[hal]; if(!isset($_GET['hal'])){ $halaman = 1; } else { $halaman = $_GET['hal']; } //tentukan jumlah data setiap halaman $hal_maksimum = 3; $mulai = (($halaman * $hal_maksimum) $hal_maksimum); ?>






$b=mysql_query($a); while($c=mysql_fetch_array($b)) {



?>
Nama Guru : $c[nama_guru]
Tempat Lahir : $c[tempat_lahir]
Tanggal Lahir : $c[tgl_lahir]
Alamat: $c[alamat]
Pendidikan Terakhir: $c[pendidikan]
Mengajar: $c[mengajar]


59



} // bangun Next link if($hal < $jumlah_halaman){ $selanjutnya = ($halaman + 1); echo "Selanjutnya->"; } echo "



Jenis Kelamin : $c[jenis_kelamin]
Agama: $c[agama]
"; ?>

"; ?>


33.

profil-sekolah




$b=mysql_query($a); $c=mysql_fetch_array($b) ?>


"; // bangun Previous link if($hal > 1){ $sebelum = ($halaman - 1); echo " <-Sebelumnya "; } if ($jumlah_halaman == 1){ echo ""; } else { for($i = 1; $i <= $jumlah_halaman; $i++){ if(($hal) == $i){ echo "$i "; } else { echo "".$i." "; } }

$c[content]"; } ?> 34. sambutan-kepala-sekolah
60

height=220 align='left' hspace=10 border=0 style='border:1px solid blue;border-radius:10px;'>

$c[content]

"; } } ?> 36. struktur-organisasi-sekolah

$c=mysql_fetch_array($b) ?>

$c[judul]

"; ?>
$c[content]

"; }else{ echo "

$c[content]

"; } } ?> 35.

$c[judul]

< hr />"; ?> $c[content]"; }else{ echo "$c[content] "; } } ?>

sejarah-sekolah

$c[judul]

"; ?>    &nbs p; $c[content]

"; }else{ echo "
37.

Visi-dan-misi


61

}else{ $a="select * from profil

$query = mysql_query("insert into hasil values('$id','$jawab',1);"); }

where id='$id'"; $b=mysql_query($a);

if ($query) { echo "<script>alert('Terima kasih telah memberikan suara anda');

$c=mysql_fetch_array($b) ?>

$c[judul]

"; ?> $c[content]

"; }else{ echo "
 $c[content]
"; } } ?>


window.location=('index.php');" ; } else { echo "<script>alert('Gagal memasukan data'); window.location=('index.php');" ; } ?> 39.

admin

window.alert('Anda Belum Login..!'); window.location=('../index.php?page=an da_belum_login')"; } //cek level user if($_SESSION['level']!="admin"){ echo "<script>window.alert('Anda Bukan Guru..!');

38. vote 0) { $query = mysql_query("update hasil set nilai=nilai+1 where jawab='$jawab';"); } else {

window.location=('../index.php?page=an da_bukan_admin')"; } ?>

62

<meta http-equiv="content-type" content="text/html; charset=utf-8" /> Control Panel Administrator SMK Binawiyata Karangmalang Sragen


63

onload =function(){ alert('Agenda gagal disimpan'); } ";



} } //Proses edit //tampilkan data yang diedit $id=$_GET['id']; $sql="select * from tblagenda where id='$id'"; $query=mysql_query($sql); $baris=mysql_fetch_array($query); if(isset($_POST['Edit'])){ $judul=$_POST['judul']; $content=$_POST['content']; $status=$_POST['status']; $gambar=$_FILES['gambar']['name']; if(strlen($gambar)>0){ if(is_uploaded_file($_FILES['gam bar']['tmp_name'])){ move_uploaded_file($_FILES['ga mbar']['tmp_name'],"../gambar/berita/".$ga mbar); } mysql_query("update tblagenda set gambar='$gambar' where id='$id'"); } $a="Update tblagenda set judul='$judul',content='$content',status='$s tatus' where id='$id'"; $b=mysql_query($a); if($b){ echo "<script type='text/javascript'> alert('Agenda telah terupdate..!'); "; echo "<meta http-equiv='refresh' content='0; url=index.php'>"; }else{ echo "<script type='text/javascript'> onload =function(){ alert('Agenda gagal diubah!'); } "; } }

Kelola Agenda Sekolah



align="center">No1 order by id DESC";

Judul Agenda
Content
Gambar
Judul
 Pengirim
Tampilkan
Aksi
Tampilkan : > Ya    > Tidak
 

Tabel Agenda Sekolah



65


$query=mysql_query($sql); $no=1; while($data=mysql_fetch_array($query)){ ?>


if(is_uploaded_file($_FILES['file'] ['tmp_name'])){ move_uploaded_file($_FILES['file ']['tmp_name'],"../file/".$file); } } if(empty($idkategori)||empty($judul)||empt y($content)){ echo "<script type='text/javascript'> onload =function(){ alert('Data isian belum lengkap, silahkan periksa kembali!'); } "; }else{ $a="insert into tblcms(id,judul,idkategori,content,gambar, file,user,status)values('','$judul','$idkategor i','$content','$gambar','$file','$_SESSION[l evel]','$status')"; $b=mysql_query($a); if($b){ echo "<script type='text/javascript'> onload =function(){ alert('Berita telah tersimpan'); } "; }else{ echo "<script type='text/javascript'> onload =function(){ alert('Berita gagal disimpan'); } "; } } } //Proses edit //tampilkan data yang diedit $id=$_GET['id']; $sql="select * from tblcms where id='$id'"; $query=mysql_query($sql); $baris=mysql_fetch_array($query); if(isset($_POST['Edit'])){ $idkategori=$_POST['idkategori']; $judul=$_POST['judul']; $content=$_POST['content']; $status=$_POST['status'];


41. Artikel_berita <script language="javascript" type="text/javascript" src="ckeditor/ckeditor.js">

Artikel Berita SMK Binawiyata Karangmalang Sragen

0){ if(is_uploaded_file($_FILES['gam bar']['tmp_name'])){ move_uploaded_file($_FILES['ga mbar']['tmp_name'],"../gambar/berita/".$ga mbar); } }

$gambar=$_FILES['gambar']['name']; if(strlen($gambar)>0){

$file=$_FILES['file']['name']; if(strlen($file)>0){

66

if(is_uploaded_file($_FILES['gam bar']['tmp_name'])){ move_uploaded_file($_FILES['ga mbar']['tmp_name'],"../gambar/berita/".$ga mbar); } mysql_query("update tblcms set gambar='$gambar' where id='$id'"); }

Kelola Artikel



$file=$_FILES['file']['name']; if(strlen($file)>0){ if(is_uploaded_file($_FILES['file'] ['tmp_name'])){ move_uploaded_file($_FILES['file ']['tmp_name'],"../file/".$file); } mysql_query("update tblcms set file='$file' where id='$id'"); }

$a="Update tblcms set judul='$judul',idkategori='$idkategori',cont ent='$content',status='$status' where id='$id'"; $b=mysql_query($a); if($b){ echo "<script type='text/javascript'> alert('Artikel telah terupdate..!'); "; echo "<meta http-equiv='refresh' content='0; url=index.php'>"; }else{ echo "<script type='text/javascript'> onload =function(){ alert('Berita gagal diubah!'); } "; } }



?>
Judul Berita
Kategori


67



Tampilkan : > Ya    > Tidak
 

Tabel Berita



"; echo ""; } ?>

68

No
Judul
 Content
Gambar
Lampirkan File
File: ".$baris['file']."
Apabila file tidak diganti, dikosongkan saja


src="../images/icon/button-cross.gif" width="20" height="20" border="0" />


Kategori

Pengirim
Tampilkan
Aksi 1 order by id DESC";

42.

data_fasilitas

script language="javascript" type="text/javascript" src="ckeditor/ckeditor.js">

Fasilitas Sekolah SMK Binawiyata Karangmalang Sragen



$query=mysql_query($sql); $no=1; while($data=mysql_fetch_array($query)){ ?>
"> ';}">
0){ if(is_uploaded_file($_FILES['foto' ]['tmp_name'])){ move_uploaded_file($_FILES['fot o']['tmp_name'],"../gambar/sarana/".$foto); } }

69

$a="insert into tblsarana(id,sarana,ukuran,jurusan,deskrips i,foto)values('','$sarana','$ukuran','$jurusan' ,'$deskripsi','$foto')"; $b=mysql_query($a); if($b){ echo "<script type='text/javascript'> onload =function(){ alert('fasilitas Berhasil disimpan'); } "; }else{ echo "<script type='text/javascript'> onload =function(){ alert('Fasilitas gagal disimpan'); } "; } } //Proses edit //tampilkan data yang diedit $id=$_GET['id']; $sql="select * from tblsarana where id='$id'"; $query=mysql_query($sql); $baris=mysql_fetch_array($query); if(isset($_POST['Edit'])){ $sarana=$_POST['sarana']; $ukuran=$_POST['ukuran']; $jurusan=$_POST['jurusan']; $deskripsi=$_POST['deskripsi']; $foto=$_FILES['foto']['name']; if(strlen($foto)>0){ if(is_uploaded_file($_FILES['foto' ]['tmp_name'])){ move_uploaded_file($_FILES['fot o']['tmp_name'],"../gambar/sarana/".$foto); } mysql_query("update tblsarana set foto='$foto' where id='$id'"); } $a="Update tblsarana set sarana='$sarana',ukuran='$ukuran',jurusan ='$jurusan',deskripsi='$deskripsi' where id='$id'"; $b=mysql_query($a); if($b){ echo "<script type='text/javascript'> alert('Fasilitas telah terupdate..!');

"; echo "<meta http-equiv='refresh' content='0; url=index.php?page=data_fasilitas'>"; }else{ echo "<script type='text/javascript'> onload =function(){ alert('Fasilitas gagal diubah!'); } "; } } ?>


Kelola Fasilitas Sekolah







Judul Fasilitas
ukuran
Gambar Jurusan
 

Tabel Fasilitas Sekolah



71

align="center">No

.php?id=';}">

Deskripsi
Nama Fasilitas


Ukuran Jurusan Deskripsi
Aksi


43.

data_guru

Data Staff dan Guru SMK Binawiyata Karangmalang Sragen



$query=mysql_query($sql); $no=1; while($data=mysql_fetch_array($query)){ ?>



">
$pendidikan=$_POST['pendidikan']; $mengajar=$_POST['mengajar']; $jabatan=$_POST['jabatan']; $golongan=$_POST['golongan']; $hp=$_POST['hp'];

72

$jenis_kelamin=$_POST['jenis_kelamin']; $agama=$_POST['agama']; $foto= $_FILES['foto']['name']; //upload foto if (strlen($foto)>0) { //upload if (is_uploaded_file($_FILES['foto']['tmp_na me'])) {

} "; } } } //proses editing //Ambil nilai yang akan di edit if (isset($_GET['nip'])) { $nip = $_GET['nip']; }

move_uploaded_file ($_FILES['foto']['tmp_name'], "../images/foto/".$foto); } } //apabila klik simpan if(isset($_POST['simpan'])){ if(empty($nip)){ echo "<script type='text/javascript'> onload =function(){ alert('Nomor induk pegawai belum diisi'); } "; }else{ $sql="insert into tblguru(nip,nama_guru,tempat_lahir,tgl_la hir,alamat,pendidikan,mengajar,golongan,j abatan,hp,jenis_kelamin,agama,foto) values('$nip','$nama_guru','$tempat_lahir',' $tgl_lahir','$alamat','$pendidikan','$mengaj ar','$golongan','$jabatan','$hp','$jenis_kela min','$agama','$foto')"; $simpan=mysql_query($sql); //bila berhasil simpan kembali ke home if ($simpan) { echo "<script type='text/javascript'>onload =function(){alert('Data Berhasil di Simpan..!');}"; echo "<meta http-equiv='refresh' content='0; url=index.php?page=data_guru'>"; } else {

//tampilkan data sebelum di edit $sql2="select * from tblguru where nip='$nip';"; $tampil=mysql_query($sql2); $baris=mysql_fetch_array($tampil); $nip=$baris['nip']; $nama_guru=$baris['nama_guru']; $tempat_lahir=$baris['tempat_lahir']; list($thn,$bln,$tgl) = explode("",$baris['tgl_lahir']); $alamat=$baris['alamat']; $pendidikan=$baris['pendidikan']; $mengajar=$baris['mengajar']; $golongan=$baris['golongan']; $jabatan=$baris['jabatan']; $hp=$baris['hp']; $jenis_kelamin=$baris['jenis_kelamin']; $agama=$baris['agama']; $foto=$baris['foto']; //apabila klik tombol edit if(isset($_POST['Edit'])) { $nama_guru= $_POST['nama_guru']; $tempat_lahir= $_POST['tempat_lahir']; $tgl_lahir= $_POST['thn']."".$_POST['bln']."-".$_POST['tgl']; $alamat= $_POST['alamat']; $pendidikan=$_POST['pendidikan']; $mengajar=$_POST['mengajar']; $golongan= $_POST['golongan']; $jabatan= $_POST['jabatan']; $hp= $_POST['hp']; $jenis_kelamin= $_POST['jenis_kelamin']; $agama= $_POST['agama']; $foto= $_FILES['foto']['name']; if (strlen($foto)>0) {

echo "<script type='text/javascript'> onload =function(){ alert('Data gagal disimpan!');

73

//upload if (is_uploaded_file($_FILES['foto']['tmp_na me'])) {

{ echo "<meta http-equiv='refresh' content='0; url=index.php?page=data_guru'>"; } else { echo "Data berhasil dihapus"; } } }

move_uploaded_file ($_FILES['foto']['tmp_name'], "../images/foto/".$foto); } mysql_query ("UPDATE tblguru SET foto='$foto' WHERE nip='$nip'"); }

?>


$SQL = "UPDATE tblguru SET nama_guru='$nama_guru',tempat_ lahir='$tempat_lahir',tgl_lahir='$tgl_lahir', alamat='$alamat',pendidikan='$pendidikan' ,mengajar='$mengajar',golongan='$golong an',jabatan='$jabatan',hp='$hp',jenis_kelam in='$jenis_kelamin',agama='$agama' where nip='$nip'"; $hasil= mysql_query($SQL); //jika berhasil kembali ke home if($hasil){ echo "<script type='text/javascript'>onload =function(){alert('Update Data Guru Berhasil..!');}"; echo "<meta http-equiv='refresh' content='0; url=index.php?page=data_guru'>"; } else { echo "<script type='text/javascript'> onload =function(){ alert('Update error!'); } "; } } //apabila klik hapus if(isset($_POST['Hapus'])) { if (!empty($nip) && $nip != "") { $SQL = "delete from tblguru where nip='$nip'"; if(mysql_query($SQL))

74



for ($i=1; $i<=31; $i++) { $tg = ($i<10) ? "0$i" : $i;



$bl = ($i<10) ? "0$i" : $i; $sele = ($bl==$bln)?"selected" : ""; echo ""; } ?>









78

Nomor Induk Pegawai
Nama
Tempat Lahir
Tanggal Lahir
Alamat
Pendidikan Terakhir
Mengajar
Golongan
Jabatan
No Hp
Jenis Kelamin
 

 
Agama
Foto


44. edit_kalender_akademik
80

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; }

$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRI NG']); } if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) { $updateSQL = sprintf("UPDATE kalender SET tanggal=%s, acara=%s, keterangan=%s WHERE id=%s",

$theValue = function_exists("mysql_real_escape_strin g") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

GetSQLValueString($_POST['tanggal'], "text"), GetSQLValueString($_POST['acara'], "text"),

switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } }

GetSQLValueString($_POST['keteranga n'], "text"), GetSQLValueString($_POST['id'], "int")); mysql_select_db($database_dbsekolah, $dbsekolah); $Result1 = mysql_query($updateSQL, $dbsekolah) or die(mysql_error()); $updateGoTo = "kalender_akademik.php"; if (isset($_SERVER['QUERY_STRING'])) { $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?"; $updateGoTo .= $_SERVER['QUERY_STRING']; } /*header(sprintf("Location: %s", $updateGoTo));*/ } $colname_edtkalender = "-1"; if (isset($_GET['id'])) { $colname_edtkalender = $_GET['id']; } mysql_select_db($database_dbsekolah, $dbsekolah); $query_edtkalender = sprintf("SELECT * FROM kalender WHERE id = %s",

$editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) {

81

GetSQLValueString($colname_edtkalen der, "int")); $edtkalender = mysql_query($query_edtkalender, $dbsekolah) or die(mysql_error()); $row_edtkalender = mysql_fetch_assoc($edtkalender); $totalRows_edtkalender = mysql_num_rows($edtkalender); ?>

Edit Kalender Akademik SMK Binawiyata Karangmalang Sragen



Keterangan:  

 

 

 





45. s

edit_kalender_akademik_succes


82

} $a="Update kalender set tanggal='$tanggal',acara='$acara',keteranga n='$keterangan' where id='$id'"; $b=mysql_query($a); if($b){ echo "<script type='text/javascript'> onload =function(){ alert('Kalender Akademik telah terupdate..!'); } ";

$sql="select * from profil where id='$id'"; $query=mysql_query($sql); $baris=mysql_fetch_array($query); if(isset($_POST['Edit'])){ $judul=$_POST['judul']; $content=$_POST['content']; $gambar=$_FILES['gambar']['name']; if(strlen($gambar)>0){ if(is_uploaded_file($_FILES['gam bar']['tmp_name'])){ move_uploaded_file($_FILES['ga mbar']['tmp_name'],"../gambar/profil/".$ga mbar); } mysql_query("update profil set gambar='$gambar' where id='$id'"); } $a="Update profil set judul='$judul',content='$content' where id='$id'"; $b=mysql_query($a); if($b){ echo "<script type='text/javascript'> alert('Profil Sekolah telah terupdate..!'); "; echo "<meta http-equiv='refresh' content='0; url=index.php?page=profil_sekolah'>"; }else{ echo "<script type='text/javascript'> onload =function(){ alert('Berita gagal diubah!'); } "; } }

echo "<meta http-equiv='refresh' content='0; url=index.php?page=kalender_akademik'> " }else{ echo "<script type='text/javascript'> onload =function(){ alert('Kalender Akademik gagal diubah!'); } "; } } ?> 46.

edit_profil_sekolah

<script language="javascript" type="text/javascript" src="ckeditor/ckeditor.js">

Edit Profil Sekolah SMK Binawiyata Karangmalang Sragen



?>
Tanggal: *
Acara: *



83

Kelola Profil Sekolah



"; } ?>
Judul Berita


Content

47. hapus_agenda
Gambar