Sistem Informasi Penjualan Obat
Uploaded by
Ady AeysSistem Informasi Penjualan Obat
Uploaded by
Ady AeysLISTING PROGRAM
Script tampilan menu utama
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head><meta
charset=utf-8" />
http-equiv="Content-Type"
content="text/html;
<title>SI Penjualan Obat</title></head><body bgcolor="#CCCCCC">
<table width="976" border="0" align="center" >
<tr>
<td colspan="2" bgcolor="#666666"><img src="gambar/[Link]"
width="971" height="200" /></td>
</tr>
<tr>
<td height="6" colspan="2" bgcolor="#339933" > </td>
</tr>
<tr>
<td width="200" height="300" align="center" bgcolor="#FFFFFF"
valign="top" ><? include "[Link]";?><br><br><? include
"[Link]";?><br><br><? include "[Link]";?><? include "[Link]";?
><br><br><? include "[Link]";?></td><td width="767"
height="300"
align="center"
bgcolor="#FFFFFF"><?
include
"[Link]";?> </td>
</tr>
<tr>
<td
height="25"
colspan="2"
bgcolor="#FF9933"><font
color="#FFFFFF" face="Palatino Linotype, Book Antiqua, Palatino,
serif"><marquee> Sistem Informasi Penjualan Obat Pada Apotek
Nauli </marquee></font></td>
</tr>
</table>
</body>
</html>
Script menu Login
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link] httpequiv="Content-Type" content="text/html; charset=utf-8" /><title>SI
Penjualan Obat</title></head>
<body
bgcolor="#CCCCCC"><table
align="center" >
width="976"
border="0"
<tr>
<td colspan="2" bgcolor="#666666"><img src="gambar/[Link]"
width="971" height="200" /></td>
</tr>
<tr>
<td height="6" colspan="2" bgcolor="#339933" > </td>
</tr>
<tr>
<td width="200" height="300" align="center" bgcolor="#FFFFFF"
valign="top" ><? include "[Link]";?><br><br><? include
"[Link]";?><br><br><? include "[Link]";?><? include "[Link]";?
><br><br><? include "[Link]";?></td>
<td width="767" height="300" align="center" bgcolor="#FFFFFF">
<form
method="post"
action="[Link]"><table
align="center"width="254"
#999999 ">
border="0"
style="border:1px
solid
<tr style="font-family:'Comic Sans MS', cursive"><td height="30"
colspan="2"bgcolor="#FF9933"align="center"><font
color="#FFFFFF">Login</font></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr
style="font-family:'Comic
width="85">User Name</td>
Sans
MS',
cursive">
<td
<td width="145"><input type="text" value="" name="user" /></td>
</tr>
<tr>
<td style="font-family:'Comic Sans MS', cursive">Password</td>
<td><input type="password" value="" name="pass" /></td>
</tr>
<tr>
<td> </td><td><table width="130" border="0">
<tr>
<td
width="124"><input
name="login" />
type="submit"
value="Login"
<input type="reset" value="Batal" name="batal" /></td>
</tr>
</table>
</td>
</tr>
<tr>
<td
height="30"
align="center"> </td>
colspan="2"
bgcolor="#FF9933"
</tr>
</table>
</form>
</td>
</tr>
<tr>
<td
height="25"
colspan="2"
bgcolor="#FF9933"><font
color="#FFFFFF" face="Palatino Linotype, Book Antiqua, Palatino,
serif"><marquee>Aplikasi
Penjualan
Obat
Pada
Apotek
Nauli</marquee>
</font></td>
</tr>
</table>
</body>
</html>
Keranjang belanja
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf8" />
<title>SI Penjualan Obat</title>
</head>
<body bgcolor="#CCCCCC">
<table width="976" border="0" align="center" >
<tr>
<td colspan="2" bgcolor="#666666"><img src="gambar/[Link]"
width="971" height="200" /></td>
</tr>
<tr>
<td height="6" colspan="2" bgcolor="#339933" > </td>
</tr>
<tr>
<td width="200" height="300" align="center" bgcolor="#FFFFFF"
valign="top" ><? include "[Link]";?>
<br><br><? include "[Link]";?><br><br><? include "[Link]";?
><? include "[Link]";?><br><br><? include "[Link]";?
></td><td
width="767"
height="300"
align="center"
bgcolor="#FFFFFF" valign="top"><?
session_start();
if(!isset($_SESSION['user'])){?>
<script
language="javascript">alert('Maaf
Anda
Dulu!!');[Link]='[Link]'</script><?
Harus
Login
exit;
}
else
{
include"[Link]";
$sqll=mysql_query("select * from obat where KD_OBAT='$kdobat'");
$ada=mysql_fetch_array($sqll);
if($ada['JUMLAH_STOK']<=0)
{
?><script
language="javascript">alert('Maaf
Stok
Habis!!');[Link]="[Link]"</script><?
sudah
break;
}
?>
<?
$sql=mysql_query("SELECT
pemesanan");
MAX(NO_PEMESANAN)
$Q=mysql_fetch_array($sql);$c=mysql_query("SELECT
MAX(NO_PEMESANAN) as j FROM keranjang");
$cc=mysql_fetch_array($c);
$cek=$Q['jm']-1;
if ($cek=$cc['j'])
{
$P=$Q['jm'];
}
else
{
$P=$Q['jm']+1;
}
$tanggal=date('d-M-Y');
?>
<?
as
jm
FROM
{
include"[Link]";
$sqll=mysql_query("select
KD_OBAT='$kdobat'");
from
keranjang
where
$cb=mysql_query("select * from obat where KD_OBAT='$kdobat'");
$harga=mysql_fetch_array($cb);
$hargaok=$harga['HARGA_JUAL'];
$ada=mysql_fetch_array($sqll);
if ($ada)
{
$JML=$ada['JUMLAH_PEMESANAN']+1;
$kd=$hargaok*$JML;
$UPDATE=mysql_query("UPDATE
keranjang
JUMLAH_PEMESANAN='$JML',
SUB_TOTAL_HARGA='$kd'
KD_OBAT='$kdobat'");
SET
where
$updateobat=mysql_query("update
pemesanan
JUMLAH_PEMESANAN='$JML',SUB_TOTAL_HARGA='$kd'
KD_OBAT='$kdobat' && NO_PEMESANAN='$P'");
set
where
$sqll=mysql_query("select * from obat where KD_OBAT='$kdobat'");
$ada=mysql_fetch_array($sqll);
if ($ada)
{
$JML=$ada['JUMLAH_STOK']-1;
$UPDATE=mysql_query("UPDATE obat SET JUMLAH_STOK='$JML' where
KD_OBAT='$kdobat'");
}
}
{
?>
<?php
{
$sq="select *from obat where KD_OBAT='$kdobat'";
$sql=mysql_query($sq);
$a=mysql_fetch_array($sql);
$aa=$a['HARGA_JUAL'];
$jumlah=1;
$totalharga=$jumlah*$a['HARGA_JUAL'];
?>
<?
$sql="insert
into
keranjang
(NO_PEMESANAN,TANGGAL,NO_KONSUMEN,JUMLAH_PEMESANAN,SUB_
TOTAL_HARGA,KD_OBAT) values
('$P','$tanggal','$P','$jumlah','$totalharga','$kdobat')";
$hasil=mysql_query($sql);
if($hasil)
{
$sqll=mysql_query("select * from obat where KD_OBAT='$kdobat'");
$ada=mysql_fetch_array($sqll);
if ($ada)
{
$JML=$ada['JUMLAH_STOK']-1;
$UPDATE=mysql_query("UPDATE obat SET JUMLAH_STOK='$JML' where
KD_OBAT='$kdobat'");
$ok="insertinto
pemesanan(NO_PEMESANAN,TANGGAL,NO_KONSUMEN,JUMLAH_PEMES
ANAN,SUB_TOTAL_HARGA,KD_OBAT,STATUS) values
('$P','$tanggal','$P','$jumlah','$totalharga','$kdobat','Belum Terkirim')";
$sip=mysql_query($ok);
}}
?>
<table width="713" border="0" style="border:1px solid #CCCCCC">
<tr>
<td
height="30"
colspan="4"
align="center"
bgcolor="#FF9933"><font size="3" face="Comic Sans MS, cursive"
color="#FFFFFF">Keranjang Belanja</font></td>
</tr>
<tr><td width="707"><br>
<font face="Times New Roman, Times, serif" size="2">
<table align="center" border="0" width="710" style="border:1px solid
#666">
<tr bgcolor="#FF9933">
<th width="27" height="23" style="border:1px solid #666">No</th>
<th width="68" style="border:1px solid #666">Gambar</th>
<th width="69" style="border:1px solid #666">Kode</th>
<th width="79" style="border:1px solid #666">Nama </th>
<th width="86" style="border:1px solid #666">Jenis </th>
<th width="82" style="border:1px solid #666">Harga</th>
<th width="53" style="border:1px solid #666">Jumlah</th>
<th width="88" style="border:1px solid #666">Total Harga</th>
<th width="118" style="border:1px solid #666">Action</th>
</tr>
<?php
{
$sq="select
[Link],keranjang.KD_OBAT,obat.NAMA_OBAT,obat.JENIS_OBAT,o
bat.HARGA_JUAL,keranjang.JUMLAH_PEMESANAN,
keranjang.SUB_TOTAL_HARGA
from
keranjang.KD_OBAT=obat.KD_OBAT";
keranjang,obat
where
$sql=mysql_query($sq);
$a=0;
while($tampil=mysql_fetch_array($sql))
{
$a++;
?>
<tr>
<td ><?php echo"$a";?></td>
<td ><?php echo"<img src='download/$tampil[GAMBAR]' width='30'
height='20'>"; ?></td>
<td ><?php echo"$tampil[KD_OBAT]"; ?></td>
<td ><?php echo"$tampil[NAMA_OBAT]"; ?></td>
<td ><?php echo"$tampil[JENIS_OBAT]"; ?></td>
<td ><?php echo"$tampil[HARGA_JUAL]"; ?></td>
<td ><?php echo"$tampil[JUMLAH_PEMESANAN]"; ?></td>
<td ><?php echo"$tampil[SUB_TOTAL_HARGA]"; ?></td>
<td align="center"><a href="[Link]?kdobat=<?php
echo"$tampil[KD_OBAT]";?>&&
&jmlpemesanan=<?
echo"$tampil[JUMLAH_PEMESANAN]";?>&&
echo"$P"; ?>">Batal</a></strong></td></tr>
&nopemesanan=<?
<?php
}}
?>
</table></font>
</td>
</tr>
<tr>
<td height="36" align="right">
<a href="[Link]?kdobat=<? echo"KD_OBAT";?>">Lanjut
Belanja</a> <a
href="[Link]?nokonsumen=<?
echo"$P"; ?>">Selesai</a>
</td></tr>
</table>
<? }}}}?>
</td>
</tr>
<tr>
<td
height="25"
colspan="2"
bgcolor="#FF9933"><font
color="#FFFFFF" face="Palatino Linotype, Book Antiqua, Palatino,
serif"><marquee>Aplikasi
Penjualan
Obat
Pada
Apotek
Nauli</marquee></font></td>
</tr>
</table>
</body>
</html>
Cara pembayaran
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf8" />
<title>SI Penjualan Obat</title>
</head>
<body bgcolor="#CCCCCC">
<table width="976" border="0" align="center" >
<tr>
<td colspan="2" bgcolor="#666666"><img src="gambar/[Link]"
width="971" height="200" /></td>
</tr>
<tr>
<td height="6" colspan="2" bgcolor="#339933" > </td>
</tr>
<tr>
<td width="200" height="300" align="center" bgcolor="#FFFFFF"
valign="top" ><? include "[Link]";?><br><br><? include
"[Link]";?><br><br><? include "[Link]";?><? include "[Link]";?
><br><br><? include "[Link]";?></td><td width="767"
height="300"
align="center"
bgcolor="#FFFFFF"><table
align="center"width="757"
border="0"
style="border:1px
solid
#999999 ">
<tr style="font-family:'Comic Sans MS', cursive">
<td
height="30"
align="center"><font
Pembayaran</font></td>
colspan="4"
bgcolor="#FF9933"
color="#FFFFFF">Cara
</tr>
<tr>
<td colspan="4"> </td>
</tr>
<tr
style="font-family:'Comic
Sans
MS',
cursive"><td
colspan="4">Lakukan Pembayaran Sesuai Dengan Nama &
Nomor Rekening BANK Yang Tercantum Di Bawah Ini: <p></td>
</tr>
<tr style="font-family:'Comic Sans MS', cursive">
<td
width="160"
rowspan="3"><img
src="gambar/[Link]"
width="158"
height="80"></td><td
width="157">Nama
BANK</td><td width="5">:</td><td width="417">BRI</td>
</tr>
<tr style="font-family:'Comic Sans MS', cursive">
<td width="157">Nama Pemilik</td>
<td width="5">:</td>
<td width="417">Budianto</td>
</tr>
<tr style="font-family:'Comic Sans MS', cursive">
<td width="157">Nomor Rekening</td>
<td width="5">:</td>
<td width="417">098-9897-6655-87</td>
</tr>
<tr style="font-family:'Comic Sans MS', cursive">
<td colspan="4"> </td>
</tr>
<tr style="font-family:'Comic Sans MS', cursive">
<td width="160" rowspan="3"><img src="gambar/[Link]"
width="158" height="80"></td><td width="157">Nama BANK</td>
<td width="5">:</td><td width="417">MANDIRI</td>
</tr>
<tr style="font-family:'Comic Sans MS', cursive">
<td width="157">Nama Pemilik</td>
<td width="5">:</td>
<td width="417">Jajang Supriadi</td>
</tr>
<tr style="font-family:'Comic Sans MS', cursive">
<td width="157">Nomor Rekening</td><td width="5">:</td>
<td width="417">002-0933-9488-09</td>
</tr>
<tr>
<td colspan="4"> </td>
</tr>
<tr>
<td
height="30"
align="center"> </td>
</tr>
</table>
</td>
</tr>
colspan="4"
bgcolor="#FF9933"
<tr>
<td
height="25"
colspan="2"
bgcolor="#FF9933"><font
color="#FFFFFF" face="Palatino Linotype, Book Antiqua, Palatino,
serif"><marquee>Sistem Informasi
Penjualan Obat Pada Apotek
Nauli</marquee></font></td>
</tr>
</table>
</body>
</html>
Tampilan input data konsumen
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf8" />
<title>SI Penjualan Obat</title>
</head><body bgcolor="#CCCCCC">
<table width="976" border="0" align="center" >
<tr>
<td colspan="2" bgcolor="#666666"><img src="gambar/[Link]"
width="971" height="200" /></td>
</tr>
<tr>
<td height="6" colspan="2" bgcolor="#339933" > </td>
</tr>
<tr>
<td width="200" height="300" align="center" bgcolor="#FFFFFF"
valign="top" ><? include "[Link]";?><br><br><? include
"[Link]";?><br><br><? include "[Link]";?><? include "[Link]";?
><br><br><? include "[Link]";?></td><td width="767"
height="300" align="center" bgcolor="#FFFFFF">
<script type="text/javascript">
function MM_validateForm() { //v4.0
if ([Link]){
var
i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.argument
s;for
(i=0;
i<([Link]-2);
i+=3)
{
test=args[i+2];
val=[Link](args[i]);
if (val) { nm=[Link]; if ((val=[Link])!="") {
if ([Link]('isEmail')!=-1) { p=[Link]('@');
if (p<1 || p==([Link]-1)) errors+='- '+nm+' must contain an e-mail
address.\n';
} else if (test!='R') { num = parseFloat(val);
if (isNaN(val)) errors+='- '+nm+' Data Harus Angka.\n';
if ([Link]('inRange') != -1) { p=[Link](':');
min=[Link](8,p); max=[Link](p+1);
if (num<min || max<num) errors+='- '+nm+' Data Harus Diantara
'+min+' and '+max+'.\n'; } } } else if ([Link](0) == 'R') errors +=
'- '+nm+' Tidak Boleh Kosong.\n'; } } if (errors) alert('Terjadi
Kesalahan:\n'+errors);
document.MM_returnValue = (errors == '');} }
</script>
<table width="100%" border="0" align="center"style="border:1px
solid #CCCCCC">
<tr>
<td width="710" height="30"
align="center" bgcolor="#FF9933"
><font
size="3"
face="Comic
Sans
MS,
cursive"
color="#FFFFFF">Data Konsumen</font></td>
</tr>
<tr>
<td>
<?php
include"[Link]";
$sql=mysql_query("select
*
from
pemesanan
where
NO_KONSUMEN='$nokonsumen'");$ok=mysql_fetch_array($sql);
?>
<formaction="[Link]?nokonsumen=<?php
echo"$ok[NO_KONSUMEN]";?>" method="post">
<table width="474" border="0" align="center">
<tr><td colspan="2"> </td></tr>
<tr>
<td
width="163">No
Konsumen</td><td
width="210"><input
name="nokonsumen"
type="text"
size="3"
id="nokonsumen"
value="<?php echo"$ok[NO_KONSUMEN]";?>"/></td>
</tr>
<tr>
<td width="171">Nama Lengkap</td>
<td
width="293"><input
name="namalengkap"
id="namalengkap" size="25" /></td>
</tr>
type="text"
<tr>
<td width="171">Provinsi</td>
<td width="293"><select name="provinsi">
<option>--Pilih--</option>
<option value="Aceh">Aceh</option>
<option value="Bali">Bali</option>
<option value="Banten">Banten</option>
<option value="Bengkulu">Bengkulu</option>
<option value="Gorontalo">Gorontalo</option>
<option value="Jakarta">Jakarta</option>
<option value="Jambi">Jambi</option>
<option value="Jawa Barat">Jawa Barat</option>
<option value="Jawa Tenga">Jawa Tengah</option>
<option value="Jawa Timur">Jawa Timur</option>
<option value="Kalimantan Barat">Kalimantan Barat</option>
<option value="Kalimantan Selatan">Kalimantan Seletan</option>
<option value="Kalimantan Tengah">Kalimantan Tengah</option>
<option value="Kalimantan Utara">Kalimantan Utara</option>
<option value="Bangka Belitung">Bangka Belitung</option>
<option value="Kepulauan Riau">Kepulauan Riau</option>
<option value="Lampung">Lampung</option>
<option value="Maluku">Maluku</option>
<option value="Maluku Utara">Maluku Utara</option>
<option value="Ntb">Nusa Tengara Barat</option>
<option value="Ntt">Nusa Tengara Timur</option>
<option value="Papua">Papua</option>
<option value="Papua Barat">Papua Barat</option>
<option value="Riau">Riau</option>
<option value="Sulawesi Barat">Sulawesi Barat</option>
<option value="Sulawesi Selatan">Sulawesi Selatan</option>
<option value="Sulawesi Tengah">Sulawesi Tengah</option>
<option value="Sulawesi Tenggara">Sulawesi Tenggara</option>
<option value="Sulawesi Utara">Sulawesi Utara</option>
<option value="Sumatra Barat">Sumatra Barat</option>
<option value="Sumatra Selatan">Sumatra Selatan</option>
<option value="Sumatra Utara">Sumatra Utara</option>
<option value="Yogyakarta">Yogyakarta</option>
</select></td>
</tr>
<tr>
<td width="171">Kota</td>
<td width="293"><input
size="20" /></td>
name="kota"
type="text"
id="kota"
</tr>
<tr>
<td>Alamat Lengkap</td><td><textarea name="alamat" cols="20"
rows="2" id="alamat" ></textarea></td>
</tr>
<tr>
<td width="171">Kode Pos</td>
<td width="293"><input name="kodepos" type="text" id="kodepos"
size="10" /></td>
</tr>
<tr>
<td
width="171">No
Thelepon</td><td
width="293"><input
name="thelepon" type="text" id="thelepon" size="20" /></td>
</tr>
<tr>
<td width="171">Email</td>
<td width="293"><input
size="25"/></td>
name="email"
type="text"
id="email"
</tr>
<tr>
<td> </td>
<td><table width="122">
<tr><td
width="114"><input
name="selesai"
type="submit"
onclick="MM_validateForm('nama','','R','kota','','R','kodepos','','RisNum'
,'thelepon','','RisNum','alamat','','R');return document.MM_returnValue"
value="Selesai" /></td>
</tr></table>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<table width="713" border="0" align="center" >
<tr>
<td height="18" colspan="4" align="center" ><font size="3"
face="Courier
New',
Courier,
monospace">------------------------------------------------------------------------</font></td>
</tr>
<tr><td width="707">
<font face="Times New Roman, Times, serif" size="2">
<table align="center" border="0" width="710" style="border:1px solid
#666">
<tr>
<td height="18" colspan="8" align="center" style="border:1px solid
#666" bgcolor="#FF9933"><font size="3" face="Comic Sans MS,
cursive" color="#FFFFFF">Keranjang Belanja</font></td>
</tr>
<tr bgcolor="#FF9933">
<th width="27" height="23" style="border:1px solid #666">No</th>
<th width="75" style="border:1px solid #666">Gambar</th>
<th width="70" style="border:1px solid #666">Kode</th>
<th width="83" style="border:1px solid #666">Nama </th>
<th width="96" style="border:1px solid #666">Jenis </th>
<th width="77" style="border:1px solid #666">Harga</th>
<th width="42" style="border:1px solid #666">Jumlah</th>
<th width="122" style="border:1px solid #666">Total Harga</th>
</tr>
<?php
{
$sq="select
[Link],keranjang.KD_OBAT,obat.NAMA_OBAT,obat.JENIS_OBAT,o
bat.HARGA_JUAL,keranjang.JUMLAH_PEMESANAN,keranjang.SUB_TOTAL
_HARGA
from
keranjang,obat
where
keranjang.KD_OBAT=obat.KD_OBAT";$sql=mysql_query($sq);
$a=0;while($tampil=mysql_fetch_array($sql))
{
$a++;
?>
<tr>
<td ><?php echo"$a";?></td>
<td ><?php echo"<img src='download/$tampil[GAMBAR]' width='30'
height='20'>"; ?></td>
<td ><?php echo"$tampil[KD_OBAT]"; ?></td>
<td ><?php echo"$tampil[NAMA_OBAT]"; ?></td>
<td ><?php echo"$tampil[JENIS_OBAT]"; ?></td>
<td ><?php echo"$tampil[HARGA_JUAL]"; ?></td>
<td ><?php echo"$tampil[JUMLAH_PEMESANAN]"; ?></td>
<td ><?php echo"$tampil[SUB_TOTAL_HARGA]"; ?></td>
</tr>
<?php
}}
?>
</table></font>
</td></tr>
</table>
<br><br>
<font face="Comic Sans MS, cursive" size="2" color="#0000FF">
<table width="713" border="0" align="center" style="border:1px solid
#666">
<tr><td>
Dalam pengisian data konsumen ini harus diisikan dengan benar
<i>(Tidak Ada Pemalsuan)</i>. Isikan Nama Lengap, Provinsi, Kota,
Alamat,
Kode Pos Dan Thelepon anda dengan benar. Obat Yang telah dibeli
tidak bisa dikembalikan. <font color="#FF0000" size="2" face="Comic
Sans MS, cursive">(FREE BIAYA PENGIRIMAN) </font>Semoga anda
telah mengisikan data dengan benar. Terimakasih.
</td>
</tr>
</table>
</font>
</td>
</tr>
<tr>
<td
height="25"
colspan="2"
bgcolor="#FF9933"><font
color="#FFFFFF" face="Palatino Linotype, Book Antiqua, Palatino,
serif"><marquee>Sistem Informasi
Penjualan Obat Pada Apotek
Nauli</marquee>
</font></td></tr>
</table>
</body>
</html>
Script data Simpan konsumen
<!DOCTYPE
html
PUBLIC
"-//W3C//DTD
XHTML
1.0
Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>SI Penjualan Obat</title>
</head>
<body bgcolor="#CCCCCC">
<table width="976" border="0" align="center" >
<tr>
<td
colspan="2"
bgcolor="#666666"><img
src="gambar/[Link]"
height="200" /></td>
</tr>
<tr>
<td height="6" colspan="2" bgcolor="#339933" > </td>
</tr>
width="971"
<tr>
<td width="200" height="300" align="center" bgcolor="#FFFFFF" valign="top" ><?
include "[Link]";?><br><br><? include "[Link]";?><br><br><? include
"[Link]";?><? include "[Link]";?><br><br><? include "[Link]";?></td>
<td width="767" height="300" align="center" bgcolor="#FFFFFF"><?
include"[Link]";$sql=mysql_query("insert
into
konsumen(NO_KONSUMEN,NAMA_LENGKAP,PROVINSI,KOTA,ALAMAT_LENG
KAP,KODE_POS,THELEPON,EMAIL)
values('$nokonsumen','$namalengkap','$provinsi','$kota','$alamat','$kodepos','$thelepon','
$email')");
if($sql)
?><form action="[Link]?nokonsumen=<? echo"$nokonsumen";?>" method="post">
<table width="713" border="0" style="border:1px solid #666">
<tr>
<td height="30" colspan="3" align="center" bgcolor="#FF9933"><font size="3"
face="Comic Sans MS, cursive" color="#FFFFFF">Data Pemesanan</font></td>
</tr>
<tr><td width="350">
[No Pemesanan : <? echo"$nokonsumen";?>]
</td>
<?
$tanggal=date('d-M-Y');
?>
<td width="454" colspan="2">[Tanggal : <? echo"$tanggal";?>]
</td></tr>
<tr><td colspan="3"><br>
<font face="Times New Roman, Times, serif" size="2">
<table align="center" border="0" width="702" style="border:1px solid #666">
<tr>
<td
height="18"
colspan="8"
align="center"
style="border:1px
solid
#666"
bgcolor="#FF9933"><font size="3" face="Comic Sans MS, cursive"
color="#FFFFFF">Data Konsumen</font></td></tr>
<tr bgcolor="#FF9933">
<th width="69" height="19" style="border:1px solid #666"><font size="2" face="Times
New Roman, Times, serif">Nama</font></th><th width="97" style="border:1px solid
#666"><font size="2" face="Times New Roman, Times, serif">Provingsi</font></th>
<th width="79"
style="border:1px solid #666"><font size="2" face="Times New
Roman, Times, serif">Kota</font></th><th width="131" style="border:1px solid
#666"><font size="2" face="Times New Roman, Times, serif">Alamat</font></th><th
width="66" style="border:1px solid #666">K<font size="2" face="Times New Roman,
Times, serif">ode Pos</font></th><th width="62" style="border:1px solid #666"><font
size="2" face="Times New Roman, Times, serif">Thelepon</font></th>
</tr>
<?php
include"[Link]";
$sql=mysql_query("select * from konsumen where NO_KONSUMEN='$nokonsumen'");
while($tampil=mysql_fetch_array($sql))
{
?>
<tr>
<td ><?php echo"$tampil[NAMA_LENGKAP]"; ?></td>
<td ><?php echo"$tampil[PROVINSI]"; ?></td>
<td ><?php echo"$tampil[KOTA]"; ?></td>
<td ><?php echo"$tampil[ALAMAT_LENGKAP]"; ?></td>
<td ><?php echo"$tampil[KODE_POS]"; ?></td>
<td ><?php echo"$tampil[THELEPON]"; ?></td>
</tr>
</table></font>
<br><br>
<table width="706" border="0" align="center">
<tr>
<td height="18" colspan="4" align="center" ><font size="3" face="Courier New',
Courier,
monospace">-------------------------------------------------------------------------
</font></td>
</tr>
<tr><td width="700">
<font face="Times New Roman, Times, serif" size="2">
<table align="center" border="0" width="703" style="border:1px solid #666">
<tr>
<td
height="18"
colspan="8"
bgcolor="#FF9933"><font
align="center"
size="3"
face="Comic
color="#FFFFFF">Keranjang Belanja</font></td>
</tr>
style="border:1px
Sans
solid
MS,
#666"
cursive"
<tr bgcolor="#FF9933">
<th width="27" height="23" style="border:1px solid #666">No</th>
<th width="75" style="border:1px solid #666">Gambar</th>
<th width="70" style="border:1px solid #666">Kode</th>
<th width="83" style="border:1px solid #666">Nama </th>
<th width="96" style="border:1px solid #666">Jenis </th>
<th width="77" style="border:1px solid #666">Harga</th>
<th width="42" style="border:1px solid #666">Jumlah</th>
<th width="122" style="border:1px solid #666">Total Harga</th>
</tr>
<?php
{
$sq="select
[Link],keranjang.KD_OBAT,obat.NAMA_OBAT,obat.JENIS_OBAT,[Link]
GA_JUAL,keranjang.JUMLAH_PEMESANAN,keranjang.SUB_TOTAL_HARGA from
keranjang,obat where keranjang.KD_OBAT=obat.KD_OBAT";$sql=mysql_query($sq);
$a=0;
while($tampil=mysql_fetch_array($sql))
{
$a++;
?>
<tr>
<td ><?php echo"$a";?></td>
<td ><?php echo"<img src='download/$tampil[GAMBAR]' width='30' height='20'>"; ?
></td>
<td ><?php echo"$tampil[KD_OBAT]"; ?></td>
<td ><?php echo"$tampil[NAMA_OBAT]"; ?></td>
<td ><?php echo"$tampil[JENIS_OBAT]"; ?></td>
<td ><?php echo"$tampil[HARGA_JUAL]"; ?></td>
<td ><?php echo"$tampil[JUMLAH_PEMESANAN]"; ?></td>
<td ><?php echo"$tampil[SUB_TOTAL_HARGA]"; ?></td>
</tr>
<?php
}}
?>
</table></font>
</td></tr>
</table>
<br><br>
<b>
<table align="center" border="0" width="703" style="border:1px solid #666">
<tr>
<td width="221" style="font-family:'Comic Sans MS', cursive" >
Jumlah Pemesanan
</td>
<?
$total=mysql_query("select
keranjang");
$ada=mysql_fetch_array($total);
$sssss=$ada['jmll']
?>
<td width="470">
<?echo"$ada[jmll] Obat";
?>
SUM(JUMLAH_PEMESANAN)
as
jmll
from
</td>
</tr>
<tr><td width="221" style="font-family:'Comic Sans MS', cursive">
Jumlah Pembayaran
</td>
<? $total=mysql_query("select SUM(SUB_TOTAL_HARGA) as jml from keranjang");
$ada=mysql_fetch_array($total);
$ssss=$ada['jml']
?>
<td width="470">
<?
echo"Rp. $ada[jml]";
?>
</td>
</tr>
<tr>
<td><b>Dicount<b></td>
<td>
<?
if ($ssss>=10000000){
$diskon=$ssss/100*5;
}
else
{
$diskon=0;
}
echo"Rp. $diskon";
?>
</td>
</tr>
<tr>
<td style="font-family:'Comic Sans MS', cursive">
Total Biaya Keseluruhan </td>
<td>
<? $aa=$ssss-$diskon; echo"Rp. $aa"; ?></td>
</tr>
</table>
</td></tr>
<tr>
<td height="27" colspan="2" align="right" >
<input type="submit" name="finis" value="Finis" /> </td>
</form>
<td>
<form action="[Link]?nopemesanan=<? echo"$nokonsumen";?>" method="post">
<table width="61" border="0"><tr><td width="55">
<input type="submit" name="batal" value="Batal" />
</td></tr></table></form>
</td></tr>
</table>
</b>
<br>
<font face="Comic Sans MS, cursive" size="2" color="#0000FF">
<table width="700" border="0" align="center" style="border:1px solid #666">
<tr><td width="697">
Tampilan diatas adalah tampilan data anda dan data obat yang anda pesan beserta jumlah
biaya keseluruhan yang harus anda bayar. Jika tidak setuju maka klik tombol
<b><i>Batal</i></b> dan jika anda setuju maka klik tombol <b><i>Finis</i></b>. Batas
pembayaran 3 (tiga) hari jika lewat dari itu maka anda dianggap telah membatalkan
pemesanan obat tersebut. Jika anda telah melakukan pembayaran maka silakan hubungi
kami dan obat akan segera kami kirim. Trimakasih atas kunjungan anda diwebsite kami.
</td></tr>
</table>
</font>
<? }?>
</td>
</tr>
<tr>
<td
height="25"
colspan="2"
bgcolor="#FF9933"><font
face="Palatino Linotype, Book Antiqua, Palatino, serif"><marquee>
Sistem Informasi Penjualan Obat Pada Apotek Nauli</marquee>
color="#FFFFFF"
</font></td>
</tr>
</table>
</body>
</html>
Tampilan konfirmasi pemesanan
<!DOCTYPE
html
PUBLIC
"-//W3C//DTD
XHTML
1.0
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>SI Penjualan Obat</title>
</head>
<body bgcolor="#CCCCCC">
<table width="976" border="0" align="center" >
<tr>
Transitional//EN"
<td
colspan="2"
bgcolor="#666666"><img
src="gambar/[Link]"
width="971"
height="200" /></td>
</tr>
<tr>
<td height="6" colspan="2" bgcolor="#339933" > </td>
</tr>
<tr>
<td width="200" height="300" align="center" bgcolor="#FFFFFF" valign="top" ><?
include "[Link]";?><br><br><? include "[Link]";?><br><br><? include
"[Link]";?><? include "[Link]";?><br><br><? include "[Link]";?></td>
<td width="767" height="300" align="center" bgcolor="#FFFFFF">
<font face="Comic Sans MS, cursive" size="4" color="#339933">
<table width="713" border="0" align="center" style="border:1px solid #666">
<tr><td align="center"><br><?
include"[Link]";
$sql=mysql_query("delete from keranjang where NO_PEMESANAN='$nokonsumen'");
echo"Anda Telah Menyelesaikan Proses Pemesanan Barang <br> Terima Kasih Telah
Belanja Di Website Kami <br> Nomor Pemesanan Anda adalah <br> <font face=Comic
Sans MS, cursive size=6 color=#FF0000><b>[ $nokonsumen ]</b></font><br>Nomor
Pemesanan Ini Harap Diingat Untuk Melanjutkan Proses Selanjutnya";
?></td></tr>
<tr><td
align="center">-----------------------------------------------------------------------------------------</td></tr>
</table>
</font>
</td>
</tr>
<tr>
<td
height="25"
colspan="2"
bgcolor="#FF9933"><font
color="#FFFFFF"
face="Palatino Linotype, Book Antiqua, Palatino, serif"><marquee>Aplikasi Penjualan
Obat Pada Apotek Nauli</marquee></font></td></tr>
</table>
</body>
</html>
Menu input data pengguna
<!DOCTYPE
html
PUBLIC
"-//W3C//DTD
XHTML
1.0
Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>SI Penjualan obat</title>
<body bgcolor="#CCCCCC">
<?
session_start();
if(!isset($_SESSION['user']))
{
?>
<script
language="javascript">alert('Maaf
Dulu!!');[Link]='[Link]'</script>
<?
exit;
}
else
Anda
Harus
Login
{
?>
<table width="976" border="0" align="center" >
<tr>
<td
colspan="2"
bgcolor="#666666"><img
src="gambar/[Link]"
width="971"
height="200" /></td></tr>
<tr>
<td height="6" colspan="2" bgcolor="#339933" > </td>
</tr>
<tr>
<td width="200" height="300" align="center" bgcolor="#FFFFFF" valign="top" ><?
include "[Link]";?><br><br><? include "[Link]";?></td>
<td width="767" height="300" align="center" bgcolor="#FFFFFF">
<style type="text/css">
<!-.style1 {
font-size: 25px;
font-weight: bold;
font-family:Lucida Console, Monaco, monospace;
}
-->
</style>
<script type="text/javascript">
function MM_validateForm() { //v4.0
if ([Link]){
var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments;
for
(i=0;
i<([Link]-2);
i+=3)
test=args[i+2];
val=[Link](args[i]);
if (val) { nm=[Link]; if ((val=[Link])!="") {
if ([Link]('isEmail')!=-1) { p=[Link]('@');
if (p<1 || p==([Link]-1)) errors+='- '+nm+' must contain an e-mail address.\n';
} else if (test!='R') { num = parseFloat(val);
if (isNaN(val)) errors+='- '+nm+' Data Harus Angka.\n';
if ([Link]('inRange') != -1) { p=[Link](':');
min=[Link](8,p); max=[Link](p+1);
if (num<min || max<num) errors+='- '+nm+' must contain a number between '+min+' and
'+max+'.\n';} } } else if ([Link](0) == 'R') errors += '- '+nm+' Tidak Boleh
Kosong.\n'; }} if (errors) alert('Terjadi Kesalahan:\n'+errors);document.MM_returnValue
= (errors == '');
}}
</script>
<?
session_start();
if(!isset($_SESSION['user']))
{
?>
<script
language="javascript">alert('Maaf
Dulu!!');[Link]='[Link]'</script>
<?
exit;
}
else
{
Anda
Harus
Login
?>
<?
include "[Link]";
$sql=mysql_query("SELECT MAX(ID_PENGGUNA) as jm FROM pengguna");
$Q=mysql_fetch_array($sql);
{
$P=$Q['jm']+1;
$pn=('P');
}
?>
<form action="[Link]?idpengguna=<? echo"$P";?><? echo"$pn";?>"
method="post" >
<table width="392" border="0">
<tr>
<td height="28" colspan="3"><div align="center"><span class="style1">INPUT DATA
PENGGUNA</span></div></td>
</tr>
<tr>
<td
height="21"
colspan="3"
valign="top"
align="center"><span
class="style1">------------------------</span></td>
</tr>
<tr>
<td
width="163"><font
face="Lucida
Console,
Monaco,
monospace">Id
Pengguna</font></td>
<td width="5"><strong>:</strong></td>
<td width="210"><input name="idpengguna" type="text" id="idpengguna" size="10"
disabled="disabled" value="<? echo"$P";?><? echo"$pn";?>"/></td>
</tr>
<tr>
<td
height="24"><font
face="Lucida
Console,
Monaco,
monospace">Nama
Pengguna</font></td><td><strong>:</strong></td>
<td><input name="nama" type="text" id="nama" size="25" /></td>
</tr>
<tr>
<td
height="24"><font
monospace">Alamat</font></td>
<td><strong>:</strong></td>
face="Lucida
Console,
Monaco,
<td><input name="alamat" type="text" id="alamat" size="35" /></td>
</tr>
<tr>
<td
height="24"><font
face="Lucida
Console,
Monaco,
monospace">User
Name</font></td><td><strong>:</strong></td>
<td><input name="username" type="text" id="username" size="20" /></td>
</tr>
<tr>
<td><font face="Lucida Console, Monaco, monospace">Password</font></td>
<td><strong>:</strong></td>
<td><input name="password" type="password" id="password" size="20" /></td>
</tr>
<tr>
<td><font face="Lucida Console, Monaco, monospace">Level</font></td>
<td><strong>:</strong></td>
<td><select name="level">
<option>--Pilih--</option>
<option value="Admin">Admin</option>
<option value="Pimpinan">Pimpinan</option>
</select>
</td>
</tr>
<tr>
<td height="32"> </td>
<td> </td>
<td><table width="184" border="0">
<tr>
<td
width="154"><input
name="simpan"
type="submit"
onclick="MM_validateForm('idpengguna','','R','nama','','R','alamat','','R','username','','R','p
assword','','R');return document.MM_returnValue" value="Simpan" />
<input name="batal" type="reset" value="Batal" /></td>
</tr>
</table></td>
</tr>
</table>
</form>
<? } ?>
</td>
</tr>
<tr>
<td
height="25"
colspan="2"
bgcolor="#FF9933"><font
color="#FFFFFF"
face="Palatino Linotype, Book Antiqua, Palatino, serif"><marquee>Sistem Informasi
Penjualan Obat Pada Apotek Nauli</marquee>
</font></td>
</tr>
</table>
<? } ?>
</body>
</head>
</html>
Tampilan Menu Data obat
<!DOCTYPE
html
PUBLIC
"-//W3C//DTD
XHTML
1.0
Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>SI Pendataan Produksi Sawit</title>
<body bgcolor="#CCCCCC">
<?
session_start();
if(!isset($_SESSION['user']))
{
?>
<script
language="javascript">alert('Maaf
Dulu!!');[Link]='[Link]'</script>
<?
exit;
Anda
Harus
Login
}
else
{
?>
<table width="976" border="0" align="center" >
<tr>
<td
colspan="2"
bgcolor="#666666"><img
src="gambar/[Link]"
width="971"
height="200" /></td>
</tr>
<tr>
<td height="6" colspan="2" bgcolor="#339933" > </td>
</tr>
<tr>
<td width="200" height="300" align="center" bgcolor="#FFFFFF" valign="top" ><?
include "[Link]";?><br><br><? include "[Link]";?></td><td width="767"
height="300" align="center" bgcolor="#FFFFFF">
<font face="Times New Roman, Times, serif" size="1">
<table width="750" border="0">
<tr><td width="750">
<form action="[Link]?carinama=carinama" method="post">
<table width="507" border="0" align="center">
<tr>
<td width="177"> <b>Nama Obat </b></td>
<td width="180"><input type="text" name="carinama" size="30" maxlength="60"
/></td><td width="136"><input type="submit" name="cari" value="Tampil Data"
/></td>
</tr>
</table>
</form>
<br><br>
<table align="center" border="0" width="750" style="border:1px solid #666">
<tr bgcolor="#FF9933">
<th width="27" height="23" style="border:1px solid #666">No</th>
<th width="43" style="border:1px solid #666">Kode</th>
<th width="70" style="border:1px solid #666">Nama </th>
<th width="70" style="border:1px solid #666">Jenis</th>
<th width="63" style="border:1px solid #666">Harga</th>
<th width="61" style="border:1px solid #666">Jum'Stok</th>
<th width="76" style="border:1px solid #666">Tot'Harga</th>
<th width="79" style="border:1px solid #666">Har'Jual</th>
<th width="77" style="border:1px solid #666">Tanggal</th>
<th width="66" style="border:1px solid #666">Gambar</th>
<th width="101" style="border:1px solid #666">Keterangan</th>
<th width="87" style="border:1px solid #666">Action</th>
</tr>
<?php
if (isset($_POST['cari']))
{
include"[Link]";
$sql=mysql_query("select * from obat where NAMA_OBAT like '%$_POST[carinama]
%'");
$a=0;
while($tampil=mysql_fetch_array($sql))
{
$a++;
?>
<tr>
<td ><?php echo"$a";?></td>
<td ><?php echo"$tampil[KD_OBAT]"; ?></td>
<td ><?php echo"$tampil[NAMA_OBAT]"; ?></td>
<td ><?php echo"$tampil[JENIS_OBAT]"; ?></td>
<td ><?php echo"$tampil[HARGA_BELI]"; ?></td>
<td ><?php echo"$tampil[JUMLAH_STOK]"; ?></td>
<td ><?php echo"$tampil[TOTAL_HARGA]"; ?></td>
<td ><?php echo"$tampil[HARGA_JUAL]"; ?></td>
<td ><?php echo"$tampil[TGL_MASUK]"; ?></td>
<td ><?php echo"<img src='download/$tampil[GAMBAR]' width='30' height='20'>"; ?
></td>
<td ><?php echo"$tampil[KETERANGAN]"; ?></td>
<td
align="center"><strong><a
href="[Link]?kdobat=<?php
echo"$tampil[KD_OBAT]";?>">Edit</a> <a href="[Link]?kdobat=<?php
echo"$tampil[KD_OBAT]";?>">Hapus</a></strong></td>
</tr>
<?php
}}
?>
</table>
</td></tr></table>
</font>
</td>
</tr>
<tr>
<td
height="25"
colspan="2"
bgcolor="#FF9933"><font
color="#FFFFFF"
face="Palatino Linotype, Book Antiqua, Palatino, serif"><marquee>Aplikasi Penjualan
Obat Pada Apotek Nauli</marquee></font></td>
</tr>
</table>
<? } ?>
</body>
</head>
</html>
Data pemesanan
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf8" />
<title>SI Pendataan Produksi Sawit</title>
<body bgcolor="#CCCCCC">
<?
session_start();
if(!isset($_SESSION['user']))
{
?>
<script
language="javascript">alert('Maaf
Anda
Dulu!!');[Link]='[Link]'</script>
<?
exit;
}
else
{
?>
<table width="976" border="0" align="center" >
<tr>
Harus
Login
<td colspan="2" bgcolor="#666666"><img src="gambar/[Link]"
width="971" height="200" /></td>
</tr>
<tr>
<td height="6" colspan="2" bgcolor="#339933" > </td>
</tr>
<tr>
<td width="200" height="300" align="center" bgcolor="#FFFFFF"
valign="top" ><? include "[Link]";?><br><br><? include
"[Link]";?></td><td width="767" height="300" align="center"
bgcolor="#FFFFFF">
<font face="Times New Roman, Times, serif" size="1">
<table width="750" border="0">
<tr><td width="750">
<form
method="post">
action="[Link]?carinama=carinama"
<table width="472" border="0" align="center">
<tr>
<td width="173"> <b>No Pemesanan </b></td>
<td width="180"><input type="text" name="carinama" size="30"
maxlength="60" /></td>
<td
width="105"><input
value="Tampilkan Data" /></td>
</tr>
</table>
</form>
<br><br>
type="submit"
name="cari"
<table align="center" border="0" width="750" style="border:1px solid
#666">
<tr bgcolor="#FF9933">
<th width="15" height="23" style="border:1px solid #666">No</th>
<th width="30" height="23"
Pesan</th>
style="border:1px solid #666">No
<th width="40" style="border:1px solid #666">Tanggal</th>
<th
width="70"
Konsumen</th>
style="border:1px
solid
#666">Nama
<th width="70" style="border:1px solid #666">Nama Barang</th>
<th width="50" style="border:1px solid #666">Harga Barang</th>
<th width="50" style="border:1px solid #666">Jumlah Pesan</th>
<th width="50" style="border:1px solid #666">Total Harga</th>
<th width="40" style="border:1px solid #666">Status</th>
<th width="40" style="border:1px solid #666">Action</th>
</tr>
<?php
if (isset($_POST['cari']))
{
include"[Link]";
$sql=mysql_query("select
pemesanan.KD_OBAT,pemesanan.NO_PEMESANAN,[Link]
AL,konsumen.NAMA_LENGKAP,obat.NAMA_OBAT,obat.HARGA_JUAL,pe
mesanan.JUMLAH_PEMESANAN,pemesanan.SUB_TOTAL_HARGA,pemes
[Link]
from
obat,konsumen,pemesanan
where
pemesanan.KD_OBAT=obat.KD_OBAT
and
pemesanan.NO_KONSUMEN=konsumen.NO_KONSUMEN
and
pemesanan.NO_PEMESANAN like '%$_POST[carinama]%'");
$a=0;
while($tampil=mysql_fetch_array($sql))
{
$a++;
?>
<tr>
<td ><?php echo"$a";?></td>
<td ><?php echo"$tampil[NO_PEMESANAN]"; ?></td>
<td ><?php echo"$tampil[TANGGAL]"; ?></td>
<td ><?php echo"$tampil[NAMA_LENGKAP]"; ?></td>
<td ><?php echo"$tampil[NAMA_OBAT]"; ?></td>
<td ><?php echo"$tampil[HARGA_JUAL]"; ?></td>
<td ><?php echo"$tampil[JUMLAH_PEMESANAN]"; ?></td>
<td ><?php echo"$tampil[SUB_TOTAL_HARGA]"; ?></td>
<td ><?php echo"$tampil[STATUS]"; ?></td>
<td align="center">
<ahref="[Link]?&no=<?php
echo"$tampil[NO_PEMESANAN]";?>">Update</a></td>
</tr>
<?php
}}
?>
</table>
</td></tr></table>
</font>
</td>
</tr>
<tr>
<td
height="25"
colspan="2"
bgcolor="#FF9933"><font
color="#FFFFFF" face="Palatino Linotype, Book Antiqua, Palatino,
serif"><marquee>Sistem Informasi
Penjualan Obat Pada Apotek
Nauli</marquee>
</font></td>
</tr>
</table>
<? } ?>
</body>
</head>
</html>
Menu data konsumen
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf8" />
<title>SI Pendataan Produksi Sawit</title>
<body bgcolor="#CCCCCC">
<?
session_start();
if(!isset($_SESSION['user']))
{
?>
<script
language="javascript">alert('Maaf
Anda
Dulu!!');[Link]='[Link]'</script>
Harus
Login
<?
exit;
}
else
{
?>
<table width="976" border="0" align="center" >
<tr>
<td colspan="2" bgcolor="#666666"><img src="gambar/[Link]"
width="971" height="200" /></td>
</tr>
<tr>
<td height="6" colspan="2" bgcolor="#339933" > </td>
</tr>
<tr>
<td width="200" height="300" align="center" bgcolor="#FFFFFF"
valign="top" ><? include "[Link]";?><br><br><? include
"[Link]";?></td><td width="767" height="300" align="center"
bgcolor="#FFFFFF">
<?
session_start();
if(!isset($_SESSION['user']))
{
?>
<script
language="javascript">alert('Maaf
Anda
Dulu!!');[Link]='[Link]'</script>
Harus
Login
<?
exit;
}
else
{
?>
<font face="Times New Roman, Times, serif" size="1">
<table width="100%" border="0">
<tr><td width="966">
<form
method="post">
action="[Link]?carinama=carinama"
<table width="472" border="0" align="center">
<tr>
<td width="173"> <b>Nama Konsumen </b></td>
<td width="180"><input type="text" name="carinama" size="30"
maxlength="60" /></td>
<td
width="105"><input
value="Tampilkan Data" /></td>
type="submit"
name="cari"
</tr>
</table>
</form>
<br><br>
<table align="center" border="0" width="750" style="border:1px solid
#666">
<tr bgcolor="#FF9933">
<th width="26" height="23" style="border:1px solid #666">No</th>
<th width="120" style="border:1px solid #666">Nama </th>
<th width="100" style="border:1px solid #666">Provinsi</th>
<th width="126" style="border:1px solid #666">Kota</th>
<th width="166" style="border:1px solid #666">Alamat</th>
<th width="79" style="border:1px solid #666">Kode Pos</th>
<th width="105" style="border:1px solid #666">Thelepon</th>
<th width="116" style="border:1px solid #666">Email</th>
<th width="69" style="border:1px solid #666">Action</th>
</tr>
<?php
if (isset($_POST['cari']))
{
include"[Link]";
$sql=mysql_query("select * from konsumen where NAMA_LENGKAP like
'%$_POST[carinama]%'");
$a=0;
while($tampil=mysql_fetch_array($sql))
{
$a++;
?>
<tr>
<td ><?php echo"$a";?></td>
<td ><?php echo"$tampil[NAMA_LENGKAP]"; ?></td>
<td ><?php echo"$tampil[PROVINSI]"; ?></td>
<td ><?php echo"$tampil[KOTA]"; ?></td>
<td ><?php echo"$tampil[ALAMAT_LENGKAP]"; ?></td>
<td ><?php echo"$tampil[KODE_POS]"; ?></td>
<td ><?php echo"$tampil[THELEPON]"; ?></td>
<td ><?php echo"$tampil[EMAIL]"; ?></td>
<td
align="center"><strong><a
href="[Link]?
nokonsumen=<?php
echo"$tampil[NO_KONSUMEN]";?
>">Hapus</a></strong></td>
</tr>
<?php
}}
?>
</table>
</td></tr></table>
</font>
<? } ?>
</td>
</tr>
<tr>
<td
height="25"
colspan="2"
bgcolor="#FF9933"><font
color="#FFFFFF" face="Palatino Linotype, Book Antiqua, Palatino,
serif"><marquee>Sistem Informasi
Penjualan Obat Pada Apotek
Nauli</marquee>
</font></td>
</tr>
</table>
<? } ?>
</body>
</head>
</html>
Menu data komentar
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf8" />
<title>SI Pendataan Produksi Sawit</title>
<body bgcolor="#CCCCCC">
<?
session_start();
if(!isset($_SESSION['user']))
{
?>
<script
language="javascript">alert('Maaf
Anda
Dulu!!');[Link]='[Link]'</script>
<?
exit;
}
Harus
Login
else
{
?>
<table width="976" border="0" align="center" >
<tr>
<td colspan="2" bgcolor="#666666"><img src="gambar/[Link]"
width="971" height="200" /></td>
</tr>
<tr>
<td height="6" colspan="2" bgcolor="#339933" > </td>
</tr>
<tr>
<td width="200" height="300" align="center" bgcolor="#FFFFFF"
valign="top" ><? include "[Link]";?><br><br><? include
"[Link]";?></td>
<td width="767" height="300" align="center" bgcolor="#FFFFFF">
<?
session_start();
if(!isset($_SESSION['user']))
{
?>
<script
language="javascript">alert('Maaf
Anda
Dulu!!');[Link]='[Link]'</script>
<?
exit;
}
Harus
Login
else
{
?>
<font face="Times New Roman, Times, serif" size="1">
<table width="100%" border="0">
<tr><td width="966">
<form
method="post">
action="[Link]?carinama=carinama"
<table width="472" border="0" align="center">
<tr>
<td width="173"> <b>Nama Konsumen </b></td>
<td width="180"><input type="text" name="carinama" size="30"
maxlength="60" /></td><td width="105"><input type="submit"
name="cari" value="Tampilkan Data" /></td>
</tr>
</table>
</form>
<br><br>
<table align="center" border="0" width="750" style="border:1px solid
#666">
<tr bgcolor="#FF9933">
<th width="26" height="23" style="border:1px solid #666">No</th>
<th width="120" style="border:1px solid #666">Nama </th>
<th width="100" style="border:1px solid #666">Provinsi</th>
<th width="126" style="border:1px solid #666">Kota</th>
<th width="166" style="border:1px solid #666">Alamat</th>
<th width="79" style="border:1px solid #666">Kode Pos</th>
<th width="105" style="border:1px solid #666">Thelepon</th>
<th width="116" style="border:1px solid #666">Email</th>
<th width="69" style="border:1px solid #666">Action</th>
</tr>
<?php
if (isset($_POST['cari']))
{
include"[Link]";
$sql=mysql_query("select * from konsumen where NAMA_LENGKAP like
'%$_POST[carinama]%'");
$a=0;
while($tampil=mysql_fetch_array($sql))
{
$a++;
?>
<tr>
<td ><?php echo"$a";?></td>
<td ><?php echo"$tampil[NAMA_LENGKAP]"; ?></td>
<td ><?php echo"$tampil[PROVINSI]"; ?></td>
<td ><?php echo"$tampil[KOTA]"; ?></td>
<td ><?php echo"$tampil[ALAMAT_LENGKAP]"; ?></td>
<td ><?php echo"$tampil[KODE_POS]"; ?></td>
<td ><?php echo"$tampil[THELEPON]"; ?></td>
<td ><?php echo"$tampil[EMAIL]"; ?></td>
<td
align="center"><strong><a
href="[Link]?
nokonsumen=<?php
echo"$tampil[NO_KONSUMEN]";?
>">Hapus</a></strong></td>
</tr>
<?php
}}
?>
</table>
</td></tr></table>
</font>
<? } ?>
</td>
</tr>
<tr>
<td
height="25"
colspan="2"
bgcolor="#FF9933"><font
color="#FFFFFF" face="Palatino Linotype, Book Antiqua, Palatino,
serif"><marquee> Sistem Informasi Penjualan Obat Pada Apotek
Nauli</marquee>
</font></td>
</tr>
</table>
<? } ?>
</body>
</head>
</html>
You might also like
- Patient Management System Login & AdminNo ratings yetPatient Management System Login & Admin60 pages
- Dokumentasiu Pengujian Pada Aplikasi Yang AdaNo ratings yetDokumentasiu Pengujian Pada Aplikasi Yang Ada42 pages
- PHP Login and Database Management ScriptsNo ratings yetPHP Login and Database Management Scripts17 pages
- Build A PHP Application With A MySQL Database For A Shopping MallNo ratings yetBuild A PHP Application With A MySQL Database For A Shopping Mall12 pages
- Flowchart Program Data Dosen dan JadwalNo ratings yetFlowchart Program Data Dosen dan Jadwal54 pages
- Pharmacy Management System Code ExamplesNo ratings yetPharmacy Management System Code Examples11 pages
- Student Directory and Programming ConceptsNo ratings yetStudent Directory and Programming Concepts74 pages
- HTML 5 Features and Differences from HTML 4No ratings yetHTML 5 Features and Differences from HTML 417 pages
- MCQ HTML Css Javascript Jquery ByJigarSirNo ratings yetMCQ HTML Css Javascript Jquery ByJigarSir37 pages
- How To Configure The Universal Worklist (NW2004)No ratings yetHow To Configure The Universal Worklist (NW2004)62 pages
- Frontend Internship Report at COOX OnlineNo ratings yetFrontend Internship Report at COOX Online28 pages