hello for all
I have a problem in my php script give me this error:
Fatal error: Maximum execution time of 30 seconds exceeded in
I have for loop in my script and its insert to db by it, the loop staart from 1 to $_GET variable maximum be 15.
this is my code:
<?php
include("config.php");
$class_name=$_GET["classes_name"];
$sort=$_GET["sort"];
$check_query=mysql_query("SELECT *
FROM TABLE_NAME
WHERE grade_name='$class_name'") or die("Error in check query because ".mysql_error());
if(mysql_num_rows($check_query)==1)
{
?>
<table style="width: 100%" class="error">
<tr>
<td style="width: 72px">
<img alt="" src="../images/error.gif" width="60" height="60" class="style1"></td>
<td>the class name "<? echo $class_name; ?> " have been taken
before.<br>
please check the class name again.<br>
if your Browser doesn't support the auto redirection <a href="javascript:history.back(2)">Click here</a>.
<script type="text/javascript">
setTimeout("history.back(2)",10000);
</script>
</td>
</tr>
</table>
<? }
else
{
$sub_classes=$_GET["sub_classes"];
$sub_classes=intval($sub_classes);
for ($ii=1;$ii <= $sub_classes; $ii++)
{
$teacher_subgrade.$ii=$_POST["teacher_subgrade$ii"];
$subgrade.$ii=$_POST["subgrade$ii"];
}
mysql_query("INSERT INTO grades
VALUES('','$class_name')") or die("Error in insert query because ".mysql_error());
$get_id=mysql_query("SELECT grade_id
FROM grades
ORDER BY grade_id DESC
LIMIT 1") or die("Error in get id query because ".mysql_error());
$fetch_id=mysql_fetch_array($get_id);
for ($i=1;$i <= $sub_classes ; $i++)
{
mysql_query("INSERT INTO TABLE_NAME
VALUES ('','$subgrade$i','$teacher_subgrade$i','$class_name','$fetch_id[0]')") or die("Error in insert subgrade query because ".mysql_error());
mysql_query("UPDATE TABLE_NAME
SET grade_id='$subgrade$i',subgrade_id='$i'
WHERE teacher_id='".$teacher_subgrade.$i."'") or die("error in insert query because ".mysql_error());
}
?>
sometimes works correctly and other time dont work
hope can help me
Thanks and Regards
