Output_kedai
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
<title>output Kedai</title>
</head>
<body bgcolor=#000000 text=#FF0080>
<?
$koneksi=mysql_connect("localhost","root","password");
if(koneksi)
{
mysql_select_db("makanan");
echo"<pre>";
echo"<h1>Kedai Moengil:</h1>";
echo"<hr><b>";
echo"No Registrasi :$no<br>";
echo"Nama Pembeli :$nama<br>";
echo"Kode makanan :$kode<br>";
if($menu= "Pop Ice")
{
$harga= "10000";
}
else if($menu= "Jus")
{
$harga= "15000";
}
else if($menu= "Roti Bakar")
{
$harga= "8000";
}
else
{
$harga= "10000";
}
}
echo"Menu makanan :$menu<br>";
echo"Jumlah Pesan :$jumlah<br>";
echo"Harga :$harga<br>";
$total=($harga*$jumlah);
echo"<hr>";
$sqlstr="insert into kedai
values('$no',$nama','$kode','$menu','$harga','$jumlah','$total')";
$hasil=mysql_query($sqlstr,$koneksi);
echo<h1>";
echo"Sudah berhasil disimpan</h1>";
echo"<table border=1>";
echo"<tr><td>No Registrasi</td><td>Nama Pembeli</td><td>Kode Makanan</td><td
Menu Makanan</td><td>harga</td><td>Jumlah Pesan</td><td>Total</td></tr>";
sqlstr2=mysql_query("select*from kedai");
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_kedai.php">Lagi</a>
</body>
</html>
Tidak ada komentar:
Posting Komentar