Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //include kode html yang berisi kode untuk desain header alias kepala alias sirah//
- include "header.php";
- //include kode php untuk bisa terhubung ke database mysql//
- include "koneksi.php";
- ?>
- <!-- membuat variabel form input -->
- <?php $fr_input="<form action='' method='post'>
- <table align='center' border='1'>
- <tr>
- <td>Nama:</td>
- <td><input type='text' name='nama'></input></td>
- </tr>
- <tr>
- <td>Email:</td>
- <td><input type='email' name='email'></input></td>
- </tr>
- <tr>
- <td>Password:</td>
- <td><input type='password' name='pas'></input></td>
- </tr>
- <tr>
- <td><input type='hidden' name='chek' value='ok'></td>
- <td><input type='submit' name='wocey' value='Input'></input></td>
- </tr>
- </table>
- </form>" ?>
- <?php
- if ($_GET['input'] == '1'){
- $no = $_POST['no'];
- $nis = $_POST['nisl'];
- $nisn = $_POST['nisn'];
- $nama = $_POST['nama'];
- $tempatlahir = $_POST['tempatlahir'];
- $agama = $_POST['agama'];
- $jurusan = $_POST['jurusan'];
- $nama_orgtua = $_POST['nama_orgtua'];
- $pkj_orgtua = $_POST['pkj_orgtua'];
- $alamat = $_POST['alamat'];
- $nohportu = $_POST['nohportu'];
- $asalsekolah = $_POST['asalsekolah'];
- $keterangan = $_POST['keterangan'];
- if ($ck = "ok" && $pas != "" && $nm != "") {
- mysql_query("INSERT INTO `siswa`(`no`, `nis`, `nisn`, `nama`, `tempatlahir`,
- `agama`, `jurusan`, `nama_orgtua`, `pkj_orgtua`, `alamat`, `nohportu`,
- `asalsekolah`,`keterangan`) VALUES
- ('','$no','$nis','$nisn','$nama','$tempatlahir','$agama','$jurusan','$nama_orgtua',
- '$pkj_orgtua','$alamat','$nohportu','$asalsekolah','$keterangan')");
- echo "Berhasil";
- }
- }
- //Kalo yang ini untuk show atau menampilkan data//
- if ($_GET['show'] == '1') {
- $sql = mysql_query("select * from siswa");
- while ($r = mysql_fetch_array($sql))
- { ?>
- <table align='center' border='1' width='900px'>
- <tr>
- <td width='200px'>No:</td>
- <td><?php echo $r['no']; ?></td>
- </tr>
- <tr>
- <td width='200px'>Nis:</td>
- <td><?php echo $r['nis']; ?></td>
- </tr>
- <tr>
- <td width='200px'>Nisn:</td>
- <td><?php echo $r['nisn']; ?></td>
- </tr>
- <tr>
- <td width='200px'>Nama:</td>
- <td><?php echo $r['nama']; ?></td>
- </tr>
- <tr>
- <td width='200px'>Tempat Lahir:</td>
- <td><?php echo $r['tempatlahir']; ?></td>
- </tr>
- <tr>
- <td width='200px'>Agama:</td>
- <td><?php echo $r['agama']; ?></td>
- </tr>
- <tr>
- <td width='200px'>Jurusan:</td>
- <td><?php echo $r['jurusan']; ?></td>
- </tr>
- <tr>
- <td width='200px'>Nama Orang Tua:</td>
- <td><?php echo $r['nama_orgtua']; ?></td>
- </tr>
- <tr>
- <td width='200px'>Pekerjaan Orang Tua:</td>
- <td><?php echo $r['pkj_orgtua']; ?></td>
- </tr>
- <tr>
- <td width='200px'>Alamat:</td>
- <td><?php echo $r['alamat']; ?></td>
- </tr>
- <tr>
- <td width='200px'>No HP Orang Tua:</td>
- <td><?php echo $r['nohportu']; ?></td>
- </tr>
- <tr>
- <td width='200px'>Asal Sekolah:</td>
- <td><?php echo $r['asalsekolah']; ?></td>
- </tr>
- <tr>
- <td width='200px'>Keterangan:</td>
- <td><?php echo $r['keterangan']; ?></td>
- </tr>
- <tr>
- <td><a href='index.php?delid=<?php echo $r['id']; ?
- >'>Hapus</a> <a href="index.php?upid=<?php echo $r['id']; ?>">Ubah</a>
- </tr>
- </table><br/>
- <?php }
- }
- ?>
- <!-- logika untuk menghapus data -->
- <?php if ($_GET['delid'] != "")
- {
- $id_hps = $_GET['delid'];
- mysql_query("DELETE FROM `siswa` WHERE id='$id_hps'");
- echo "berhasil di hapus";
- }
- //kalo yang ini logika untuk update data//
- if ($_GET['upid'] != "")
- {
- echo "Update data";
- $nm = $_POST['nama'];
- $em = $_POST['email'];
- $pas = $_POST['pas'];
- $ck = $_POST['chek'];
- echo $fr_input;
- $id_up = $_GET['upid'];
- mysql_query("UPDATE `user` SET `nama`='$nm',`email`='$em',`password`='$pas'
- WHERE id='$id_up'");
- }
- ?>
- <!-- Ini includekan php saya yang berisi kode untuk footer alias kaki alias sikil
- -->
- <?php include "footer.php"; ?>
Add Comment
Please, Sign In to add comment