proses input stok nya :
<?
$host="localhost";
$user="root";
$password="";
$database="galon";
mysql_connect("$host","$user","$password")or die("cannot connect");
mysql_select_db("$database")or die(" cannot selectt DB");
$merek=$_POST['merek'];
$sisa=$_POST['sisa'];
$tanggal=date("d M Y");
$merek=stripslashes($merek);
$sisa=stripslashes($sisa);
$merek=mysql_real_escape_string($merek);
$sisa=mysql_real_escape_string($sisa);
$query = "insert into stok values('$tanggal','$merek','$sisa')";
$result=mysql_query($query);
header("location:inputstok.php");
?>
ini inputstok
<?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>
<h2 style="text-align: center;">Input Stok</h2>
<div id="kiri">
<?php
echo "Jumlah Stok :<br>";
$host="localhost";
$user="root";
$password="";
$database="galon";
mysql_connect("$host","$user","$password")or die("cannot connect");
mysql_select_db("$database")or die(" cannot selectt DB");
$query = "SELECT * FROM stok ";
$exe = mysql_query($query);
while($row = mysql_fetch_assoc($exe)){
$a = $row['merek'];
$b = $row['sisa'];
$tanggal = $row['tanggal'];
echo "$tanggal<br><tr><td>$a :</td></tr>
<tr><td>$b</td></tr><br>";
}
?>
</div>
<div id="kanan">
<form action="proses_input_stok.php" method="POST">
<table border="0" cellpadding="5" cellspacing="0">
<tbody>
<tr>
<td>Merek Galon</td>
<td>:</td>
<td>
<select name="merek">
<option value="aqua" selected="Aqua">Aqua</option>
<option value="akua">Akua</option>
<option value="JS">JS</option>
<option value="JM">JM</option>
<option value="ballo">Ballo</option>
</select></td>
</tr>
<tr>
<td>Jumlah Stok</td>
<td>:</td>
<td><input style="width:50px; border:1px solid blue; border-radius:4px; -moz-border-radius:4px; height:20px; margin-left:10px;" type="text" name="sisa" maxlength="20" required="required" /></td>
</tr>
<tr>
<td align="right" colspan="3"><input type="submit" name="submit" value="Simpan" /></td>
</tr>
</tbody>
</table>
</form>
</div>
</body>
</html>
Tidak ada komentar:
Posting Komentar