SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | //===========KONEKSINYA MANA========= | |
| 3 | ||
| 4 | if (mysqli_connect_errno()) | |
| 5 | {
| |
| 6 | echo "Failed to connect to MySQL: " . mysqli_connect_error(); | |
| 7 | } | |
| 8 | ||
| 9 | ||
| 10 | if(isset($_POST['add'])){
| |
| 11 | $nopeserta = $_POST['nopeserta']; | |
| 12 | $nama = $_POST['nama']; | |
| 13 | $tmp_lahir = $_POST['tmp_lahir']; | |
| 14 | $desa = $_POST['desa']; | |
| 15 | $kecamatan = $_POST['kecamatan']; | |
| 16 | $kabupaten = $_POST['kabupaten']; | |
| 17 | $tgl = $_POST['tgl']; | |
| 18 | $kelamin = $_POST['kelamin']; | |
| 19 | $fakultas = $_POST['fakultas']; | |
| 20 | $jurusan = $_POST['jurusan']; | |
| 21 | $noinduk = $_POST['noinduk']; | |
| 22 | $ayah = $_POST['ayah']; | |
| 23 | $jobayh = $_POST['jobayh']; | |
| 24 | $alamata = $_POST['alamata']; | |
| 25 | $ibu = $_POST['ibu']; | |
| 26 | $jobibu = $_POST['jobibu']; | |
| 27 | $alamati = $_POST['alamati']; | |
| 28 | $ipk = $_POST['ipk']; | |
| 29 | $pnddkanakhir = $_POST['pnddkanakhir']; | |
| 30 | - | $sql = mysqli_query($koneksi, "SELECT * FROM mahasiswa WHERE nopeserta='$nopeserta'"); |
| 30 | + | |
| 31 | $keterampilan = $_POST['keterampilan']; | |
| 32 | - | if($pass1 == $pass2){
|
| 32 | + | |
| 33 | - | $pass = md5($pass1); |
| 33 | + | |
| 34 | - | $insert = mysqli_query($koneksi, "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, password) 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', '$pass')") or die(mysqli_error());
|
| 34 | + | |
| 35 | $ukranjket = $_POST['ukranjket']; | |
| 36 | $penyakit = $_POST['penyakit']; | |
| 37 | ||
| 38 | $sql = mysqli_query($koneksi, "SELECT * FROM mahasiswa WHERE nopeserta='$nopeserta'")or | |
| 39 | die( mysqli_error($koneksi) ); | |
| 40 | if(mysqli_num_rows($sql) == 0){
| |
| 41 | if(TRUE){
| |
| 42 | //$pass = md5($pass1); | |
| 43 | $sql="INSERT INTO mahasiswa | |
| 44 | ( | |
| 45 | nopeserta, nama, tmp_lahir, desa, kecamatan, | |
| 46 | - | } |
| 46 | + | kabupaten, tgl, kelamin, fakultas, jurusan, |
| 47 | noinduk, ayah, jobayh, alamata, ibu, | |
| 48 | jobibu, alamati, ipk, pnddkanakhir, status, | |
| 49 | keterampilan, organisasi, almatbna, hp, ukranjket, | |
| 50 | penyakit ) | |
| 51 | VALUES | |
| 52 | ( | |
| 53 | '$nopeserta','$nama', '$tmp_lahir', '$desa', '$kecamatan', | |
| 54 | '$kabupaten', '$tgl', '$kelamin', '$fakultas', '$jurusan', | |
| 55 | '$noinduk', '$ayah', '$jobayh', '$alamata', '$ibu', | |
| 56 | '$jobibu', '$alamati', '$ipk', '$pnddkanakhir', '$status', | |
| 57 | '$keterampilan', '$organisasi', '$almatbna', '$hp', '$ukranjket', | |
| 58 | '$penyakit' )"; | |
| 59 | $insert = mysqli_query($koneksi, $sql) or | |
| 60 | die( mysqli_error($koneksi) ); | |
| 61 | ||
| 62 | if($insert){
| |
| 63 | 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>'; | |
| 64 | }else{
| |
| 65 | 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>'; | |
| 66 | } | |
| 67 | } else{ // mengecek jika password yang diinput tidak sama
| |
| 68 | 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!' | |
| 69 | } | |
| 70 | }else{ // mengecek jika nim yang akan ditambahkan sudah ada dalam database
| |
| 71 | 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..!' | |
| 72 | } | |
| 73 | ||
| 74 | }else{ }
| |
| 75 | ?> |
