Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php include 'koneksi.php'; ?>
- <!DOCTYPE html>
- <html>
- <head>
- <title>Form Daftar</title>
- <link rel="stylesheet" href="style.css">
- </head>
- <body>
- <div class="container">
- <div class="row">
- <form action="index.php" method="post">
- <h2>Form Pendaftaran Mahasiswa</h2>
- <hr>
- </form>
- <div class="col-md-8 col-md-offset-2">
- <div class="panel panel-default">
- <div class="panel-heading">
- <h3 class="panel-title">Input Data Mahasiswa</h3>
- </div>
- <div class="panel-body">
- <form method="post" class="form-horizontal">
- <div class="form-group">
- <label class="control-label col-md-3">NPM</label>
- <div class="col-md-7">
- <input type="text" name="npm" class="form-control" required>
- </div>
- </div>
- <div class="form-group">
- <label class="control-label col-md-3">Nama</label>
- <div class="col-md-7">
- <input type="text" name="nama" class="form-control" required>
- </div>
- </div>
- <div class="form-group">
- <label class="control-label col-md-3">Kelas</label>
- <div class="col-md-7">
- <input type="text" name="kelas" class="form-control" required>
- </div>
- </div>
- <div class="form-group">
- <label class="control-label col-md-3">Jenis Kelamin</label>
- <div class="col-md-7">
- <td>
- <input type="radio" id="lakilaki" name="Jenis_kelamin" required=""> <label for="lakilaki">Laki - Laki</label>
- <input type="radio" id="perempuan" name="Jenis_kelamin" required=""> <label for="perempuan">Perempuan</label>
- </td>
- </div>
- </div>
- <div class="form-group">
- <label class="control-label col-md-3">Asal Kota</label>
- <div class="col-md-7">
- <td>
- <td><select name="Asal_kota" required="">
- <option value="Kota Jakarta"> Jakarta</option>
- <option value="Kota Depok">Depok</option>
- <option value="Kota Bogor">Bogor</option>
- <option value="Kota Bekasi">Bekasi</option>
- <option value="Kota Tangerang" selected>Tangerang</option>
- </select>
- </td>
- </td>
- </div>
- </div>
- <div class="form-group">
- <div class="col-md-7 col-md-offset-3">
- <button class="btn btn-primary" name="daftar">Daftar</button>
- </div>
- </div>
- </form>
- <?php
- //jika tombol daftar ditekan
- if (isset($_POST["daftar"]))
- {
- //mengambil npm,nama,kelas,jenis kelamin,asal_kota
- $npm = $_POST["npm"];
- $nama = $_POST["nama"];
- $kelas = $_POST["kelas"];
- $Jenis_kelamin = $_POST["Jenis_kelamin"];
- $Asal_kota = $_POST["Asal_kota"];
- //cek npm apakah sudah digunakan
- $ambil = $koneksi->query("SELECT * FROM biodata WHERE npm='$npm'");
- $yangcocok = $ambil->num_rows;
- if ($yangcocok==1)
- {
- echo"<script>alert('pendaftaran gagal, npm sudah digunakan')</script>";
- echo"<script>location='index.php';</script>";
- }else{
- //query insert ke data biodata
- $koneksi->query("INSERT INTO biodata(npm,nama,kelas,Jenis_kelamin,Asal_kota)
- VALUES ('$npm','$nama','$kelas','$Jenis_kelamin','$Asal_kota')");
- echo"<script>alert('pendaftaran sukses')</script>";
- echo"<script>location='index.php';</script>";
- }
- }
- ?>
- </div>
- </div>
- </div>
- </div>
- <h2>Data Mahasiswa</h2>
- <hr>
- <table class="table table-bordered">
- <thead>
- <tr>
- <th>No</th>
- <th>NPM</th>
- <th>Nama</th>
- <th>Kelas</th>
- <th>Asal Kota</th>
- </tr>
- </thead>
- <tbody>
- <?php $nomor=1; ?>
- <?php $ambil = $koneksi->query("SELECT * FROM biodata"); ?>
- <?php while($pecah = $ambil->fetch_assoc()) { ?>
- <tr>
- <td><?php echo $nomor; ?></td>
- <td><?php echo $pecah['NPM']; ?></td>
- <td><?php echo $pecah['Nama']; ?></td>
- <td><?php echo $pecah['Kelas']; ?></td>
- <td><?php echo $pecah['Asal_kota']; ?></td>
- <td>
- <a href="index.php?halaman=hapusbiodata&npm=<?php echo $pecah['NPM']; ?>" class="btn btn-danger">Hapus</a>
- </td>
- </tr>
- <?php $nomor++; ?>
- <?php } ?>
- </tbody>
- </table>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement