Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if (isset($_GET['no_induk'])) {
- require_once 'db.php';
- $no_induk = $_GET['no_induk'];
- $sql = "SELECT * FROM mahasiswa WHERE no_induk='$no_induk'";
- $results = $mysqli->query($sql);
- $mhs = $results->fetch_array(MYSQLI_ASSOC);
- }
- ?>
- <!DOCTYPE>
- <html>
- <head>
- <meta charset="utf-8">
- <title>Edit Mahasiswa</title>
- <link rel="stylesheet" type="text/css" href="../../bootstrap/css/bootstrap.min.css">
- </head>
- <body>
- <div class="container">
- <h2>Edit Mahasiswa</h2>
- <form action="" method="POST" class="form-horizontal" enctype="multipart/form-data">
- <div class="form-group">
- <label for="no_induk" class="control-label col-md-2">Nomor Induk</label>
- <div class="col-md-8">
- <input type="text" name="no_induk" id="no_induk" class="form-control" placeholder="Nomor Induk Mahasiswa" value="<?= $mhs['no_induk'] ?>" readonly required>
- </div>
- </div>
- <div class="form-group">
- <label for="nama_lengkap" class="control-label col-md-2">Nama Lengkap</label>
- <div class="col-md-8">
- <input type="text" name="nama_lengkap" id="nama_lengkap" class="form-control" placeholder="Nama Lengkap" value="<?= $mhs['nama_lengkap'] ?>"required>
- </div>
- </div>
- <div class="form-group">
- <label for="tempat_lahir" class="control-label col-md-2">Tempat Lahir</label>
- <div class="col-md-8">
- <input type="text" name="tempat_lahir" id="tempat_lahir" class="form-control" placeholder="Tempat Lahir Mahasiswa" value="<?= $mhs['tempat_lahir'] ?>" required>
- </div>
- </div>
- <div class="form-group">
- <label for="tanggal_lahir" class="control-label col-md-2">Tanggal Lahir</label>
- <div class="col-md-8">
- <input type="text" name="tanggal_lahir" id="tanggal_lahir" class="form-control" placeholder="yyyy-mm-dd" value="<?= $mhs['tanggal_lahir'] ?>"required>
- </div>
- </div>
- <div class="form-group">
- <label for="agama" class="control-label col-md-2">Agama</label>
- <div class="col-md-8">
- <select class="form-control" name="agama">
- <option value="" >--PILIH AGAMA--</option>
- <option value="Islam" <?= ($mhs['agama']=="Islam") ? "selected" : ""; ?>>Islam</option>
- <option value="Protestan" <?= ($mhs['agama']=="Protestan") ? "selected" : ""; ?>>Protestan</option>
- <option value="Katolik" <?= ($mhs['agama']=="Katolik") ? "selected" : ""; ?>>Katolik</option>
- <option value="Hindu" <?= ($mhs['agama']=="Hindu") ? "selected" : ""; ?>>Hindu</option>
- <option value="Budha" <?= ($mhs['agama']=="Budha") ? "selected" : ""; ?>>Budha</option>
- <option value="Konghucu" <?= ($mhs['agama']=="Konghucu") ? "selected" : ""; ?>>Konghucu</option>
- </select>
- </div>
- </div>
- <div class="form-group">
- <label for="alamat" class="control-label col-md-2">Alamat</label>
- <div class="col-md-8">
- <textarea class="form-control" name="alamat" rows="6"><?= $mhs['alamat'] ?></textarea>
- </div>
- </div>
- <div class="form-group">
- <label for="Jurusan" class="control-label col-md-2">Jurusan</label>
- <div class="col-md-8">
- <select class="form-control" name="jurusan">
- <option value="">--PILIH JURUSAN--</option>
- <option value="Teknik Informatika" <?= ($mhs['jurusan']=="Teknik Informatika") ? "selected" : ""; ?>>Teknik Informatika</option>
- <option value="Teknik Telekomunikasi" <?= ($mhs['jurusan']=="Teknik Telekomunikasi") ? "selected" : ""; ?>>Teknik Telekomunkasi</option>
- <option value="Teknik Mekatronika (Alat Berat)" <?= ($mhs['jurusan']=="Teknik Mekatronika (Alat Berat)") ? "selected" : ""; ?>>Teknik Mekatronika (Alat Berat)</option>
- <option value="Teknik Mekatronika (Otomasi Industri)" <?= ($mhs['jurusan']=="Teknik Mekatronika (Otomasi Industri)") ? "selected" : ""; ?>>Teknik Mekatronika (Otomasi Industri)</option>
- </select>
- </div>
- </div>
- <div class="form-group">
- <label for="email" class="control-label col-md-2">Email</label>
- <div class="col-md-8">
- <input type="text" name="email" id="email" class="form-control" placeholder="Alamat Email" value="<?= $mhs['email'] ?>" required>
- </div>
- </div>
- <div class="form-group">
- <label for="foto" class="control-label col-md-2">Foto</label>
- <div class="col-md-8">
- <input type="file" name="foto" id="foto" class="form-control" value="<?= $mhs['foto'] ?>" required>
- <img src="images/<?= $mhs['foto'] ?>" width="200">
- </div>
- </div>
- <div class="col-md-offset-2">
- <button class="btn btn-primary" name="submit" value="submit" type="submit">Simpan</button>
- </div>
- </form>
- <?php
- require 'db.php';
- if (!empty($_POST)) {
- if (!empty($_FILES['foto'])) {
- $file_name = $_FILES['foto']['name'];
- $file_size = $_FILES['foto']['size'];
- $file_tmp = $_FILES['foto']['tmp_name'];
- $file_type = $_FILES['foto']['type'];
- $file_ext = pathinfo($file_name,PATHINFO_EXTENSION);
- $errors = array();
- $extension = array("jpg","jpeg","png","gif", "JPG", "JPEG", "PNG", "GIF");
- }
- if (in_array($file_ext,$extension)=== false) {
- $errors[]="File tidak di dukung";
- }
- if ($file_size > 2000000) {
- $errors[]="Ukuran terlalu besar";
- }
- if (empty($errors)===true) {
- $no_induk = $mysqli->real_escape_string($_POST['no_induk']);
- $nama_lengkap = $mysqli->real_escape_string($_POST['nama_lengkap']);
- $tempat_lahir = $mysqli->real_escape_string($_POST['tempat_lahir']);
- $tanggal_lahir = $mysqli->real_escape_string($_POST['tanggal_lahir']);
- $agama = $mysqli->real_escape_string($_POST['agama']);
- $alamat = $mysqli->real_escape_string($_POST['alamat']);
- $jurusan = $mysqli->real_escape_string($_POST['jurusan']);
- $email = $mysqli->real_escape_string($_POST['email']);
- $foto = $file_name;
- $sql = "UPDATE mahasiswa
- SET nama_lengkap='$nama_lengkap', tempat_lahir='$tempat_lahir', tanggal_lahir='$tanggal_lahir', agama='$agama', alamat='$alamat', jurusan='$jurusan', email='$email', foto='$foto'
- WHERE no_induk='$no_induk'";
- move_uploaded_file($file_tmp, "images/".$file_name);
- }else{
- foreach ($errors as $err) {
- echo $err."<br>";
- }
- }
- if ($mysqli->query($sql) === TRUE) {
- echo "Data berhasil dimasukkan"."<br>";
- header('Location: jobsheet2.php');
- }else{
- echo "Error: ".$sql."<br>".$mysqli->error;
- }
- }
- $sql = "SELECT * FROM mahasiswa";
- $results = $mysqli->query($sql);
- $mahasiswa = $results->fetch_all(MYSQLI_ASSOC);
- $mysqli->close();
- ?>
- <hr>
- <div class="container">
- <table class="table">
- <thead>
- <tr>
- <th>No</th>
- <th>Nomor Induk</th>
- <th>Nama Lengkap</th>
- <th>TTL</th>
- <th>Agama</th>
- <th>Alamat</th>
- <th>Jurusan</th>
- <th>Email</th>
- <th>Foto</th>
- <th>Edit</th>
- <th>Delete</th>
- </tr>
- </thead>
- <tbody>
- <?php $i=1; ?>
- <?php foreach ($mahasiswa as $row): ?>
- <tr>
- <td><?= $i ?></td>
- <td><?= $row['no_induk'] ?></td>
- <td><?= $row['nama_lengkap'] ?></td>
- <td><?= $row['tempat_lahir'] ?>, <?= $row['tanggal_lahir'] ?></td>
- <td><?= $row['agama'] ?></td>
- <td><?= $row['alamat'] ?></td>
- <td><?= $row['jurusan'] ?></td>
- <td><?= $row['email'] ?></td>
- <td><img src="images/<?= $row['foto'] ?>" width="200"></td>
- <td>
- <a href="edit.php?no_induk=<?= $row['no_induk'] ?>" class="btn btn-warning btn-sm">Edit</a>
- </td>
- <td>
- <a href="delete.php?no_induk=<?= $row['no_induk'] ?>" class="btn btn-danger btn-sm">Delete</a>
- </td>
- </tr>
- <?php $i++; ?>
- <?php endforeach ?>
- </tbody>
- </table>
- </div>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement