Untitled

<?php
session_start();
$user_id=$_SESSION['user_id'];
$user_pass=$_SESSION['user_pass'];
if(!isset($_SESSION['user_id']) or ! isset($_SESSION['user_pass']))
{
	header("location:../index.html");
}
?>


<?php
include "../db.php";

if(isset ($_POST['submit']))
{
	$id=addslashes($_POST['id']);
	$nama_masalah=addslashes($_POST['nama_masalah']);
	$solusi_masalah=addslashes($_POST['solusi_masalah']);
	$dept=addslashes($_POST['dept']);
	$user=addslashes($_POST['user']);
	$time=addslashes($_POST['time']);
	$tgl=addslashes($_POST['tgl']);
	$ket=addslashes($_POST['ket']);


	if(empty($nama_masalah)||empty($solusi_masalah)||empty($dept)||empty($user)||empty($time)||empty($tgl)||empty($ket))
 {
?>
<script language="JavaScript">
alert('Data Belum Lengkap');
</script>
<?php
 }
 else
 {

// insert data ke dalam tabel sparepart
$sql =mysql_query("insert into laporan_problem (nama_masalah,solusi_masalah,dept,user,time,tgl,ket) values ('$nama_masalah','$solusi_masalah','$dept','$user','$time','$tgl','$ket')");

if($sql)
{


?>
<script language="JavaScript">
alert('DATA TELAH DIINPUT');

</script>
<?php
}
else{
echo mysql_error();
}
 }
}

?>


<html>
<head>
<title> DB TEKNISI</title>
<link href="../style.css" rel="stylesheet" type="text/css">
<table width="996" height="471" border="0" cellpadding="0" cellspacing="0" bgcolor="#ffffff" valign="top" marginheight="0">
<tr>
<td width="992" height="405" valign="top" class="tabtex">
<div align="center">
<table widt="481" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<form action=""method="post"name="frmguest">
<tr>
<td height="21" colspan="2" align="center" valign="middle" bgcolor="#A8A8A8">INPUT DATA REPORTING MASALAH</td>
</tr>
<tr>
<td height="15" colspan="2" valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>
</tr>

<tr>
<td width="101" height="18" valign="meiddle">&nbsp;Nama Masalah</td>
<td width="378" valign="meiddle">:

 <?

// Menarik data dari tabel jenis, colom nama ke option
$sql ="select nama_masalah from masalah";
$query =mysql_query($sql);
echo "<select name=\"nama_masalah\" >";
while($data =mysql_fetch_array($query)){
echo "<option value=\"".$data['nama_masalah']."\" >".$data['nama_masalah']."</option>";
}
echo "</select>";
?>


<tr>
<td height="18" valign="middle"><!--DWLayoutEmptyCell-->&nbsp;</td>

</tr>

<tr>
<td width="101" height="18" valign="meiddle">&nbsp;User</td>
<td width="378" valign="meiddle">:

 <?

// Menarik data dari tabel jenis, colom nama ke option
$sql ="select nama_user from user";
$query =mysql_query($sql);
echo "<select name=\"user\" >";
while($data =mysql_fetch_array($query)){
echo "<option value=\"".$data['nama_user']."\" >".$data['nama_user']."</option>";
}
echo "</select>";
?>


<tr>
<td height="18" valign="middle"><!--DWLayoutEmptyCell-->&nbsp;</td>

</tr>

<tr>
<td width="101" height="18" valign="meiddle">&nbsp;Departement</td>
<td width="378" valign="meiddle">:

 <?

// Menarik data dari tabel jenis, colom nama ke option
$sql ="select nama_dept from dept";
$query =mysql_query($sql);
echo "<select name=\"dept\" >";
while($data =mysql_fetch_array($query)){
echo "<option value=\"".$data['nama_dept']."\" >".$data['nama_dept']."</option>";
}
echo "</select>";
?>


<tr>
<td height="18" valign="middle"><!--DWLayoutEmptyCell-->&nbsp;</td>

</tr>


<tr>
<td width="101" height="18" valign="meiddle">&nbsp;Tanggal</td>
<td width="378" valign="meiddle">:

 <input name="tgl"type ="text"id="tgl"size="20"maxlength="20"></td>

<tr>
<td height="18" valign="middle"><!--DWLayoutEmptyCell-->&nbsp;</td>

</tr>
<tr>
<td width="101" height="18" valign="meiddle">&nbsp;Waktu</td>
<td width="378" valign="meiddle">:

 <input name="time"type ="text"id="time"size="30"maxlength="20"></td>

<tr>
<td height="18" valign="middle"><!--DWLayoutEmptyCell-->&nbsp;</td>

</tr>


<tr>
<td width="101" height="18" valign="meiddle">&nbsp;Solusi Masalah</td>
<td width="378" valign="meiddle">:

  <textarea name="solusi_masalah" cols="50" rows="3" id="solusi_masalah"></textarea></td>

<tr>
<td height="18" valign="middle"><!--DWLayoutEmptyCell-->&nbsp;</td>

</tr>

<tr>
<td height="49" valign="top">&nbsp;Keterangan</td>
<td valign="top">&nbsp; <textarea name="ket" cols="50" rows="3" id="ket"></textarea>
</tr>

<tr>
<td height="18" valign="middle"><!--DWLayoutEmptyCell-->&nbsp;</td>

</tr>
<tr>
<td height="14"></td>

<td><input name="submit" type="submit" id="submit" value="ISI DATA"> <input type="reset"name="Reset"value="BATAL">

<a href="../view/rpt_problem.php">Lihat Data</a>
 </tr>
 </table>
 <br>
 </div>
</div>
</td>
<?php
include "../in_.html";
?>
</tr>
</table>


</td>


</tr>
<tr>
 <td colspan="3">
<table width="1003" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000">
<tr>
    <td>
	<table width="1003" cellspacing="1" cellpadding="3" border="0">

<tr>
    <td colspan="3" width="999" height="15" bgcolor="#ACB8D2" class="menu" align="right" background="../images/rowbg.gif"><!--Untere Tabellenzelle oben volle Breite-->
	  <div align="center"></div></td>

</tr>
</table>
</td>
</tr>
</table>

</td>
</tr>
</table></div>


</body>
</html>