Hasil output yang koneksinya di gabungkan :
Hasil inputan
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
<title>BUTIK CHICHA HANDAYANI</title>
</head>
<body bgcolor=purple text=black>
<font face="arial">
<form action="output_butik.php" method="post">
<center><blink>
<h1><b>BUTIK CHICHA HANDAYANI</h1>
Jl.KH.MUCHTAR THABRANI NO.52<br>
TELP.(021)8888888 </center><b><br></blink>
<hr>
<?
require("koneksi.php");
echo"<pre>";
echo"No.Transaksi :$no<br>";
echo"Nama Petugas :$nama<br>";
echo"Nama Pembeli :$nabel<br>";
echo"Kode Pembelian :$kode<br>";
echo"Nama pakaian :$napa<br>";
if ($kode=="KMJ")
{
$jenis="kemeja";
if ($nape=="kemeja pria")
{
$harga=150000;
}
elseif ($nape=="kemeja wanita")
{
$harga=170000;
}
else
{
$harga=200000;
}
}
elseif ($kode=="BTK")
{
$jenis="batik";
if ($nape=="batik keris")
{
$harga=300000;
}
elseif ($nape="batik pekalongan")
{
$harga=250000;
}
else
{
$harga=300000;
}
}
else
{
$jenis="Baju Muslim";
if ($nape=="Baju Muslim Gamis")
{
$harga=400000;
}
else
{
$harga=450000;
}
}
echo"Harga :$harga<br>";
echo"Jumlah :$jumlah<br>";
$total=$jumlah*$harga;
echo"Total :$total<br>";
$simpan=mysql_query("Insert into butik
values('$no','$nama','$nabel','$kode','$napa','$jenis','$harga','$jumlah','$total')");
if ($simpan)
{
echo "<h1>";
echo "Sudah berhasil disimpan</h1>";
echo "<table border=1>";
echo "<tr><td>No.Pembelian</td><td>Nama Petugas</td><td>Nama Pembeli</td><td>Kode</td><td>Nama Pakaian</td><td>Jenis_pakaian</td><td>Harga</td><td>Jumlah</td><td>Total</td><tr>";
$sqlstr2=mysql_query("select*from butik");
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"<td>$hasil[7]</td>";
echo"<td>$hasil[8]</td>";
echo"<td>$hasil[9]</td>";
echo"<td>$hasil[10]</td>";
echo"</tr>";
}
echo"</table>";
mysql_close($koneksi);
}
else
echo "Tidak berhasil";
?>
<a href="input_butik.php">lagi</a>
</body>
</html>
<html>
<head>
<title>BUTIK CHICHA HANDAYANI</title>
</head>
<body bgcolor=purple text=black>
<font face="arial">
<form action="output_butik.php" method="post">
<center><blink>
<h1><b>BUTIK CHICHA HANDAYANI</h1>
Jl.KH.MUCHTAR THABRANI NO.52<br>
TELP.(021)8888888 </center><b><br></blink>
<hr>
<?
require("koneksi.php");
echo"<pre>";
echo"No.Transaksi :$no<br>";
echo"Nama Petugas :$nama<br>";
echo"Nama Pembeli :$nabel<br>";
echo"Kode Pembelian :$kode<br>";
echo"Nama pakaian :$napa<br>";
if ($kode=="KMJ")
{
$jenis="kemeja";
if ($nape=="kemeja pria")
{
$harga=150000;
}
elseif ($nape=="kemeja wanita")
{
$harga=170000;
}
else
{
$harga=200000;
}
}
elseif ($kode=="BTK")
{
$jenis="batik";
if ($nape=="batik keris")
{
$harga=300000;
}
elseif ($nape="batik pekalongan")
{
$harga=250000;
}
else
{
$harga=300000;
}
}
else
{
$jenis="Baju Muslim";
if ($nape=="Baju Muslim Gamis")
{
$harga=400000;
}
else
{
$harga=450000;
}
}
echo"Harga :$harga<br>";
echo"Jumlah :$jumlah<br>";
$total=$jumlah*$harga;
echo"Total :$total<br>";
$simpan=mysql_query("Insert into butik
values('$no','$nama','$nabel','$kode','$napa','$jenis','$harga','$jumlah','$total')");
if ($simpan)
{
echo "<h1>";
echo "Sudah berhasil disimpan</h1>";
echo "<table border=1>";
echo "<tr><td>No.Pembelian</td><td>Nama Petugas</td><td>Nama Pembeli</td><td>Kode</td><td>Nama Pakaian</td><td>Jenis_pakaian</td><td>Harga</td><td>Jumlah</td><td>Total</td><tr>";
$sqlstr2=mysql_query("select*from butik");
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"<td>$hasil[7]</td>";
echo"<td>$hasil[8]</td>";
echo"<td>$hasil[9]</td>";
echo"<td>$hasil[10]</td>";
echo"</tr>";
}
echo"</table>";
mysql_close($koneksi);
}
else
echo "Tidak berhasil";
?>
<a href="input_butik.php">lagi</a>
</body>
</html>
