Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE>
- <html>
- <head>
- <meta charset="utf-8">
- <title>Form Mahasiswa</title>
- <link rel="stylesheet" type="text/css" href="../../bootstrap/css/bootstrap.min.css">
- </head>
- <body>
- <div class="container">
- <h2>Form 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" 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" 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" 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" 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">Islam</option>
- <option value="Protestan">Protestan</option>
- <option value="Katolik">Katolik</option>
- <option value="Hindu">Hindu</option>
- <option value="Budha">Budha</option>
- <option value="Konghucu">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"></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">Teknik Informatika</option>
- <option value="Teknik Telekomunikasi">Teknik Telekomunkasi</option>
- <option value="Teknik Mekatronika (Alat Berat)">Teknik Mekatronika (Alat Berat)</option>
- <option value="Teknik Mekatronika (Otomasi Industri)">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" 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" required>
- </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");
- }
- 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 = "INSERT INTO mahasiswa (no_induk, nama_lengkap, tempat_lahir, tanggal_lahir, agama, alamat, jurusan, email, foto)
- VALUES ('$no_induk', '$nama_lengkap', '$tempat_lahir', '$tanggal_lahir', '$agama', '$alamat', '$jurusan', '$email', '$foto')";
- 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>";
- }else{
- echo "Error: ".$sql."<br>".$mysqli->error;
- }
- }
- $sql = "SELECT * FROM mahasiswa";
- $results = $mysqli->query($sql);
- $mahasiswa = $results->fetch_all(MYSQLI_ASSOC);
- ?>
- <hr>
- <div class="container">
- <form action="" method="GET" class="form-horizontal">
- <div class="form-group">
- <div class="col-md-offset-6">
- <label for="nama_lengkap" class="control-label col-md-2">Pencarian</label>
- <div class="col-md-4">
- <input type="search" name="nama_lengkap" class="form-control">
- </div>
- <div class="col-md-2">
- <input type="submit" name="search" value="Cari" class="form-control">
- </div>
- </div>
- </div>
- <div class="form-group">
- <div class="col-md-offset-9">
- <a href="jobsheet2.php" class="btn btn-info">Refresh</a>
- </div>
- </div>
- </form>
- <?php
- if (!empty($_GET['nama_lengkap'])) {
- $nama = $mysqli->real_escape_string($_GET['nama_lengkap']);
- $sql = "SELECT * FROM mahasiswa WHERE nama_lengkap LIKE '%$nama%'";
- $results = $mysqli->query($sql);
- $rows = $results->fetch_all(MYSQLI_ASSOC);
- }
- if (!empty($_GET['search'])) {
- if (isset($results) && $results->num_rows > 0) { ?>
- <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 ($rows as $row): ?>
- <tr>
- <td><?= $i ?></td>
- <td><?= $row['no_induk'] ?></td>
- <td><?= $row['nama_lengkap'] ?></td>
- <td><?= $row['tempat_lahir'] ?>, <?= $row_search['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>
- <?php }else{
- echo "Data tidak ditemukan";
- }
- }
- ?>
- <?php if (empty($_GET['search'])): ?>
- <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>
- <?php endif ?>
- </div>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement