[ask]
delete nya tidak berfungsi >.< kenapa ya
<?PHP
session_start();
if (!(isset($_SESSION['user']) && $_SESSION['user'] != '')) {
header ("Location: index");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Home</title>
<link rel="stylesheet" href="css/stylenavigasi.css" />
<link rel="stylesheet" href="css/style.css" />
</head>
<body>
<ul id="nav">
<li><a href="home">Home</a></li>
<li>
<a href="#">Input Data</a>
<ul>
<li><a href="inputpelanggan">Input Data Pelanggan</a></li>
<li><a href="inputstok">Input Stok</a></li>
</ul>
</li>
<li><a href="cekstok">Cek Stok</a></li>
<li><a href="fun">Jangan Di Klik XD</a></li>
<li><a href="logout">Logout</a></li>
<li>
</ul>
<div id="jam"> <script type="text/javascript">
//var currenttime = '<!--#config timefmt="%B %d, %Y %H:%M:%S"--><!--#echo var="DATE_LOCAL" -->' //SSI method of getting server date
var currenttime = '<? print date("F d, Y H:i:s", time()+60*60*7)?>' //PHP method of getting server date
var montharray=new Array("Januari","Februari","Maret","April","Mei","Juni","Juli","Agustus","September","Oktober","November","Desember")
var serverdate=new Date(currenttime)
function padlength(what){
var output=(what.toString().length==1)? "0"+what : what
return output
}
function displaytime(){
serverdate.setSeconds(serverdate.getSeconds()+1)
var datestring=montharray[serverdate.getMonth()]+" "+padlength(serverdate.getDate())+", "+serverdate.getFullYear()
var timestring=padlength(serverdate.getHours())+":"+padlength(serverdate.getMinutes())+":"+padlength(serverdate.getSeconds())
document.getElementById("servertime").innerHTML=datestring+" "+timestring
}
window.onload=function(){
setInterval("displaytime()", 1000)
}
</script>
<p><span id="servertime"></span></p></li>
</div>
<div id="kiri"></div>
<div id="kanan"></div>
<?php
mysql_connect("localhost","root","");
mysql_select_db("galon");
$warnaGenap = "lightgreen"; // warna abu-abu
$warnaGanjil = "yellow"; // warna putih
$warnaHeading = "pink"; // warna merah untuk heading tabel
$query = "SELECT * FROM stok" or die(mysql_error());
$hasil = mysql_query($query);
echo "<br><center><table border='1'>";
echo "<tr bgcolor='".$warnaHeading."'>
<td> Tanggal </td>
<td> Merek Galon </td>
<td> SISA STOK</td>
</tr>";
$counter = 1;
while($data = mysql_fetch_array($hasil))
{
// cek apakah counternya ganjil atau genap
if ($counter % 2 == 0) $warna = $warnaGenap;
else $warna = $warnaGanjil;
echo "<tr bgcolor='".$warna."'>";
echo "<td>".$data['tanggal']."</td>";
echo "<td>".$data['merek']."</td>";
echo "<td>".$data['sisa']."</td>";
//proses hapus & edit
echo '<td><a href="proses_hapus_stok.php">hapus</a></td>';
echo '<td><a href="proses_edit_stok.php">edit</a></td>';
echo "</tr>";
$counter++; // menambah counter
}
echo "</table></center>";
?>
</body>
</html>
nah untuk proses_hapus_stok.php
<?
$host="localhost";
$user="root";
$password="";
$database="galon";
$tabel="stok";
mysql_connect("$host","$user","$password")or die("cannot connect");
mysql_select_db("$database")or die(" cannot selectt DB");
$merek = $_GET['merek'];
$query = " delete from $tabel where merek = '$merek'";
$hasil = mysql_query($query);
if ($hasil) {
header("location: cekstok.php");
}
?>
Tidak ada komentar:
Posting Komentar