Senin, 09 Januari 2012

WEB PROGRAMING I


PULSA KANAN KIRI OK
Input_buah.php










Output_buah.php



Data Base tugasyurry
Table pulsa

Table otomotif


Koneksi Terpisah Toko otomotif
Input_komputer.php

Kode Program
Input_buah.php
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Toko Buah Yurry Jaya</title>
</head>
<body bgcolor=orange><font color=blue>
<br>
<center><h1><font face="consolas">INPUT DATA PEMBELIAN</h1></font></center>
<hr><br>
<form action="output_buah.php" method="post">
<font face="Rockwell"><b>
<center><table border=1>
<tr><td>No Pelanggan      :</td>
    <td><input type="text" name=no></td></tr>
<tr><td>Nama Pelanggan    :</td>
    <td><input type="text" name=nama></td></tr>
<tr><td>Kode Buah         :</td>
    <td><select name=kode>
                        <option value="J01">J01</option>
                        <option value="M0">M02</option>
                        <option value="P01">P01</option>
                        </select></td></tr>
<tr><td>Jumlah Beli       :</td>
    <td><input type="text" name=jumlah></td></tr>
<tr><td><center><input type="submit" value=simpan></center></td> <td><center><input type="submit" value=simpan></center></td></tr>
<br>
</table></font></center>
<br>
<hr>
</body>
</html>





Output_buah.php
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Simpan Data</title>
</head>
<body bgcolor=#9FFF9F><font color=#004040>
<h1><font face="consolas">TOKO BUAH YURRY JAYA</h1></font>
<hr><br>
<?
if ($kode=="J01")
   {
       $nama="JAMBU";
       $harga=15000;
   }
else if ($kode=="M01")
   {
     $nama="MANGGA";
     $harga=25000;
   }
else
   {
       $nama="PISANG";
       $harga=45000;
   }
$total=$jumlah*$harga;
//tampilan output
           echo"<pre>";
           echo"<h1>Pulsa Kanan Kiri OK:</h1>";
           echo"<hr><b>";
           echo"<No Pelanggan      : $no<br>";
           echo"<Nama Pelanggan : $namapel<br>";
           echo"<Kode Buah          : $kode<br>";
           echo"<Nama Buah          : $nama<br>";
           echo"<hr>";
           echo"<Harga                   : $harga<br>";
           echo"<Jumlah Beli         : $jumlah<br>";
           echo"<Total                     : $total<br>";
//koneksi dan penyimpanan data ke data base
$koneksi=mysql_connect("localhost","root","password");
  if($koneksi)
  {
      mysql_select_db("tugasyurry");
      $sqlstr="Insert into buah values('$no','$nope','$kode','$nama','$harga','$jumlah','$total')";
      $hasil=mysql_query($sqlstr,$koneksi);
      echo"<h1>";
      echo"Sudah Berhasil Disimpan";
      echo"<table border=1>";
      echo"<tr><td> NO PELANGGAN </td><td> No HP </td><td> KODE </td><td> NAMA </td><td> HARGA </td><td> JUMLAH </td><td> TOTAL </td></tr>";
      $sqlstr2=mysql_query("select*from buah");
      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>";
      mysql_close($koneksi);
  }
      else
      echo"Tidak Berhasil";
?>
<br>
<a href="input_buah.php">Lagi</a>
</body>
</html>

Input_otomotif.php
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Toko Komputer Keras Lembek</title>
</head>
<body bgcolor=orange><font color=blue>
<br>
<center><h1><font face="consolas">INPUT DATA PEMBELIAN</h1></font></center>
<hr><br>
<form action="output_otomotif.php" method="post">
<font face="Rockwell"><b>
<center><table border=1>
<tr><td>No Pelanggan      :</td>
    <td><input type="text" name=no></td></tr>
<tr><td>Nama Pelanggan    :</td>
    <td><input type="text" name=nama></td></tr>
<tr><td>Kode              :</td>
    <td><select name=kode>
                        <option value="B01">B01</option>
                        <option value="K02">K02</option>
                        <option value="BL1">BL1</option>
                        </select></td></tr>
<tr><td>Jumlah Beli       :</td>
    <td><input type="text" name=jumlah></td></tr>
<tr><td><center><input type="submit" value=simpan></center></td> <td><center><input type="submit" value=simpan></center></td></tr>
<br>
</table></font></center>
<br>
<hr>
</body>
</html>




Koneksiku.php
<?
mysql_connect(“localhost”,”root”,”password”)
mysql_select_db(“tugasyurry”)
?>

Output_komputer.php
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Simpan Data</title>
</head>
<body bgcolor=#9FFF9F><font color=#004040>
<form action="input_otomotif.php" method="post">
<h1><font face="consolas">DATA TRANSAKSI OTOMOTIF</h1></font>
<hr><br>
<?
require("koneksiku.php");
if ($kode=="B01")
   {
       $nabar="BUSI";
       $harga=12000;
   }
else if ($kode=="K02")
   {
       $nabar="Kbel Koil";
       $harga=4500;
   }
else
   {
       $nabar="Ban Luar";
       $harga=120000;
   }
$total=$jumlah*$harga;
$simpan=mysql_query("Insert into otomotif values('$no','$nama','$kode','$nabar','$harga','$jumlah','$total')");
  if($simpan)
  {
      echo"Sudah Berhasil Disimpan";
      echo"<table border=1>";
      echo"<tr><td> NO PELANGGAN </td><td> Nama </td><td> KODE </td><td> NAMA BARANG </td><td> HARGA </td><td> JUMLAH </td><td> TOTAL </td></tr>";
      $sqlstr2=mysql_query("select*from otomotif");
      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>";
      mysql_close($koneksi);
  }
      else
      echo"Tidak Berhasil";
?>
<br>
<a href="input_otomotif.php">Lagi</a>
</body>
</html>