Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include("header.php");
- include("koneksi.php");
- ?>
- <div class="container">
- <div class="content">
- <h2>Data Mahasiswa » Tambah Data</h2>
- <hr />
- <?php
- include("koneksi.php");
- if (isset($_POST['add'])) {
- $nopeserta = addslashes($_POST['nopeserta']);
- $nama = addslashes($_POST['nama']);
- $tmp_lahir = addslashes($_POST['tmp_lahir']);
- $desa = addslashes($_POST['desa']);
- $kecamatan = addslashes($_POST['kecamatan']);
- $kabupaten = addslashes($_POST['kabupaten']);
- $tgl = addslashes($_POST['tgl']);
- $kelamin = addslashes($_POST['kelamin']);
- $fakultas = addslashes($_POST['fakultas']);
- $jurusan = addslashes($_POST['jurusan']);
- $noinduk = addslashes($_POST['noinduk']);
- $ayah = addslashes($_POST['ayah']);
- $jobayh = addslashes($_POST['jobayh']);
- $alamata = addslashes($_POST['alamata']);
- $ibu = addslashes($_POST['ibu']);
- $jobibu = addslashes($_POST['jobibu']);
- $alamati = addslashes($_POST['alamati']);
- $ipk = addslashes($_POST['ipk']);
- $pnddkanakhir = addslashes($_POST['pnddkanakhir']);
- $status = addslashes($_POST['status']);
- $keterampilan = addslashes($_POST['keterampilan']);
- $organisasi = addslashes($_POST['organisasi']);
- $almatbna = addslashes($_POST['almatbna']);
- $hp = addslashes($_POST['hp']);
- $ukranjket = addslashes($_POST['ukranjket']);
- $penyakit = addslashes($_POST['penyakit']);
- $folder = './img/';
- $name_p = $_FILES['foto']['name'];
- $sumber_p = $_FILES['foto']['tmp_name'];
- $foto = $name_p;
- move_uploaded_file($sumber_p, $folder . $name_p);
- $sql = "SELECT * FROM mahasiswa WHERE nopeserta='$nopeserta'";
- $query = mysqli_query($koneksi, $sql)or
- die(mysqli_error($koneksi) . $sql);
- $sql = "INSERT INTO mahasiswa(nopeserta, nama, tmp_lahir, desa, kecamatan, kabupaten, tgl, kelamin, "
- . "fakultas, jurusan, noinduk, ayah, jobayh, alamata, ibu, jobibu, alamati, ipk, pnddkanakhir, "
- . "status, keterampilan, organisasi, almatbna, hp, ukranjket, penyakit, foto)"
- . " VALUES('$nopeserta','$nama', '$tmp_lahir', '$desa', "
- . "'$kecamatan', '$kabupaten', '$tgl', '$kelamin', '$fakultas', "
- . "'$jurusan', '$noinduk', '$ayah', '$jobayh', '$alamata', '$ibu', "
- . "'$jobibu', '$alamati', '$ipk', '$pnddkanakhir', '$status', '$keterampilan', "
- . "'$organisasi', '$almatbna', '$hp', '$ukranjket', '$penyakit','$foto')";
- //die($sql);
- if (mysqli_num_rows($query) == 0) {
- if (TRUE) {
- $sql = "INSERT INTO mahasiswa"
- . "(nopeserta, nama, tmp_lahir, desa, kecamatan, "
- . "kabupaten, tgl, kelamin, fakultas, jurusan, "
- . "noinduk, ayah, jobayh, alamata, ibu, "
- . "jobibu, alamati, ipk, pnddkanakhir, status, "
- . "keterampilan, organisasi, almatbna, hp, ukranjket, "
- . "penyakit, foto)"
- . " VALUES"
- . "('$nopeserta','$nama', '$tmp_lahir', '$desa', '$kecamatan', "
- . "'$kabupaten', '$tgl', '$kelamin', '$fakultas', '$jurusan', "
- . "'$noinduk', '$ayah', '$jobayh', '$alamata', '$ibu',"
- . " '$jobibu', '$alamati', '$ipk', '$pnddkanakhir', '$status', "
- . "'$keterampilan', '$organisasi', '$almatbna', '$hp', '$ukranjket', "
- . "'$penyakit','$foto')"
- ;
- $insert = mysqli_query($koneksi, $sql) or
- die(mysqli_error($koneksi) . $sql);
- if ($insert) {
- echo '<div class="alert alert-success alert-dismissable">'
- . '<button type="button" class="close" data-dismiss="alert" '
- . 'aria-hidden="true">×</button>Data Mahasiswa '
- . 'Berhasil Di Simpan. <a href="data.php"><- Kembali</a></div>';
- } else {
- echo '<div class="alert alert-danger alert-dismissable"><button '
- . 'type="button" class="close" data-dismiss="alert" '
- . 'aria-hidden="true">×</button>Ups, Data '
- . 'Mahasiswa Gagal Di simpan! <a href="data.php"><- Kembali</a></div>';
- }
- } else { // mengecek jika password yang diinput tidak sama
- echo '<div class="alert alert-danger alert-dismissable">'
- . '<button type="button" class="close" data-dismiss="alert" '
- . 'aria-hidden="true">×</button>Password Tidak sama!</div>';
- // maka tampilkan 'Password Tidak sama!'
- }
- } else { // mengecek jika nim yang akan ditambahkan sudah ada dalam database
- echo '<div class="alert alert-danger alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>NIM Sudah Ada..! <a href="data.php"><- Kembali</a></div>'; // maka tampilkan 'nim Sudah Ada..!'
- }
- } else {
- }
- ?>
- <form class="form-horizontal" action="" method="post" enctype="multipart/form-data">
- <div class="form-group">
- <label class="col-sm-3 control-label">Nomor Peserta</label>
- <div class="col-sm-4">
- <input type="text" name="nopeserta" class="form-control" placeholder="Nomor Peserta" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Nama Mahasiswa</label>
- <div class="col-sm-4">
- <input type="text" name="nama" class="form-control" placeholder="Nama Mahasiswa" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Tempat Lahir</label>
- <div class="col-sm-4">
- <input type="text" name="tmp_lahir" class="form-control" placeholder="Tempat Lahir" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Desa</label>
- <div class="col-sm-4">
- <input type="text" name="desa" class="form-control" placeholder="Desa" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Kecamatan</label>
- <div class="col-sm-4">
- <input type="text" name="kecamatan" class="form-control" placeholder="Kecamatan" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Kabupaten</label>
- <div class="col-sm-4">
- <input type="text" name="kabupaten" class="form-control" placeholder="Kabupaten" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Tanggal Lahir</label>
- <div class="col-sm-4">
- <input type="date" name="tgl" class="form-control" placeholder="Tanggal Lahir" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Jenis Kelamin</label>
- <div class="col-sm-2">
- <input type="radio" name="kelamin" value="laki-laki">Laki-Laki
- <input type="radio" name="kelamin" value="perempuan">Perempuan
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Fakultas</label>
- <div class="col-sm-4">
- <input type="text" name="fakultas" class="form-control" placeholder="Fakultas" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Jurusa</label>
- <div class="col-sm-4">
- <input type="text" name="jurusan" class="form-control" placeholder="Jurusa" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Nomor Induk Mahasiswa</label>
- <div class="col-sm-3">
- <input type="text" name="noinduk" class="form-control" placeholder="Nomor Induk Mahasiswa" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Nama Ayah</label>
- <div class="col-sm-3">
- <input type="text" name="ayah" class="form-control" placeholder="Nama Ayah" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Pekerjaan Ayah</label>
- <div class="col-sm-3">
- <input type="text" name="jobayh" class="form-control" placeholder="Pekerjaan Ayah" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Alamat Ayah</label>
- <div class="col-sm-3">
- <input type="text" name="alamata" class="form-control" placeholder="Alamat Ayah" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Nama ibu</label>
- <div class="col-sm-3">
- <input type="text" name="ibu" class="form-control" placeholder="Nama ibu" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Pekerjaan Ibu</label>
- <div class="col-sm-3">
- <input type="text" name="jobibu" class="form-control" placeholder="Pekerjaan Ibu" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Alamat Ibu</label>
- <div class="col-sm-3">
- <input type="text" name="alamati" class="form-control" placeholder="Alamat Ibu" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">IPK Terakhir</label>
- <div class="col-sm-4">
- <input type="text" name="ipk" class="form-control" placeholder="IPK Terakhir" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Pendidikan Terakhir</label>
- <div class="col-sm-4">
- <input type="text" name="pnddkanakhir" class="form-control" placeholder="Pendidikan Terakhir" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Status Perkawinan</label>
- <div class="col-sm-2">
- <select name="status" class="form-control" required>
- <option value=""> - Pilih - </option>
- <option value="kawin">Kawin</option>
- <option value="janda">Janda</option>
- <option value="duda">Duda</option>
- <option value="belumkwn">Belum Kawin</option>
- </select>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Keterampilan</label>
- <div class="col-sm-2">
- <input type="checkbox" name="keterampilan" value="Pidato">Pidato <br>
- <input type="checkbox" name="keterampilan" value="Khutbah">Khutbah<br>
- <input type="checkbox" name="keterampilan" value="Baca Al-Qur'an">Baca Al-Qur'an<br>
- <input type="checkbox" name="keterampilan" value="Membuat Kue">Membuat Kue<br>
- <input type="checkbox" name="keterampilan" value="Merangkai Bunga">Merangkai Bunga<br>
- <input type="checkbox" name="keterampilan" value="Masak-Masak">Masak-Masak<br>
- <input type="checkbox" name="keterampilan" value="Penataan-Ruangan">Penataan-Ruangan<br>
- <input type="checkbox" name="keterampilan" value="Mengajar">Mengajar
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Organisasi</label>
- <div class="col-sm-2">
- <input type="radio" name="organisasi" value="laki-laki">Intra
- <input type="radio" name="organisasi" value="perempuan">Extra
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Alamat Lengkap Di Banda Aceh</label>
- <div class="col-sm-4">
- <textarea name="almatbna" class="form-control" placeholder="Alamat Lengkap Di Banda Aceh" required></textarea>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Telopn/ HP</label>
- <div class="col-sm-4">
- <input type="text" name="hp" class="form-control" placeholder="Telopn/ HP" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Ukuran Baju Jaket</label>
- <div class="col-sm-4">
- <input type="text" name="ukranjket" class="form-control" placeholder="Ukuran Baju jaket" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Jenis Penyakit Yang Sering DI Alami</label>
- <div class="col-sm-4">
- <input type="text" name="penyakit" class="form-control" placeholder="Jenis Penyakit Yang Sering DI Alami" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label">Upload Foto</label>
- <div class="col-sm-4">
- <input type="file" name="foto" class="form-control" placeholder="Upload Foto" required>
- </div>
- </div>
- <div class="form-group">
- <label class="col-sm-3 control-label"> </label>
- <div class="col-sm-6">
- <input type="submit" name="add" class="btn btn-sm btn-primary" value="Simpan" data-toggle="tooltip" title="Simpan Data mahasiswa">
- <a href="index.php" class="btn btn-sm btn-danger" data-toggle="tooltip" title="Batal">Batal</a>
- </div>
- </div>
- </form>
- </div>
- </div>
- <?php
- include("footer.php");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement