Rabu, 04 Januari 2012

MATERI WEB PROGRAMMING

//TAMPILAN INPUT KONEKSI TERPISAH


//LISTING INPUT KONEKSI TERPISAH
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Input Toko</title>
</head>
<body bgcolor=red text=black>
<form action="outputberas.php" method="post">
<center><blink><b><h1><font face="arial" size=14>***TOKO BERAS MAKMUR***</font></b></blink><br>
Jl.KH.Agus Salim No.101<br>
Bekasi Timur<br>
17111<br>
-------------------------------------------------------------------------------------------------<br><p>
<table border=6>
<tr>
    <td rowspan=10 width=30><img src="mane-image.jpg" height=200></td>
</tr>
   <td>No Pembelian     : </td>
   <td><input type="text" name="nopembeli"></td></tr>
<tr>
   <td>Nama Pembeli   : </td>
   <td><input type="text" name=namapembeli></td></tr>
<tr>
   <td>Alamat           : </td>
   <td><textarea rows=1 name=alamat></textarea></td></tr>
<tr>
   <td>Kode Beras      : </td>
   <td><select name="kode">
       <option value="B001">B001</option><br>
       <option value="B002">B002</option><br>
       <option value="B003">B003</option><br></select></td></tr>
<tr>
   <td>Kode Ukuran Beras      : </td>
       <td><input type="radio" name="kouk" value="1">1<br>
           <input type="radio" name="kouk" value="2">2<br>
           <input type="radio" name="kouk" value="3">3<br></td>
</tr>
<tr>
<td>Jumlah Beli      : </td>
   <td><input type="text" name="jumlah" size=5 maxlength=3>Karung</td>
</tr>
<tr>
<td><input type="submit" name="Cetak" value="Cetak"><input type="submit" name="Batal" value="Batal"></td></tr>
</center></table>
</body>
</html>


//TAMPILAN OUTPUT KONEKSI TERPISAH




//Listing Koneksi :

<?
mysql_connect("localhost","root","password");
mysql_select_db("gie_12094624");
?>





//LISTING OUTPUT KONEKSI TERPISAH

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Output Toko</title>
</head>
<body bgcolor=red text=black>
<form action="output-beras.php" method="post">
<center><blink><b><h1><font face="arial" size=14>***TOKO BERAS MAKMUR***</font></b></blink><br>
Jl.KH.Agus Salim No.101<br>
Bekasi Timur<br>
17111<br>
-------------------------------------------------------------------------------------------------<br></center><p>
<?
require("koneksi.php");
if($kode=="B001")
{
    $jenisberas="ROJO LELE";
    if ($kouk=='1')
    {
        $ukuran="50Kg";
        $harga=550000;
    }
    elseif($kouk=='2')
    {
        $ukuran="25Kg";
        $harga=275000;
    }
    else
    {
        $ukuran="10Kg";
        $harga=175000;
    }
}
elseif ($kode=="B001")
{
    $jenisberas="PANDAN WANGI";
    if ($kouk=='1')
    {
        $ukuran="50Kg";
        $harga=600000;
    }
    elseif($kouk=='2')
    {
        $ukuran="25Kg";
        $harga=300000;
    }
    else
    {
        $ukuran="10";
        $harga=180000;
    }
}
else
{
    $jenisberas="RAJA BERAS";
    if ($kouk=='1')
    {
        $ukuran="50Kg";
        $harga=450000;
    }
    elseif($kouk=='2')
    {
        $ukuran="25Kg";
        $harga=300000;
    }
    else
    {
        $ukuran="10Kg";
        $harga=130000;
    }
}
$total=($harga*$jumlah);
echo"<pre>";
echo "No Pembelian      : $nopembeli<br>";
echo "Nama Pembeli      : $namapembeli<br>";
echo "Alamat            : $alamat<br>";
echo "Kode Beras        : $kode<br>";
echo "Jenis Beras       : $jenisberas<br>";
echo "Ukuran            : $ukuran<br>";
echo "Harga             : $harga<br>";
echo "Jumlah Beli       : $jumlah<br>";
echo "********************************************<br>";
echo "Total             :Rp. $total<br>";
echo "********************************************<br>";
echo"</pre>";
$simpan=mysql_query("insert into beras values('$nopembeli','$namapembeli','$alamat','$jenisberas','$harga','$jumlah','$total')");
if($simpan)
{
echo"Data Sudah Berhasil Disimpan</h1>";
echo"<table border=1 bgcolor=#FFFFFF>";
echo"<tr><td>No Pembelian</td><td>Nama Pembeli</td><td>Alamat</td><td>Jenis Beras</td><td>Harga</td><td>Jumlah</td><td>Total Harga</td></tr>";
$sqlstr2=mysql_query("select*from beras");
while($hasil=mysql_fetch_row($sqlstr2))
{
    echo "<tr>";
    echo "<td>$hasil[0]</td>";
    echo "<td>$hasil[1]</td>";
    echo "<td>$hasil[2]</td>";
    echo "<td>$hasil[3]</td>";
    echo "<td>$hasil[4]</td>";
    echo "<td>$hasil[5]</td>";
    echo "<td>$hasil[6]</td>";
    echo"</tr>";
}
echo"</table>";
}
else
echo "Tidak Berhasil";
?>
<br>
<a href="inputberas.php">Lagi</a>
</body>
</html>


//TAMPILAN DATA BASE :


Diposting oleh di

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)