i changed to GET for $maklumat....
but still the same...
to make it easier,i attach my two pages code
this is the first page(semakAduan.php):
Code: Select all
<?php
include("../inc/config.php");
?>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<form name="myform">
<table width="100%" border="1" bgcolor="#FF9900" bordercolor="#333333" align="center">
<tr>
<td align="center" bgcolor="#FFCC00"> <font face="verdana" size="2" color="white"><b>
<font color="#000000">MODUL SENARAI PAPARAN ADUAN KEROSAKAN YANG BELUM
DI BAIKPULIH </font></b></font> </td>
</tr>
</table>
<br>
<?
function query($query, $line, $file)
{
$result = mysql_query($query);
if (empty($result) && ini_get('display_errors') == 1)
{
echo mysql_error().": ";
echo mysql_errno()."<br />\n";
echo $query."<br />\n";
echo "@ $line in $file\n";
}
return $result;
}
?>
<?
//***********PANGGIL DATA DARIPADA PANGKALAN DATA******
$result=query("Select * from aduankerosakan where status = 'Baru' ", __LINE__, __FILE__);
$senarai=result;
if (empty($senarai))
{
?>
<br>
<table width="100%" border="0"align="center">
<tr>
<td align="center">
<font face="verdana" size="2" color="red"><b>
Maaf ! Tiada maklumat di dalam pangkalan data
</b></font>
</td>
</tr>
</table>
<P><BR>
<?
}
else {
?>
<!--**********TABLE PAPARAN VIEW********************-->
<TABLE BORDER="1" WIDTH="100%" BGCOLOR="#FFFFFF" align=center cellPadding=1 cellSpacing=1 borderColor=black height=1 style="HEIGHT: 1px">
<TR ALIGN="CENTER">
<TD ALIGN="CENTER" BGCOLOR="#FFCC00"> <font face="verdana" size="2" color="white"><strong>
<font color="#000000">Bil </font></strong></font> </TD>
<TD ALIGN="CENTER" BGCOLOR="#FFCC00"> <font face="verdana" size="2" color="white"><strong>
<font color="#000000">ID Aduan </font></strong></font> </TD>
<TD ALIGN="CENTER" BGCOLOR="#FFCC00"> <font face="verdana" size="2" color="white"><strong>
<font color="#000000">Tarikh Aduan </font></strong></font> </TD>
<TD ALIGN="CENTER" BGCOLOR="#FFCC00"> <font face="verdana" size="2" color="white"><strong>
<font color="#000000">Waktu Aduan </font></strong></font> </TD>
<TD ALIGN="CENTER" BGCOLOR="#FFCC00"> <font face="verdana" size="2" color="white"><strong>
<font color="#000000">ID Major </font></strong></font> </TD>
<TD ALIGN="CENTER" BGCOLOR="#FFCC00"> <font face="verdana" size="2" color="white"><strong>
<font color="#000000">Punca </font></strong></font> </TD>
<TD ALIGN="CENTER" BGCOLOR="#FFCC00"> <font face="verdana" size="2" color="white"><strong>
<font color="#000000">Status </font></strong></font> </TD>
</TR>
<?
$bil=1;
while ($senarai = mysql_fetch_array($result, MYSQL_ASSOC))
{
?>
<TR>
<TD><font face="verdana" size="2"><?=$bil?></font></TD>
<TD><a href="semakAduan1.php?id=<?=$senarai["idAduan"]?>"><font face="verdana" size="2"><?=$senarai["idAduan"]?></font></a></TD>
<TD><font face="verdana" size="2"><?=$senarai["tarikhAduan"]?></font></TD>
<TD><font face="verdana" size="2"><?=$senarai["waktuAduan"]?></font></TD>
<TD><font face="verdana" size="2"><?=$senarai["idMajor"]?></font></TD>
<TD><font face="verdana" size="2"><?=$senarai["punca"]?></font></TD>
<TD><font face="verdana" size="2"><?=$senarai["status"]?></font></TD>
</TR>
<?
$bil=$bil+1;
}
?>
</table>
<?
}
?>
<P><BR>
</form>
<pre><?php
print_r($_POST); // print_r()
?></pre>
</BODY>
</HTML>
and this is the second page(semakAduan1.php),where i have to get the id from semakAduan.php):
Code: Select all
<?php
extract($_GET);
include("../inc/config.php");
include("../inc/veryuseful.inc");
function query($query,$line, $file)
{
$result = mysql_query($query);
if (empty($result) && ini_get('display_errors') == 1)
{
echo mysql_error().": ";
echo mysql_errno()."<br />\n";
echo $query."<br />\n";
echo "@ $line in $file\n";
}
return $result;
}
?>
<html>
<head>
<meta NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</head>
<body>
<form name="myform">
<?
//'{$_GET["id"]}'
$status= "Diproses";
$jenis="BM";
$result = query("UPDATE aduankerosakan SET status = '" . $status . "' WHERE idAduan = '" . $_GET['id'] . "'", __LINE__, __FILE__);
$maklumat = query("SELECT * FROM aduankerosakan INNER JOIN tpartminor ON aduankerosakan.idMajor = tpartminor.idMajor WHERE aduankerosakan.idAduan ='" . $_GET['id'] . "'", __LINE__, __FILE__);
//----------------------------------------------------
// CAPAI DATA DARIPADA PANGKALAN DATA
// NAMA TABLE : PEKERJA
//----------------------------------------------------
$pekerja = query("SELECT * FROM temployee where status = 'BMW'", __LINE__, __FILE__);
//----------------------------------------------------
// CAPAI DATA DARIPADA PANGKALAN DATA
// NAMA TABLE : tpartminor
//----------------------------------------------------
$komponen = query("SELECT * FROM tpartminor", __LINE__, __FILE__);
?>
<table align="center" border="1" width="100%">
<tr>
<td align="center">
<table width="100%" align="center" border="0">
<tr>
<td align="center" width="25%"> </td>
<td align="center" width="50%"><img src="../images/logo.gif" WIDTH="170" HEIGHT="53"></td>
<td align="center" width="25%">
<font size="2" color="black"><strong>
TARIKH : <?=$maklumat["tarikhAduan"]?>
</strong></font>
</td>
</tr>
</table>
<br>
<table align="center" width="100%">
<tr>
<td width="70%">
<font size="2" color="black"><strong>
BORANG LAPORAN KERJA PEMBAIKAN KEROSAKAN MESIN
</strong></font>
</td>
<td align="right">
<font size="2" color="black"><strong>
NO ID ADUAN : <?=$maklumat["idAduan"]?>
</strong></font>
</td>
</table>
<br>
<table border="1" width="100%">
<tr>
<td width="50%">
<table width="100%" align="center">
<tr>
<td> <font size="2" color="black"><strong> Maklumat Mesin </strong></font>
</td>
</tr>
<tr>
<td> <font size="2" color="black"> Nama Aset : CENTRIFUGAL PUMP</font></td>
</tr>
<tr>
<td> <font size="2" color="black"> ID Major:
<?=$maklumat["idMajor"]?>
</font> </td>
</tr>
<tr>
<td> <font size="2" color="black"> ID Minor:
<?=$maklumat["idMinor"]?>
</font> </td>
</tr>
<tr>
<td> <font size="2" color="black"> Minor Name:
<?=$maklumat["minorName"]?>
</font> </td>
</tr>
<tr>
<td> <font size="2" color="black"> Stok :
<?=$maklumat["jmlhStok"]?>
</font> </td>
</tr>
</table>
</td>
<td width="50%" rowspan="2">
<p> <font size="2"><strong>Deskripsi Tugas</strong></font> <br>
<?=$maklumat["punca"]?></textarea>
</p>
<p> </p>
<p> </p>
<p> </p>
</td>
</tr>
</table>
<br>
<table align="center" width="100%">
<tr>
<td width="70%">
<font size="2" color="black"><strong>
SENARAI KOMPONEN
</strong></font>
</td>
</table>
<br>
<table border="1" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td align="center"><strong>Kod Pekerja</strong></td>
<td align="center"><strong>Tarikh Mula</strong></td>
<td align="center"><strong>Masa Mula</strong></td>
<td align="center"><strong>Tarikh Tamat</strong></td>
<td align="center"><strong>Masa Tamat</strong></td>
<td align="center" width="30%"><strong>Nama Komponen</strong></td>
<td align="center"><strong>Kuantiti</strong></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<br>
<table border="1" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td width="50%">
<table align="center" width="100%">
<tr>
<td><font size="2"><strong> Jumlah Masa Kerosakan</strong></font></td>
</tr>
<tr>
<td><font size="2"><strong>
_______Hari ________Jam _________Minit<br>
</strong></font></td>
</tr>
</table>
</td>
<td width="50%">
<table align="center" width="100%">
<tr>
<td><font size="2"><strong> </strong></font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" colspan="2">
<p>
<font size="2"><strong> Maklumat Kerja</strong></font>
</p>
<p> </p>
<table align="center" width="100%">
<tr>
<td width="70%">
<font size="2" color="black"><strong>
Penyelia Yang Terlibat :__________________________
</strong></font>
</td>
<td align="left">
<font size="2" color="black"><strong>
Tarikh :____________________
</strong></font>
</td>
</table>
</td>
</tr>
</table>
<br>
<p>
<font size="2" color="black"><strong>
Kerja Sempurna Disahkan Oleh :
</strong></font>
</p>
<table border="0" width="100%">
<tr>
<td width="25%"> </td>
<td width="25%"> </td>
<td width="25%">
<font size="2" color="black"><strong>
Tarikh Pengesahan
</strong></font>
</td>
<td width="25%">
<font size="2" color="black"><strong>
Tandatangan
</strong></font>
</td>
</tr>
<tr>
<td width="25%">
<font size="2" color="black"><strong>
Subkontrak
</strong></font>
</td>
<td width="25%">______________</td>
<td width="25%">______________</td>
<td width="25%">______________</td>
</tr>
<tr>
<td width="25%">
<font size="2" color="black"><strong>
PMSB
</strong></font>
</td>
<td width="25%">______________</td>
<td width="25%">______________</td>
<td width="25%">______________</td>
</tr>
<tr>
<td width="25%">
<font size="2" color="black"><strong>
Hospital
</strong></font>
</td>
<td width="25%">______________</td>
<td width="25%">______________</td>
<td width="25%">______________</td>
</tr>
</table>
<br><br>
</td></tr>
</table>
<p align="center">
<font face="verdana" size="2" color="red"><strong>
* Sila cetak dan simpan salinan laporan kerja ini untuk proses penyimpanan maklumat kerosakan
dan pengesahan...
</strong></font>
</p>
<center>
<a href="javascript:if (window.print != null) { window.print(); } else { alert('Harap Maaf, pelayar anda tidak dapat menyokong fungsi ini. Sila pilih Print daripada menu File.'); }"><b> CETAK</b></a>
<br><!--
<a href="../mainframe.htm"><b> KEMBALI</b></a>
-->
</center>
</form>
<pre><?php
print_r($_POST); // print_r()
?></pre>
</body>
</html>
from here,the problem in this topic occurs...
so any idea?