Tugas Akhir Praktek Pemrogram SQl

Membuat Aplikasi Sistem Informasi Akademik

1.1 Perancangan Database

Perancangan database yang akan diimplementasikan pada DBMS adalah sebagai berikut:

Gambar 1 Perancangan Database yang Akan Digunakan

Di dalam database terdapat 5 tabel yang saling berelasi. Tabel-tabelnya terdiri dari: Tabel Dosen, Tabel Mahasiswa, Tabel Nilai, Tabel Ruangan, Tabel Jadwal, Tabel Mata Kuliah.

1.2 Implementasi pada DBMS

Setelah melakukan perancangan database, selanjutnya adalah mengimplementasikan perancangan database ke dalam sebuah DBMS. DBMS yang digunakan untuk membuat Tugas UAS ini adalah SQL Server.

APLIKASI SISTEM INFORMASI AKADEMIK UNIVERSITAS MURIA KUDUS

2.1 Implementasi SQL pada Aplikasi

Dalam Aplikasi Sistem Informasi Akademik universitas muria kudus terdapat beberapa form yang dapat diakses oleh beberapa hak akses tertentu. Hak Akses Admin dapat mengakses seluruh form aplikasi. Hak Akses Dosen dapat mengakses jadwal dan nilai. Hak Akses Mahasiswa dapat mengakses jadwal dan nilai. Berikut adalah screenshot dari form-form Aplikasi Sistem Informasi Akademik Universitas Muria Kudus.
ini adalah link dari project saya klik

2.1.1 Form Login

Gambar 15 Form Login

Sintak Php :

<?php

session_start();

if (isset($_SESSION['ses_id_user'])=="") {

} else {

echo"<content='0;url=?page=login'>";

}

<!DOCTYPE html>

<html>

<head>

<title>Login</title>

</head>

<a href="index.php"><b>Login</b></a>

</div>

<p class="login-box-msg">Masuk untuk memulai pekerjaan</p>

</div>

</div>

</div>

<button type="submit" name="login" class="btn btn-primary btn-block btn-flat">Masuk</button>

</div>

</form>

<?php

require_once "koneksi.php";

if (isset($_POST['login'])) {

$query = sqlsrv_query($konek, "SELECT id_user, username, password from tb_admin where username = '".$_POST['username']."' and password='".$_POST['password']."'");

$data = sqlsrv_fetch_array($query);

if ($data['id_user']=='1') {

$_SESSION['ses_username'] = $data['username'];

$_SESSION['ses_id_user'] = $data['id_user'];

echo"<meta http-equiv='refresh' content='0;url=admin/index.php'>";

}elseif ($data['id_user']=='2') {

$_SESSION['ses_id_user'] = $data['id_user'];

$_SESSION['ses_username'] = $data['username'];

echo"<meta http-equiv='refresh' content='0;url=dosen/index.php'>";

}elseif ($data['id_user']=='3') {

$_SESSION['ses_id_user'] = $data['id_user'];

$_SESSION['ses_username'] = $data['username'];

echo"<meta http-equiv='refresh' content='0;url=mahasiswa/index.php'>";

}else{

echo "<div align='center'>

<font color='red'> Login Gagal !!! </font>

</div>";

}

<br>

</div>

</body>

</html>

2.1.2 Form Dosen

Gambar 17 Form Dosen

Implementasi SQL yang digunakan untuk menampilkan data pada form pengajar adalah:

Sintak Php :

<!DOCTYPE html>

<html>

<head>

<title>Data Dosen</title>

</head>

<body>

</div>

<a href="?page=tambah_dosen"><div class="col-sm-2"><button type="button" class="btn btn-block btn-primary">Tambah</button></div></a><div class="col-sm-8"></div><a href="laporan_dosen.php"><div class="col-sm-2"><button type="button" class="btn btn-block btn-info">Laporan</button></div></a><br><hr>

<thead>

<tr>

<th>Nama Dosen</th>

<th>Tanggal Lahir</th>

<th>Jenis Kelamin</th>

<th>Alamat</th>

</tr>

</thead>

<tbody>

<?php

$query = sqlsrv_query($konek, "SELECT *, FORMAT(tgl_lahir, 'dd-MM-yyyy', 'en-US') AS tgl_lahir FROM dosen order by id_dosen asc")or die(sqlsrv_errors());

$no = 1;

while ($data = sqlsrv_fetch_array($query))

{

<tr>

<td>

<a href="?page=hapus&id=<?php echo $data ['id_dosen'];?>" onClick="return confirm('Yakin menghapus data ?');"> <button type="button" class="btn btn-default btn-sm"><i class="fa fa-trash-o"></i></button></a>

</td>

</tr>

<?php

$no ++;

}

</tbody>

</table>

</div>

</section>

</body>

</html>

Gambar 18 Form Tambah Dosen

Implementasi SQL yang digunakan untuk manambahkan data pada form pengajar adalah:

Gambar 19 Form Edit Dosen

Sintak Php :

<?php
$query = sqlsrv_query($konek, "SELECT *, FORMAT(tgl_lahir, 'dd-MM-yyyy', 'en-US') AS tgl_lahir from dosen where id_dosen = '".addslashes($_GET['id'])."'");
$data = sqlsrv_fetch_array($query);
?>
< section class="content">
< div class="row">
<div class="col-md-12">
<div class="box">
<div class="box-header">

<form method="post" enctype="multipart/form-data">
<h3 class="box-title">UBAH DATA
<small>Dosen</small>
</h3>
<div class="box-body">
<div class="form-group">
<label for="exampleInputEmail1">Nama Dosen</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="nama_dosen" placeholder="Nama Dosen" value="<?php echo $data['nama_dosen']?>">
</div>
<div class="form-group">
<label for="exampleInputEmail1">Tanggal Lahir</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="tgl_lahir" placeholder="Tanggal Lahir" value="<?php echo $data['tgl_lahir']?>">
</div>
<div class="form-group">
<label for="exampleInputEmail1">Jenis Kelamin</label>
<select class="form-control" name="jekel">
<option value="Laki-Laki">Laki-Laki</option>
<option value="Perempuan">Perempuan</option>
</select>
</div>
<div class="form-group">
<label for="exampleInputEmail1">No.Telp</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="telp" placeholder="No.Telp" value="<?php echo $data['no_telp']?>">
</div>
<div class="form-group">
<label for="exampleInputEmail1">Alamat</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="alamat" placeholder="Alamat" value="<?php echo $data['alamat']?>">
</div>
</div>
<div class="box-footer">
<button type="submit" class="btn btn-primary" name="simpan">Ubah</button>
</div>
</form>
</div>
</div>
<?php
error_reporting(0);
require_once "../koneksi.php";
if (isset($_POST['simpan'])) {

$sql_insert = "UPDATE dosen set
nama_dosen = '".$_POST['nama_dosen']."',
tgl_lahir = '".$_POST['tgl_lahir']."',
jekel = '".$_POST['jekel']."',
no_telp = '".$_POST['telp']."',
alamat = '".$_POST['alamat']."' where id_dosen = '".$data['id_dosen']."'";

$query_insert = sqlsrv_query($konek, $sql_insert) or die (sqlsrv_errors());

if ($query_insert) {

echo "<div class='alert alert-success'>
<a href='?page=dosen' class='close' data-dismiss='alert'>×
</a>Berhasil Diubah
</div>";
echo "<meta http-equiv='refresh'content='1; url=?page=dosen'>";
}else{
echo "<div class='alert alert-danger'>
<a href='' class='close' data-dismiss='alert'>×
</a>Gagal Simpan !
</div>";
}
}
?>
</div>
< /div>
< /section>

Gambar 20 Form Delete Dosen

Implementasi SQL yang digunakan untuk menghapus data pada form pengajar adalah:

DELETE FROM dosenWHERE id_dosen='”.$_GET[‘id’].”'

Gambar 21 Laporan Data Dosen

Sintak Php :

<!DOCTYPE html>

<html>

<head>

<title>Data Dosen</title>

<!-- AdminLTE Skins. Choose a skin from the css/skins

folder instead of downloading all of them to reduce the load. -->

</head>

<body>

</div>

<thead>

<tr>

<th>Nama Dosen</th>

<th>Tanggal Lahir</th>

<th>Jenis Kelamin</th>

<th>Alamat</th>

</tr>

</thead>

<tbody>

<?php

require_once "../koneksi.php";

$query = sqlsrv_query($konek, "SELECT *, FORMAT(tgl_lahir, 'dd-MM-yyyy', 'en-US') AS tgl_lahir FROM dosen order by id_dosen asc")or die(sqlsrv_errors());

$no = 1;

while ($data = sqlsrv_fetch_array($query))

{

<tr>

</tr>

<?php

$no ++;

}

</tbody>

</table>

</div>

</section>

window.print();

</script>

</body>

</html>

2.1.3 Form Mahasiswa

Gambar 22 Form Mahasiswa

Sintak Php :
< !DOCTYPE html>
< html>
< head>
<title>Data Mahasiswa</title>
< /head>
< body>
< section class="content">
<div class="row">
<div class="col-xs-12">

<div class="box">
<div class="box-header">
</div>

<div class="box-body">
<a href="?page=tambah_mahasiswa"><div class="col-sm-2"><button type="button" class="btn btn-block btn-primary">Tambah</button></div></a><div class="col-sm-8"></div><a href="laporan_mahasiswa.php"><div class="col-sm-2"><button type="button" class="btn btn-block btn-info">Laporan</button></div></a><br><hr>
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>No</th>
<th>Nama Mahasiswa</th>
<th>Tanggal Lahir</th>
<th>Jenis Kelamin</th>
<th>No.Telp</th>
<th>Alamat</th>
</tr>
</thead>
<tbody>
<?php
$query = sqlsrv_query($konek, "SELECT *, FORMAT(tgl_lahir, 'dd-MM-yyyy', 'en-US') AS tgl_lahir FROM mahasiswa order by id_mahasiswa asc")or die(sqlsrv_errors());
$no = 1;
while ($data = sqlsrv_fetch_array($query))
{
?>
<tr>
<td><?php echo $no;?></td>
<td><?php echo $data['nama_mahasiswa'];?></td>
<td><?php echo date_format(new DateTime($data['tgl_lahir']),'d M Y') ;?></td>
<td><?php echo $data['jekel'];?></td>
<td><?php echo $data['no_telp'];?></td>
<td><?php echo $data['alamat'];?></td>
<td>
<a href="?page=ubah_mahasiswa&id=<?php echo $data['id_mahasiswa'];?>"><button type="button" class="btn btn-default btn-sm"><img src="imgFoto/10.png" height="15"></button></a>
<a href="?page=hapus_mahasiswa&id=<?php echo $data ['id_mahasiswa'];?>" onClick="return confirm('Yakin menghapus data ?');"> <button type="button" class="btn btn-default btn-sm"><i class="fa fa-trash-o"></i></button></a>
</td>
</tr>
<?php
$no ++;
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
< /section>
< /body>
< /html>

Gambar 23 Form Tambah Mahasiswa

Sintak Php :
< section class="content">
< div class="row">
<div class="col-md-12">
<div class="box">
<div class="box-header">

<form method="post" enctype="multipart/form-data">
<h3 class="box-title">TAMBAH DATA
<small>Mahasiswa</small>
</h3>
<div class="box-body">
<div class="form-group">
<label for="exampleInputEmail1">Nama Mahasiswa</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="nama_mahasiswa" placeholder="Nama Mahasiswa">
</div>
<div class="form-group">
<label for="exampleInputEmail1">Tanggal Lahir</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="tgl_lahir" placeholder="Tanggal Lahir">
</div>
<div class="form-group">
<label for="exampleInputEmail1">Jenis Kelamin</label>
<select class="form-control" name="jekel">
<option value="Laki-Laki">Laki-Laki</option>
<option value="Perempuan">Perempuan</option>
</select>
</div>
<div class="form-group">
<label for="exampleInputEmail1">No.Telp</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="telp" placeholder="No.Telp">
</div>
<div class="form-group">
<label for="exampleInputEmail1">Alamat</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="alamat" placeholder="Alamat">
</div>
</div>
<div class="box-footer">
<button type="submit" class="btn btn-primary" name="simpan">Simpan</button>
</div>
</form>
</div>
</div>
<?php
error_reporting(0);
require_once "../koneksi.php";
if (isset($_POST['simpan'])) {

$sql_insert = "INSERT into mahasiswa (nama_mahasiswa, tgl_lahir, jekel, no_telp, alamat) values(
'".$_POST['nama_mahasiswa']."',
'".$_POST['tgl_lahir']."',
'".$_POST['jekel']."',
'".$_POST['telp']."',
'".$_POST['alamat']."')";

$query_insert = sqlsrv_query($konek, $sql_insert) or die (sqlsrv_errors());

if ($query_insert) {

echo "<div class='alert alert-success'>
<a href='?page=mahasiswa' class='close' data-dismiss='alert'>×
</a>Berhasil Disimpan
</div>";
echo "<meta http-equiv='refresh'content='1; url=?page=mahasiswa'>";
}else{
echo "<div class='alert alert-danger'>
<a href='' class='close' data-dismiss='alert'>×
</a>Gagal Simpan !
</div>";
}
}
?>
</div>
< /div>
< /section>

Gambar 24 Form Ubah Mahasiswa

Sintak Php :

< ?php
$query = sqlsrv_query($konek, "SELECT *, FORMAT(tgl_lahir, 'dd-MM-yyyy', 'en-US') AS tgl_lahir from mahasiswa where id_mahasiswa = '".addslashes($_GET['id'])."'");
$data = sqlsrv_fetch_array($query);
?>
< section class="content">
< div class="row">
<div class="col-md-12">
<div class="box">
<div class="box-header">

<form method="post" enctype="multipart/form-data">
<h3 class="box-title">UBAH DATA
<small>Mahasiswa</small>
</h3>
<div class="box-body">
<div class="form-group">
<label for="exampleInputEmail1">Nama Mahasiswa</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="nama_mahasiswa" placeholder="Nama Mahasiswa" value="<?php echo $data['nama_mahasiswa']?>">
</div>
<div class="form-group">
<label for="exampleInputEmail1">Tanggal Lahir</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="tgl_lahir" placeholder="Tanggal Lahir" value="<?php echo $data['tgl_lahir']?>">
</div>
<div class="form-group">
<label for="exampleInputEmail1">Jenis Kelamin</label>
<select class="form-control" name="jekel">
<option value="Laki-Laki">Laki-Laki</option>
<option value="Perempuan">Perempuan</option>
</select>
</div>
<div class="form-group">
<label for="exampleInputEmail1">No.Telp</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="telp" placeholder="No.Telp" value="<?php echo $data['no_telp']?>">
</div>
<div class="form-group">
<label for="exampleInputEmail1">Alamat</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="alamat" placeholder="Alamat" value="<?php echo $data['alamat']?>">
</div>
</div>
<div class="box-footer">
<button type="submit" class="btn btn-primary" name="simpan">Simpan</button>
</div>
</form>
</div>
</div>
<?php
error_reporting(0);
require_once "../koneksi.php";
if (isset($_POST['simpan'])) {

$sql_insert = "UPDATE mahasiswa set
nama_mahasiswa = '".$_POST['nama_mahasiswa']."',
tgl_lahir = '".$_POST['tgl_lahir']."',
jekel = '".$_POST['jekel']."',
no_telp = '".$_POST['telp']."',
alamat = '".$_POST['alamat']."' where id_mahasiswa = '".$data['id_mahasiswa']."'";

$query_insert = sqlsrv_query($konek, $sql_insert) or die (sqlsrv_errors());

if ($query_insert) {

echo "<div class='alert alert-success'>
<a href='?page=mahasiswa' class='close' data-dismiss='alert'>×
</a>Berhasil Diubah
</div>";
echo "<meta http-equiv='refresh'content='1; url=?page=mahasiswa'>";
}else{
echo "<div class='alert alert-danger'>
<a href='' class='close' data-dismiss='alert'>×
</a>Gagal Simpan !
</div>";
}
}
?>
</div>
< /div>
< /section>

Gambar 25 Form Hapus Mahasiswa

Implementasi SQL yang digunakan untuk menampilkan data pada form hapus peserta adalah:

DELETE FROM mahasiswa WHERE id_mahasiswa ='”.$_GET[‘id’].”'

Gambar 26 Laporan Data Mahasiswa

Sintak Php :

<!DOCTYPE html>
< html>
< head>
<title>Data Mahasiswa</title>
<link rel="stylesheet" href="../bootstrap/css/bootstrap.min.css">
< !-- Font Awesome -->
< link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.5.0/css/font-awesome.min.css">
< !-- Ionicons -->
< link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/ionicons/2.0.1/css/ionicons.min.css">
< !-- DataTables -->
< link rel="stylesheet" href="../plugins/datatables/dataTables.bootstrap.css">
< !-- Theme style -->
< link rel="stylesheet" href="../dist/css/AdminLTE.min.css">
< !-- AdminLTE Skins. Choose a skin from the css/skins
folder instead of downloading all of them to reduce the load. -->
< link rel="stylesheet" href="../dist/css/skins/_all-skins.min.css">
< link rel="stylesheet" href="../plugins/iCheck/all.css">
< /head>
< body>
< section class="content">
<div class="row">
<div class="col-xs-12">

<div class="box">
<div class="box-header">
</div>

<div class="box-body">
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>No</th>
<th>Nama Mahasiswa</th>
<th>Tanggal Lahir</th>
<th>Jenis Kelamin</th>
<th>No.Telp</th>
<th>Alamat</th>
</tr>
</thead>
<tbody>
<?php
require_once "../koneksi.php";
$query = sqlsrv_query($konek, "SELECT *, FORMAT(tgl_lahir, 'dd-MM-yyyy', 'en-US') AS tgl_lahir FROM mahasiswa order by id_mahasiswa asc")or die(sqlsrv_errors());
$no = 1;
while ($data = sqlsrv_fetch_array($query))
{
?>
<tr>
<td><?php echo $no;?></td>
<td><?php echo $data['nama_mahasiswa'];?></td>
<td><?php echo date_format(new DateTime($data['tgl_lahir']),'d M Y') ;?></td>
<td><?php echo $data['jekel'];?></td>
<td><?php echo $data['no_telp'];?></td>
<td><?php echo $data['alamat'];?></td>
</tr>
<?php
$no ++;
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
< /section>
< script>
window.print();
< /script>
< /body>
< /html>

2.1.4 Form Ruangan

Gambar 27 Form Ruangan

Sintak Php :
< !DOCTYPE html>
< html>
< head>
<title>Data Ruangan</title>
< /head>
< body>
< section class="content">
<div class="row">
<div class="col-xs-12">

<div class="box">
<div class="box-header">
</div>

<div class="box-body">
<a href="?page=tambah_ruangan"><div class="col-sm-2"><button type="button" class="btn btn-block btn-primary">Tambah</button></div></a><div class="col-sm-8"></div><a href="laporan_ruangan.php"><div class="col-sm-2"><button type="button" class="btn btn-block btn-info">Laporan</button></div></a><br><hr>
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>No</th>
<th>Nama Ruangan</th>
<th>Kapasitas</th>
<th>Aksi</th>
</tr>
</thead>
<tbody>
<?php
$query = sqlsrv_query($konek, "SELECT * FROM ruangan order by id_ruangan asc")or die(sqlsrv_errors());
$no = 1;
while ($data = sqlsrv_fetch_array($query))
{
?>
<tr>
<td><?php echo $no;?></td>
<td><?php echo $data['nama_ruangan'];?></td>
<td><?php echo $data['kapasitas'];?></td>
<td>
<a href="?page=ubah_ruangan&id=<?php echo $data['id_ruangan'];?>"><button type="button" class="btn btn-default btn-sm"><img src="imgFoto/10.png" height="15"></button></a>
<a href="?page=hapus&id=<?php echo $data ['id_ruangan'];?>" onClick="return confirm('Yakin menghapus data ?');"> <button type="button" class="btn btn-default btn-sm"><i class="fa fa-trash-o"></i></button></a>
</td>
</tr>
<?php
$no ++;
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
< /section>
< /body>
< /html>

Gambar 28 Form Tambah Ruangan

Gambar 29 Form Edit Ruangan

Sintak Php :
< ?php
$query = sqlsrv_query($konek, "SELECT * from ruangan where id_ruangan = '".addslashes($_GET['id'])."'");
$data = sqlsrv_fetch_array($query);
?>
< section class="content">
< div class="row">
<div class="col-md-12">
<div class="box">
<div class="box-header">

<form method="post" enctype="multipart/form-data">
<h3 class="box-title">UBAH DATA
<small>Ruangan</small>
</h3>
<div class="box-body">
<div class="form-group">
<label for="exampleInputEmail1">Nama Ruangan</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="nama_ruangan" placeholder="Nama Ruangan" value="<?php echo $data['nama_ruangan']?>">
</div>
<div class="form-group">
<label for="exampleInputEmail1">Kapasitas</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="kapasitas" placeholder="Kapasitas" value="<?php echo $data['kapasitas']?>">
</div>
</div>
<div class="box-footer">
<button type="submit" class="btn btn-primary" name="simpan">Simpan</button>
</div>
</form>
</div>
</div>
<?php
error_reporting(0);
require_once "../koneksi.php";
if (isset($_POST['simpan'])) {

$sql_insert = "UPDATE ruangan set
nama_ruangan = '".$_POST['nama_ruangan']."',
kapasitas = '".$_POST['kapasitas']."' where id_ruangan = '".$data['id_ruangan']."'";

$query_insert = sqlsrv_query($konek, $sql_insert) or die (sqlsrv_errors());

if ($query_insert) {

echo "<div class='alert alert-success'>
<a href='?page=ruangan' class='close' data-dismiss='alert'>×
</a>Berhasil Disimpan
</div>";
echo "<meta http-equiv='refresh'content='1; url=?page=ruangan'>";
}else{
echo "<div class='alert alert-danger'>
<a href='' class='close' data-dismiss='alert'>×
</a>Gagal Simpan !
</div>";
}
}
?>
</div>
< /div>
< /section>

Gambar 30 Form Hapus Ruangan

Implementasi SQL yang digunakan untuk menampilkan data pada form hapus ruangan adalah:

DELETE FROM ruangan WHERE id_ruangan='”.$_GET[‘id’].”'

Gambar 31 Laporan Data Ruangan

Sintak Php :

<!DOCTYPE html>

<html>

<head>

<title>Data Ruangan</title>

<!-- AdminLTE Skins. Choose a skin from the css/skins

folder instead of downloading all of them to reduce the load. -->

</head>

<body>

</div>

<thead>

<tr>

<th>Nama Ruangan</th>

<th>Kapasitas</th>

</tr>

</thead>

<tbody>

<?php

require_once "../koneksi.php";

$query = sqlsrv_query($konek, "SELECT * FROM ruangan order by id_ruangan asc")or die(sqlsrv_errors());

$no = 1;

while ($data = sqlsrv_fetch_array($query))

{

<tr>

</tr>

<?php

$no ++;

}

</tbody>

</table>

</div>

</section>

window.print();

</script>

</body>

</html>

2.1.5 Form Mata Kuliah

Gambar 32 Form Mata Kuliah

<!DOCTYPE html>
< html>
< head>
<title>Data Mata Kuliah</title>
< /head>
< body>
< section class="content">
<div class="row">
<div class="col-xs-12">

<div class="box">
<div class="box-header">
</div>

<div class="box-body">
<a href="?page=tambah_makul"><div class="col-sm-2"><button type="button" class="btn btn-block btn-primary">Tambah</button></div></a><div class="col-sm-8"></div><a href="laporan_makul.php"><div class="col-sm-2"><button type="button" class="btn btn-block btn-info">Laporan</button></div></a><br><hr>
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>No</th>
<th>Nama Mata Kuliah</th>
<th>Jumlah SKS</th>
<th>Biaya</th>
</tr>
</thead>
<tbody>
<?php
$query = sqlsrv_query($konek, "SELECT * FROM makul order by id_makul asc")or die(sqlsrv_errors());
$no = 1;
while ($data = sqlsrv_fetch_array($query))
{
?>
<tr>
<td><?php echo $no;?></td>
<td><?php echo $data['nama_makul'];?></td>
<td><?php echo $data['jumlah_sks'];?></td>
<td><?php echo $data['biaya'];?></td>
<td>
<a href="?page=ubah_makul&id=<?php echo $data['id_makul'];?>"><button type="button" class="btn btn-default btn-sm"><img src="imgFoto/10.png" height="15"></button></a>
<a href="?page=hapus&id=<?php echo $data ['id_makul'];?>" onClick="return confirm('Yakin menghapus data ?');"> <button type="button" class="btn btn-default btn-sm"><i class="fa fa-trash-o"></i></button></a>
</td>
</tr>
<?php
$no ++;
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
< /section>
< /body>
< /html>

Gambar 33 Form Tambah Mata Kuliah

Sintak Php :
< section class="content">
< div class="row">
<div class="col-md-12">
<div class="box">
<div class="box-header">

<form method="post" enctype="multipart/form-data">
<h3 class="box-title">TAMBAH DATA
<small>Mata Kuliah</small>
</h3>
<div class="box-body">
<div class="form-group">
<label for="exampleInputEmail1">Nama Mata Kuliah</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="nama_makul" placeholder="Nama Mata Kuliah">
</div>
<div class="form-group">
<label for="exampleInputEmail1">Jumlah SKS</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="jumlah_sks" placeholder="Jumlah SKS">
</div>
<div class="form-group">
<label for="exampleInputEmail1">Biaya</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="biaya" placeholder="Biaya">
</div>
</div>
<div class="box-footer">
<button type="submit" class="btn btn-primary" name="simpan">Simpan</button>
</div>
</form>
</div>
</div>
<?php
error_reporting(0);
require_once "../koneksi.php";
if (isset($_POST['simpan'])) {

$sql_insert = "INSERT into makul (nama_makul, jumlah_sks, biaya) values(
'".$_POST['nama_makul']."',
'".$_POST['jumlah_sks']."',
'".$_POST['biaya']."')";

$query_insert = sqlsrv_query($konek, $sql_insert) or die (sqlsrv_errors());

if ($query_insert) {

echo "<div class='alert alert-success'>
<a href='?page=makul' class='close' data-dismiss='alert'>×
</a>Berhasil Disimpan
</div>";
echo "<meta http-equiv='refresh'content='1; url=?page=makul'>";
}else{
echo "<div class='alert alert-danger'>
<a href='' class='close' data-dismiss='alert'>×
</a>Gagal Simpan !
</div>";
}
}
?>
</div>
< /div>
< /section>

Gambar 34 Form Ubah Mata Kuliah

<?php
$query = sqlsrv_query($konek, "SELECT * from makul where id_makul = '".addslashes($_GET['id'])."'");
$data = sqlsrv_fetch_array($query);
?>
< section class="content">
< div class="row">
<div class="col-md-12">
<div class="box">
<div class="box-header">

<form method="post" enctype="multipart/form-data">
<h3 class="box-title">UBAH DATA
<small>Mata Kuliah</small>
</h3>
<div class="box-body">
<div class="form-group">
<label for="exampleInputEmail1">Nama Mata Kuliah</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="nama_makul" placeholder="Nama Mata Kuliah" value="<?php echo $data['nama_makul']?>">
</div>
<div class="form-group">
<label for="exampleInputEmail1">Jumlah SKS</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="jumlah_sks" placeholder="Jumlah SKS" value="<?php echo $data['jumlah_sks']?>">
</div>
<div class="form-group">
<label for="exampleInputEmail1">Biaya</label>
<input type="text" class="form-control" id="exampleInputEmail1" name="biaya" placeholder="Biaya" value="<?php echo $data['biaya']?>">
</div>
</div>
<div class="box-footer">
<button type="submit" class="btn btn-primary" name="simpan">Simpan</button>
</div>
</form>
</div>
</div>
<?php
error_reporting(0);
require_once "../koneksi.php";
if (isset($_POST['simpan'])) {

$sql_insert = "UPDATE makul set
nama_makul = '".$_POST['nama_makul']."',
jumlah_sks = '".$_POST['jumlah_sks']."',
biaya = '".$_POST['biaya']."' where id_makul = '".$data['id_makul']."'";

$query_insert = sqlsrv_query($konek, $sql_insert) or die (sqlsrv_errors());

if ($query_insert) {

echo "<div class='alert alert-success'>
<a href='?page=makul' class='close' data-dismiss='alert'>×
</a>Berhasil Diubah
</div>";
echo "<meta http-equiv='refresh'content='1; url=?page=makul'>";
}else{
echo "<div class='alert alert-danger'>
<a href='' class='close' data-dismiss='alert'>×
</a>Gagal Simpan !
</div>";
}
}
?>
</div>
< /div>
< /section>

Gambar 35 Form Hapus Mata Kuliah

Implementasi SQL yang digunakan untuk menampilkan data pada form hapus kursus adalah:

DELETE FROM makul WHERE id_makul ='”.$_GET['id'].”'

Gambar 36 Laporan Data Mata Kuliah

Sintak Php :

<!DOCTYPE html>

<html>

<head>

<title>Data Mata Kuliah</title>

<!-- AdminLTE Skins. Choose a skin from the css/skins

folder instead of downloading all of them to reduce the load. -->

</head>

<body>

</div>

<thead>

<tr>

<th>Nama Mata Kuliah</th>

<th>Jumlah SKS</th>

<th>Biaya</th>

</tr>

</thead>

<tbody>

<?php

require_once "../koneksi.php";

$query = sqlsrv_query($konek, "SELECT * FROM makul order by id_makul asc")or die(sqlsrv_errors());

$no = 1;

while ($data = sqlsrv_fetch_array($query))

{

<tr>

</tr>

<?php

$no ++;

}

</tbody>

</table>

</div>

</section>

window.print();

</script>

</body>

</html>

2.1.6 Form Jadwal

Gambar 37 Form Jadwal

Sintak Php :
< !DOCTYPE html>
< html>
< head>
<title>Data Jadwal</title>
< /head>
< body>
< section class="content">
<div class="row">
<div class="col-xs-12">

<div class="box">
<div class="box-header">
</div>

<div class="box-body">
<a href="?page=tambah_jadwal"><div class="col-sm-2"><button type="button" class="btn btn-block btn-primary">Tambah</button></div></a><div class="col-sm-8"></div><a href="laporan_jadwal.php"><div class="col-sm-2"><button type="button" class="btn btn-block btn-info">Laporan</button></div></a><br><hr>
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>No</th>
<th>Nama Dosen</th>
<th>Mata Kuliah</th>
<th>Ruangan</th>
<th>Hari</th>
<th>Jam</th>
<th>Aksi</th>
</tr>
</thead>
<tbody>
<?php
$query = sqlsrv_query($konek, "SELECT jadwal.id_jadwal, dosen.nama_dosen, makul.nama_makul, ruangan.nama_ruangan, jadwal.jam, jadwal.hari from jadwal inner join dosen on jadwal.id_dosen = dosen.id_dosen inner join makul on jadwal.id_makul=makul.id_makul inner join ruangan on jadwal.id_ruangan=ruangan.id_ruangan")or die(sqlsrv_errors());
$no = 1;
while ($data = sqlsrv_fetch_array($query))
{
?>
<tr>
<td><?php echo $no;?></td>
<td><?php echo $data['nama_dosen'];?></td>
<td><?php echo $data['nama_makul'];?></td>
<td><?php echo $data['nama_ruangan'];?></td>
<td><?php echo $data['hari'];?></td>
<td><?php echo $data['jam'];?></td>
<td>
<a href="?page=ubah_jadwal&id=<?php echo $data['id_jadwal'];?>"><button type="button" class="btn btn-default btn-sm"><img src="imgFoto/10.png" height="15"></button></a>
<a href="?page=hapus&id=<?php echo $data ['id_jadwal '];?>" onClick="return confirm('Yakin menghapus data ?');"> <button type="button" class="btn btn-default btn-sm"><i class="fa fa-trash-o"></i></button></a>
</td>
</tr>
<?php
$no ++;
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
< /section>
< /body>
< /html>

Gambar 38 Form Tambah Jadwal

<section class="content">
< div class="row">
<div class="col-md-12">
<div class="box">
<div class="box-header">

<form method="post" enctype="multipart/form-data">
<h3 class="box-title">TAMBAH DATA
<small>Jadwal</small>
</h3>
<div class="box-body">

<div class="form-group">
<label>Pilih Dosen</label>
<select class="form-control" name="id_dosen">
<?php
$query = sqlsrv_query($konek, "select * from dosen");
while ($data = sqlsrv_fetch_array($query)) {

?>
<option value="<?php echo $data['id_dosen']?>"><?php echo $data['nama_dosen']?></option>
<?php
}
?>
</select>
</div>

<div class="form-group">
<label>Pilih Makul</label>
<select class="form-control" name="id_makul">
<?php
$query = sqlsrv_query($konek, "select * from makul");
while ($data = sqlsrv_fetch_array($query)) {

?>
<option value="<?php echo $data['id_makul']?>"><?php echo $data['nama_makul']?></option>
<?php
}
?>
</select>
</div>

<div class="form-group">
<label>Pilih Ruangan</label>
<select class="form-control" name="id_ruangan">
<?php
$query = sqlsrv_query($konek, "select * from ruangan");
while ($data = sqlsrv_fetch_array($query)) {

?>
<option value="<?php echo $data['id_ruangan']?>"><?php echo $data['nama_ruangan']?></option>
<?php
}
?>
</select>
</div>

<div class="form-group">
<label>Hari</label>

<div class="input-group">

<div class="input-group-addon">

<i class="fa fa-calendar"></i>
</div>
<select class="form-control" name="hari">
<option value="Senin">Senin</option>
<option value="Selasa">Selasa</option>
<option value="Rabu">Rabu</option>
<option value="Kamis">Kamis</option>
<option value="Jum'at">Jum'at</option>
<option value="Sabtu">Sabtu</option>
</select>

</div>

</div>

<div class="form-group">
<label>Jam Mulai</label>

<div class="input-group col-md-3">

<div class="input-group-addon">

<i class="fa fa-clock-o"></i>
</div>
<input type="text" class="form-control timepicker" name="mulai">

</div>

</div>

<div class="form-group">
<label>Jam Selesai</label>

<div class="input-group col-md-3">

<div class="input-group-addon">

<i class="fa fa-clock-o"></i>
</div>
<input type="text" class="form-control timepicker" name="selesai">

</div>
</div>

</div>
<div class="box-footer">
<button type="submit" class="btn btn-primary" name="simpan">Simpan</button>
</div>
</form>
</div>
</div>
<?php
error_reporting(0);
require_once "../koneksi.php";
if (isset($_POST['simpan'])) {

$jam = $_POST['mulai']."-".$_POST['selesai'];

$sql_insert = "INSERT into jadwal (id_dosen, id_makul, id_ruangan, hari, jam) values(
'".$_POST['id_dosen']."',
'".$_POST['id_makul']."',
'".$_POST['id_ruangan']."',
'".$_POST['hari']."',
'".$jam."')";

$query_insert = sqlsrv_query($konek, $sql_insert) or die (sqlsrv_errors());

if ($query_insert) {

echo "<div class='alert alert-success'>
<a href='?page=jadwal' class='close' data-dismiss='alert'>×
</a>Berhasil Disimpan
</div>";
echo "<meta http-equiv='refresh'content='1; url=?page=jadwal'>";
}else{
echo "<div class='alert alert-danger'>
<a href='' class='close' data-dismiss='alert'>×
</a>Gagal Simpan !
</div>";
}
}
?>
</div>
< /div>
< /section>

Gambar 39 Form Edit Jadwal

<?php
$sql = sqlsrv_query($konek, "SELECT * from jadwal where id_jadwal = '".addslashes($_GET['id'])."'");
$data = sqlsrv_fetch_array($sql);
?>
< section class="content">
< div class="row">
<div class="col-md-12">
<div class="box">
<div class="box-header">

<form method="post" enctype="multipart/form-data">
<h3 class="box-title">UBAH DATA
<small>Jadwal</small>
</h3>
<div class="box-body">

<div class="form-group">
<label>Pilih Dosen</label>
<select class="form-control" name="id_dosen">
<?php
$query = sqlsrv_query($konek, "select * from dosen where id_dosen = '".$data['id_dosen']."'");
while ($data = sqlsrv_fetch_array($query)) {

?>
<option value="<?php echo $data['id_dosen']?>"><?php echo $data['nama_dosen']?></option>
<?php
}
?>
</select>
</div>

<div class="form-group">
<label>Pilih Makul</label>
<select class="form-control" name="id_makul">
<?php
$query = sqlsrv_query($konek, "select * from makul");
while ($data = sqlsrv_fetch_array($query)) {

?>
<option value="<?php echo $data['id_makul']?>"><?php echo $data['nama_makul']?></option>
<?php
}
?>
</select>
</div>

<div class="form-group">
<label>Pilih Ruangan</label>
<select class="form-control" name="id_ruangan">
<?php
$query = sqlsrv_query($konek, "select * from ruangan");
while ($data = sqlsrv_fetch_array($query)) {

?>
<option value="<?php echo $data['id_ruangan']?>"><?php echo $data['nama_ruangan']?></option>
<?php
}
?>
</select>
</div>

<div class="form-group">
<label>Hari</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-calendar"></i>
</div>
<select class="form-control" name="hari">
<option value="Senin">Senin</option>
<option value="Selasa">Selasa</option>
<option value="Rabu">Rabu</option>
<option value="Kamis">Kamis</option>
<option value="Jum'at">Jum'at</option>
<option value="Sabtu">Sabtu</option>
</select>
</div>
</div>

<div class="form-group">
<label>Jam Mulai</label>

<div class="input-group col-md-3">

<div class="input-group-addon">

<i class="fa fa-clock-o"></i>
</div>
<input type="text" class="form-control timepicker" name="mulai">

</div>

</div>

<div class="form-group">
<label>Jam Selesai</label>

<div class="input-group col-md-3">

<div class="input-group-addon">

<i class="fa fa-clock-o"></i>
</div>
<input type="text" class="form-control timepicker" name="selesai">

</div>
</div>

</div>
<div class="box-footer">
<button type="submit" class="btn btn-primary" name="simpan">Simpan</button>
</div>
</form>
</div>
</div>
<?php
error_reporting(0);
require_once "../koneksi.php";
if (isset($_POST['simpan'])) {

$jam = $_POST['mulai']."-".$_POST['selesai'];

$sql_insert = "UPDATE jadwal SET
id_dosen = '".$_POST['id_dosen']."',
id_makul = '".$_POST['id_makul']."',
id_ruangan = '".$_POST['id_ruangan']."',
hari = '".$_POST['hari']."',
jam = '".$jam."' where id_jadwal = '".$data['id_jadwal']."'";

$query_insert = sqlsrv_query($konek, $sql_insert) or die (sqlsrv_errors());

if ($query_insert) {

echo "<div class='alert alert-success'>
<a href='?page=jadwal' class='close' data-dismiss='alert'>×
</a>Berhasil Disimpan
</div>";
echo "<meta http-equiv='refresh'content='1; url=?page=jadwal'>";
}else{
echo "<div class='alert alert-danger'>
<a href='' class='close' data-dismiss='alert'>×
</a>Gagal Simpan !
</div>";
}
}
?>
</div>
< /div>
< /section>

Gambar 39 Form Hapus Jadwal

Implementasi SQL yang digunakan untuk menampilkan data pada form hapus jadwal adalah:

DELETE FROM jadwal WHERE id_jadwal='”.$_GET['id'].”';

Gambar 40 Laporan Data Jadwal

Sitak Php :

<!DOCTYPE html>

<html>

<head>

<title>Data Jadwal</title>

<!-- AdminLTE Skins. Choose a skin from the css/skins

folder instead of downloading all of them to reduce the load. -->

</head>

<body>

</div>

<thead>

<tr>

<th>Nama Dosen</th>

<th>Mata Kuliah</th>

<th>Ruangan</th>

</tr>

</thead>

<tbody>

<?php

require_once "../koneksi.php";

$query = sqlsrv_query($konek, "SELECT jadwal.id_jadwal, dosen.nama_dosen, makul.nama_makul, ruangan.nama_ruangan, jadwal.jam, jadwal.hari from jadwal inner join dosen on jadwal.id_dosen = dosen.id_dosen inner join makul on jadwal.id_makul=makul.id_makul inner join ruangan on jadwal.id_ruangan=ruangan.id_ruangan")or die(sqlsrv_errors());

$no = 1;

while ($data = sqlsrv_fetch_array($query))

{

<tr>

</tr>

<?php

$no ++;

}

</tbody>

</table>

</div>

</section>

window.print();

</script>

</body>

</html>

Belajar SQL Shinta Blog

Monday 19 June 2017

Tugas Akhir Pemrograman SQL

Membuat Aplikasi Sistem Informasi Akademik

1.1 Perancangan Database

1.2 Implementasi pada DBMS

APLIKASI SISTEM INFORMASI AKADEMIK UNIVERSITAS MURIA KUDUS

2.1 Implementasi SQL pada Aplikasi

2.1.1 Form Login

2.1.2 Form Dosen

2.1.3 Form Mahasiswa

2.1.4 Form Ruangan

2.1.5 Form Mata Kuliah

2.1.6 Form Jadwal

1 comment:

Blog Archive