DATA FAKTUR

DATA FAKTUR

INPUT.PHP
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Title here!</title>
</head>
<body bgcolor=yellow>
<form action=output2.php method="post">
<?
echo"<br>TGL  :" .date('l d-M-Y');
echo"<br> Jam :" .date('g:i:s A');
?>
<font face="Lucida Calligraphy" Size=4 color=#FFFFFF>
<p> Selamat DatanG </p>
<table border=4 bgcolor=balck cellspasing=5 cellpadding=25 align=center>
<pre>
<form action=output2.php method="post">
<tr><td colspan="6"><strong><div align="center">Data Faktur</strong></div></tr></td>

<tr>
<td>
No Faktur    :<td><input type="text" name="nofak"></tr></td>
<tr>
<td>
Tgl. Faktur  :<td><input type="text" name="tglfaktur"></tr></td>
<tr>
<td>
Nama Barang  :<td><Select size=1 name="nabar">
              <option value="kulkas">Kulkas</option>
              <option value="radio">Radio</option>
              <option value="lampu">Lampu</option></select></tr></td>
<tr>
<td>
Jumlah        <td><input type="text" name="qty"></tr></td>
<tr>
<td>
Jenis Bayar   <td><input type="radio" value="cash" name="jbayar">  Cash  <br>
                  <input type="radio" value="kredit" name="jbayar">  Kredit</tr></td>
<tr><td colspan="6">
<div align="center"><input type="submit" value="Masukan Data"> <input type="reset" value="Hapus Data">
</div>
</pre>
</td>
</tr>
</body>
</html>

OUTPUT.PHP
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Title here!</title>
</head>
<body>
<?
$konek=mysql_connect("localhost","root","password")
or die ("koneksi gagal".mysql_error());
echo"Koneksi Berhasil<br>";

$sql="insert into faktur(nofak,tglfaktur,nabar,qty,jbayar)
values('$nofak','$tglfaktur','$nabar','$qty','$jbayar')";
$qry=mysql_db_query("12099939",$sql,$konek);

if($qry){
    print"berhasil disimpan<br>";
}
else{
    print"gak masuk<br>";
}
echo"<h3><center>Daftar Transaksi</center></h3>";

$sql="select*from faktur";
$qry=mysql_db_query("12099939",$sql,$konek)or die("gagal tampil".mysql_error());

echo"<pre>
<table border='4' align='center'>
<tr><td>No.faktur<td>tgl.Faktur<td>Nama Barang<td>Harga<td>Quality<td>Subtotal<td>Cara Bayar<td>Aksi";
while($row=mysql_fetch_row($qry))

{if($row[2]=="radio"){$harga=50000;}
if($row[2]=="lampu"){$harga=20000;}
if($row[2]=="kulkas"){$harga=800000;}
$subt=$harga*$row[3];
echo"<tr><td>$row[0]<td>$row[1]<td>$row[2]<td>$row[3]<td>$row[4]
<td><a href='hapus.php?nofak=$row[0]'>Hapus</a>";
echo"<br>";
}
echo"</table></pre>";
print"<a href='output1.php'>Masukan Data Lagi</a>";

 ?>
</body>
</html>
 HAPUS.PHP
 <!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Title here!</title>
</head>
<body>
<?
$konek=mysql_connect("localhost","root","password")
or die ("koneksi hapus gagal".mysql_error());
$sql="DELETET FROM faktur WHERE nofak='$nofak'";
$qry=mysql_db_query("masukan nama database",$sql,$konek)
or die ("query salahh".mysql_error());
if($qry)(
echo"Data Berhasil Di Hapus";
echo"<a href=output.php>kembali ke tampil</a>
}
else
echo"GAGAL MENGHAPUS";
exit;?>
</body>
</html>
Data Faktur

No Faktur    :

Tgl. Faktur  :

Nama Barang  :

Jumlah       

Jenis Bayar   		  Cash 

                    Kredit


Best Regard,
This share facebook Posted by Unknown
Labels:

0 comments:

Post a Comment

No Coment No Spam!!!

Subscribe to: Post Comments (Atom)
Image Hosted by ImageShack.us