Project Database Programming Menggunakan PHP #2

JAWABAN, B:

1. File bukadata.php

<?php

    $host="localhost";

    $user="root";

    $pass="";

    $db="perpustakaan";

    $terhubung = mysqli_connect($host, $user, $pass, $db);

    if(!$terhubung)

        echo "Database Tidak Terhubung";

?>

2. File utama.php

<table>

    <tr>

        <td><a href="tambahbuku.php">Tambah</a></td>

        <td colspan="2">

            <form action="" method="get">

                <input type="text" name="key" />

                <input type="submit" name="cari" value="Cari" />

            </form>

        </td>

        <td></td>

    </tr>

    <tr align="center">

        <td>ID Buku</td>

        <td>ID Penerbit</td>

        <td>Judul Buku</td>

        <td>Stok</td>

        <td></td>

    </tr>

    <?php

        require "bukadata.php";

    if(isset($_GET['key'])){

        $cari = $_GET['key'];

        $tampil = mysql_query("SELECT * FROM buku 

        WHERE nama_buku LIKE '%$cari%'");

    }

    else

        $tampil = mysql_query("SELECT * FROM buku");

        while($buku = mysql_fetch_array($tampil)){

    ?>

    <tr>

        <td align="center"><?php echo $buku[0]; ?></td>

        <td align="center"><?php echo $buku[1]; ?></td>

        <td><?php echo $buku[2]; ?></td>

        <td align="center"><?php echo $buku[3]; ?></td>

        <td><a href="ubahbuku.php?idb=<?php 

        echo $buku[0]; ?>&idp=<?php 

        echo $buku[1]; ?>&judul=<?php 

        echo $buku[2]; ?>&stok=<?php 

        echo $buku[3]; ?>">Ubah</a> 

        | <a href="hapusbuku.php?idb=<?php 

        echo $buku[0]; ?>&idp=<?php 

        echo $buku[1]; ?>&judul=<?php 

        echo $buku[2]; ?>&stok=<?php 

        echo $buku[3]; ?>">Hapus</a>

        </td>

    </tr>

    <?php

        }

    ?>

</table>

3. File tambahbuku.php

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

<table>

    <tr>

        <td>ID Buku </td>

        <td><input type="text" name="idb" /></td>

    </tr>

    <tr>

        <td>ID Penerbit</td>

        <td><input type="text" name="idp" /></td>

    </tr>

    <tr>

        <td>Judul Buku</td>

        <td><input type="text" name="judul" /></td>

    </tr>

    <tr>

        <td>Stok</td>

        <td><input type="text" name="stok" /></td>

    </tr>

    <tr>

        <td></td>

        <td>

            <input type="submit" name="simpan" value="Simpan" />

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

        </td>

    </tr>

</table>

</form>

4. File prosestambah.php

<?php

    include "bukadata.php";

    $idb = $_GET['idb'];

    $idp = $_GET['idp'];

    $judul = $_GET['judul'];

    $stok = $_GET['stok'];

    $qrsimpan = "INSERT INTO buku VALUES('$idb', '$idp',

    '$judul', '$stok')";

    $simpan = mysql_query($qrsimpan);

    if($simpan)

        header('Location: Utama.php');

    else

        header('Location: tambahbuku.php');

?>

<< Sebelumnya                                                                                         Selanjutnya >>