Pertemuan 11

Database Perpustakaan

Koneksi

<?

mysql_connect("localhost","root","gazthanz");

mysql_select_db("dbperpustakaan");

?>

Tampil Buku

<?

include"koneksi.php";

$ambil=mysql_query("select*from tbuku");

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

echo"<div align=center>

          <table border=0 width=46%>

                   <tr>

                             <td colspan=2>

                             <p align=center><b><font size=4 face=Comic Sans MS>Data Buku</font></b></td>

                   </tr>

                   <tr>

                             <td width=17%><b><font face=Andalus>Kode Buku</font></b></td>

                             <td width=27%>&nbsp;kode</td>

                   </tr>

                   <tr>

                             <td width=17%><b><font face=Andalus>Judul</font></b></td>

                             <td width=27%>&nbsp;judul</td>

                   </tr>

                   <tr>

                             <td width=17%><b><font face=Andalus>Pengarang</font></b></td>

                             <td width=27%>&nbsp;pengarang</td>

                   </tr>

                   <tr>

                             <td width=17%><b><font face=Andalus>Tahun Terbit</font></b></td>

                             <td width=27%>&nbsp;tahun</td>

                   </tr>

          </table>

</div>";

}

echo"<hr><a href=form_buku.php>Tambah Data Buku</a>";

?>

Form Buku

<?

include"form_buku.htm";

?>

Target Buku

<?

include"koneksi.php";

$kode=$_POST['kode'];

$judul=$_POST['judul'];

$pengarang=$_POST['pengarang'];

$tahun=$_POST['tahun'];

$masuk=mysql_query("insert into

tbuku(kode_buku,judul,pengarang,tahun_terbit) values

('$kode','$judul','$pengarang','$tahun')");

if($masuk){

echo"<center>OK Data Sudah Disimpan

<meta http-equiv='refresh' content='2;URL=tampil.php'>";

}

else{

echo"<center>Data GAGAL Disimpan

<meta http-equiv='refresh' content='2;URL=form_buku.php'>";

}

?>

Tampil Peminjam

<?

include"koneksi.php";

$ambil=mysql_query("select*from tpeminjam");

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

echo"<div align=center>

          <table border=0 width=46%>

                   <tr>

                             <td colspan=2>

                             <p align=center><b><font size=4 face=Comic Sans MS>Data

                             Peminjam</font></b></td>

                   </tr>

                   <tr>

                             <td width=17%><b><font face=Andalus>ID</font></b></td>

                             <td width=27%>&nbsp;$data[id]</td>

                   </tr>

                   <tr>

                             <td width=17%><b><font face=Andalus>NIM</font></b></td>

                             <td width=27%>&nbsp;$data[nim]</td>

                   </tr>

                   <tr>

                             <td width=17%><b><font face=Andalus>Nama</font></b></td>

                             <td width=27%>&nbsp;$data[nama]</td>

                   </tr>

                   <tr>

                             <td width=17%><b><font face=Andalus>Kode Buku</font></b></td>

                             <td width=27%>&nbsp;$data[kode_buku]</td>

                   </tr>

                   <tr>

                             <td width=17%><b>Tanggal Pinjam</b></td>

                             <td width=27%>&nbsp;$data[tgl_pinjam]</td>

                   </tr>

          </table>

</div>";

}

echo"<hr><a href=form_peminjam.php>Tambah Data Peminjam</a>";

?>

Form Peminjam

<?

include"form_peminjam.htm";

?>

Target Peminjam

<?

include"koneksi1.php";

$id=$_POST['id'];

$nim=$_POST['nim'];

$nama=$_POST['nama'];

$kode=$_POST['kode'];

//tanggal

$tgl=$_POST['tgl'];

$bulan=$_POST['bulan'];

$tahun=$_POST['tahun'];

if (strlen($bulan)==1){

          $bulan="0".$bulan;

}

$tgl=$tahun."-".$bulan."-".$tgl;

$masuk=mysql_query("insert into

tpeminjam(id,nim,nama,kode_buku,tgl_pinjam) values

('$id','$nim','$nama','$kode','$tgl')");

if($masuk){

echo"<center>OK Data Sudah Disimpan

<meta http-equiv='refresh' content='2;URL=tampil1.php'>";

}

else{

echo"<center>Data GAGAL Disimpan

<meta http-equiv='refresh' content='2;URL=form_peminjam.php'>";

}

?>

Tampil Kembali

<?

include"koneksi.php";

$ambil=mysql_query("select*from tkembali");

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

echo"<div align=center>

          <table border=0 width=52%>

                   <tr>

                             <td colspan=2>

                             <p align=center><font size=5>Inputan Data</font></td>

                   </tr>

                   <tr>

                             <td width=22%>ID</td>

                             <td width=40%>&nbsp;$data[id]</td>

                   </tr>

                   <tr>

                             <td width=22%>NIM</td>

                             <td width=40%>&nbsp;$data[nim]</td>

                   </tr>

                   <tr>

                             <td width=22%>Nama</td>

                             <td width=40%>&nbsp;$data[nama]</td>

                   </tr>

                   <tr>

                             <td width=22%>Kode Buku</td>

                             <td width=40%>&nbsp;$data[kode_buku]</td>

                   </tr>

                   <tr>

                             <td width=22%>Tanggal Kembali</td>

                             <td width=40%>&nbsp;$data[tgl_kembali]</td>

                   </tr>

          </table>

</div>";

}

echo"<hr><a href=form_kembali.php>Tambah Data Pengembalian</a>";

?>

Form Kembali

<?

include"form_kembali.htm";

?>

Target Kembali

<?

include"koneksi2.php";

$id=$_POST['id'];

$nim=$_POST['nim'];

$nama=$_POST['nama'];

$kode=$_POST['kode'];

//tanggal

$tanggal=$_POST['tanggal'];

$bulan=$_POST['bulan'];

$tahun=$_POST['tahun'];

if (strlen($bulan)==1){

          $bulan="0".$bulan;

}

$tanggal=$tahun."-".$bulan."-".$tanggal;

$masuk=mysql_query("insert into

tkembali(id,nim,nama,kode_buku,tgl_kembali) values

('$id','$nim','$nama','$kode','$tanggal')");

if($masuk){

echo"<center>OK Data Sudah Disimpan

<meta http-equiv='refresh' content='2;URL=tampil2.php'>";

}

else{

echo"<center>Data GAGAL Disimpan

<meta http-equiv='refresh' content='2;URL=form_kembali.php'>";

}

?>