Technologies And Automotif: UAS Rekayasa Perangkat Lunak - Aulia Ulfah

1. Analisa Kebutuhan Data

Aplikasi ini berfungsi untuk menyimpan data nilai mahasiswa tiap matakuliah yang telah ditempuh.
Menghitung Nilai Akhir dan Grade yang diperoleh mahasiswa.
Mempermudah dalam memasukan data:

Data Fakultas
Data Program Studi
Data Matakuliah
Data Mahasiswa
Data Penilaian Mahasiswa

Perancangan Database :

1. Data Admin (Tabel: tbadmin)

Username (Field: username, text, 50, Primary Key)
Password (Field: passuser, text, 50)
Nama Lengkap (Field: Nama, text, 100)
E-mail(Field: email, text, 100)
Telepon (Field: no_tlp, text, 20)
Level User (Field: level, text, 20)
Blokir (Field: blokir, enum, 'Y', 'N')

Fungsi : Untuk membatasi hak akses pengguna yang diperbolehkan mengakses aplikasi

2. Data Fakultas (Tabel: tbfakultas)

Kode Fakultas (Field: KodeFakultas, text, 5, Primary Key)
Nama Fakultas (Field: NamaFakultas, text, 50)

3. Data Program Studi (Tabel: tbprodi)

Kode Program Studi (Field: KodeProdi, text, 5, Primary Key)
Nama Program Studi (Field: NamaProdi, text, 50)
Kode Fakultas (Field: KodeFakultas, text, 5)

4. Data Matakuliah (Tabel: tbmk)

Kode Matakuliah (Field: KodeMK, text, 5, Primary Key)
Nama Matakuliah (Field: NamaMK, text, 50)
SKS (Field: SKS, numberic, 2)
Semester (Field: Semester, numberic, 2)

5. Data Mahasiswa (Tabel: tbmahasiswa)

NIM (Field: NIM, text, 16, Primary Key)
Nama Mahasiswa (Field: NamaMahasiswa, text, 50)
Alamat Mahasiswa (Field: AlamatMahasiswa, text, 50)
Telepon Mahasiswa (Field: TlpMahasiswa, text, 50)
Kode Program Studi (Field: KodeProdi, text, 5)

6. Data Penilaian (Tabel: tbnilai)

NIM (Field: NIM, text, 16)
Kode Matakuliah (Field: KodeMK, text, 5)
Jumlah Pertemuan (Field: Pertemuan, numberic, 2)
Jumlah Kehadiran (Field: Kehadiran, numberic, 2)
Nilai Tugas (Field: NTugas, numberic, 2)
Nilai Ujian Tengah Semester (Field: NUTS, numberic, 2)
Nilai Ujian Akhir Semester (Field: NUAS, numberic, 2)
Nilai Akhir (Field: NA, numberic, 5)
Grade (Field: Grade, text, 1)

2. Perancangan Interface

http://localhost/akademik/paneladmin/index.php

<!DOCTYPE html>

<html>

<head>

<title>Ruang Administrator - Nilai Akademik</title>

jQuery(document).ready(function(){

jQuery('#login').submit(function(){

var u = jQuery('#username').val();

var p = jQuery('#password').val();

if(u == '' && p == '') {

jQuery('.login-alert').fadeIn();

return false;

}

});

</script>

</head>

<div class="alert alert-error">Username Dan Password Masih Kosong</div>

</div>

</div>

</div>

<button name="submit">LOGIN</button>

</div>

</form>

</div>

</div>

<p>2018. Aulia Ulfah. </p>

</div>

</body>

</html>

http://localhost/akademik/paneladmin/cek_login.php

<?php
include "../config/koneksi.php";
function antiinjection($data){
$filter_sql = mysql_real_escape_string(stripslashes(strip_tags(htmlspecialchars($data,ENT_QUOTES))));
return $filter_sql;
}

$username = antiinjection($_POST['username']);
$passuser = antiinjection(md5($_POST['password']));

$login=mysql_query("SELECT * FROM admins WHERE username='$username' AND passuser='$passuser' AND blokir='N'");
$ketemu=mysql_num_rows($login);
$r=mysql_fetch_array($login);

// Apabila username dan password ditemukan
if ($ketemu > 0){
session_start();

$_SESSION[namauser] = $r[username];
$_SESSION[namalengkap] = $r[nama_lengkap];
$_SESSION[passuser] = $r[password];
$_SESSION[leveluser] = $r[level];

header('location:media.php?p=home');
}
else{
echo "<script>alert('Username Atau Password Anda Salah'); window.location = 'index.php'</script>";
}
?>

http://localhost/akademik/paneladmin/home.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<?php include "../config/koneksi.php"; ?>

<head>

<title>Untitled Document</title>

</head>

<body>

<li><a href="#">Simple Admin</a> <span class="divider">></span></li>

<li class="active">Dashboard</li>

</ul>

</div>

<?php

$jmladmin=mysql_num_rows(mysql_query("select * from admins"));

</div>

<?php

$jmlfakultas=mysql_num_rows(mysql_query("select * from fakultas"));

</div>

<?php

$jmlprodi=mysql_num_rows(mysql_query("select * from prodi"));

</div>

<?php

$jmlmk=mysql_num_rows(mysql_query("select * from mk"));

</div>

<?php

$jmlmahasiswa=mysql_num_rows(mysql_query("select * from mahasiswa"));

</div>

<?php

$jmlnilai=mysql_result(mysql_query("SELECT * FROM nilai"), 0);

</div>

<?php

$sorder=mysql_query("select * from mk");

$torder=mysql_num_rows($sorder);

<h3>Matakuliah</h3>

</div>

<span><?php echo"$torder"; ?> <b>Total Matakuliah</b></span>

</div>

<?php

$aktif=mysql_query("select * from mahasiswa where status_mahasiswa='Aktif'");

$taktif=mysql_num_rows($aktif);

$cuti=mysql_query("select * from mahasiswa where status_mahasiswa='Cuti'");

$tcuti=mysql_num_rows($cuti);

$nonaktif=mysql_query("select * from mahasiswa where status_mahasiswa='Nonaktif'");

$tnonaktif=mysql_num_rows($nonaktif);

$tcus=mysql_query("select * from mahasiswa ");

$tjcus=mysql_num_rows($tcus);

<h3>Mahasiswa</h3>

</div>

<span><?php echo"$tjcus"; ?> <b>Total Mahasiswa</b></span>

<span><?php echo"$taktif"; ?> <b> Mahasiswa Aktif</b></span>

<span><?php echo"$tcuti"; ?> <b> Mahasiswa Cuti</b></span>

<span><?php echo"$tnonaktif"; ?> <b>Mahasiswa Nonaktif</b></span>

</div>

<?php

// Statistik user

$qstatistik=mysql_num_rows(mysql_query("select * from modul where nama_modul='Statistik User' and publish='Y'"));

// Apabila modul Statistik diaktifkan Publish=Y, maka tampilkan modul Statistik

//if ($qstatistik > 0){

// echo "<hr color=#e0cb91 noshade=noshade /><br />

// <img src='$f[folder]/images/statistik.jpg' /><br />";

$ip = $_SERVER['REMOTE_ADDR']; // Mendapatkan IP komputer user

$tanggal = date("Ymd"); // Mendapatkan tanggal sekarang

$waktu = time(); //

// Mencek berdasarkan IPnya, apakah user sudah pernah mengakses hari ini

$s = mysql_query("SELECT * FROM statistik WHERE ip='$ip' AND tanggal='$tanggal'");

// Kalau belum ada, simpan data user tersebut ke database

if(mysql_num_rows($s) == 0){

mysql_query("INSERT INTO statistik(ip, tanggal, hits, online) VALUES('$ip','$tanggal','1','$waktu')");

}

else{

mysql_query("UPDATE statistik SET hits=hits+1, online='$waktu' WHERE ip='$ip' AND tanggal='$tanggal'");

}

$pengunjung = mysql_num_rows(mysql_query("SELECT * FROM statistik WHERE tanggal='$tanggal' GROUP BY ip"));

$totalpengunjung = mysql_result(mysql_query("SELECT COUNT(hits) FROM statistik"), 0);

$hits = mysql_fetch_assoc(mysql_query("SELECT SUM(hits) as hitstoday FROM statistik WHERE tanggal='$tanggal' GROUP BY tanggal"));

$totalhits = mysql_result(mysql_query("SELECT SUM(hits) FROM statistik"), 0);

$tothitsgbr = mysql_result(mysql_query("SELECT SUM(hits) FROM statistik"), 0);

$bataswaktu = time() - 300;

$pengunjungonline = mysql_num_rows(mysql_query("SELECT * FROM statistik WHERE online > '$bataswaktu'"));

$path = "counter/";

$ext = ".png";

$tothitsgbr = sprintf("%06d", $tothitsgbr);

for ( $i = 0; $i <= 9; $i++ ){

$tothitsgbr = str_replace($i, "<img src='$path$i$ext' alt='$i'>", $tothitsgbr);

}

<h3>Total Penilaian</h3>

</div>

<span><?php echo"$pengunjung ";?><b>Pengunjung Hari ini</b></span>

<span><?php echo"$totalpengunjung";?> <b> TotalPengunjung</b></span>

<span><?php echo"$pengunjungonline";?> <b>Pengunjung Online</b></span>

</div>

</ul>

</div>

<h3>Fakultas</h3>

<div>

<thead>

<tr>

<th width="100">Kode Fakultas</th><th>Nama Fakultas</th>

</tr>

</thead>

<tbody>

<?php

$tampilfakultas=mysql_query("select * from fakultas order by kode_fakultas ASC limit 3");

while($fakultas=mysql_fetch_array($tampilfakultas))

{

echo"<tr>

<td><span class='date'>$fakultas[kode_fakultas]</span>

<td><a href='#'>$fakultas[nama_fakultas]</a></td>

</tr>";

}

</tbody>

<tfoot>

<tr>

</tr>

</tfoot>

</table>

</div>

<h3>Order</h3>

<div>

<thead>

<tr>

<th width="60">Tanggal</th><th>Nama Kustomer</th><th width="60">Total</th>

</tr>

</thead>

<tbody>

<?php

$tampilorder=mysql_query("select * from orders order by id_orders ASC limit 3");

while($order=mysql_fetch_array($tampilorder))

{

echo "<tr>

<td><span class='date'>$order[tgl_order]</span><span class='time'>$order[jam_order]</span></td>";

$tampilkustomer=mysql_query("select * from kustomer order by id_kustomer='$order[id_kustomer]' ASC limit 3");

$kustomer=mysql_fetch_array($tampilkustomer);

echo"<td><a href='#'>$kustomer[nama_lengkap]</a></td>";

echo"<td><span class='price'>$order[status_order]</span></td>";

echo"</tr>";

}

<tfoot>

<tr>

</tr>

</tfoot>

</table>

</div>

<div>

<thead>

<tr>

<th width="60">Paket</th><th>Nama Kota</th><th width="60">Ongkir</th>

</tr>

</thead>

<tbody>

<?php

$tampilkota=mysql_query("select * from kota limit 3");

while($kota=mysql_fetch_array($tampilkota))

{

$tampilshop=mysql_query("select * from shop_pengiriman where id_perusahaan='$kota[id_perusahaan]'");

$shop=mysql_fetch_array($tampilshop);

echo"<tr>

<td><span class='date'>$shop[nama_perusahaan]</span></td>

<td><span class='price'>$kota[ongkos_kirim]</span></td>

</tr>";

}

</tbody>

<tfoot>

<tr>

</tr>

</tfoot>

</table>

</div>

<h1>Sekilas Info</h1>

</ul>

</div>

<?php

$tampilsekilas=mysql_query("select * from sekilasinfo");

while($sekilas=mysql_fetch_array($tampilsekilas))

{

echo"<div class='item'>

<p>$sekilas[info]</p>

<span class='date'>$sekilas[tgl_posting]</span>

</div>

</div>";

}

</div>

<h1>Kustomer</h1>

</ul>

</div>

<?php

$tampilcus=mysql_query("select * from kustomer");

while($customer=mysql_fetch_array($tampilcus))

{

echo"<div class='item clearfix'>

<a href='#' class='name'>$customer[nama_lengkap]</a>

<div class='controls'>";

if ($customer[aktif]=="Y")

{

echo"<a href='#' class='icon-ok'></a>";

}

else

{

echo"<a href='#' class='icon-remove'></a>";

}

echo"</div>

</div>

</div>";

}

</div>

<h1>Komentar</h1>

</ul>

</div>

<?php

$tampilpesan=mysql_query("select * from komentar");

while ($pesan=mysql_fetch_array($tampilpesan))

{

$tgl=tgl_indo($pesan[tgl]);

echo"<div class='itemIn'>

<span class='name'>$pesan[nama_komentar]</span>

<span class='date'>$tgl--$pesan[jam_komentar]</span>

</div>

$pesan[isi_komentar]

</div>

</div>";

}

</div>

<h1>Calendar</h1>

</div>

</div>

</div>

</body>

</html>

Technologies And Automotif

Search This Blog

19 November 2018

UAS Rekayasa Perangkat Lunak - Aulia Ulfah - Aplikasi Nilai Mahasiswa

1. Analisa Kebutuhan Data

Perancangan Database :

2. Perancangan Interface

http://localhost/akademik/paneladmin/index.php

http://localhost/akademik/paneladmin/cek_login.php

http://localhost/akademik/paneladmin/home.php

http://localhost/akademik/paneladmin/menu.php

http://localhost/akademik/paneladmin/modul/fakultas/fakultas.php

http://localhost/akademik/paneladmin/modul/fakultas/aksi_fakultas.php

http://localhost/akademik/paneladmin/modul/prodi/prodi.php

http://localhost/akademik/paneladmin/modul/prodi/aksi_prodi.php

http://localhost/akademik/paneladmin/modul/mk/mk.php

http://localhost/akademik/paneladmin/modul/mk/aksi_mk.php

http://localhost/akademik/paneladmin/modul/mahasiswa/mahasiswa.php

http://localhost/akademik/paneladmin/modul/mahasiswa/aksi_mahasiswa.php

http://localhost/akademik/paneladmin/modul/nilai/nilai.php

http://localhost/akademik/paneladmin/modul/nilai/aksi_nilai.php

No comments:

Tokopedia | Arberry

Popular posts

Google Maps: Ar Berry Frozen