tabel 1 untuk admin
tabel 2 untuk barang
KONEKSI.PHP
<?php
mysql_connect("localhost","root","");
mysql_select_db("tugas2");
?>
INDEX.PHP
<p align='right'><a href='form_login.php'>login </a> (untuk admin).</p>
<center><h2>Daftar dan harga barang<h2></center>
<table border="1" width="550" align="center" bgcolor=#000ff>
<tr>
<td align="center"width=50 height=20 align="center" width=50><b>Kode</b></td>
<td align="center" width=200><b>Nama Barang</b></td>
<td align='center' width=300><b>Deskripsi</b></td>
<td align='center' width=300><b>Harga</b></td>
</tr>
<?php
include "koneksi.php";
$qdata = mysql_query("select kode,nama,deskripsi, harga from barang");
while($rdata = mysql_fetch_array($qdata))
{
$kode = $rdata["kode"];
$nama = $rdata["nama"];
$deskripsi = $rdata["deskripsi"];
$harga = $rdata["harga"];
echo "<tr>
<td align='center' >$kode</tad>
<td>$nama</td>
<td>$deskripsi</td>
<td>Rp. $harga</td>
</tr>";
}
?>
</table>
LOGIN.PHP
<?php
include "koneksi.php";
$nama = $_POST['nama'];
$pasword = $_POST['pasword'];
$masuk = mysql_query("select * from admin where nama='$nama' and pasword='$pasword'");
$cek = mysql_num_rows($masuk);
if($cek){
echo "<script>alert('Login berhasil..!!')</script>";
echo "<script >location.href='admin_home.php';</script>";
}
else{
echo "<script>alert('login gagal...!!')</script>";
echo "<script >location.href='form_login.php';</script>";
echo mysql_error();
}
?>
FROM_LOGIN
<?php
echo "<form action='login.php' method='post'>";
echo "<table cellpadding='3' cellspacing='3' align='center' bgcolor=#000ff>
<caption><strong><h3>Login Admin</h3></strong></caption></br>
<tr>
<td>Username</td>
<td> <input type='text' name='username'></td>
</tr>
<tr>
<td>Password</td>
<td><input type='password' name='password'></td>
</tr>
<td></td><td><input type='submit' name='login' value='login'></td>
</tr>";
echo "</table></form>";
?>
SIMPAN.PHP
<?php
include "koneksi.php";
$kode = $_POST['kode_barang'];
$nama = $_POST['nama_barang'];
$deskripsi = $_POST['deskripsi'];
$harga = $_POST['harga'];
$insert = "INSERT INTO barang (kode, nama, deskripsi, harga) VALUES('$kode','$nama','$deskripsi','$harga')";
$insert_query = mysql_query($insert);
if($insert_query){
echo "<script>alert('Insert data $kode berhasil..!!')</script>";
echo "<script >location.href='admin_home.php';</script>";
}
else{
echo "<script>alert('Gagal insert $kode')</script>";
echo "<script >location.href='form_barang.php';</script>";
echo mysql_error();
}
?>
FORM_BARANG.PHP
<?php
echo "<form action='simpan_data.php' method='post'>";
echo "<table cellpadding='3' cellspacing='3' align='center'>
<caption><strong><h3>Input Data Barang</h3></strong></caption></br>
<tr>
<td>Kode Barang</td>
<td> <input type='text' name='kode_barang' size=4 ></td>
</tr>
<tr>
<td>Nama Barang</td>
<td><input type='text' name='nama_barang'></td>
</tr>
<tr>
<td>Deskripsi</td>
<td><textarea name='deskripsi' cols=40 rows=6></textarea></td>
</tr>
<tr>
<td>Harga</td>
<td>Rp. <input type='text' name='harga'><td>
</tr>
<tr>
<td></td><td><input type='submit' name='simpan' value='simpan'></td>
</tr>";
echo "</table></form>";
?>
FORM_EDIT.PHP
<?php
include "koneksi.php";
$kirim_edit = (!empty($_GET['kode']) ? $_GET['kode'] : '');
$edit = (!empty($_GET['edit']) ? $_GET['edit'] : '');
if($edit==1){
$kode = $kirim_edit;
$qdata2 = mysql_query("select nama, deskripsi, harga from barang where kode='$kode'");
while($rdata2 = mysql_fetch_array($qdata2)){
$nama2 = $rdata2["nama"];
$deskripsi2 = $rdata2["deskripsi"];
$harga2 = $rdata2["harga"];
}
echo "<form method='post' action='admin_home.php'>
<input type='hidden' name='kodeg' value='$kode'>
<input type='hidden' name='kirim_edit' value=1>";
echo "<table cellpadding='3' cellspacing='3' align='center'>
<caption><strong><h3>Edit Data Barang</h3></strong></caption></br>
<tr>
<td>Kode Barang </td>
<td><input type='text' name='kode' size=4 value='$kode'></td>
</tr>
<tr>
<td>Nama Barang </td>
<td><input type='text' name='nama' value='$nama2'></td>
</tr>
<tr>
<td valign='middle'>Deskripsi </td>
<td><textarea name='deskripsi' cols=40 rows=6>$deskripsi2</textarea></td>
</tr>
<tr>
<td valign='middle'>Harga </td>
<td>Rp. <input type='text' name='harga' value='$harga2'></td>
</tr>
<tr>
<td></td><td><input type='submit' name='simpan' value='simpan'></td>
</tr>";
echo "</table></form></p>";
}
?>
ADMIN.HOME.PHP
<p align='right'><a href='logout.php'>logout </a></p>
<center><h2>Daftar Barang<h2></center>
<table border="1" width="1000" align="center" bgcolor=#F00ff>
<tr>
<td align="center"width=50 height=20 align="center" width=50><b>Kode</b></td>
<td align="center" width=200><b>Nama Barang</b></td>
<td align='center' width=300><b>Deskripsi</b></td>
<td align='center' width=150><b>Harga</b></td>
<td align='center' width=300><b>Fungsi</b></td>
</tr>
<?php
include "koneksi.php";
//fungsi edit
$kirim_edit = (!empty($_GET['kode']) ? $_GET['kode'] : '');
$edit = (!empty($_GET['edit']) ? $_GET['edit'] : '');
if($kirim_edit==1){
$query3 = "update barang set kode='$kode', nama='$nama', deskripsi='$deskripsi' harga='$harga' where kode='$kodeg'";
mysql_query($query3);
}
$i=0;
//fungsi hapus
$hapus=(!empty($_GET['hapus']) ? $_GET['hapus']:'');
if($hapus==1){
$kode=$_GET['kode'];
$query2="delete from barang where kode='$kode'";
mysql_query($query2);
}
$i=0;
$qdata = mysql_query("select kode,nama,deskripsi,harga from barang");
while($rdata = mysql_fetch_array($qdata))
{
$kode = $rdata["kode"];
$nama = $rdata["nama"];
$deskripsi = $rdata["deskripsi"];
$harga = $rdata["harga"];
echo "<tr>
<td align='center' >$kode</tad>
<td>$nama</td>
<td>$deskripsi</td>
<td>Rp. $harga</td>
<td align='center'>
<a href='form_edit.php?kode=$kode&edit=1'>edit</a>
<a href='admin_home.php?kode=$kode&hapus=1'>hapus</a></td>
</tr>";
$i++;
}
?>
</table>
<?php
echo"<form action='form_barang.php' method='post' aligm='center'>";
echo"<p align='center'><input type='submit'name='tambah' value='tambah data' bgcolor=#f00ff></p></form>";
?>
LOGOUT.PHP
<?php session_start();
session_destroy();
echo "<script>alert('Anda sudah logout..!!')</script>";
echo "<script >location.href='index.php';</script>";
?>
0 komentar:
Posting Komentar