Rabu, 04 Januari 2012

MATERI WEB PROGRAMMING II

//TAMPILAN INPUT KONEKSI DI DALAM :


//LISTING INPUT KONEKSI DI DALAM
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Input Toko Beras</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><p>
<table border=8>
<tr>
    <td rowspan=10 width=30><img src="mane-image.jpg" height=200></td>
</tr>
    <td>No Pembeli </td>
    <td><input type="text" name=nopembeli></td>
</tr>
<tr>
    <td>Nama Pembeli </td>
    <td><input type="text" name=namapembeli></td>
</tr>
<tr>
    <td>Jenis Beras</td>
    <td><input type="radio" name="kode" value="1">1.ROJO LELE<br>
        <input type="radio" name="kode" value="2">2.PANDAN WANGI<br>
        <input type="radio" name="kode" value="3">3.RAJA BERAS<br></td>
</tr>
<tr>
    <td><input type=submit name=Proses value=Proses></td>
    <td><input type=reset name=Bersih value=Bersih>
</td></tr>
</table>
</body>
</html>


//TAMPILAN OUTPUT KONEKSI DI DALAM




//LISTING OUTPUT KONEKSI DI DALAM

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Output Toko Beras</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></center><p>
<?
   switch($kode)
    {
        case"1":$jenisberas="ROJO LELE";
        $harga=550000;
        break;
        case"2":$jenisberas="PANDAN WANGI";
        $harga=650000;
        break;
        case"3":$jenisberas="RAJA BERAS";
        $harga=450000;
        break;
        default:$jenisberas="BELUM DIPILIH";
        $harga=0;
        break;
    }
    echo "<pre>";
    echo "<hr><b>";
    echo "No Pembeli                           :$nopembeli<br>";
    echo "Nama Pembeli                         :$namapembeli<br>";
    echo "Jenis Beras                          :$jenisberas<br>";
    echo "Harga                                :$harga<br>";
    echo "<hr>";
$koneksi=mysql_connect("localhost","root","password");
    if($koneksi)
    {
      mysql_select_db("gie_12094624");
     $sqlstr="Insert into beli values('$nopembeli','$namapembeli','$jenisberas','$harga')";
     $hasil=mysql_query($sqlstr,$koneksi);
     echo "<h1>";
     echo "Sudah Berhasil Disimpan</h1>";
     echo"<table border=1 bgcolor=#FFFFFF>";
echo"<tr><td>No Pembeli</td><td>Nama Pembeli</td><td>Jenis Beras</td><td>Harga</td></tr>";
$sqlstr2=mysql_query("select*from beli");
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"</tr>";
}
echo"</table>";
     mysql_close($koneksi);
}
else
echo "Tidak Berhasil";
?>
<br>
<a href="input-beras.php">Beli Lagi</a>
</body>
</html>




//TAMPILAN DATABASE :

Tidak ada komentar:

Posting Komentar