5 Jan 2015

Aplikasi CRUD Data Siswa dalam PHP




A.      Program CRUD Data Siswa
Program adalah himpunan atau kumpulan instruksi tertulis yang dibuat oleh programmer atau sebagian executable dari suatu software. Dan program ini dibuat untuk memnuhi tugas UAS matakuliah Pempprograman PHP, yang mana program ini  didalamnya berisi perintah CRUD.Tenntunya program ini masih banyak kekurangan baik dari coding program ataupun tampilan program setidaknya kita bisa mengembangkan untuk lebih kreatif lagi khusunya bagi para pembaca.

B.       Tentang Coding Program

Ø  Membuat koneksi database ke xampp
<?php
$host = "localhost";    
$user = "root";
$pass = "";      
$name = "belajar";      

$koneksi = mysql_connect($host, $user, $pass) or die("Koneksi ke database gagal!");
mysql_select_db($name, $koneksi) or die("Tidak ada database yang dipilih!");
?>

Ø  Membuat form lagi dengan nama index.php
<!DOCTYPE html>
<html>
<head>
            <title>CRUD</title>
</head>
<body>
            <h2>CRUD</h2>
           
            <p><a href="index.php">Beranda</a> / <a href="tambah.php">Tambah Data</a></p>
           
            <h3>Data Siswa</h3>
           
            <table cellpadding="5" cellspacing="0" border="1">
                        <tr bgcolor="#CCCCCC">
                                    <th>No.</th>
                                    <th>npm</th>
                                    <th>Nama Lengkap</th>
                                    <th>Kelas</th>
                                    <th>Jurusan</th>
                                    <th>Opsi</th>
                        </tr>
                       
                        <?php
                        //iclude file koneksi ke database
                        include('koneksi.php');
                       
                       
                        $query = mysql_query("SELECT * FROM tbl_belajar ORDER BY siswa_npm DESC") or die(mysql_error());
                       
                       
                        if(mysql_num_rows($query) == 0){  
                                   
                                   
                                    echo '<tr><td colspan="6">Tidak ada data!</td></tr>';
                                   
                        }else{ 
                                   
                                   
                                    $no = 1;          
                                    while($data = mysql_fetch_assoc($query)){ 
                                               
                                                //menampilkan row dengan data di database
                                                echo '<tr>';
                                                            echo '<td>'.$no.'</td>';          
                                                            echo '<td>'.$data['siswa_npm'].'</td>';         
                                                            echo '<td>'.$data['siswa_nama'].'</td>';       
                                                            echo '<td>'.$data['siswa_kelas'].'</td>';        
                                                            echo '<td>'.$data['siswa_jurusan'].'</td>';    
                                                            echo '<td><a href="edit.php?id='.$data['siswa_id'].'">Edit</a> / <a href="hapus.php?id='.$data['siswa_id'].'" onclick="return confirm(\'Anda Sudah Yakin?\')">Hapus</a></td>'; //menampilkan link edit dan hapus dimana tiap link terdapat GET id -> ?id=siswa_id
                                                echo '</tr>';
                                               
                                                $no++; //menambah jumlah nomor urut setiap row    
                                    }
                        }
                        ?>
            </table>
</body>
</html>

Ø  Membuat form tambah dengan nama tambah.php
<!DOCTYPE html>
<html>
<head>
            <title>CRUD</title>
</head>
<body>
            <h2>CRUD</h2>
           
            <p><a href="index.php">Beranda</a> / <a href="tambah.php">Tambah Data</a></p>
           
            <h3>Tambah Data Siswa</h3>
           
            <form action="tambah-proses.php" method="post">
                        <table cellpadding="5" cellspacing="0">
                                    <tr>
                                                <td>Npm</td>
                                                <td>:</td>
                                                <td><input type="text" name="npm" required></td>
                                    </tr>
                                    <tr>
                                                <td>Nama Lengkap</td>
                                                <td>:</td>
                                                <td><input type="text" name="nama" size="50" required></td>
                                    </tr>
                                    <tr>
                                                <td>Kelas</td>
                                                <td>:</td>
                                                <td>
                                                            <select name="kelas" required>
                                                                        <option value="">Pilih Kelas</option>
                                                                        <option value="A">A</option>
                                                                        <option value="B">B</option>
                                                                        <option value="C">C</option>
                                                            </select>
                                                </td>
                                    </tr>
                                    <tr>
                                                <td>Jurusan</td>
                                                <td>:</td>
                                                <td>
                                                            <select name="jurusan" required>
                                                                        <option value="">Pilih Jurusan</option>
                                                                        <option value="Tkj">Tkj</option>
                                                                        <option value="Multimedia">Multimedia</option>
                                                                        <option value="Akuntansi">Akuntansi</option>
                                                                        <option value="Perbankan">Perbankan</option>
                                                                        <option value="Pemasaran">Pemasaran</option>
                                                            </select>
                                                </td>
                                    </tr>
                                    <tr>
                                                <td>&nbsp;</td>
                                                <td></td>
                                                <td><input type="submit" name="tambah" value="Tambah"></td>
                                    </tr>
                        </table>
            </form>
</body>
</html>

Ø  Membuat form tampil dengan nama tambah-proses.php
<?php
//mulai proses tambah data


if(isset($_POST['tambah'])){
           
            include('koneksi.php');
           
            $npm               = $_POST['npm'];      
            $nama              = $_POST['nama'];     
            $kelas              = $_POST['kelas'];     
            $jurusan           = $_POST['jurusan'];  
           
           
            $input = mysql_query("INSERT INTO tbl_belajar VALUES(NULL, '$npm', '$nama', '$kelas', '$jurusan')") or die(mysql_error());
           
            //jika query input sukses
            if($input){
                       
                        echo 'Data berhasil di tambahkan! ';              
                        echo '<a href="tambah.php">Kembali</a>';  
                       
            }else{
                        echo 'Gagal menambahkan data! ';                
                        echo '<a href="tambah.php">Kembali</a>';              
            }

}else{ 

            //redirect atau dikembalikan ke halaman tambah
            echo '<script>window.history.back()</script>';

}
?>


Ø  Membuat form edit dengan nama edit.php
<!DOCTYPE html>
<html>
<head>
            <title>CRUD</title>
</head>
<body>
            <h2>CRUD</h2>
           
            <p><a href="index.php">Beranda</a> / <a href="tambah.php">Tambah Data</a></p>
           
            <h3>Edit Data Siswa</h3>
           
            <?php
           
           
            //include atau memasukkan file koneksi ke database
            include('koneksi.php');
           
           
            $id = $_GET['id'];
           
           
            $show = mysql_query("SELECT * FROM tbl_belajar WHERE siswa_id='$id'");
           
            //cek apakah data dari hasil query ada atau tidak
            if(mysql_num_rows($show) == 0){
                       
                       
                        echo '<script>window.history.back()</script>';
                       
            }else{
           
                       
                        $data = mysql_fetch_assoc($show);   //mengambil data ke database yang nantinya akan ditampilkan di form edit di bawah
           
            }
            ?>
           
            <form action="edit-proses.php" method="post">
                        <input type="hidden" name="id" value="<?php echo $id; ?>">      
                        <table cellpadding="3" cellspacing="0">
                                    <tr>
                                                <td>Npm</td>
                                                <td>:</td>
                                                <td><input type="text" name="npm" value="<?php echo $data['siswa_npm']; ?>" required></td>      
                                    </tr>
                                    <tr>
                                                <td>Nama Lengkap</td>
                                                <td>:</td>
                                                <td><input type="text" name="nama" size="30" value="<?php echo $data['siswa_nama']; ?>" required></td>
                                    </tr>
                                    <tr>
                                                <td>Kelas</td>
                                                <td>:</td>
                                                <td>
                                                            <select name="kelas" required>
                                                                        <option value="">Pilih Kelas</option>
                                                                        <option value="X" <?php if($data['siswa_kelas'] == 'A'){ echo 'selected'; } ?>>A</option>    <!-- jika data di database sama dengan value maka akan terselect/terpilih -->
                                                                        <option value="XI" <?php if($data['siswa_kelas'] == 'B'){ echo 'selected'; } ?>>B</option>   
                                                                        <option value="XII" <?php if($data['siswa_kelas'] == 'C'){ echo 'selected'; } ?>>C</option>      
                                                            </select>
                                                </td>
                                    </tr>
                                    <tr>
                                                <td>Jurusan</td>
                                                <td>:</td>
                                                <td>
                                                            <select name="jurusan" required>
                                                                        <option value="">Pilih Jurusan</option>
                                                                        <option value="Teknik Komputer dan Jaringan" <?php if($data['siswa_jurusan'] == 'Tkj'){ echo 'selected'; } ?>>Tkj</option>        <!-- jika data di database sama dengan value maka akan terselect/terpilih -->
                                                                        <option value="Multimedia" <?php if($data['siswa_jurusan'] == 'Multimedia'){ echo 'selected'; } ?>>Multimedia</option>  
                                                                        <option value="Akuntansi" <?php if($data['siswa_jurusan'] == 'Akuntansi'){ echo 'selected'; } ?>>Akuntansi</option>      
                                                                        <option value="Perbankan" <?php if($data['siswa_jurusan'] == 'Perbankan'){ echo 'selected'; } ?>>Perbankan</option>      
                                                                        <option value="Pemasaran" <?php if($data['siswa_jurusan'] == 'Pemasaran'){ echo 'selected'; } ?>>Pemasaran</option>     
                                                            </select>
                                                </td>
                                    </tr>
                                    <tr>
                                                <td>&nbsp;</td>
                                                <td></td>
                                                <td><input type="submit" name="simpan" value="Simpan"></td>
                                    </tr>
                        </table>
            </form>
</body>
</html>

Ø  Membuat form  dengan nama edit-proses.php

<?php
//mulai proses edit data

//cek dahulu, jika tombol simpan di klik
if(isset($_POST['simpan'])){
           
            //inlcude atau memasukkan file koneksi ke database
            include('koneksi.php');
           
            //jika tombol tambah benar di klik maka lanjut prosesnya
            $id                               = $_POST['id'];          
            $npm               = $_POST['npm'];      
            $nama              = $_POST['nama'];     
            $kelas              = $_POST['kelas'];     
            $jurusan           = $_POST['jurusan'];  
           
           
            $update = mysql_query("UPDATE tbl_belajar SET siswa_npm='$npm', siswa_nama='$nama', siswa_kelas='$kelas', siswa_jurusan='$jurusan' WHERE siswa_id='$id'") or die(mysql_error());
           
            //jika query update sukses
            if($update){   
                        echo 'Data berhasil di simpan! ';        
                        echo '<a href="edit.php?id='.$id.'">Kembali</a>';                           
            }else{
                       
                        echo 'Gagal menyimpan data! ';                     
                        echo '<a href="edit.php?id='.$id.'">Kembali</a>';                           
            }
}else{ 
            echo '<script>window.history.back()</script>';

}
?>





Ø  Membuat form hapus dengan nama hapus.php
<?php
//memulai proses hapus data


if(isset($_GET['id'])){
           
            //inlcude atau memasukkan file koneksi ke database
            include('koneksi.php');
           
           
            $id = $_GET['id'];
           
           
            $cek = mysql_query("SELECT siswa_id FROM tbl_belajar WHERE siswa_id='$id'") or die(mysql_error());
           
            //jika data siswa tidak ada
            if(mysql_num_rows($cek) == 0){
                       
                       
                        echo '<script>window.history.back()</script>';
           
            }else{
                       
                       
                        $del = mysql_query("DELETE FROM tbl_belajar WHERE siswa_id='$id'");
                       
                        //jika query DELETE berhasil
                        if($del){
                                   
                                    echo 'Data siswa berhasil di hapus! ';             
                                    echo '<a href="index.php">Kembali</a>';     //membuat Link untuk kembali ke halaman beranda
                                   
                        }else{
                                   
                                    echo 'Gagal menghapus data! ';                     
                                    echo '<a href="index.php">Kembali</a>';     //membuat Link untuk kembali ke halaman beranda        
                        }
            }
           
}else{
           
            //redirect atau dikembalikan ke halaman beranda
            echo '<script>window.history.back()</script>';
}
?>
A.      Tentang print screen program

Ø Tampilan pertama tentang program Data Siswa


Ø Memasukkan inputan siswa, npm,  nama, kelas, jurusan, seperti contoh gambar dibawah ini.



Ø dibawah ini tampilan data yang sudah  kita inputkan


Ø Untuk mengedit data kita cukup klik edit data yang ada disebelah kanan data.





Ø  Itu saja program CRUD yang saya buat kurang lebihnya mohon maaf dan semoga bermanfaat, Amiieenn.
http://sahrul-ti.blogspot.com

0 comments:

Post a Comment

Jadilah Orang yang Bermanfaat Bagi Orang Lain.