Update Delete PHP

Halo guys

Kali ini kita akan belajar cara Update dan Delete pada php
Berikut adalah source code untuk bahan belajar:)

Sebelumnya database sudah terisi pada phpmyadmin...
dan pastikan nama database, nama tabel dan nama kolom sesuai dengan yang kalian buat ya...

-------------------------------------------------------------

Praktek 1 ( NAMA )

Code Index.php

<table align="center"  border="1" cellpadding="5" cellspacing="0" >
    <tr>
        <th>ID</th>
        <th>NAMA</th>
        <th colspan="2">Aksi</th>
</tr>

<?php

include "Koneksi.php";

$ambildata = mysqli_query($conn, "select * from praktek1");
while($tampil = mysqli_fetch_array($ambildata)){
    echo"
    <tr>
        <td>$tampil[ID]</td>
        <td>$tampil[NAMA]</td>
        <td><a href='?kode=$tampil[ID]'> Hapus </a></td>
        <td><a href='Update.php?kode=$tampil[ID]'> Edit </a></td>
    <tr>";
   
}
?>
</table>

<?php
    include "Koneksi.php";

    if(isset($_GET['kode'])){
    mysqli_query($conn,"delete from praktek1 where ID='$_GET[kode]'");
   
    function function_alert($message) {
     
        // Display the alert box
        echo "<script>alert('$message');</script>";
    }
     
    // Function call
    function_alert("Data berhasil dihapus");
    echo "<meta http-equiv=refresh content=0;URL='Index.php'>";

    }
    ?>

Code Koneksi.php

<?php

$conn = mysqli_connect("localhost", "root", "", "projek1");

?>

Code Update.php

<?php
include "Koneksi.php";
$sql=mysqli_query($conn,"select * from praktek1 where ID='$_GET[kode]'");
$data=mysqli_fetch_array($sql);

?>

<h3> Ubah Data</h3>

<form action="" method="post">
<table>
    <tr>
        <td width="120">  </td>
        <td> <input type="text" name="nama" value="<?php echo $data['NAMA']; ?>"> </td>
    </tr>
    <tr>
        <td></td>
        <td><input type="submit" name="proses" value="Ubah"> </td>
    </tr>
</table>

</form>

<?php
include "Koneksi.php";

if(isset($_POST['proses'])){
mysqli_query($conn, "update praktek1 set  
NAMA = '$_POST[nama]'
where ID = '$_GET[kode]'");

echo "Data barang telah diubah";
echo "<meta http-equiv=refresh content=0;URL='Index.php'>";

}

?>

Hasil

Menampilkan database yang telah kita buat:



Klik 'edit'  
Masukkan kembali data yang akan diubah


Klik 'ubah'
Data telah terupdate
Klik 'hapus'
Data akan terhapus


Praktek 2 ( NAMA, KELAS)

Code Index.php

<table align="center"  border="1" cellpadding="5" cellspacing="0" >
    <tr>
        <th>ID</th>
        <th>NAMA</th>
        <th>KELAS</th>
        <th colspan="2">Aksi</th>
</tr>

<?php

include "Koneksi.php";

$ambildata = mysqli_query($conn, "select * from praktek2");
while($tampil = mysqli_fetch_array($ambildata)){
    echo"
    <tr>
        <td>$tampil[ID]</td>
        <td>$tampil[NAMA]</td>
        <td>$tampil[KELAS]</td>
        <td><a href='?kode=$tampil[ID]'> Hapus </a></td>
        <td><a href='Update.php?kode=$tampil[ID]'> Edit </a></td>
    <tr>";
   
}
?>
</table>

<?php
    include "Koneksi.php";

    if(isset($_GET['kode'])){
    mysqli_query($conn,"delete from praktek2 where ID='$_GET[kode]'");
   
    function function_alert($message) {
     
        // Display the alert box
        echo "<script>alert('$message');</script>";
    }
     
    // Function call
    function_alert("Data berhasil dihapus");
    echo "<meta http-equiv=refresh content=0;URL='Index.php'>";

    }
    ?>

Code Koneksi.php

<?php

$conn = mysqli_connect("localhost", "root", "", "projek2");

?>

Code Update.php

<?php
include "Koneksi.php";
$sql=mysqli_query($conn,"select * from praktek2 where ID='$_GET[kode]'");
$data=mysqli_fetch_array($sql);

?>

<h3> Ubah Data</h3>

<form action="" method="post">
<table>
    <tr>
        <td width="120">  </td>
        <td> <input type="text" name="nama" value="<?php echo $data['NAMA']; ?>"> </td>
    </tr>
    <tr>
        <td width="120">  </td>
        <td> <select name="kelas">
        <option value="X"><?php if($data['KELAS'] === "X"){ echo "<option value='X' selected>X</option>"; }else{ echo "<option type = value='X'>X</option>"; }?></option>
        <option value="XI"><?php if($data['KELAS'] === "XI"){ echo "<option value='XI' selected>XI</option>"; }else{ echo "<option value='XI'>XI</option>"; }?></option>
        <option value="XII"><?php if($data['KELAS'] === "XII"){ echo "<option value='XII' selected>XII</option>"; }else{ echo "<option value='XII'>XII</option>"; }?></option>
        </select></td>
    </tr>
    <tr>
        <td></td>
        <td><input type="submit" name="proses" value="Ubah"> </td>
    </tr>
</table>

</form>

<?php
include "Koneksi.php";

if(isset($_POST['proses'])){
mysqli_query($conn, "update praktek2 set  
NAMA = '$_POST[nama]',
KELAS = '$_POST[kelas]'
where ID = '$_GET[kode]'");

echo "Data barang telah diubah";
echo "<meta http-equiv=refresh content=0;URL='Index.php'>";

}

?>

Hasil

Menampilkan database yang telah kita buat:


Klik 'edit'  
Masukkan kembali data yang akan diubah



Klik 'ubah'
Data telah terupdate

Klik 'hapus'
Data akan terhapus



Praktek 3 ( NAMA, JENIS KELAMIN)

Code Index.php

<table align="center" border="1" cellpadding="5" cellspacing="0">
    <tr>
        <th>ID</th>
        <th>NAMA</th>
        <th>JENIS KELAMIN</th>
        <th colspan="2">Aksi</th>
</tr>

<?php

include "Koneksi.php";

$ambildata = mysqli_query($conn, "select * from praktek3");
while($tampil = mysqli_fetch_array($ambildata)){
    echo"
    <tr>
        <td>$tampil[ID]</td>
        <td>$tampil[NAMA]</td>
        <td>$tampil[JENKEL]</td>
        <td><a href='?kode=$tampil[ID]'> Hapus </a></td>
        <td><a href='Update.php?kode=$tampil[ID]'> Edit </a></td>
    <tr>";
   
}
?>
</table>

<?php
    include "Koneksi.php";

    if(isset($_GET['kode'])){
    mysqli_query($conn,"delete from praktek3 where ID='$_GET[kode]'");
   
    function function_alert($message) {
     
        // Display the alert box
        echo "<script>alert('$message');</script>";
    }
     
    // Function call
    function_alert("Data berhasil dihapus");
    echo "<meta http-equiv=refresh content=0;URL='Index.php'>";

    }
    ?>

Code Koneksi.php

<?php

$conn = mysqli_connect("localhost", "root", "", "projek3");

?>

Code Update.php

<?php
include "Koneksi.php";
$sql=mysqli_query($conn,"SELECT * from praktek3 where ID='$_GET[kode]'");
$data=mysqli_fetch_array($sql);

?>

<h3> Ubah Data </h3>

<form action="" method="post">
<table>
    <tr>
        <td width="120">  </td>
        <td> <input type="text" name="nama" value="<?php echo $data['NAMA']; ?>"> </td>
    </tr>
    <tr>
        <td width="120">  </td>
        <td> <input type="radio" name="jenkel" value="Pria" <?php if ($data['JENKEL'] == 'Pria') echo 'checked="checked"'; ?>/> Pria
        <input type="radio" name="jenkel" value="Wanita" <?php if ($data['JENKEL'] == 'Wanita') echo 'checked="checked"'; ?>/> Wanita</td>
    </tr>
    <tr>
        <td></td>
        <td><input type="submit" name="proses" value="Ubah"> </td>
    </tr>
</table>

</form>

<?php
include "Koneksi.php";

if(isset($_POST['proses'])){
mysqli_query($conn, "update praktek3 set  
NAMA = '$_POST[nama]',
JENKEL = '$_POST[jenkel]'
where ID = '$_GET[kode]'");

echo "Data barang telah diubah";
echo "<meta http-equiv=refresh content=0;URL='Index.php'>";

}

?>

Hasil

Menampilkan database yang telah kita buat:



Klik 'edit'  
Masukkan kembali data yang akan diubah


Klik 'ubah'
Data telah terupdate


Klik 'hapus'
Data akan terhapus



Praktek 4 ( NAMA, HOBI )

Code Index.php

<table align="center" border="1" cellpadding="5" cellspacing="0">
    <tr>
        <th>ID</th>
        <th>NAMA</th>
        <th>HOBI</th>
        <th colspan="2">Aksi</th>
</tr>

<?php

include "Koneksi.php";

$ambildata = mysqli_query($conn, "select * from praktek4");
while($tampil = mysqli_fetch_array($ambildata)){
    echo"
    <tr>
        <td>$tampil[ID]</td>
        <td>$tampil[NAMA]</td>
        <td>$tampil[HOBY]</td>
        <td><a href='?kode=$tampil[ID]'> Hapus </a></td>
        <td><a href='Update.php?kode=$tampil[ID]'> Edit </a></td>
    <tr>";
   
}
?>
</table>

<?php
    include "Koneksi.php";

    if(isset($_GET['kode'])){
       
    mysqli_query($conn,"delete from praktek4 where ID='$_GET[kode]'");
   
    function function_alert($message) {
     
        // Display the alert box
        echo "<script>alert('$message');</script>";
    }
     
    // Function call
    function_alert("Data berhasil dihapus");
    echo "<meta http-equiv=refresh content=0;URL='Index.php'>";

    }
    ?>

Code Koneksi.php

<?php

$conn = mysqli_connect("localhost", "root", "", "projek4");

?>

Code Update.php

<?php
include "Koneksi.php";
$sql=mysqli_query($conn,"SELECT * FROM praktek4 WHERE ID='$_GET[kode]'");
$data=mysqli_fetch_array($sql);

if(isset($_POST["proses"])) {
    $hobi  = implode(', ', $_POST['hobi']);
    $sql = mysqli_query ($conn, "UPDATE praktek4 SET NAMA = '$_POST[nama]', HOBY = '$hobi' WHERE ID = '$_GET[kode]' ");

    echo "Data barang telah diubah";
    echo "<meta http-equiv=refresh content=0;URL='Index.php'>";
}
    $checked = explode(', ', $data['HOBY']);
    $query = mysqli_query($conn, "SELECT * FROM praktek4 ORDER BY ID DESC");

?>



<form action="" method="post">
<table>
    <tr>
        <td width="120">  </td>
        <td> <input type="text" name="nama" value="<?php echo $data['NAMA']; ?>"> </td>
    </tr>
    <tr>
        <td width="120">  </td>
        <td> <input type="checkbox" name="hobi[]" value="Olahraga" <?php in_array ('Olahraga', $checked) ? print "checked" : ""; ?> > Olahraga<br>
    <input type="checkbox" name="hobi[]" value="Gammers" <?php in_array ('Gammers', $checked) ? print "checked" : ""; ?> > Gammers<br>
    <input type="checkbox" name="hobi[]" value="Slebew" <?php in_array ('Slebew', $checked) ? print "checked" : ""; ?> > Slebew<br></td>
    </tr>
    <tr>
        <td></td>
        <td><input type="submit" name="proses" value="Ubah"> </td>
    </tr>
</table>

</form>

Hasil

Menampilkan database yang telah kita buat:



Klik 'edit'  
Masukkan kembali data yang akan diubah



Klik 'ubah'
Data telah terupdate


Klik 'hapus'
Data akan terhapus


-----------------------------------------

Sekian praktik yang saya buat
Semoga bisa bermanfaat:)

Komentar

Posting Komentar

Postingan populer dari blog ini

OPERATOR STRING

Gambar
CODE: <?php $nama = "Nandana" ; $barang = "Monitor" ; $hasil = "Terimakasih { $nama } telah memesan " . $barang ; $harga = 50000 ; $diskon = 50000 * 0.15 ; $bayar = $harga - $diskon ; $uang = 100000 ; $kembali = $uang - $bayar ; ? > < html > < head > < title > penjualan produk </ title > < style type = "text/css" > body {     background-image : url ( 'wp.jpg' );     background-size : 100% ;     font-family : roboto; } h1 {         color : red ; } tr {     background-color : #96D4D4 ; } table {     background-color : blue ; } .harga p {     color : green ; } .diskon p {     color : red ;     font-size : 40px ;     text-align : center ; } </ style > </ head > < body > < h1 align = "middle" > TOKO KOMPUTER MURAH </ h1 > < br > < table   bordercolor = "purple" border = "1" cellpadding...
Baca selengkapnya