KARTU BIMBINGAN TUGAS AKHIR MAHASISWA

KEMENTERIAN PENDIDIKAN DAN KEBUDAYAAN NASIONAL UNIVERSITAS SUMATERA UTARA FAKULTAS MATEMATIKA DAN ILMU PENGETAHUAN ALAM Jl. Bioteknologi No.1 Kampus USU Padang Bulan Medan - 20155 Telp. (061) 8211050, Fax (061) 8214290

KARTU BIMBINGAN TUGAS AKHIR MAHASISWA Nama Mahasiswa

: NICO DAVID L TOBING

Nomor Stambuk

: 102406231

Judul Tugas Akhir

: PEMBUATAN SISTEM INFORMASI PADA SMP YAYASAN PENDIDIKAN PERSADA INDAH DENGAN PHP DAN MYSQL

Dosen Pembimbing

: Dra. Elly Rosmaini, M.Si

Tanggal Mulai Bimbingan

:

Tanggal Selesai Bimbingan :

No

Tanggal Asisten Bimbingan

Pembahasan pada Asistensi Mengenai, pada Bab:

Paraf Dosen Pembimbing

Keterangan

1. 2. 3. 4. 5. 6. 7. * Kartu ini harap dikembalikan ke Departemen Matematika bila bimbingan telah selesai.

Diketahui: Ketua Departemen Matematika FMIPA USU

Prof. Dr. Tulus,M.Si., Ph.D. NIP. 19620901 198803 1 002

Disetujui Pembimbing Utama/ Penanggung Jawab

Dra Elly Rosmaini, M,Si. NIP.19600520 198503 2 002

Universitas Sumatera Utara

SURAT KETERANGAN Hasil Uji Program Tugas Akhir

Yang bertanda tangan dibawah ini, menerangkan bahwa Mahasiswa Tugas Akhir Program Diploma-3 Teknik Informatika :

Nama

: NICO DAVID L TOBING

NIM

: 102406248

Prog. Studi

: Diploma - III Teknik Informatika

Judul TA

: PEMBUATAN SISTEM INFORMASI PADA SMP YPPI TUALANG PERAWANG DENGAN PHP DAN MYSQL

Telah melaksanakan tes program Tugas Akhir Mahasiswa tersebut di atas pada tanggal 22 Juni 2013

Dengan Hasil :

Sukses / Gagal

Demikian diterangkan untuk digunakan melengkapi syarat pendaftaran Ujian Meja Hijau Tugas Akhir Mahasiswa bersangkutan di Departemen Matematika FMIPA USU Medan.

Medan,

Juni 2013

Dosen Pembimbing

Dra. Elly Rosmaini NIP.19600520 198503 2 002


Form conn.php

Form content.php

Sistem Informasi SMP YPPI Form dashboard.php

if($kelamin=='laki-laki'){ $sapaan='Pak '; }else{ $sapaan='Ibu '; } $pengguna=$sapaan.$username; }else{ $pengguna=ucwords($_SESSION['username']); } ?>Sistem Informasi SMP YPPI <style type="text/css">

Selamat Datang di Sistem Nilai Online SMP YPPI,

You have a new message. Go to Inbox.

-->



Nama Sekolah : SMP YPPI Tualang

Alamat : Jalan Gaharu Komplek KPR I Perawang

Kecamatan : Tualang

Kabupaten : Siak

Provinsi : Riau

NIS : 200180

NSS : 202091104018

NPSN : 10403463

Akreditasi : A

Mulai Berdiri : Tahun 2000

Mulai Beroperasi : Tahun 2000

Status Tanah : Hak Milik

Luas Tanah : 11468 M²

Status Bangunan : Yayasan Persada Indah (Indah Kiat Tbk)

No. Telp : (0761) - 693265

<marquee behavior='scroll' class='html-marquee' direction='left' onmouseout='this.start();' onmouseover='this.stop();' scrollamount='3' scrolldelay='3'>


Form data_guru..php

<script language="javascript">document.location.href="?page=data_guru&status=1";<script language="javascript">document.location.href="?page=data_guru&status=2";

} }else{ unset($_POST['submit']); }

?> Sistem Informasi SMP YPPI <script src="SpryAssets/SpryCollapsiblePanel.js" type="text/javascript">

Data Guru


Nama Guru

NIP

Kelamin <select name="kelamin" class="styledselect_form_1">

Alamat

Telpon

Username

Password


<script type="text/javascript"> Form data_siswa.php <script language="javascript">document.location.href="?page=data_siswa&status=1";<script language="javascript">document.location.href="?page=data_siswa&status=2";

} }else{ unset($_POST['submit']); }

?> Sistem Informasi SMP YPPI

Data Siswa


Nama Siswa

NIS

Kelamin <select name="kelamin" class="styledselect_form_1">

Alamat

Telpon

Username

Password


Form hasil_nilai.php Sistem Informasi SMP YPPI

Hasil Nilai


Form home.php <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> Sistem Informasi SMP YPPI <script src="js/jquery/jquery-1.4.1.min.js" type="text/javascript"> <script src="js/jquery/ui.core.js" type="text/javascript"> <script src="js/jquery/ui.checkbox.js" type="text/javascript"> <script src="js/jquery/jquery.bind.js" type="text/javascript"> <script type="text/javascript"> $(function(){ $('input').checkBox(); $('#toggle-all').click(function(){ $('#toggle-all').toggleClass('toggle-checked'); $('#mainform input[type=checkbox]').checkBox('toggle'); return false; }); }); <script src="js/jquery/jquery.selectbox-0.5.js" type="text/javascript"> <script type="text/javascript"> $(document).ready(function() { $('.styledselect').selectbox({ inputClass: "selectbox_styled" }); });


<script src="js/jquery/jquery.selectbox-0.5_style_2.js" type="text/javascript"> <script type="text/javascript"> $(document).ready(function() { $('.styledselect_form_1').selectbox({ inputClass: "styledselect_form_1" }); $('.styledselect_form_2').selectbox({ inputClass: "styledselect_form_2" }); }); <script src="js/jquery/jquery.selectbox-0.5_style_2.js" type="text/javascript"> <script type="text/javascript"> $(document).ready(function() { $('.styledselect_pages').selectbox({ inputClass: "styledselect_pages" }); }); <script src="js/jquery/jquery.filestyle.js" type="text/javascript"> <script type="text/javascript" charset="utf-8"> $(function() { $("input.file_1").filestyle({ image: "images/forms/choose-file.gif", imageheight : 21, imagewidth : 78, width : 310 }); }); <script src="js/jquery/custom_jquery.js" type="text/javascript"> <script src="js/jquery/jquery.tooltip.js" type="text/javascript"> <script src="js/jquery/jquery.dimensions.js" type="text/javascript"> <script type="text/javascript"> $(function() { $('a.info-tooltip ').tooltip({ track: true, delay: 0, fixPNG: true,


showURL: false, showBody: " - ", top: -35, left: 5 }); });

<script src="js/jquery/date.js" type="text/javascript"> <script src="js/jquery/jquery.datePicker.js" type="text/javascript"> <script type="text/javascript" charset="utf-8"> $(function() { // initialise the "Select date" link $('#date-pick') .datePicker( // associate the link with a date picker { createButton:false, startDate:'01/01/2005', endDate:'31/12/2020' } ).bind( // when the link is clicked display the date picker 'click', function() { updateSelects($(this).dpGetSelected()[0]); $(this).dpDisplay(); return false; } ).bind( // when a date is selected update the SELECTs 'dateSelected', function(e, selectedDate, $td, state) { updateSelects(selectedDate); } ).bind( 'dpClosed', function(e, selected) { updateSelects(selected[0]); } );


var updateSelects = function (selectedDate) { var selectedDate = new Date(selectedDate); $('#d option[value=' + selectedDate.getDate() + ']').attr('selected', 'selected'); $('#m option[value=' + (selectedDate.getMonth()+1) + ']').attr('selected', 'selected'); $('#y option[value=' + (selectedDate.getFullYear()) + ']').attr('selected', 'selected'); } // listen for when the selects are changed and update the picker $('#d, #m, #y') .bind( 'change', function() { var d = new Date( $('#y').val(), $('#m').val()-1, $('#d').val() ); $('#date-pick').dpSetSelected(d.asString()); } ); // default the position of the selects to today var today = new Date(); updateSelects(today.getTime()); // and update the datePicker to reflect it... $('#d').trigger('change'); });


Settings


Inbox


Form index.php

$username=$_POST['username']; $password=md5($_POST['password']); $domain=$_POST['domain']; if($domain=="admin"){ $query=mysql_query("select * from user_admin where username='$username' and password='$password'"); $cek=mysql_num_rows($query); $row=mysql_fetch_array($query); $id_admin=$row['id_admin']; if($cek){ $_SESSION['username']=$username; $_SESSION['id_admin']=$id_admin; $_SESSION['domain']=$domain; $_SESSION['waktu']=date("Y-m-d H:i:s"); ?><script language="javascript">document.location.href="home.php";<script language="javascript">document.location.href="index.php?status=Gagal Login";<script language="javascript">document.location.href="home.php";<script language="javascript">document.location.href="index.php?status=Gagal Login";

if($domain=="siswa"){ $query=mysql_query("select * from data_siswa where username='$username' and password='$password'"); $cek=mysql_num_rows($query); $row=mysql_fetch_array($query); $id_siswa=$row['id_siswa']; if($cek){ $_SESSION['username']=$username; $_SESSION['id_siswa']=$id_siswa; $_SESSION['waktu']=date("Y-m-d H:i:s"); $_SESSION['domain']=$domain; ?><script language="javascript">document.location.href="home.php";<script language="javascript">document.location.href="index.php?status=Gagal Login"; <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> Sistem Informasi SMP YPPI <script src="js/jquery/jquery-1.4.1.min.js" type="text/javascript"> <script src="js/jquery/custom_jquery.js" type="text/javascript"> <script src="js/jquery/jquery.pngFix.pack.js" type="text/javascript"> <script type="text/javascript"> $(document).ready(function(){ $(document).pngFix( );


});


Username

Password

Akses <select name="domain" class="styledselect">

Form input_nilai.php <script language="javascript">document.location.href="?page=input_nilai_siswa&id_guru=< ?php echo $id_guru;?>&id_pelajaran=&id_kelas=";<script language="javascript">document.location.href="?page=input_nilai_update&id_guru= &id_pelajaran=&id_kelas=";

} }else{ unset($_POST['id_guru']); }

?>

Input Nilai

1

Pilih Mata Pelajaran

2

Input Nilai Siswa

3

Selesai


Nomor Nama Mata Pelajaran Kelas

&id_pelajaran=&id_kelas=" style="text-decoration:underline" title="Pilih Mata Pelajaran">


Form input_nilai_selesai.php Sistem Informasi SMP YPPI

Input Nilai

1


2

Input Nilai Siswa

3

Selesai


$guru=mysql_fetch_array(mysql_query("select * from data_guru where id_guru='$id_guru'")); $kelas=mysql_fetch_array(mysql_query("select * from setup_kelas where id_kelas='$id_kelas'")); $pelajaran=mysql_fetch_array(mysql_query("select * from setup_pelajaran where id_pelajaran='$id_pelajaran'")); $nama_guru=$guru['nama_guru']; $nama_kelas=$kelas['nama_kelas']; $nama_pelajaran=$pelajaran['nama_pelajaran']; ?>

Nama Guru

Pelajaran

Kelas


Nomor Nama Siswa NIS Nilai Siswa

Form input_nilai_siswa.php

include "conn.php"; if(isset($_POST['submit'])){ $jumSis = $_POST['jumlah'];

for ($i=1; $i<=$jumSis; $i++) { $id_siswa = $_POST['id_siswa'.$i]; $nilai = $_POST['nilai'.$i]; $id_guru = $_POST['id_guru']; $id_kelas = $_POST['id_kelas']; $id_pelajaran = $_POST['id_pelajaran']; $query = "insert into tbl_nilai values('','$id_siswa','$id_pelajaran','$id_kelas','$id_guru','$nilai')"; $hasil=mysql_query($query); } if($hasil){ ?><script language="javascript">document.location.href="?page=input_nilai_selesai&id_guru= &id_kelas=&id_pelajaran=";<script language="javascript">document.location.href="?page=input_nilai_selesai&status=2" ;

Input Nilai


1


2

Input Nilai Siswa

3

Selesai


Nama Guru

Pelajaran

Kelas


"; ?>


"; ?>

Form input_nilai_update.php

for ($i=1; $i<=$jumSis; $i++) { $id_siswa = $_POST['id_siswa'.$i]; $nilai = $_POST['nilai'.$i]; $id_guru = $_POST['id_guru']; $id_kelas = $_POST['id_kelas']; $id_pelajaran = $_POST['id_pelajaran']; $query = "insert into tbl_nilai values('','$id_siswa','$id_pelajaran','$id_kelas','$id_guru','$nilai')"; $hasil=mysql_query($query); } if($hasil){ ?><script language="javascript">document.location.href="?page=input_nilai_selesai&id_guru= &id_kelas=&id_pelajaran=";<script language="javascript">document.location.href="?page=input_nilai_selesai&status=2" ;

Input Nilai


1


2

Input Nilai Siswa

3

Selesai


Nama Guru

Pelajaran

Kelas

"; ?>



"; ?>

Form jadwal_pengajaran.php

$query=mysql_query("insert into tbl_jadwal values('','$id_guru','$id_pelajaran','$id_kelas')");

if($query){ ?><script language="javascript">document.location.href="?page=jadwal_pengajaran&status=1" ;<script language="javascript">document.location.href="?page=jadwal_pengajaran&status=2" ;
}else{ unset($_POST['submit']); }

?>

Jadwal Pengajaran


Guru <select name="id_guru" class="styledselect_form_1">


Pelajaran <select name="id_pelajaran" class="styledselect_form_1">

Kelas <select name="id_kelas" class="styledselect_form_1">

<em>*Tidak boleh 1 Kelas, 1 Pelajaran di ajarkan oleh 2 Guru atau lebih


$view=mysql_query("select * from tbl_jadwal jadwal, setup_kelas kelas, setup_pelajaran pelajaran, data_guru guru where jadwal.id_kelas=kelas.id_kelas and jadwal.id_pelajaran=pelajaran.id_pelajaran and jadwal.id_guru=guru.id_guru order by id_jadwal asc"); $no=0; while($row=mysql_fetch_array($view)){ ?>

Nomor Nama Guru NIP Mata Pelajaran Kelas Aksi

Form jadwal_ruangkelas.php

if(isset($_POST['submit'])){ $id_siswa=htmlentities($_POST['id_siswa']); $id_kelas=htmlentities($_POST['id_kelas']); $query=mysql_query("insert into tbl_ruangan values('','$id_siswa','$id_kelas')"); if($query){ ?><script language="javascript">document.location.href="?page=jadwal_ruangkelas&status=1" ;<script language="javascript">document.location.href="?page=jadwal_ruangkelas&status=2" ;

Ruang Kelas


Siswa <select name="id_siswa" class="styledselect_form_1">

?>

Kelas <select name="id_kelas" class="styledselect_form_1">

<em>*Satu Siswa hanya untuk Satu Ruang Kelas


?>

Nomor Nama Siswa NIS Kelas Aksi

Form laporan_penilaian.php Sistem Informasi SMP YPPI

Laporan Penilaian



?>

Nomor Nama Siswa NIS Kelas Mata Pelajaran Nilai

Username
Password
Akses	<select name="domain" class="styledselect">

KARTU BIMBINGAN TUGAS AKHIR MAHASISWA

Recommend Documents

Selamat Datang di Sistem Nilai Online SMP YPPI,

Data Guru

Data Siswa

Hasil Nilai

Input Nilai

Input Nilai

Input Nilai

Input Nilai

Jadwal Pengajaran

Ruang Kelas

Laporan Penilaian

Laporan Penilaian

Setup Kelas

Setup Pelajaran