Tugas Pemrograman Web Dinamis Part 2

Proyek sederhana .php
Membuat halaman jual beli online sederhana
Target:
1.Form Login Admin
2.Form Tambah,Edit,Hapus
3.Halaman Untuk User


Home.php

<p align='right'><a href='admin.php'>SILAHKAN MASUK </a> [[ADMIN ONLY]]</p>
<center><h2>DAFTAR BARANG <h2></center>
<table border="1" width="550" align="center" bgcolor=#000ff>
<tr>
    <td align="center"width=50 height=20 align="center" width=50><b>Kode</b></td>
    <td align="center" width=200><b>Nama Barang</b></td>
    <td align='center' width=300><b>Deskripsi</b></td>
    <td align='center' width=300><b>Harga</b></td>
</tr>
<?php
include "koneksi.php";
$qdata = mysql_query("select kode,nama,deskripsi, harga from data");
while($rdata = mysql_fetch_array($qdata))
{
    $kode = $rdata["kode"];
    $nama = $rdata["nama"];
    $deskripsi = $rdata["deskripsi"];
    $harga = $rdata["harga"];
    echo "<tr>
            <td align='center' >$kode</tad>
            <td>$nama</td>
            <td>$deskripsi</td>
            <td>Rp. $harga</td>
        </tr>";
}
?>

</table>

OUTPUT:

Admin.php

<?php
echo "<form method='post' action='form_barang.php' >";
echo "<table cellpadding='3' cellspacing='3' align='center' bgcolor=#fff0ff>
        <caption><strong><h3>SILAHKAN MASUK</h3></strong></caption></br>
            <tr>
                <td>Username</td>
                <td> <input type='text' name='username'></td>
            </tr>
            <tr>
                <td>Password</td>
                <td><input type='password' name='password'></td>
            </tr>
            <td></td><td><input type='submit' name='login' value='masuk'></td>
            </tr>";
echo "</table></form>";
?>

OUTPUT:

Form Barang.php

<?php  

echo "<form action='simpan.php' method='post'>";  

echo "<table cellpadding='3' cellspacing='3' align='center'>  

        <caption><strong><h3>Input Data Barang</h3></strong></caption></br>  

            <tr>  

                <td>Kode Barang</td>  

                <td> <input type='text' name='kode' size=8 ></td>  

            </tr>  

            <tr>  

                <td>Nama Barang</td>  

                <td><input type='text' name='nama'></td>  

            </tr>  

            <tr>  

                <td>Deskripsi</td>  

                <td><textarea name='deskripsi' cols=20 rows=2></textarea></td>  

            </tr>  

            <tr>  

                <td>Harga</td>  

                <td>Rp. <input type='text' name='harga'><td>  

            </tr>  

            <tr>  

            <td></td><td><input type='submit' name='simpan' value='TAMBAH'></td>  

            </tr>";  

echo "</table></form>";  

?>  

OUTPUT:

Simpan.php

<?php  

include "koneksi.php";  

    $kode = $_POST['kode'];  

    $nama = $_POST['nama'];  

    $deskripsi = $_POST['deskripsi'];  

    $harga = $_POST['harga']; 

    $insert = "INSERT INTO data (kode, nama, deskripsi, harga) VALUES('$kode','$nama','$deskripsi','$harga')";  

    $insert_query = mysql_query($insert);  

    if($insert_query){  

        echo "<script>alert('Insert data $kode berhasil..!!')</script>";  

        echo "<script >location.href='home.php';</script>";  

    }  

    else{  

        echo "<script>alert('Gagal insert $kode')</script>";  

        echo "<script >location.href='form_barang.php';</script>";  

        echo mysql_error();  

    }  

?>  

OUTPUT:

Setelah berhasil menambahkan data dari form data.php,kita akan langsung ditujukan ke halaman home.php lagi:

Edit.php

<?php

include “koneksi.php”;?>

<table border=”1″ width=”550″ align=”center”>

<tr><td height=20 align=”center” width=50><b>Kode</b></td>

<td align=”center” width=170><b>Nama Barang</b></td>

<td align=’center’ width=250><b>deskripsi</b></td>

<td align=’center’ width=80><b>Harga</b></td>

</tr>

<?php

if($kirim_edit==1)

{

$query3 = “update data set kode=’$kode’, nama=’$nama’, deskripsi=’$deskripsi’, harga=’$harga’

where kode=’$kodeg’”;

mysql_query($query3);

}

$i=0;

$qdata = mysql_query(“select kode,nama,deskripsi,harga from data order by kode”);

while($rdata = mysql_fetch_array($qdata))

{

$pkode = $rdata["kode"];

$pnama = $rdata["nama"];

$pketerangan = $rdata["deskripsi"];

$pharga = $rharga["harga"];

echo “<tr><td align=’center’>$pkode</td>

<td>$pnama</td>

<td>$pketerangan</td>

<td>$pharga</td>

<td align=’center’><a href=’edit.php?kode=$pkode&edit=1′>Edit</a></td></tr>”;

$i++;

}?>

</table>

<br>

<?php

if($edit==1)

{

$qdata2 = mysql_query(“select nama, deskripsi, harga from data where kode=’$kode’”);

while($rdata2 = mysql_fetch_array($qdata2))

{

$nama2 = $rdata2["nama"];

$keterangan2 = $rdata2["deskripsi"];

$harga2 = $rdata2["harga"];

}

echo “<p align=’center’>Ubah Data Barang <br><br>”;

echo “<form method=’post’ action=’edit_barang.php’>

<input type=’hidden’ name=’kodeg’ value=’kode’>

<input type=’hidden’ name=’kirim_edit’ value=1>”;

echo “<table border=0 width=500 align=’center’>”;

echo “<tr><td width=150>Kode </td>

<td><input type=’text’ name=’kode’ size=4 value=’kode’></td></tr>

<tr><td>Nama Barang </td>

<td><input type=’text’ name=’nama’ size=40 value=’nama2′></td></tr>

<tr><td valign=’middle’>deskripsi </td>

<td><textarea name=’definisi’ cols=40 rows=6>deskripsi2</textarea></td></tr>

<tr><td>Harga</td>

<td><input type=’text’ name=’harga’ size=40 value=’harga2′></td></tr>

<tr><td colspan=2 align=’center’><input type=’submit’ value=’EDIT’></td></tr>”;

echo “</table></form></p>”;

}

?>

[________________________________________________________________________________]

Hapus.php

<?php include "koneksi.php"; ?>

<table border="1" width="550" align="center">

<tr><td height=20 align="center" width=50><b>KODE</b></td>

<td align="center" width=170><b>NAMA</b></td>

<td align='center' width=250><b>DESKRIPSI</b></td>

<td align='center' width=80><b>HARGA</b></td></tr>

<?php

$hapus = (!empty($_GET['hapus']) ? $_GET['hapus'] : ");

if($hapus==1)

{

$kode = '$_GET[kode]';

$query2 = "delete from data where kode='$kode'";

mysql_query($query2);

}

$qdata= mysql_query("select kode,nama,deskripsi,harga from data order by kode");

$i = 0;

while($rdata= mysql_fetch_array($qdata))

{

$pkode= $rdata["kode"];

$pnama= $rdata["nama"];

$pdeskripsi= $rdata["deskripsi"];

$pharga= $rharga["harga"];

echo "<tr><td align='center'>$pkode</td><td >$pdeskripsi</td>

<td>$pnama_barang</td><td>$pharga</td><td align='center'>

<a href='hapus_data.php?kode=$pkode&hapus=1'>Hapus</a></td></tr>";

$i++;

}?>

        SEKIAN DAN TERIMA KASIH ATAS PERHATIANNYA,SEMOEGA BERMANFAAT

[_______________________________________________________________________________]

Tugas Pemrograman Web Dinamis Part 1

Koneksi Database.php:

Membuat Form:

Outputnya:

Simpan:

  

  

Output:

Daftar Data:

 

Output:

Edit:
_________________________________________________________________________________

<?php include "koneksi.php";?>

<table border="1" width="550" align="center">

<tr><td height=20 align="center" width=50><b>Kode</b></td>

<td align="center" width=170><b>Nama Penyakit</b></td>

<td align='center' width=250><b>Definisi</b></td>

<td align='center' width=80><b>Fungsi</b></td>

</tr>

<?php

$kirim_edit = (!empty($_GET['kode']) ? $_GET['kode'] : '');

$edit = (!empty($_GET['edit']) ? $_GET['edit'] : '');

if($kirim_edit==1)

{

$query3 = "update penyakit set kode='$kode_penyakit',

nama='$nama_penyakit', definisi='$definisi'

where kode='$kodeg'";

mysql_query($query3);

}

$i=0;

$qdata = mysql_query("select kode,nama,definisi from penyakit order by kode");

while($rdata = mysql_fetch_array($qdata))

{

$pkode = $rdata["kode"];

$pnama = $rdata["nama"];

$pdefinisi = $rdata["definisi"];

echo "<tr><td align='center'>$pkode</td><td >$pnama</td>

<td>$pdefinisi</td><td align='center'>

<a href='edit_data.php?kode=$pkode&edit=1'>Edit</a></td></tr>";

$i++;

}?>

</table>

<br>

<?php if($edit==1)

{

    $kode = $kirim_edit;

$qdata2 = mysql_query("select nama, definisi from penyakit where kode='$kode'");

while($rdata2 = mysql_fetch_array($qdata2))

{

$nama2 = $rdata2["nama"];

$definisi2 = $rdata2["definisi"];

}

echo "<p align='center'>Ubah Data Penyakit <br><br>";

echo "<form method='post' action='edit_data.php'>

<input type='hidden' name='kodeg' value='$kode'>

<input type='hidden' name='kirim_edit' value=1>";

echo "<table border=0 width=500 align='center'>";

echo "<tr><td width=150>Kode Penyakit </td><td><input type='text' name='kode_penyakit' size=4 value='$kode'></td></tr>

<tr><td>Nama Penyakit </td>

<td><input type='text' name='nama_penyakit' size=40 value='$nama2'></td></tr>

<tr><td valign='middle'>Definisi Penyakit </td>

<td><textarea name='definisi' cols=40 rows=6>$definisi2</textarea></td></tr>

<tr><td colspan=2 align='center'><input type='submit' value='EDIT'></td></tr>";

echo "</table></form></p>";

}

?>

  _________________________________________________________________________________

Output:

Yang terakhir adalah menghapus data:

Output: 

 

Semoega bermanfaat....Terima Kasih !!