this is my code:
[code]
<?php
ob_start();
include("../inc/config.php");
function query($query, $link, $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;
}
$Tdate = getdate();
$datToday = strftime("%m/%d/%Y");
$NowYear=strftime($datToday,"%Y");
$mulaServis=$_POST["mulaServis"];
$tamatServis=$_POST["tamatServis"];
$start=date("YmdHis",strtotime($mulaServis));
$end=date("YmdHis",strtotime($tamatServis));
?>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<form name="myform" action="outSnapKomponen1.php">
<table width="100%" border="1" bgcolor="#666666" bordercolor="#333333" align="center">
<tr>
<td align="center">
<b>
BILANGAN KEROSAKAN BERDASARKAN KOMPONEN
</b>
</td>
</tr>
</table>
<br>
<?php
//****************PANGGIL SEMUA PEKERJA***********
$viewall=query("Select * from repairbreakdown inner join komponen on repairbreakdown.komponen = komponen.id WHERE repairbreakdown.waktuTamat BETWEEN '$start' AND '$end'", $link, __LINE__, __FILE__);
$senarai=mysql_fetch_array($viewall);
?>
<?php
if (empty($senarai))
{
?>
<br>
<table width="100%" border="0"align="center">
<tr>
<td align="center">
<b>
Maaf ! Tiada maklumat di dalam pangkalan data
</b>
</td>
</tr>
</table>
<P><BR>
<CENTER>
<A HREF="snapMenu.php">
<STRONG>
KEMBALI
</STRONG>
</A>
</CENTER>
<?php
}
else
{
$bil=1;
?>
<?php
while($senarai)
{
?>
<?php
//----------------------------------------------------
// CAPAI DAN TABLE SEMENTARA
// NAMA TABLE : TEMPLOKASI
//----------------------------------------------------
$viewCheck=query("SELECT * FROM tempkomponen WHERE komponen = '{$senarai["alat"]}' ORDER BY komponen", $link, __LINE__, __FILE__);
$periksa=mysql_fetch_array($viewCheck);
if (empty($periksa))
{
//----------------------------------------------------------------
//SEKIRANYA TIADA LOKASI YANG SAMA DALAM PANGKALAN DATA TEMPLOKASI
//----------------------------------------------------------------
$jumlah=1;
$SQLinsert=query("INSERT INTO tempkomponen(komponen,jumlah) VALUES('{$senarai["alat"]}','$jumlah')", $link, __LINE__, __FILE__);
}
else
{
//----------------------------------------------------------------
//SEKIRANYA ADA LOKASI YANG SAMA DALAM PANGKALAN DATA TEMPLOKASI
//----------------------------------------------------------------
$nilai=$periksa["jumlah"]+1;
$SQLupd=query("UPDATE tempkomponen SET jumlah = '$nilai' WHERE komponen ='{$senarai["alat"]}'", $link, __LINE__, __FILE__);
}
$bil=$bil+1;
}
?>
</table>
<P><BR>
<?php
//----------------------------------------------------
// CAPAI DAN TABLE SEMENTARA
// NAMA TABLE : TEMPLOKASI
//----------------------------------------------------
$viewCheck=query("SELECT * FROM tempKomponen order by komponen", $link, __LINE__, __FILE__);
$periksa1=mysql_fetch_row($viewCheck);
?>
<?php
$ParameterCounter=1;
while($periksa1)
$alat[]=$periksa1[0];
$jum[]=$periksa1[1];
{
?>
<?php
session_start();
$_SESSION["firstquarter"] = $alat;
$_SESSION["firstquarter2"] = $jum;
$ParameterCounter=$ParameterCounter+1;
}
?>
<center><IMG SRC="outSnapkomponen1.php"></center>
<BR><BR>
<CENTER>
<strong>
Anda dikehendaki menekan butang delete terlebih dahulu sekiranya anda hendak melihat keputusan yang tepat pada masa yang akan datang......
</strong></strong>
<br><br><br>
<input style="BACKGROUND-COLOR: #cccccc; BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; COLOR: #333333; FONT-FAMILY: Verdana; FONT-SIZE: 7pt" type="submit" value="DELETE" name="submit">
</center>
<?php
}
?>
</form>
</BODY>
</HTML>
[code]
but..it gives me this error:
Fatal error: Maximum execution time of 30 seconds exceeded in g:\programming\phpdev\www\mmis\analysis\outsnapkom ponen.php on line 7
the line 7 is:
Code:
$result = mysql_query($query);
connection timeout
