Incredibly Slow Loading

[KingWylim]

Dear Coders,

I have a couple of problems with this PHP program but I can not locate them. I have E_ALL set in php.ini and am useing PHP 5 along with MySQL 4.0.25-nt.

I can not figure out why my program is running so horridly slow and why it actually stopped function on certain areas.

When I select a day on my calendar for this program it should print out all data in the database that was logged on that day.

I know that there is no error or fault in the calendar code because running it alone works perfectly with no errors. There seems to be an error with either my entry Function or my Logging function they are following any help in resolving this issue would be greatly appreciated.

This function generates the form for Logging Possession of the Mail

/**
 * Mail Logger designed for PRA International
 * Designed by Alex Autrey
 * @version 1.0
 * @copyright 2005 
 */


function Logging($yyyymm){

$logging_table_row_begin .= "<tr>";
$logging_table_row_end .= "</tr>";
$logging_column_begin .= "<td>";
$logging_column_end .= "</td>";
$day = $_GET["day"];

if($day != "  "){
	$day = "0$day";
}

$useable_date = "$yyyymm$day";
echo "<form method=post action=scripts/process.php?Logging=Update>";

echo "<table border=\"0\" width=\"100%\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">";
echo "<tr>";
echo "<th align=center>&nbsp;</th>";
echo "<th align=center>Track #</th>";
echo "<th align=center>Project ID</th>";
echo "<th align=center>Doc Type</th>";
echo "<th align=center>Scanner</th>";
echo "<th align=center>Processor</th>";
echo "<th align=center>Filer</th>";
echo "<th align=center>Completed</th>";
echo "</tr>";

$hostname = "localhost";
$mysql_user = "root";
$mysql_paswd = "";
$dbname = "test";
$db_table_name = "mts";
$completed_date = date('Y-m-d'); 

$db = mysql_connect($hostname,$mysql_user,$mysql_paswd);
mysql_select_db($dbname,$db);

$query = "SELECT * FROM $db_table_name WHERE EntryDate = '$useable_date' ORDER BY EntryID ASC";
$result = mysql_query($query, $db) or exit(mysql_error());

if(mysql_fetch_array($result) == ""){
	echo "<tr><td colspan=8 align=center>No Data Entered for Selected Date.</td></tr>";
}

while ($myrow = mysql_fetch_row($result)) {

echo "<tr style='background:white;' onMouseOver=\"swapBG(this,'white','orange')\" OnMouseOut=\"swapBG(this,'orange','white')\">";
printf("<td>%s <input type='hidden' name='EntryID' value='%s'></td>", $myrow[0], $myrow[0]); // Entry ID
printf("<td align=center>%s</td>", $myrow[2]); //Tracking Number
printf("<td align=center>%s</td>", $myrow[5]); //Project ID
printf("<td align=center>%s</td>", $myrow[6]); // Document Type

//Checks to see if a Data Scanner has been set if so it returns the information
// if not is allows the person entering the data to input who is checking this
// document out to have that process complted.
if ($myrow[12] == "") {
	echo "<td align=center><input type=text name=data_scanner></td>";
} else {
	printf("<td align=center>%s<input type=hidden name=datascanner value=%s></td>", $myrow[12], $myrow[12]); // Data Scanner
	if($myrow[14] == ""){
		echo "<td align=center><input type=text name=data_scanner2></td>";
	} else {
		printf("<td align=center>%s<input type=hidden name=datascanner2 value=%s></td>", $myrow[14], $myrow[14]);
	}
}
if($myrow[13] == ""){
	echo "<input type=hidden name=datascanner_date value=$completed_date>";
} else {
	echo "<input type=hidden name=datascanner_date value=$myrow[13]>";
}
if($myrow[15] == ""){
	echo "<input type=hidden name=datascanner_date value=$completed_date>";
} else {
	echo "<input type=hidden name=datascanner_date value=$myrow[15]>";
}

//Checks to see if a Processor has been set if so it returns the information
// if not it allows the person entering the data to input who is checking this
// document out to have that process completed.
if($myrow[8] == "") {
	echo "<td align=center><input type=text name=processor></td>";
} else {
	printf("<td align=center>%s<input type=hidden name=processor value=%s></td>", $myrow[8], $myrow[8]); // Processor
	if ($myrow[10] == "") {
	    echo "<td align=center><input type=text name=processor2></td>";
	} else {
		printf("<td align=center>%s<input type=hidden name=processor2 value=%s><td>", $myrwo[10], $myrow[10]);
	}
}
if($myrow[9] == ""){
	echo "<input type=hidden name=datascanner_date value=$completed_date>";
} else {
	echo "<input type=hidden name=datascanner_date value=$myrow[9]>";
}
if($myrow[11] == ""){
	echo "<input type=hidden name=datascanner_date value=$completed_date>";
} else {
	echo "<input type=hidden name=datascanner_date value=$myrow[11]>";
}

//Checks to see if a Filer has been set if so it returns the information
// if not is allows the person entering the data to input who is checking this
// document out to have that process complted.
if ($myrow[16] == "") {
	echo "<td align=center><input type=text name=filer></td>";
} else {
	printf("<td align=center>%s<input type=hidden name=filer value=%s></td>", $myrow[16], $myrow[16]); // Data Scanner
	if($myrow[18] == ""){
		echo "<td align=center><input type=text name=filer2></td>";
	} else {
		printf("<td align=center>%s<input type=hidden name=filer2 value=%s></td>", $myrow[18], $myrow[18]);
	}
}
if($myrow[17] == ""){
	echo "<input type=hidden name=datascanner_date value=$completed_date>";
} else {
	echo "<input type=hidden name=datascanner_date value=$myrow[17]>";
}
if($myrow[19] == ""){
	echo "<input type=hidden name=datascanner_date value=$completed_date>";
} else {
	echo "<input type=hidden name=datascanner_date value=$myrow[19]>";
}

//Checks to see if a Completed date has been set if not it returns the current date.
if ($myrow[20] == "") {
	echo "<td align=center>$completed_date<input type=hidden name=completed_date value=$completed_date></td></tr>\n"; // Completed Date
} else {
	printf("<td align=center>%s <input type=hidden name=completed_date value=%s></td>", $myrow[20], $myrow[20]);
}
}
	echo "<tr><td align=center colspan=11><input type=submit name=submit value=Save></td></tr>";
	echo "</form>";
	echo "</table>";
}

This function generates the form to enter mail.

function EnterMail(){
session_start();
$logged_by = $_SESSION["username"];

$logging_table_row_begin .= "<tr>";
$logging_table_row_end .= "</tr>";
$logging_column_begin .= "<td>";
$logging_column_end .= "</td>";

echo "<form method=post action=scripts/process.php?mailentry=update>";
echo "<center><input type=submit name=submit value=Save></center>";

echo "<table border=\"0\" width=\"100%\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">";
echo "<tr>";
echo "<th>Date</th>";
echo "<th align=center>Track #</th>";
echo "<th align=center>Type of Delivery</th>";
echo "<th align=center>Sent To</th>";
echo "<th align=center>Project ID</th>";
echo "<th align=center>Doc Type</th>";
echo "<th align=center>Logged By</th>";
echo "</tr>";

$today = date('Y-m-d');

for($i=0; $i<=20; $i++) {
	echo "<tr style='background:white;' onMouseOver=\"swapBG(this,'white','orange')\" OnMouseOut=\"swapBG(this,'orange','white')\">";
	echo "<td><input type=hidden name=EntryDate[$i] value=$today>$today</td>";
	echo "<td><input type=text name=tracking_number[$i]></td>";
	echo "<td><input type=text name=delivery_type[$i]></td>";
	echo "<td><input type=text name=SentTo[$i]></td>";
	echo "<td><input type=text name=project_id[$i]></td>";
	echo "<td><input type=text name=doc_type[$i]></td>";
	echo "<td><input type=hidden name=logged_by[$i] value=$logged_by>$logged_by</td>";
	echo "</tr>";
}
echo "</form>";
echo "</table>";
}

[KingWylim]

This function actually enter's the data entered for logging the mail:

if(isset($_GET['Logging']) && $_GET['Logging'] == 'Update'){
	UpdateRecords($EntryID,$processor,$processor_date,$processor2, $processor2_date,$datascanner,$datascanner_date,$datascanner2,$datascanner2_date,$filer,$filer_date,$filer2,$filer2_date,$completed_date);
}



//Updateing the Information in the Database or Entering it for the first time.
function UpdateRecords($EntryID,$processor,$processor_date,$processor2, $processor2_date,$datascanner,$datascanner_date,$datascanner2,$datascanner2_date,$filer,$filer_date,$filer2,$filer2_date,$completed_date){


//Saves the changes that are made by the person logging possession of the documents.			
$hostname = "localhost";
$mysql_user = "root";
$mysql_paswd = "";
$dbname = "test";
$db_table_name = "mts";
$completed_date = date('Y-m-d'); 

$db = mysql_connect($hostname,$mysql_user,$mysql_paswd);
mysql_select_db($dbname,$db);

$query = "UPDATE $db_table_name SET processor='$processor', processor_date='$processor_date', processor2='$processor2', processor2_date='$processor2_date', datascanner='$datascanner', datascanner_date='$datascanner_date', datascanner2='$datascanner2', datascanner2_date='$datascanner2_date', filer='$filer', filer_date='$filer_date', filer2='$filer2', filer2_date='$filer2_date', completed_date='$completed_date' WHERE EntryID='$EntryID'";

$result = mysql_query($query, $db) or die(mysql_error());
echo "<a href=/logging.php>Click Here to Return to the Logging Sheet</a><br>";
}

if(isset($_GET['mailentry']) && $_GET['mailentry'] == 'update'){
	MailLogged($EntryDate,$tracking_number,$delivery_type,$SentTo,$project_id,$doc_type,$logged_by);
}

This function Saves the Entered Mail (or should):

//Updateing the Information in the Database or Entering it for the first time.
function MailLogged($EntryDate,$tracking_number,$delivery_type,$SentTo,$project_id,$doc_type,$logged_by){


//Saves the changes that are made by the person logging possession of the documents.			
$hostname = "localhost";
$mysql_user = "root";
$mysql_paswd = "";
$dbname = "test";
$db_table_name = "mts";
$completed_date = date('Y-m-d'); 

$db = mysql_connect($hostname,$mysql_user,$mysql_paswd);
mysql_select_db($dbname,$db);

$total_entrys = count($Entry_Date);
echo "$total_entrys";

for($i = 0; $i >= $total_entrys; $i++){
	$query = "INSERT INTO $db_table_name
	(EntryDate, tracking_number, delivery_type, SentTo, project_id, doc_type, logged_by)
	VALUES
	('$EntryDate[$i]', '$tracking_number[$i]', '$delivery_type[$i]', '$SentTo[$i]', '$project_id[$i]', '$doc_type[$i]', '$logged_by[$i]')";

	$result = mysql_query($query, $db) or die(mysql_error());
}

echo '<a href=/entry.php>Click Here to Return to the Mail Entry Sheet</a>';
}

[KingWylim]

Please ignore the above. I have been able to narrow the problem down to my top.php page which I can not find any errors in. So I'm thinking that there might be a MySQL error that is not being reported and since it's not being reported I don't know what to do any advice on this would be greatly appreciated.

top.php following:

<?php
include("scripts/process.php");

if (isset($_POST["username"])) {
	$username = $_POST["username"];
    $password = $_POST["password"];
	login($username, $password);
} 

$mysql_errors = mysql_error();
echo "$mysql_errors";
?>
<HTML>
<HEAD>
	<TITLE>PRA - Mail Tracking System</TITLE>
<STYLE>
<!--
	A:link {color:blue; text-decoration:none;}
	A:active {color:green; text-decoration:none;}
	A:visited {color:blue; text-decoration:none;}
	A:hover {color:red; text-decoration:underline; font:bold;}
-->
</STYLE>
<script type="text/javascript" language="javascript">

function swapBG(el, BG1, BG2) {
el.style.background = (el.style.background == BG1) ? BG2 : BG1;
}

</script>
</HEAD>
<BODY TOPMARGIN="0" LEFTMARGIN="0">
<TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
	<TD align="left" colspan="2"><img src="logo_insidepra.jpg" border="0" alt="PRA MTS"><img src="left_02.jpg" height="38" width="80%"></TD>
</TR>
<TR>
	<TD align="center" colspan="2"><h1>PRA Mail Tracking System</h1></TD>
</TR>
<TR>
	<!--Begin Nav Bar-->

<TD width="10%" valign="top">
<?php
  // Main  

  if (isset($_GET["yyyymm"])) {
  	$yyyymm = $_GET["yyyymm"];
	if(strlen($yyyymm) == 6) {
     	$yyyy = substr($yyyymm, 0, 4);
     	$mm = substr($yyyymm, 4, 2);
  	}
  } else {
    $today = getdate();
    $yyyy = $today['year'];
    $mm = $today['mon'];
  }

  gen_month($yyyy, $mm);

echo '<a href="index.php">Home</a></br>';
echo '<a href="index.php#faq">FAQ</a></br>';

if (isset($_SESSION["authorized"]) && $_SESSION["authorized"] == "1") {
	echo '<a href="/scripts/process.php?LogOut=now">Log Out</a><br>';
	echo '<a href="Logging.php">Log Mail</a><br>';
	echo '<a href="Entry.php">Enter Mail</a><br>';
	echo '<a href="search.php">Search</a><br>';
	echo '<a href="/scripts/process.php?User=CP">Control Panel</a><br>';
  } else {
	echo '<a href="index.php">Log In</a><br>';
	echo '<a href="search.php">Search</a><br>';
  }
	echo '</TD>';
?>
	<!--Begin Login-->
	<TD with="90%" valign="top">

The above post have all of the information in them that is included in process.php if anyone was curious of what that was.