Giveaway Evercoss Winner Y Ultra (Event Berakhir 27 Oktober 2015)

Tugas Praktikum 4

Tugas Praktikum 4 Nomer 1

      Soal :

     Buatlah Database Tabel Mahasiswa tb_mhs

Jawabannya :

Pertama Buat :

Setelah Ditambah Satu Data :

Tugas Praktikum 4 Nomer 2

Soal :

  Buatlah Halaman WEB dari Database diatas dan seperti di Modul 

Jawabannya :

·   Koneksi :

Programnya :

      $konek = mysql_connect("localhost", "root", "") or die("Koneksi ke server gagal");

      mysql_select_db("praktikum_daskom",$konek) or die ("Database tidak ditemukan");

?>

·   Halaman Awal :

Programnya :

      

   

      

      

                      

SELAMAT DATANG

                      

---

                      

                                      

INPUT DATA MAHASISWA

                                      

LIHAT DATA MAHASISWA

                      

                      

---

      

Outputnya :

·   Input Data Mahasiswa :

Programnya :

    

    if(isset($_POST['simpan'])){

                    include "koneksi.php";

                    $nbi = $_POST['nbi'];

                    $nama = $_POST['nama'];

                    $kelas = $_POST['kelas'];

                    $alamat = $_POST['alamat'];

                    $query = "INSERT INTO `tb_mhs` (nbi, nama, kelas, alamat) VALUES ('".$nbi."','".$nama."','".$kelas."','".$alamat."')";

                    $query_sukses = mysql_query($query);

                    if($query_sukses){

                                    header("location:lihat_data.php");

                    }else{

                                    echo(

                                                    ''

                                    );

                    }

    }

?>

   

   

                   

---

                   

INPUTKAN DATA ANDA

                   

---

                   

                                   

                                                                                          

                                                                    NBI

                                                                   

                                                                    

                                                   

                                                                                          

                                                                    Nama

                                                                   

                                                                    

                                                   

                                                                                          

                                                                    Kelas

                                                                   

                                                                    

                                                   

                                                                                          

                                                                    Alamat

                                                                   

                                                                    

                                                   

                                                                                          

                                                                   

                                                                                    

                                                                                    

                                                                   

                                                   

                                                   

                                   

                   

   

Outputnya :

·   Lihat Data Mahasiswa :

Programnya :

    

   

   

                   

---

                   

DATA NAMA PRAKTIKUM

                   

---

                   

                   

                                    NBI

                                    NAMA

                                    ALAMAT

                                    EKSEKUSI

                   

                    include "koneksi.php";

                    $data=mysql_query("SELECT * FROM tb_mhs");

                    while($hasil=mysql_fetch_array($data)){

?>

                                   

                                                   

                                                   

                                                   

                                                   

                                                   

                                                                    edit

                                                                    /

                                                                    hapus

                                                   

                                   

                    };

?>

                   

    Tambah Data

    Kembali

   

Outputnya :

Pada SQLyog (Database) Data otomatis bertambah :

·   Edit :

Programnya :

    if(isset($_POST['edit'])){

                    include "koneksi.php";

                    $nbi = $_POST['nbi'];

                    $nama = $_POST['nama'];

                    $kelas = $_POST['kelas'];

                    $alamat = $_POST['alamat'];

                    $query ="UPDATE `tb_mhs` SET

                                                                    NBI='".$nbi."',

                                                                    NAMA='".$nama."',

                                                                    KELAS='".$kelas."',

                                                                    ALAMAT='".$alamat."'

                                                    WHERE NBI='".$_GET['NBI']."'";

                    $query_sukses = mysql_query($query);

                    if($query_sukses){

                                    header("location:lihat_data.php");

                    }else{

                                    echo(

                                                    ''

                                    );

                    }

    }else{

                    include "koneksi.php";

                    $data=mysql_query("SELECT * FROM tb_mhs WHERE NBI='".$_GET['NBI']."'");

                    $hasil=mysql_fetch_array($data);

    }

?>

   

   

                   

SILAHKAN EDIT DATA ANDA

                   

                                   

                                                                                          

                                                                    NBI

                                                                   

                                                                    

                                                   

                                                                                          

                                                                    Nama

                                                                   

                                                                    

                                                   

                                                                                          

                                                                    Kelas

                                                                   

                                                                    

                                                   

                                                                                          

                                                                    Alamat

                                                                   

                                                                    

                                                   

                                                                                          

                                                                   

                                                                                    

                                                                                    

                                                                   

                                                   

                                                   

                                   

                   

   

Output :

·   Delete :

Programnya :

    if ($_GET['pilih']==0){

?>

   

    }else{

                    include "koneksi.php";

                    mysql_query("DELETE FROM tb_mhs WHERE NBI='".$_GET['NBI']."'") or die ("Data gagal dihapus");

                    header("location:lihat_data.php");

    }

?>

Output :

Sudah Tidak ada di “Lihat Data Mahasiswa” :

Di Database juga otomatis kehapus :