Tugas kali ini membuat website yang mengimplementasikan PHP atau PHP: Hypertext Preprocessor. PHP merupakan bahasa script server-side karena diproses pada komputer server. PHP sering digunakan untuk pembuatan dan pengembangan website agar memiliki kemampuan untuk memproses data dengan dinamis. Di sini terdapat aplikasi CRUD (Create, Read, Update, Delete) sederhana, yaitu pendaftaran mahasiswa baru pada Institut Teknologi Sepuluh Nopember Surabaya. Dalam proses pengerjaannya, menggunakan HTML, CSS (Bootstrap), dan SQL. Laman website-nya dapat diakses pada link berikut. Untuk hosting web sendiri memakai 000webhost.
Konten dari website:
- Main page, berisi halaman depan yang memuat menu dan nantinya digunakan untuk proses CRUD.
- Form daftar page, berisi halaman formulir pendaftaran mahasiswa baru. Ada beberapa hal mesti diinputkan ke dalam formulir seperti nama, alamat, jenis kelamin, agama, asal sekolah, dan departemen pilihan.
- List mahasiswa page, berisi halaman daftar mahasiswa baru yang sudah mendaftar. Halaman ini menyajikan data dalam bentuk tabel. Di halaman ini juga dapat dilakukan proses Edit dan Delete suatu data.
- Form edit page, berisi halaman edit data pendaftaran mahasiswa baru.
Tampilan Website
- config.php
- form-daftar.php
- form-edit.php
- hapus.php
- index.php
- list-mahasiswa.php
- proses-edit.php
- proses-pendaftaran.php
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
$server = "localhost"; | |
$user = "root"; | |
$password = ""; | |
$database = "pendaftaran_mahasiswa"; | |
$db = mysqli_connect($server, $user, $password, $database); | |
if (!$db) { | |
die("Gagal terhubung dengan database: " . mysqli_connect_error()); | |
} | |
?> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!DOCTYPE html> | |
<html lang="en"> | |
<head> | |
<meta charset="UTF-8"> | |
<meta http-equiv="X-UA-Compatible" content="IE=edge"> | |
<meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous"> | |
<link rel="icon" type="image/png" href="https://img.icons8.com/color/48/000000/source-code.png"> | |
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script> | |
<title>Formulir Pendaftaran Mahasiswa Baru | ITS Surabaya</title> | |
<style> | |
.back { | |
width: 100px; | |
margin: 20px 20px 0 20px; | |
transition-duration: 0.4s; | |
} | |
.submit { | |
width: 80px; | |
margin-top: 10px; | |
font-size: 17px; | |
} | |
textarea { | |
resize: none; | |
} | |
</style> | |
</head> | |
<body> | |
<button class="btn btn-info back" onclick="window.location.href='./'">Back</button> | |
<div class="container mb-5"> | |
<h2 align="center" style="margin: 30px 10px 10px 10px;">Formulir Pendaftaran Mahasiswa Baru</h2> <hr /> | |
<form action="proses-pendaftaran.php" method="POST"> | |
<div class="row"> | |
<div class="col-sm-12"> | |
<div class="form-group"> | |
<label class="font-weight-bold">Nama</label> | |
<input class="form-control" type="text" name="nama" placeholder="Masukkan nama lengkap" required> | |
</div> | |
<div class="form-group"> | |
<label class="font-weight-bold">Alamat</label> | |
<textarea class="form-control" name="alamat" id="alamat" rows="3" placeholder="Masukkan alamat" required></textarea> | |
</div> | |
<div class="form-group"> | |
<label class="font-weight-bold">Jenis Kelamin</label> | |
<div class="form-check"> | |
<input class="form-check-input" type="radio" name="jenis_kelamin" id="jenis_kelamin" value="Laki-laki" checked> | |
<label class="form-check-label" for="jenis_kelamin"> | |
Laki-laki | |
</label> | |
</div> | |
<div class="form-check"> | |
<input class="form-check-input" type="radio" name="jenis_kelamin" id="jenis_kelamin" value="Perempuan"> | |
<label class="form-check-label" for="jenis_kelamin"> | |
Perempuan | |
</label> | |
</div> | |
</div> | |
<div class="form-group"> | |
<label class="font-weight-bold">Agama</label> | |
<select class="form-control" name="agama" id="agama"> | |
<option disabled selected>Pilih agama</option> | |
<option>Islam</option> | |
<option>Kristen Katolik</option> | |
<option>Kristen Protestan</option> | |
<option>Hindu</option> | |
<option>Buddha</option> | |
<option>Kong Hu Cu</option> | |
</select> | |
</div> | |
<div class="form-group"> | |
<label class="font-weight-bold">Sekolah Asal</label> | |
<input class="form-control" type="text" name="sekolah_asal" placeholder="Masukkan sekolah asal" required> | |
</div> | |
<div class="form-group"> | |
<label class="font-weight-bold">Departemen</label> | |
<select name="departemen" id="departemen" class="form-control"> | |
<option selected disabled>Pilih Jurusan</option> | |
<option>Fisika</option> | |
<option>Matematika</option> | |
<option>Statistika</option> | |
<option>Kimia</option> | |
<option>Biologi</option> | |
<option>Aktuaria</option> | |
<option>Teknik Perkapalan</option> | |
<option>Teknik Sistem Perkapalan</option> | |
<option>Teknik Kelautan</option> | |
<option>Teknik Transportasi Laut</option> | |
<option>Teknik Mesin</option> | |
<option>Teknik Kimia</option> | |
<option>Teknik Fisika</option> | |
<option>Teknik Sistem dan Industri</option> | |
<option>Teknik Material</option> | |
<option>Teknik Elektro</option> | |
<option>Teknik Biomedik</option> | |
<option>Teknik Komputer</option> | |
<option>Teknik Informatika</option> | |
<option>Sistem Informasi</option> | |
<option>Teknologi Informasi</option> | |
<option>Teknik Sipil</option> | |
<option>Arsitektur</option> | |
<option>Teknik Lingkungan</option> | |
<option>Perencanaan Wilayah dan Kota</option> | |
<option>Teknik Geomatika</option> | |
<option>Teknik Geofisika</option> | |
<option>Desain Produk Industri</option> | |
<option>Desain Interior</option> | |
<option>Desain Komunikasi Visual</option>/ | |
<option>Manajemen Bisnis</option> | |
<option>Studi Pembangunan</option> | |
<option>Manajemen Teknologi</option> | |
</select> | |
</div> | |
<button class="btn btn-success submit" type="submit" name="daftar" value="daftar">Daftar</button> | |
</div> | |
</div> | |
</form> | |
</div> | |
</body> | |
</html> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
include("config.php"); | |
if (!isset($_GET['id'])) { | |
header('Location: list-mahasiswa.php'); | |
} | |
$id = $_GET['id']; | |
$sql = "SELECT * FROM calon_mahasiswa WHERE id=$id"; | |
$query = mysqli_query($db, $sql); | |
$mahasiswa = mysqli_fetch_assoc($query); | |
if (mysqli_num_rows($query) < 1) { | |
die("Data tidak ditemukan."); | |
} | |
?> | |
<!DOCTYPE html> | |
<html lang="en"> | |
<head> | |
<meta charset="UTF-8"> | |
<meta http-equiv="X-UA-Compatible" content="IE=edge"> | |
<meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous"> | |
<link rel="icon" type="image/png" href="https://img.icons8.com/color/48/000000/source-code.png"> | |
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script> | |
<title>Formulir Edit Mahasiswa | ITS Surabaya</title> | |
<style> | |
.back { | |
width: 100px; | |
margin: 20px 20px 0 20px; | |
transition-duration: 0.4s; | |
} | |
.submit { | |
width: 80px; | |
margin-top: 10px; | |
font-size: 17px; | |
} | |
textarea { | |
resize: none; | |
} | |
</style> | |
</head> | |
<body> | |
<button class="btn btn-info back" onclick="window.location.href='./list-mahasiswa.php'">Back</button> | |
<div class="container mb-5"> | |
<h2 align="center" style="margin: 30px 10px 10px 10px;">Formulir Pendaftaran Mahasiswa Baru</h2> <hr /> | |
<form action="proses-edit.php" method="POST"> | |
<div class="row"> | |
<div class="col-sm-12"> | |
<input type="hidden" name="id" value="<?php echo $mahasiswa['id'] ?>"> | |
<div class="form-group"> | |
<label class="font-weight-bold">Nama</label> | |
<input class="form-control" type="text" name="nama" placeholder="Masukkan nama lengkap" value="<?php echo $mahasiswa['nama'] ?>" required> | |
</div> | |
<div class="form-group"> | |
<label class="font-weight-bold">Alamat</label> | |
<textarea class="form-control" name="alamat" id="alamat" rows="3" placeholder="Masukkan alamat" required><?php echo $mahasiswa['alamat'] ?></textarea> | |
</div> | |
<div class="form-group"> | |
<label class="font-weight-bold">Jenis Kelamin</label> | |
<div class="form-check"> | |
<?php $gender = $mahasiswa['jenis_kelamin']; ?> | |
<input class="form-check-input" type="radio" name="jenis_kelamin" id="jenis_kelamin" value="Laki-laki" <?php echo ($gender == 'Laki-laki') ? "checked": "" ?>> | |
<label class="form-check-label" for="jenis_kelamin"> | |
Laki-laki | |
</label> | |
</div> | |
<div class="form-check"> | |
<input class="form-check-input" type="radio" name="jenis_kelamin" id="jenis_kelamin" value="Perempuan" <?php echo ($gender == 'Perempuan') ? "checked": "" ?>> | |
<label class="form-check-label" for="jenis_kelamin"> | |
Perempuan | |
</label> | |
</div> | |
</div> | |
<div class="form-group"> | |
<?php $agama = $mahasiswa['agama']; ?> | |
<label class="font-weight-bold">Agama</label> | |
<select class="form-control" name="agama" id="agama"> | |
<option disabled>Pilih agama</option> | |
<option <?php echo ($agama == 'Islam') ? "selected": "" ?>>Islam</option> | |
<option <?php echo ($agama == 'Kristen Katolik') ? "selected": "" ?>>Kristen Katolik</option> | |
<option <?php echo ($agama == 'Kristen Protestan') ? "selected": "" ?>>Kristen Protestan</option> | |
<option <?php echo ($agama == 'Hindu') ? "selected": "" ?>>Hindu</option> | |
<option <?php echo ($agama == 'Buddha') ? "selected": "" ?>>Buddha</option> | |
<option <?php echo ($agama == 'Kong Hu Cu') ? "selected": "" ?>>Kong Hu Cu</option> | |
</select> | |
</div> | |
<div class="form-group"> | |
<label class="font-weight-bold">Sekolah Asal</label> | |
<input class="form-control" type="text" name="sekolah_asal" placeholder="Masukkan sekolah asal" value="<?php echo $mahasiswa['sekolah_asal'] ?>" required> | |
</div> | |
<div class="form-group"> | |
<?php $jurusan = $mahasiswa['departemen']; ?> | |
<label class="font-weight-bold">Departemen</label> | |
<select name="departemen" id="departemen" class="form-control"> | |
<option disabled>Pilih Jurusan</option> | |
<option <?php echo ($jurusan == 'Fisika') ? "selected": "" ?>>Fisika</option> | |
<option <?php echo ($jurusan == 'Matematika') ? "selected": "" ?>>Matematika</option> | |
<option <?php echo ($jurusan == 'Statistika') ? "selected": "" ?>>Statistika</option> | |
<option <?php echo ($jurusan == 'Kimia') ? "selected": "" ?>>Kimia</option> | |
<option <?php echo ($jurusan == 'Biologi') ? "selected": "" ?>>Biologi</option> | |
<option <?php echo ($jurusan == 'Aktuaria') ? "selected": "" ?>>Aktuaria</option> | |
<option <?php echo ($jurusan == 'Teknik Perkapalan') ? "selected": "" ?>>Teknik Perkapalan</option> | |
<option <?php echo ($jurusan == 'Teknik Sistem Perkapalan') ? "selected": "" ?>>Teknik Sistem Perkapalan</option> | |
<option <?php echo ($jurusan == 'Teknik Kelautan') ? "selected": "" ?>>Teknik Kelautan</option> | |
<option <?php echo ($jurusan == 'Teknik Transportasi Laut') ? "selected": "" ?>>Teknik Transportasi Laut</option> | |
<option <?php echo ($jurusan == 'Teknik Mesin') ? "selected": "" ?>>Teknik Mesin</option> | |
<option <?php echo ($jurusan == 'Teknik Kimia') ? "selected": "" ?>>Teknik Kimia</option> | |
<option <?php echo ($jurusan == 'Teknik Fisika') ? "selected": "" ?>>Teknik Fisika</option> | |
<option <?php echo ($jurusan == 'Teknik Sistem dan Industri') ? "selected": ""?>>Teknik Sistem dan Industri</option> | |
<option <?php echo ($jurusan == 'Teknik Material') ? "selected": "" ?>>Teknik Material</option> | |
<option <?php echo ($jurusan == 'Teknik Elektro') ? "selected": "" ?>>Teknik Elektro</option> | |
<option <?php echo ($jurusan == 'Teknik Biomedik') ? "selected": "" ?>>Teknik Biomedik</option> | |
<option <?php echo ($jurusan == 'Teknik Komputer') ? "selected": "" ?>>Teknik Komputer</option> | |
<option <?php echo ($jurusan == 'Teknik Informatika') ? "selected": "" ?>>Teknik Informatika</option> | |
<option <?php echo ($jurusan == 'Sistem Informasi') ? "selected": "" ?>>Sistem Informasi</option> | |
<option <?php echo ($jurusan == 'Teknologi Informasi') ? "selected": "" ?>>Teknologi Informasi</option> | |
<option <?php echo ($jurusan == 'Teknik Sipil') ? "selected": "" ?>>Teknik Sipil</option> | |
<option <?php echo ($jurusan == 'Arsitektur') ? "selected": "" ?>>Arsitektur</option> | |
<option <?php echo ($jurusan == 'Teknik Lingkungan') ? "selected": "" ?>>Teknik Lingkungan</option> | |
<option <?php echo ($jurusan == 'Perencanaan Wilayah dan Kota') ? "selected": "" ?>>Perencanaan Wilayah dan Kota</option> | |
<option <?php echo ($jurusan == 'Teknik Geomatika') ? "selected": "" ?>>Teknik Geomatika</option> | |
<option <?php echo ($jurusan == 'Teknik Geofisika') ? "selected": "" ?>>Teknik Geofisika</option> | |
<option <?php echo ($jurusan == 'Desain Produk Industri') ? "selected": "" ?>>Desain Produk Industri</option> | |
<option <?php echo ($jurusan == 'Desain Interior') ? "selected": "" ?>>Desain Interior</option> | |
<option <?php echo ($jurusan == 'Desain Komunikasi Visual') ? "selected": "" ?>>Desain Komunikasi Visual</option>/ | |
<option <?php echo ($jurusan == 'Manajemen Bisnis') ? "selected": "" ?>>Manajemen Bisnis</option> | |
<option <?php echo ($jurusan == 'Studi Pembangunan') ? "selected": "" ?>>Studi Pembangunan</option> | |
<option <?php echo ($jurusan == 'Manajemen Teknologi') ? "selected": "" ?>>Manajemen Teknologi</option> | |
</select> | |
</div> | |
<button class="btn btn-success submit" type="submit" name="simpan" value="simpan">Simpan</button> | |
</div> | |
</div> | |
</form> | |
</div> | |
</body> | |
</html> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
include("config.php"); | |
if (isset($_GET['id'])) { | |
$id = $_GET['id']; | |
$sql = "DELETE FROM calon_mahasiswa WHERE id=$id"; | |
$query = mysqli_query($db, $sql); | |
if ($query) { | |
header('Location: list-mahasiswa.php'); | |
} | |
else { | |
die("Gagal menghapus."); | |
} | |
} | |
else { | |
die("Akses dilarang!"); | |
} | |
?> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!DOCTYPE html> | |
<html lang="en"> | |
<head> | |
<meta charset="UTF-8"> | |
<meta http-equiv="X-UA-Compatible" content="IE=edge"> | |
<meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
<link href='https://fonts.googleapis.com/css?family=Poppins' rel='stylesheet'> | |
<link rel="icon" type="image/png" href="https://img.icons8.com/color/48/000000/source-code.png"> | |
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous"> | |
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script> | |
<title>Pendaftaran Mahasiswa Baru | ITS Surabaya</title> | |
<style> | |
body { | |
font-family: 'Poppins'; | |
text-align: center; | |
justify-content: center; | |
background-image: url('its.jpg'); | |
background-repeat: no-repeat; | |
background-attachment: fixed; | |
background-size: cover; | |
} | |
h1 { | |
font-size: 42px; | |
margin-bottom: 20px; | |
color: white; | |
font-weight: bold; | |
} | |
h3 { | |
font-size: 25px; | |
margin-bottom: 15px; | |
color: white; | |
font-weight: bold; | |
} | |
button { | |
margin-left: 10px; | |
margin-right: 10px; | |
transition-duration: 0.4s; | |
} | |
.container { | |
top: 50%; | |
left: 50%; | |
position: absolute; | |
-moz-transform: translateX(-50%) translateY(-50%); | |
-webkit-transform: translateX(-50%) translateY(-50%); | |
transform: translateX(-50%) translateY(-50%); | |
-webkit-animation: fadein 1.5s; | |
-moz-animation: fadein 1.5s; | |
animation: fadein 1.5s; | |
} | |
@keyframes fadein { | |
from { opacity: 0; } | |
to { opacity: 1; } | |
} | |
@-moz-keyframes fadein { | |
from { opacity: 0; } | |
to { opacity: 1; } | |
} | |
</style> | |
</head> | |
<body> | |
<div class="container"> | |
<h1>Pendaftaran Mahasiswa Baru</h1> | |
<h3>Institut Teknologi Sepuluh Nopember Surabaya</h3> | |
<img src="logo.png" alt="Logo ITS" width="200px" style="margin-bottom: 35px"> | |
<center> | |
<button class="btn btn-info" onclick="window.location.href='./form-daftar.php'">Daftar Baru</button> | |
<button class="btn btn-info" onclick="window.location.href='./list-mahasiswa.php'">Pendaftar</button> | |
</center> | |
</div> | |
</body> | |
</html> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php include("config.php"); ?> | |
<!DOCTYPE html> | |
<html lang="en"> | |
<head> | |
<meta charset="UTF-8"> | |
<meta http-equiv="X-UA-Compatible" content="IE=edge"> | |
<meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous"> | |
<link rel="icon" type="image/png" href="https://img.icons8.com/color/48/000000/source-code.png"> | |
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script> | |
<title>Pendaftaran Mahasiswa Baru | ITS Surabaya</title> | |
<style> | |
.back { | |
width: 100px; | |
margin: 20px 20px 0 20px; | |
transition-duration: 0.4s; | |
} | |
a, a:link, a:visited, a:hover, a:active { | |
text-decoration: none; | |
} | |
</style> | |
</head> | |
<body> | |
<button class="btn btn-info back" onclick="window.location.href='./'">Back</button> | |
<div class="container mb-5"> | |
<h2 align="center" style="margin: 30px 10px 10px 10px;">Mahasiswa yang Sudah Mendaftar</h2> <hr /> | |
<table class="table table-hover table-striped"> | |
<thead> | |
<tr> | |
<th scope="col">No.</th> | |
<th scope="col">Nama</th> | |
<th scope="col">Alamat</th> | |
<th scope="col">Jenis Kelamin</th> | |
<th scope="col">Agama</th> | |
<th scope="col">Sekolah Asal</th> | |
<th scope="col">Jurusan</th> | |
<th scope="col">Tindakan</th> | |
</tr> | |
</thead> | |
<tbody> | |
<?php | |
$sql = "SELECT * FROM calon_mahasiswa"; | |
$query = mysqli_query($db, $sql); | |
while ($mahasiswa = mysqli_fetch_array($query)) { | |
echo "<tr>"; | |
echo "<td>".$mahasiswa['id']."</td>"; | |
echo "<td>".$mahasiswa['nama']."</td>"; | |
echo "<td>".$mahasiswa['alamat']."</td>"; | |
echo "<td>".$mahasiswa['jenis_kelamin']."</td>"; | |
echo "<td>".$mahasiswa['agama']."</td>"; | |
echo "<td>".$mahasiswa['sekolah_asal']."</td>"; | |
echo "<td>".$mahasiswa['departemen']."</td>"; | |
echo "<td>"; | |
echo "<button class='btn btn-warning' style='margin-bottom: 5px' onclick=window.location.href='form-edit.php?id=".$mahasiswa['id']."'>Edit</button>"; | |
echo "<br />"; | |
echo "<button class='btn btn-danger' onclick=window.location.href='hapus.php?id=".$mahasiswa['id']."'>Hapus</button>"; | |
echo "</td>"; | |
echo "</tr>"; | |
} | |
?> | |
</tbody> | |
</table> | |
<h5>Total: <?php echo mysqli_num_rows($query) ?></h5> | |
</div> | |
</body> | |
</html> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
include("config.php"); | |
if (isset($_POST['simpan'])) { | |
$id = $_POST['id']; | |
$nama = $_POST['nama']; | |
$alamat = $_POST['alamat']; | |
$gender = $_POST['jenis_kelamin']; | |
$agama = $_POST['agama']; | |
$sekolah = $_POST['sekolah_asal']; | |
$jurusan = $_POST['departemen']; | |
$sql = "UPDATE calon_mahasiswa SET nama='$nama', alamat='$alamat', jenis_kelamin='$gender', agama='$agama', sekolah_asal='$sekolah', departemen='$jurusan' WHERE id=$id"; | |
$query = mysqli_query($db, $sql); | |
if ($query) { | |
?> <script> | |
alert("Data telah disimpan."); | |
window.location.href='./list-mahasiswa.php'; | |
</script> <?php | |
} | |
else { | |
die("Gagal menyimpan."); | |
} | |
} | |
else { | |
die("Akses dilarang!"); | |
} | |
?> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
include("config.php"); | |
if (isset($_POST['daftar'])) { | |
$nama = $_POST['nama']; | |
$alamat = $_POST['alamat']; | |
$gender = $_POST['jenis_kelamin']; | |
$agama = $_POST['agama']; | |
$sekolah = $_POST['sekolah_asal']; | |
$jurusan = $_POST['departemen']; | |
$sql = "INSERT INTO calon_mahasiswa (nama, alamat, jenis_kelamin, agama, sekolah_asal, departemen) VALUE ('$nama', '$alamat', '$gender', '$agama', '$sekolah', '$jurusan')"; | |
$query = mysqli_query($db, $sql); | |
if ($query) { | |
?> <script> | |
alert("Data telah disimpan."); | |
window.location.href='./index.php?status=sukses'; | |
</script> <?php | |
} | |
else { | |
?> <script> | |
alert("Data gagal disimpan."); | |
window.location.href='./index.php?status=gagal'; | |
</script> <?php | |
} | |
} | |
else { | |
die("Akses dilarang!"); | |
} | |
?> |
Komentar
Posting Komentar