http://www.4shared.com/folder/MjFMEOIf/_online.html
1.KONEKSI BERSAMBUNG
"Tampilan input"
input_tas.php
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
<title>input Toko Tas</title>
</head>
<body bgcolor=black text=red>
<form action="output_tas.php" method="post">
<marquee behavior="alternate">
<h1><b><blink>"TOKO TAS JAWIR"</blink></h1>
</marquee>
Telp : 087875200777<br>
jl.jawa no.05 Bekasi Utara<br>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
<table size=100% border=2>
<tr>
<td rowspan=8 width=5%></td>
<td>Nama Penjual :</td>
<td><input type="text" name="napen" size=30 maxlength=20></td></tr>
<tr>
<td>Alamat :</td>
<td><textarea rows=3 name="alamat"></textarea></tr>
<tr>
<td>Nama Pembeli :</td>
<td><input type="text" name="napem" size=30 maxlength=20></td></tr>
<tr>
<td>Kode Tas :</td>
<td><select name="kode">
<option value="NK01">NIKE</option><br>
<option value="AD02">ADIDAS</option><br>
<option value="PL03">POLLO</option><br></select></tr>
<tr>
<td>Kode Ukuran :</td>
<td><input type="radio" name="koukur" value="B">B<br>
<input type="radio" name="koukur" value="K">K<br>
<input type="radio" name="koukur" value="S">S<br></td></tr>
<tr>
<td>Jumlah Beli :</td>
<td><input type="text" name="jumlah" size=5 maxlength=5>Buah</td></tr>
<tr>
<td>Tanggal Beli :</td>
<td><select name="tgl"><option value=0 selected>tanggal
<?
for($i=1;$i<=31;$i++)
echo"<option value=$i>$i";
?>
</option></select>
<select name="bln"><option value=0 selected>bulan
<?
for($i=1;$i<=12;$i++)
echo"<option value=$i>$i";
?>
</option></select>
<select name="thn"><option value=0 selected>tahun
<?
for($i=2000;$i<=2012;$i++)
echo"<option value=$i>$i";
?>
</option></select></tr>
<tr>
<td colspan=2><input type="submit" name="simpan" value="simpan"><input type="reset" name="batal" value="batal"></td></tr>
</body>
</html>
"Tampilan Output"
Output_tas.php
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
<title>output Toko Tas Jawir</title>
</head>
<body bgcolor=black text=Red>
<marquee behavior="alternate">
<h1><b><blink>"TOKO TAS JAWIR"</blink></h1>
</marquee>
<center><td rowspan=8 width=5%></td></center>
*****************************************<p>
struk pembayaran :</b>
<?
if($kode=="NK01")
{
$merk="NK01";
if($koukur=='B')
{
$ukuran="Besar";
$harga=350000;
}
else if($koukur=='K')
{
$ukuran="Kecil";
$harga=200000;
}
else
{
$ukuran="Sedang";
$harga=250000;
}
}
else if($kode=="AD02")
{
$merk="ADIDAS";
if($koukur=='B')
{
$ukuran="Besar";
$harga=310000;
}
else if($koukur=='K')
{
$ukuran="Kecil";
$harga=210000;
}
else
{
$ukuran="Sedang";
$harga=260000;
}
}
else
{
$merk="POLLO";
if($koukur=='B')
{
$ukuran="Besar";
$harga=365000;
}
else if($koukur=='K')
{
$ukuran="Kecil";
$harga=260000;
}
else
{
$ukuran="Sedang";
$harga=320000;
}
}
$koneksi=mysql_connect("localhost","root","password");
if($koneksi)
{
mysql_select_db("tugas_12094861");
echo"<pre>";
echo"***************************************<br>";
echo"nama penjual :$napen<br>";
echo"alamat :$alamat<br>";
echo"nama pembeli :$napem<br>";
echo"kode Tas :$kode<br>";
echo"Merk Tas :$merk<br>";
echo"ukuran :$ukuran<br>";
echo"harga :Rp.$harga<br>";
echo"jumlah beli :$jumlah<br>";
echo"=======================================<br>";
$total=($harga*$jumlah);
echo"total bayar :Rp.$total<p>";
$sqlstr="insert into toko_tas values('$napen','$alamat','$napem','$kode','$ukuran','$harga','$jumlah','$total')";
$hasil=mysql_query($sqlstr,$koneksi);
echo"<h1>";
echo"sudah berhasil disimpan</h1>";
echo"<table border=1>";
echo"<tr><td>nama penjual</td><td>alamat</td><td>nama pembeli</td><td>kode tas</td><td>ukuran</td><td>harga</td><td>jumlah beli</td><td>total bayar</td></tr>";
$sqlstr2=mysql_query("select*from toko_tas");
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"</tr>";
}
echo"</table>";
mysql_close($koneksi);
}
else
echo"tidak berhasil";
echo"==================TERIMA KASIH ATAS KUNJUNGAN ANDA======================<br>";
echo gmdate("Y-m-d H:i:s", time()+60*60*7); //menampilkan jam GMT+7
?>
</tr></td></table><br>
<a href="input_tas.php">lagi</a>
</body>
</html>
"tampilan database"
"hasil browse"
2. KONEKSI TERPISAH
"Tampilan Input Studio"
input_studio.php
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
<title>input studio music</title>
</head>
<body bgcolor= black text="green">
<form action="output_studio.php" method="post">
<marquee behavior="alternate">
<h1><b><blink>"*" STUDIO MUSIC D'JAVA "*"</blink></h1>
</marquee>
JL.Marangan NO.25 <br>
Telp : 021-999993<br>
<============================================>
<table size=100% border=12>
<tr>
<td>No.Daftar :</td>
<td><input type="text" name="no" size=20 maxlength=20></td>
<td rowspan=8 width=5%></td></tr>
<tr>
<td>Nama Penyewa :</td>
<td><input type="text" name="nama" size=30 maxlength=20></td></tr>
<tr>
<td>Kelas :</td>
<td><select name="kelas">
<option value="medium">medium</option><br>
<option value="small">small</option><br>
<option value="large">large</option><br></select></tr>
<tr>
<td>pilih waktu :</td>
<td><input type="radio" name="pilih" value="1">1.pagi<br>
<input type="radio" name="pilih" value="2">2.siang<br>
<input type="radio" name="pilih" value="3">3.malam<br></td></tr>
<tr>
<td>lama sewa :</td>
<td><input type="text" name="lama" size=5 maxlength=5>jam</td></tr>
<tr>
<td>tanggal sewa :</td>
<td><select name="tgl"><option value=0 selected>tanggal
<?
for($i=1;$i<=31;$i++)
echo"<option value=$i>$i";
?>
</option></select>
<select name="bln"><option value=0 selected>bulan
<?
for($i=1;$i<=12;$i++)
echo"<option value=$i>$i";
?>
</option></select>
<select name="thn"><option value=0 selected>tahun
<?
for($i=2000;$i<=2012;$i++)
echo"<option value=$i>$i";
?>
</option></select></tr>
<tr>
<td colspan=2><input type="submit" name="simpan" value="simpan"><input type="reset" name="batal" value="batal"></td></tr>
</body>
</html>
"
"Tampilan Output Studio"
Output_studio.php
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
<title>output studio music </title>
</head>
<body bgcolor= black text="green">
<marquee behavior="alternate">
<h1><b><blink>"*" STUDIO MUSIC D'JAVA "*"</blink></h1>
</marquee>
<center><td rowspan=8 width=5%></td></center>
*****************************************<p>
JL.Marangan NO.25 <br>
Telp : 021-999993<br>
struk pembayaran :</b>
==========================================>>>>>><br>
<?
require("koneksiku.php");
switch($pilih)
{
case"1":{$waktu="pagi";$harga=75000;}break;
case"2":{$waktu="siang";$harga=85000;}break;
case"3":{$waktu="malam";$harga=95000;}break;
default:{$waktu="belum dipilih";$harga=0;}break;
}
$simpan=mysql_query("insert into studio values('$no','$nama','$waktu','$lama','$harga')");
if($simpan)
{
echo"<h1>data sudah berhasil disimpan</h1>";
echo"<table border=1>";
echo"<tr><td>no daftar</td><td>nama penyewa</td><td>waktu</td><td>lama sewa</td><td>harga</td></tr>";
$sqlstr2=mysql_query("select*from studio");
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"</tr>";
}
echo"</table>";
mysql_close($koneksi);
}
else
echo"tidak berhasil";
?>
<a href="input_studio.php">lagi</a>
</body>
</html>
"Koneksiku.php"
<?
mysql_connect("localhost","root","password");
mysql_select_db("tugas_12094861");
?>
"Tampilan Database"
"Hasil Browse"