Project Database Programming Menggunakan PHP #3

JAWABAN, B:

5. File ubahbuku.php

<form action="prosesubah.php" method="get">

    <table>

    <tr>

        <td>ID Buku </td>

        <td><input type="text" name="idb" value="<?php 

            echo $_GET['idb']; ?>" readonly="true"/></td>

    </tr>

    <tr>

        <td>ID Penerbit</td>

        <td><input type="text" name="idp" value="<?php 

            echo $_GET['idp']; ?>"/></td>

    </tr>

    <tr>

        <td>Judul Buku</td>

        <td><input type="text" name="judul" value="<?php 

            echo $_GET['judul']; ?>"/></td>

    </tr>

    <tr>

        <td>Stok</td>

        <td><input type="text" name="stok" value="<?php 

            echo $_GET['stok']; ?>"/></td>

    </tr>

    <tr>

        <td></td>

        <td>

            <input type="submit" name="ubah" value="Ubah" />

            <input type="reset" name="batal" value="Batal" />

        </td>

    </tr>

</table>

</form>

6. File prosesubah.php

<?php

    include "bukadata.php";

    $idb = $_GET['idb'];

    $idp = $_GET['idp'];

    $judul = $_GET['judul'];

    $stok = $_GET['stok'];

    $qrubah = "UPDATE buku SET id_penerbit='$idp',

    nama_buku='$judul',stok='$stok' WHERE id_buku='$idb'";

    $ubah = mysql_query($qrubah);

    if($ubah)

        header('Location: Utama.php');

    else

        header('Location: ubahbuku.php');

?>

7. File hapusbuku.php

<form action="proseshapus.php" method="get">

    <table>

    <tr>

        <td>ID Buku </td>

        <td><input type="text" name="idb" value="<?php 

            echo $_GET['idb']; ?>" readonly="true"/></td>

    </tr>

    <tr>

        <td>ID Penerbit</td>

        <td><input type="text" name="idp" value="<?php 

            echo $_GET['idp']; ?>" readonly="true"/></td>

    </tr>

    <tr>

        <td>Judul Buku</td>

        <td><input type="text" name="judul" value="<?php 

            echo $_GET['judul']; ?>" readonly="true"/></td>

    </tr>

    <tr>

        <td>Stok</td>

        <td><input type="text" name="stok" value="<?php 

            echo $_GET['stok']; ?>" readonly="true"/></td>

        

    </tr>

    <tr>

        <td></td>

        <td>

            <input type="submit" name="hapus" value="Hapus" />

            <input type="reset" name="batal" value="Batal" />

        </td>

    </tr>

</table>

</form>

8. File proseshapus.php

<?php

    include "bukadata.php";

    $idb = $_GET['idb'];

    $idp = $_GET['idp'];

    $judul = $_GET['judul'];

    $stok = $_GET['stok'];

    $qrhapus = "DELETE FROM buku WHERE id_buku='$idb'";

    $hapus = mysql_query($qrhapus);

    if($hapus)

        header('Location: Utama.php');

    else

        header('Location: hapusbuku.php');

?>

<< Sebelumnya