I have the following code and at times, it seems at randome I get the SERVER 500 error.. any ideas? or may code tweaks?
Thanks
[php]
<?
include('../application.php ');
include('../includes/xajax/xajax.inc.php') ;
set_time_limit( 0);
$xajax = new xajax();
$xajax -> regf('updata');
$xajax -> processRequest( );
$ajax = $xajax -> getJavascript(" ", "../includes/xajax/xajax_js/xajax.js");
function updata()
{
$objResponse = new xajaxResponse() ;
$objResponse -> assign('dinf', "innerHTML" , get_mydata());
return $objResponse;
}
function get_mydata()
{
$code = "<table border=0 width=100% cellpadding=2 cellspacing=1>" ;
$code .= '<tr class="header">
<td align=left width=10 valign=top>#</TD>
<td align=left valign=top>DATE </TD>
<td align=left valign=top>REC</TD>
<td align=left valign=top>DISP </TD>
<td align=left valign=top>ARR</TD>
<td align=left valign=top>COMP </TD>
<td align=left valign=top>NATU RE</TD>
<td width=250 align=left valign=top>LOCA TION</TD>
<td align=left valign=top>UNIT </TD>
<td align=left valign=top>BACK UP</TD>
<td align=left valign=top>ZONE </TD>
<td align=left valign=top>OCA #</TD>
<td align=left valign=top>DISP R</TD>
<td align=left valign=top>D</TD></tr>';
$number=1;
$qc = mysql_query("SE LECT * FROM `cad_cad` ORDER BY `soc_id` ASC");
while ($rc = mysql_fetch_ass oc($qc))
{
extract($rc);
$soc_Date = trim($soc_Date) ;
$soc_Received = trim($soc_Recei ved);
$soc_Dispatched = trim($soc_Dispa tched);
$soc_Arrived = trim($soc_Arriv ed);
$soc_Completed = trim($soc_Compl eted);
$soc_Nature = trim($soc_Natur e);
$soc_Cfs = trim($soc_Cfs);
$soc_Location = trim($soc_Locat ion);
$soc_Unit = trim($soc_Unit) ;
$soc_Backup = trim($soc_Backu p);
$soc_Zone = trim($soc_Zone) ;
$soc_Case = trim($soc_Case) ;
$soc_Dispatcher = trim($soc_Dispa tcher);
$soc_Dispositio n = trim($soc_Dispo sition);
if (empty($soc_Rec eived) and empty($soc_Disp atched) && empty($soc_Arri ved)) $tdclass = "tdrec";
if ($soc_Received != "" && empty($soc_Disp atched) && empty($soc_Arri ved)) $tdclass = "tdrec";
if ($soc_Received != "" && $soc_Dispatched !="" && empty($soc_Arri ved)) $tdclass = "tdyel";
if ($soc_Received != "" && $soc_Dispatched !="" && $soc_Arrived != "") $tdclass = "tdgreen";
if (ltrim($soc_Sta tus)=='Complete d') $tdclass="tdcom pl";
$code .= "<tr>
<td align=left valign=top class=td3><b>". $number."</b></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Date</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Received</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Dispatched</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Arrived</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Completed</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Nature</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Location</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Unit</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Backup</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Zone</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'><a href=\"?oca=$so c_Cfs\">$soc_Ca se</a></span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Dispatcher</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Disposition</span></td>
</tr> ";
$number++;
}
$code .= "</table>";
return $code;
}
?>
<HTML>
<HEAD>
<TITLE>Cad Calls</TITLE>
<style>
.header {font-size: 14px; font-family: "Tahoma, Arial"; color:#ffffff; background-color: #719ece; }
#results TD { font-size:14px; font-family: \"Tahoma, Arial\"; }
.td1{font-size: 14px; font-family: "Tahoma, Arial"; color:#dcdcdc; background-color: #000000; padding: 2px; }
.td2{font-size: 14px; font-family: "Tahoma, Arial"; color:#000000; background-color: #eeeeee; padding: 2px; }
.td3{font-size: 14px; font-family: "Tahoma, Arial"; color:#dcdcdc; background-color: #000000; padding: 2px; }
.td_zone{font-size: 14px; font-family: "Tahoma, Arial"; color:#000000; background-color: #eeeeee; color:#cc0000 }
.text1{font-size: 14px; font-family: "Tahoma, Arial"; color:#000000; background-color: #ffffff;}
.text2{font-size: 14px; font-family: "Tahoma, Arial"; color:#000000; background-color: #ececec;}
.text{font-size: 14px; font-family: "Tahoma, Arial";}
.tdcompl{font-size: 14px; font-family: "Tahoma, Arial"; color:#dcdcdc; background-color: #000000; padding: 2px; }
.tdrec{font-size: 14px; font-family: "Tahoma, Arial"; color:#ff3300; background-color: #000000; padding: 2px; }
.tdyel{font-size: 14px; font-family: "Tahoma, Arial"; color:#ffff00; background-color: #000000; padding: 2px; }
.tdgreen{font-size: 14px; font-family: "Tahoma, Arial"; color:#66cc00; background-color: #000000; padding: 2px; }
.bttn { font-size:12px; font-family:Arial,sa ns-serif; height:25px; background-color:#ffffff; background-image:url(/images/back03.gif); border-style:solid; border: 1 solid #aaaaaa; }
</style>
<meta http-equiv="imagetoo lbar" content="no" />
</HEAD>
<BODY BGCOLOR="#00000 0" alink='#aaaaaa' vlink='#aaaaaa' link='#aaaaaa' leftmargin=0 rightmargin=0 bottommargin=0 topmargin=0 oncontextmenu=" return false" >
<?php
echo $ajax;
if (isset($_GET['oca']))
{
echo '
<table border=0 width=100% cellpadding=2 cellspacing=1>
<tr class="header">
<td align=left width=25% valign=top>Call er Information</TD>
<td align=left valign=top>Call Notes</TD>
</tr>';
$oca = $_GET['oca'];
$qc = mysql_query("SE LECT * FROM `cad_cad` WHERE `soc_Cfs` = '$oca'");
if (mysql_num_rows ($qc) > 0)
{
while ($rc = mysql_fetch_ass oc($qc))
{
extract($rc);
echo "
<tr>
<td align=left width=25% valign=top class='td1'>
Last Name: <font color=yellow>$s oc_Last<br><fon t color=white>
First Name: <font color=yellow>$s oc_First<p><fon t color=white>
Address:<br>
<font color=yellow>$s oc_Address<br>
$soc_City, $soc_State. $soc_ZipCode<p>
<font color=white>
Phone: <font color=yellow>$s oc_Phone<p>
<Font color=white>
10-15 Time: <font color=yellow>$s oc_InCustodyTim e<p>
<Font color=white>
CFS: <font color=yellow>$s oc_Cfs
</td>
<td align=left valign=top class='td1'>$so c_Notes</td>
</tr>";
}
}
echo "</table>";
echo "<br><br><i nput type=button value=\"Back To CAD\" class='bttn' onclick=\"locat ion.replace('ca ddisplay.php')\ "><br><br>" ;
}
else
{
echo "<div id='dinf'>". get_mydata() . "</div>";
echo "
<script type=\"text/javascript\">
function timeupdate()
{
t = setTimeout(\" timeupdate()\", 20000);
xajax_updata();
}
timeupdate();
</script>";
}
?>
</table></BODY></HTML>
[/php]
Thanks
Thanks
[php]
<?
include('../application.php ');
include('../includes/xajax/xajax.inc.php') ;
set_time_limit( 0);
$xajax = new xajax();
$xajax -> regf('updata');
$xajax -> processRequest( );
$ajax = $xajax -> getJavascript(" ", "../includes/xajax/xajax_js/xajax.js");
function updata()
{
$objResponse = new xajaxResponse() ;
$objResponse -> assign('dinf', "innerHTML" , get_mydata());
return $objResponse;
}
function get_mydata()
{
$code = "<table border=0 width=100% cellpadding=2 cellspacing=1>" ;
$code .= '<tr class="header">
<td align=left width=10 valign=top>#</TD>
<td align=left valign=top>DATE </TD>
<td align=left valign=top>REC</TD>
<td align=left valign=top>DISP </TD>
<td align=left valign=top>ARR</TD>
<td align=left valign=top>COMP </TD>
<td align=left valign=top>NATU RE</TD>
<td width=250 align=left valign=top>LOCA TION</TD>
<td align=left valign=top>UNIT </TD>
<td align=left valign=top>BACK UP</TD>
<td align=left valign=top>ZONE </TD>
<td align=left valign=top>OCA #</TD>
<td align=left valign=top>DISP R</TD>
<td align=left valign=top>D</TD></tr>';
$number=1;
$qc = mysql_query("SE LECT * FROM `cad_cad` ORDER BY `soc_id` ASC");
while ($rc = mysql_fetch_ass oc($qc))
{
extract($rc);
$soc_Date = trim($soc_Date) ;
$soc_Received = trim($soc_Recei ved);
$soc_Dispatched = trim($soc_Dispa tched);
$soc_Arrived = trim($soc_Arriv ed);
$soc_Completed = trim($soc_Compl eted);
$soc_Nature = trim($soc_Natur e);
$soc_Cfs = trim($soc_Cfs);
$soc_Location = trim($soc_Locat ion);
$soc_Unit = trim($soc_Unit) ;
$soc_Backup = trim($soc_Backu p);
$soc_Zone = trim($soc_Zone) ;
$soc_Case = trim($soc_Case) ;
$soc_Dispatcher = trim($soc_Dispa tcher);
$soc_Dispositio n = trim($soc_Dispo sition);
if (empty($soc_Rec eived) and empty($soc_Disp atched) && empty($soc_Arri ved)) $tdclass = "tdrec";
if ($soc_Received != "" && empty($soc_Disp atched) && empty($soc_Arri ved)) $tdclass = "tdrec";
if ($soc_Received != "" && $soc_Dispatched !="" && empty($soc_Arri ved)) $tdclass = "tdyel";
if ($soc_Received != "" && $soc_Dispatched !="" && $soc_Arrived != "") $tdclass = "tdgreen";
if (ltrim($soc_Sta tus)=='Complete d') $tdclass="tdcom pl";
$code .= "<tr>
<td align=left valign=top class=td3><b>". $number."</b></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Date</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Received</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Dispatched</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Arrived</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Completed</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Nature</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Location</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Unit</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Backup</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Zone</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'><a href=\"?oca=$so c_Cfs\">$soc_Ca se</a></span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Dispatcher</span></td>
<td align=left valign=top class='".$tdcla ss."'><span class='text'>$s oc_Disposition</span></td>
</tr> ";
$number++;
}
$code .= "</table>";
return $code;
}
?>
<HTML>
<HEAD>
<TITLE>Cad Calls</TITLE>
<style>
.header {font-size: 14px; font-family: "Tahoma, Arial"; color:#ffffff; background-color: #719ece; }
#results TD { font-size:14px; font-family: \"Tahoma, Arial\"; }
.td1{font-size: 14px; font-family: "Tahoma, Arial"; color:#dcdcdc; background-color: #000000; padding: 2px; }
.td2{font-size: 14px; font-family: "Tahoma, Arial"; color:#000000; background-color: #eeeeee; padding: 2px; }
.td3{font-size: 14px; font-family: "Tahoma, Arial"; color:#dcdcdc; background-color: #000000; padding: 2px; }
.td_zone{font-size: 14px; font-family: "Tahoma, Arial"; color:#000000; background-color: #eeeeee; color:#cc0000 }
.text1{font-size: 14px; font-family: "Tahoma, Arial"; color:#000000; background-color: #ffffff;}
.text2{font-size: 14px; font-family: "Tahoma, Arial"; color:#000000; background-color: #ececec;}
.text{font-size: 14px; font-family: "Tahoma, Arial";}
.tdcompl{font-size: 14px; font-family: "Tahoma, Arial"; color:#dcdcdc; background-color: #000000; padding: 2px; }
.tdrec{font-size: 14px; font-family: "Tahoma, Arial"; color:#ff3300; background-color: #000000; padding: 2px; }
.tdyel{font-size: 14px; font-family: "Tahoma, Arial"; color:#ffff00; background-color: #000000; padding: 2px; }
.tdgreen{font-size: 14px; font-family: "Tahoma, Arial"; color:#66cc00; background-color: #000000; padding: 2px; }
.bttn { font-size:12px; font-family:Arial,sa ns-serif; height:25px; background-color:#ffffff; background-image:url(/images/back03.gif); border-style:solid; border: 1 solid #aaaaaa; }
</style>
<meta http-equiv="imagetoo lbar" content="no" />
</HEAD>
<BODY BGCOLOR="#00000 0" alink='#aaaaaa' vlink='#aaaaaa' link='#aaaaaa' leftmargin=0 rightmargin=0 bottommargin=0 topmargin=0 oncontextmenu=" return false" >
<?php
echo $ajax;
if (isset($_GET['oca']))
{
echo '
<table border=0 width=100% cellpadding=2 cellspacing=1>
<tr class="header">
<td align=left width=25% valign=top>Call er Information</TD>
<td align=left valign=top>Call Notes</TD>
</tr>';
$oca = $_GET['oca'];
$qc = mysql_query("SE LECT * FROM `cad_cad` WHERE `soc_Cfs` = '$oca'");
if (mysql_num_rows ($qc) > 0)
{
while ($rc = mysql_fetch_ass oc($qc))
{
extract($rc);
echo "
<tr>
<td align=left width=25% valign=top class='td1'>
Last Name: <font color=yellow>$s oc_Last<br><fon t color=white>
First Name: <font color=yellow>$s oc_First<p><fon t color=white>
Address:<br>
<font color=yellow>$s oc_Address<br>
$soc_City, $soc_State. $soc_ZipCode<p>
<font color=white>
Phone: <font color=yellow>$s oc_Phone<p>
<Font color=white>
10-15 Time: <font color=yellow>$s oc_InCustodyTim e<p>
<Font color=white>
CFS: <font color=yellow>$s oc_Cfs
</td>
<td align=left valign=top class='td1'>$so c_Notes</td>
</tr>";
}
}
echo "</table>";
echo "<br><br><i nput type=button value=\"Back To CAD\" class='bttn' onclick=\"locat ion.replace('ca ddisplay.php')\ "><br><br>" ;
}
else
{
echo "<div id='dinf'>". get_mydata() . "</div>";
echo "
<script type=\"text/javascript\">
function timeupdate()
{
t = setTimeout(\" timeupdate()\", 20000);
xajax_updata();
}
timeupdate();
</script>";
}
?>
</table></BODY></HTML>
[/php]
Thanks
Comment