Update multiple checkboxes (PHP/MySQL): PHP, MySQL

by: kcalderPosted on 2009-09-06 at 01:24:28ID: 25269122

Oops, just seen that I forgot to add the screenshot!

checkbox.jpg
- 108 KB
checkboxes

by: Ray_PaseurPosted on 2009-09-06 at 07:11:23ID: 25269990

Checkboxes that are not checked do not appear in the $_POST array. See the code snippet...

<?php // RAY_checkbox_test.php
error_reporting(E_ALL);
 
// IF THE FIELDS HAVE BEEN POSTED
if (!empty($_POST["_submit"]))
{
// CHECK FOR AT LEAST ONE BOX CHECKED - REMOTE THE SUBMIT BUTTON
   unset($_POST["_submit"]);
 
// IF THE POST ARRAY IS EMPTY NOW, NO BUTTONS WERE CHECKED
   if (empty($_POST))
   {
      echo "YOU DID NOT CHOOSE A CHECKBOX";
   }
   else
   {
      echo "THANK YOU!";
      var_dump($_POST); // SHOW WHAT WAS CHECKED
   }
}
// END OF PHP - PUT UP FORM
?>
<html>
<body>
<form method="POST">
CHECK OR UNCHECK BOXES<br/>
BOX1 <input name="box1" type="checkbox" value="MyBox1" <?php if (isset($_POST["box1"])) echo " checked"; ?> /><br/>
BOX2 <input name="box2" type="checkbox" value="MyBox2" <?php if (isset($_POST["box2"])) echo " checked"; ?> /><br/>
<input type="submit" name="_submit"  value="go" />
</form>
</body>
</html>

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:

Select all Open in new window

by: Ray_PaseurPosted on 2009-09-06 at 07:14:39ID: 25270003

Your example looks more like this one (not a "delete" but similar, in that it uses an array for the checkboxes). I think your script needs to be aware of the checkboxes so it can test for and update the on and off conditions for each checkbox. Perhaps using a named element of the checkbox() array would be an easy way to go after this problem.

Best regards, ~Ray

<?php // RAY_checkbox_delete.php
error_reporting(E_ALL);
echo "<pre>\n";
 
// IF ANYTHING IS POSTED?
if (!empty($_POST))
{
// DUMP THE POST ARRAY TO SHOW WHAT CAME THROUGH
   echo "POST: "; var_dump($_POST); echo "\n\n";
 
// ITERATE OVER THE "box" SUB-ARRAY TO SHOW WHAT WAS CHECKED
   foreach ($_POST["box"] as $id)
   {
      $sql = 'DELETE FROM mytable WHERE id = ' . $id;
      echo "\n$sql"; // IN REAL LIVE WE WOULD RUN THIS QUERY - HERE WE JUST PRINT IT
   }
}// END PHP, PUT UP THE FORM
?>
<form method="POST">
CHECK A BOX TO INDICATE THAT YOU WANT TO DELETE THE RECORD
<input name=box[] type="checkbox" value="1">ONE
<input name=box[] type="checkbox" value="2">TWO
<input name=box[] type="checkbox" value="3">TRE
<input name=box[] type="checkbox" value="4">FOR
<input type="submit" />
</form>

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:

Select all Open in new window

by: kcalderPosted on 2009-09-06 at 11:11:00ID: 25270881

Thanks for posting. I need to loop through to determine the checked status of each checkbox in order to update the table. For this I need to identify not just the checkbox value but the checked status (0 or 1). How can I achieve this?

by: Ray_PaseurPosted on 2009-09-06 at 11:12:10ID: 25270887

I _think_ a named element in the checkbox might work. I'll experiment and post a script if I can get this to work...

by: Ray_PaseurPosted on 2009-09-06 at 11:35:09ID: 25270971

<?php // RAY_checkbox_names.php
error_reporting(E_ALL);
echo "<pre>\n";
 
// TEST DATA IN AN ARRAY
$arr = array('cats', 'dogs', 'pigs', 'cows','fish');
 
// MAKE AN ARRAY TO HOLD OUR POST DATA RESULTS
$animals = array();
foreach ($arr as $animal)
{
    $animals[$animal] = 'off';
}
 
 
 
 
 
 
// IF ANYTHING IS POSTED
if (!empty($_POST))
{
// USE OUR TEST DATA ARRAY TO BE AWARE OF THE CHECKBOX ELEMENTS FROM THE FORM
    foreach ($animals as $animal => $flag)
    {
        if (isset($_POST["box"][$animal])) $animals[$animal] = 'on';
    }
    echo "\nTHE \$animals() ARRAY:\n";
    print_r($animals);
}
 
 
 
 
 
// PUT UP THE FORM BASED ON THE ARRAY OF ANIMALS IN $arr
echo "<form method=\"post\">\n";
foreach ($animals as $animal => $flag)
{
    echo "<input type=\"checkbox\" name=\"box[$animal]\"";
    if ($flag == 'on') echo " checked ";
    echo "/> $animal \n";
}
echo "<input type=\"submit\" />\n";
echo "</form>\n";

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:

Select all Open in new window

by: kcalderPosted on 2009-09-07 at 23:11:58ID: 25279019

As you can see from my code I am using a repeat region behaviour to list out the items rather than a 'foreach' loop so I am not sure how to apply the flag to the checkbox.

by: Ray_PaseurPosted on 2009-09-08 at 05:10:37ID: 25280976

I don't think the choice of iterator matters. The key here is knowing what checkboxes are expected and applying some predictable name to the checkboxes in the form script. Then in the action script, you also need to know what checkboxes are expected, so you can know that the ones which are omitted from the POST array are the ones that are "off".

Referring to the snippet posted above, at line 12 we produce an associative array of animals. This is the predictable set of names for the checkboxes. That array is available to both the action script and the form script. The action script processing is shown in lines 20~30. The form script is shown in lines 36~45.

You might want to install this code snippet and run it so you can watch the behavior. HTH, ~Ray

by: kcalderPosted on 2009-09-08 at 06:17:43ID: 25281515

Yes, thanks I have tried the script and it works well. It's just that I cannot see how to incorporate it into my code. In my form script I show an array of checkboxes where the value is set as the check value (0 or 1) which is obviously incorrect so I have changed the value to the item ID (primary key). However, I can't see how to embed the principles of your code into it, and I am looking to update the database using a routine like the one below. Could you possibly incorporate the logic into the code I have posted?

<?php
// Manually update the database
if (isset($_POST['setVisButton']))
{
    // Create an array of user names to use in finding persons who have checked out documents
    @ $db = new mysqli('host', 'user', 'pw', 'db');
    if (!$db) die ('Could not connect to the database: '.mysql_error());
    // Update the database with all 
    foreach($_POST['checkbox'] as $id)
    {
	$query = sprintf("UPDATE document SET docVisible=%d WHERE doc_pk=%s", $checked, $id);
	$result = $db->query($query);
    }
}
?>

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:

Select all Open in new window

by: Ray_PaseurPosted on 2009-09-08 at 06:23:53ID: 25281567

Please post the entire script you're using and I will see if I can help. It's a hectic week, and I may not have time be very useful to you beyond showing the principles, but before I have to sign off this question, I'll take a look...

by: kcalderPosted on 2009-09-08 at 07:40:58ID: 25282328

Much appreciated. Script below...

<form method="post" name="setDocVisibility" id="setDocVisibility">
						<?php 
						do 
						{ ?>
							<tr>
								<td class="visDocListTitle">
									<input type="checkbox" name="checkbox[]" id="checkbox"
										<?php if ($row_rstVisDocList['docVisible'] == 1) echo 'checked="checked"'; ?>
										onclick="$('#setVisButton').removeAttr('disabled').addClass('boldRed');"
										value="<?php echo $row_rstVisDocList['doc_pk']; ?>"
									/>
									<?php echo $row_rstVisDocList['docTitle']; ?>
								</td>
								<td class="visDocListRevision"><?php
								if (!strcmp($row_rstVisDocList['docRevision'],"")) 
									echo '-';
								else
									echo $row_rstVisDocList['docRevision']; ?></td>
								<td class="visDocListZone"><?php echo $row_rstVisDocList['zoneTitle']; ?></td>
							</tr>
						<?php } while ($row_rstVisDocList = mysql_fetch_assoc($rstVisDocList)); 
						?>
						<tr>
							<td class="visDocListTitle" colspan="4">
								<input name="setVisButton" id="setVisButton" type="submit" disabled="disabled" value="Update" />
							</td>							
						</tr>
						<input type="hidden" name="tab" id="tab" value="2" />
					</form>
					<?php } 
					// Manually update the database
					if (isset($_POST['setVisButton']))
					{
						// Create an array of user names to use in finding persons who have checked out documents
						@ $db = new mysqli('host', 'user', 'pw', 'db');
						if (!$db) die ('Could not connect to the database: '.mysql_error());
						// Update the database with all 
						foreach($_POST['checkbox'] as $id)
						{
							$query = sprintf("UPDATE document SET docVisible=%d WHERE doc_pk=%s", $checked, $id);
							$result = $db->query($query);
						}
					}
					?>

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:

Select all Open in new window

by: Ray_PaseurPosted on 2009-09-08 at 09:28:39ID: 25283526

I'm confused here - it looks like the var $checked in undefined in this script, yet it's being used in a query. ??

by: kcalderPosted on 2009-09-08 at 13:13:42ID: 25285725

Yes that's right, it's there as a reminder but doesn't do anything at the moment. However, the MySQL query does need both an ID and a value for the checked status, it's just that I don't know how to get that out of the code above it.

by: Ray_PaseurPosted on 2009-09-09 at 04:55:28ID: 25290185

"don't know how to get that out of the code above it."

What code "above it?"

Let me ask this again, "Please post the entire script" so we do not have to guess at the contents of undefined variables. Also, I would ask you to do two additional things to help debug this.

1. Turn on the error reporting by adding this to the top of the script:

error_reporting(E_ALL);

2. Use "echo" to print out the value of $query after it is prepared on line 40 and before it is used on line 41. Use var_dump() to print out the value of $result after line 41.

Thanks, ~Ray

by: kcalderPosted on 2009-09-09 at 08:37:03ID: 25292386

Perhaps the best thing is if I simply upload the whole file but it has to be in txt format. The code section of interest is within the div called TabbedPanel4

file.txt
- 74 KB
file showing checkboxes

by: Ray_PaseurPosted on 2009-09-09 at 11:07:06ID: 25293952

It's best to use the code snippet for code - that way we can all see the same line numbers.

But I have to say, I do not think a 1,600+ line script is something to get debugged at EE. We can answer questions, and I have done that, showing you what must be done to identify checkboxes that are not checked. But for something of this size you should hire a software developer who can get paid for the time it is going to take to work through all of this.

best of luck with your project, ~Ray

<?php
if (!isset($_SESSION)) {
  session_start();
}
$MM_authorizedUsers = "Director,admin,MD,docOwner,docGroupAdmin,businessManager";
$MM_donotCheckaccess = "false";
 
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) { 
  // For security, start by assuming the visitor is NOT authorized. 
  $isValid = False; 
 
  // When a visitor has logged into this site, the Session variable MM_Username set equal to their username. 
  // Therefore, we know that a user is NOT logged in if that Session variable is blank. 
  if (!empty($UserName)) { 
    // Besides being logged in, you may restrict access to only certain users based on an ID established when they login. 
    // Parse the strings into arrays. 
    $arrUsers = Explode(",", $strUsers); 
    $arrGroups = Explode(",", $strGroups); 
    if (in_array($UserName, $arrUsers)) { 
      $isValid = true; 
    } 
    // Or, you may restrict access to only certain users based on their username. 
    if (in_array($UserGroup, $arrGroups)) { 
      $isValid = true; 
    } 
    if (($strUsers == "") && false) { 
      $isValid = true; 
    } 
  } 
  return $isValid; 
}
 
$MM_restrictGoTo = "../denied.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {   
  $MM_qsChar = "?";
  $MM_referrer = $_SERVER['PHP_SELF'];
  if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
  if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0) 
  $MM_referrer .= "?" . $QUERY_STRING;
  $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
  header("Location: ". $MM_restrictGoTo); 
  exit;
}
?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
?>
<?php require_once('../connections/RED_links.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
 
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
 
$currentPage = $_SERVER["PHP_SELF"];
 
if ((isset($_POST['deleteRadio'])) && ($_POST['deleteRadio'] != "")) {
  $deleteSQL = sprintf("DELETE FROM `document` WHERE doc_pk=%s",
                       GetSQLValueString($_POST['deleteRadio'], "int"));
 
  mysql_select_db($database_RED_links, $RED_links);
  $Result1 = mysql_query($deleteSQL, $RED_links) or die(mysql_error());
}
 
$maxRows_rstCheckoutDocList = 5;
$pageNum_rstCheckoutDocList = 0;
if (isset($_GET['pageNum_rstCheckoutDocList'])) {
  $pageNum_rstCheckoutDocList = $_GET['pageNum_rstCheckoutDocList'];
}
$startRow_rstCheckoutDocList = $pageNum_rstCheckoutDocList * $maxRows_rstCheckoutDocList;
 
$userPK_rstCheckoutDocList = "1";
if (isset($_SESSION['MM_Username'])) {
  $userPK_rstCheckoutDocList = $_SESSION['MM_Username'];
}
mysql_select_db($database_RED_links, $RED_links);
$query_rstCheckoutDocList = sprintf("SELECT doc_pk, docTitle, docFilename, docApplication, docRevision, docEditable, docFileType_id, docFileType, zoneTitle, docOwnerPK, docPassword, docArchived, docCheckedOut, docCheckedOutBy FROM document  LEFT JOIN docRevision ON docRevision_id = docRevision_pk LEFT JOIN docFileType ON docFileType_id = docFileType_pk  LEFT JOIN adminGroup ON adminGroup_pk = docAdminGroup LEFT JOIN zone ON docZone_id = zone_pk LEFT JOIN user ON user_pk = %s WHERE docTRL = 0 AND docArchived = 0 AND (((docOwnerPK = %s) OR (docAdminGroup = adminGroupA) OR (docAdminGroup = adminGroupB) OR (docAdminGroup = adminGroupC) OR (docAdminGroup = adminGroupD) OR (docAdminGroup = adminGroupE) OR (docAdminGroup = adminGroupF) OR (docAdminGroup = adminGroupG) OR (docAdminGroup = adminGroupH) OR (docAdminGroup = adminGroupI) OR (docAdminGroup = adminGroupJ) OR (docAdminGroup = adminGroupK) OR (docAdminGroup = adminGroupL) OR (docAdminGroup = adminGroupM))) ORDER BY docTitle ASC, docRevision DESC", GetSQLValueString($userPK_rstCheckoutDocList, "int"),GetSQLValueString($userPK_rstCheckoutDocList, "int"));
$query_limit_rstCheckoutDocList = sprintf("%s LIMIT %d, %d", $query_rstCheckoutDocList, $startRow_rstCheckoutDocList, $maxRows_rstCheckoutDocList);
$rstCheckoutDocList = mysql_query($query_limit_rstCheckoutDocList, $RED_links) or die(mysql_error());
$row_rstCheckoutDocList = mysql_fetch_assoc($rstCheckoutDocList);
 
if (isset($_GET['totalRows_rstCheckoutDocList'])) {
  $totalRows_rstCheckoutDocList = $_GET['totalRows_rstCheckoutDocList'];
} else {
  $all_rstCheckoutDocList = mysql_query($query_rstCheckoutDocList);
  $totalRows_rstCheckoutDocList = mysql_num_rows($all_rstCheckoutDocList);
}
$totalPages_rstCheckoutDocList = ceil($totalRows_rstCheckoutDocList/$maxRows_rstCheckoutDocList)-1;
 
mysql_select_db($database_RED_links, $RED_links);
$query_rstZoneHelp = "SELECT helpText FROM helpText WHERE helpText_pk = 3";
$rstZoneHelp = mysql_query($query_rstZoneHelp, $RED_links) or die(mysql_error());
$row_rstZoneHelp = mysql_fetch_assoc($rstZoneHelp);
$totalRows_rstZoneHelp = mysql_num_rows($rstZoneHelp);
 
$userPK_rstDocOwner = "1";
if (isset($_SESSION['MM_Username'])) {
  $userPK_rstDocOwner = $_SESSION['MM_Username'];
}
mysql_select_db($database_RED_links, $RED_links);
$query_rstDocOwner = sprintf("SELECT user_pk, firstName, lastName FROM user WHERE user_pk = %s", $userPK_rstDocOwner);
$rstDocOwner = mysql_query($query_rstDocOwner, $RED_links) or die(mysql_error());
$row_rstDocOwner = mysql_fetch_assoc($rstDocOwner);
$totalRows_rstDocOwner = mysql_num_rows($rstDocOwner);
 
$maxRows_rstDocOwnerList = 5;
$pageNum_rstDocOwnerList = 0;
if (isset($_GET['pageNum_rstDocOwnerList'])) {
  $pageNum_rstDocOwnerList = $_GET['pageNum_rstDocOwnerList'];
}
$startRow_rstDocOwnerList = $pageNum_rstDocOwnerList * $maxRows_rstDocOwnerList;
 
$userPK_rstDocOwnerList = "1";
if (isset($_SESSION['MM_Username'])) {
  $userPK_rstDocOwnerList = $_SESSION['MM_Username'];
}
mysql_select_db($database_RED_links, $RED_links);
$query_rstDocOwnerList = sprintf("SELECT doc_pk, docTitle, docRevision, docZone_id, zoneTitle, docArchived, user_pk FROM document LEFT JOIN docRevision ON docRevision_id = docRevision_pk LEFT JOIN zone ON docZone_id = zone_pk LEFT JOIN user ON %s = user_pk WHERE docOwnerPK = %s ORDER BY zoneTitle ASC, docTitle ASC, docRevision ASC", GetSQLValueString($userPK_rstDocOwnerList, "int"),GetSQLValueString($userPK_rstDocOwnerList, "int"));
$query_limit_rstDocOwnerList = sprintf("%s LIMIT %d, %d", $query_rstDocOwnerList, $startRow_rstDocOwnerList, $maxRows_rstDocOwnerList);
$rstDocOwnerList = mysql_query($query_limit_rstDocOwnerList, $RED_links) or die(mysql_error());
$row_rstDocOwnerList = mysql_fetch_assoc($rstDocOwnerList);
 
if (isset($_GET['totalRows_rstDocOwnerList'])) {
  $totalRows_rstDocOwnerList = $_GET['totalRows_rstDocOwnerList'];
} else {
  $all_rstDocOwnerList = mysql_query($query_rstDocOwnerList);
  $totalRows_rstDocOwnerList = mysql_num_rows($all_rstDocOwnerList);
}
$totalPages_rstDocOwnerList = ceil($totalRows_rstDocOwnerList/$maxRows_rstDocOwnerList)-1;
 
$maxRows_rstAddRevisedDocList = 5;
$pageNum_rstAddRevisedDocList = 0;
if (isset($_GET['pageNum_rstAddRevisedDocList'])) {
  $pageNum_rstAddRevisedDocList = $_GET['pageNum_rstAddRevisedDocList'];
}
$startRow_rstAddRevisedDocList = $pageNum_rstAddRevisedDocList * $maxRows_rstAddRevisedDocList;
 
$userPK_rstAddRevisedDocList = "1";
if (isset($_SESSION['MM_Username'])) {
  $userPK_rstAddRevisedDocList = $_SESSION['MM_Username'];
}
mysql_select_db($database_RED_links, $RED_links);
$query_rstAddRevisedDocList = sprintf("SELECT doc_pk, docTitle, docFilename, docRevision_id, docRevision, docFileType_id, docFileType, docAdminGroup, docEditable, docApplication, docPassword, zone_pk, zoneTitle, sector_pk, sectorTitle FROM document LEFT JOIN docRevision ON docRevision_id + 1 = docRevision_pk LEFT JOIN adminGroup ON adminGroup_pk = docAdminGroup LEFT JOIN zone ON zone_pk = docZone_id LEFT JOIN sector ON sector_pk = docSector_id LEFT JOIN docFileType ON docFileType_id = docFileType_pk  LEFT JOIN user ON docOwnerPK = user_pk WHERE docTRL = 0 AND docCheckedOut = 1 AND docOwnerPK = %s ORDER BY zone_pk ASC, docTitle ASC, docRevision_id ASC", GetSQLValueString($userPK_rstAddRevisedDocList, "int"));
$query_limit_rstAddRevisedDocList = sprintf("%s LIMIT %d, %d", $query_rstAddRevisedDocList, $startRow_rstAddRevisedDocList, $maxRows_rstAddRevisedDocList);
$rstAddRevisedDocList = mysql_query($query_limit_rstAddRevisedDocList, $RED_links) or die(mysql_error());
$row_rstAddRevisedDocList = mysql_fetch_assoc($rstAddRevisedDocList);
 
if (isset($_GET['totalRows_rstAddRevisedDocList'])) {
  $totalRows_rstAddRevisedDocList = $_GET['totalRows_rstAddRevisedDocList'];
} else {
  $all_rstAddRevisedDocList = mysql_query($query_rstAddRevisedDocList);
  $totalRows_rstAddRevisedDocList = mysql_num_rows($all_rstAddRevisedDocList);
}
$totalPages_rstAddRevisedDocList = ceil($totalRows_rstAddRevisedDocList/$maxRows_rstAddRevisedDocList)-1;
 
$userPK_rstUserSector1 = "1";
if (isset($_SESSION['MM_Username'])) {
  $userPK_rstUserSector1 = $_SESSION['MM_Username'];
}
mysql_select_db($database_RED_links, $RED_links);
$query_rstUserSector1 = sprintf("SELECT sector_pk, sectorTitle, isDirector, director_sector1_id FROM sector LEFT JOIN user ON sector_pk = director_sector1_id WHERE user_pk = %s", GetSQLValueString($userPK_rstUserSector1, "int"));
$rstUserSector1 = mysql_query($query_rstUserSector1, $RED_links) or die(mysql_error());
$row_rstUserSector1 = mysql_fetch_assoc($rstUserSector1);
$totalRows_rstUserSector1 = mysql_num_rows($rstUserSector1);
 
$userPK_rstUserSector2 = "1";
if (isset($_SESSION['MM_Username'])) {
  $userPK_rstUserSector2 = $_SESSION['MM_Username'];
}
mysql_select_db($database_RED_links, $RED_links);
$query_rstUserSector2 = sprintf("SELECT sector_pk, sectorTitle, director_sector2_id FROM sector LEFT JOIN user ON sector_pk = director_sector2_id WHERE user_pk = %s", GetSQLValueString($userPK_rstUserSector2, "int"));
$rstUserSector2 = mysql_query($query_rstUserSector2, $RED_links) or die(mysql_error());
$row_rstUserSector2 = mysql_fetch_assoc($rstUserSector2);
$totalRows_rstUserSector2 = mysql_num_rows($rstUserSector2);
 
$userPK_rstUserSector3 = "1";
if (isset($_SESSION['MM_Username'])) {
  $userPK_rstUserSector3 = $_SESSION['MM_Username'];
}
mysql_select_db($database_RED_links, $RED_links);
$query_rstUserSector3 = sprintf("SELECT sector_pk, sectorTitle, director_sector3_id FROM sector LEFT JOIN user ON sector_pk = director_sector3_id WHERE user_pk = %s", GetSQLValueString($userPK_rstUserSector3, "int"));
$rstUserSector3 = mysql_query($query_rstUserSector3, $RED_links) or die(mysql_error());
$row_rstUserSector3 = mysql_fetch_assoc($rstUserSector3);
$totalRows_rstUserSector3 = mysql_num_rows($rstUserSector3);
 
$maxRows_rstDelDocList = 5;
$pageNum_rstDelDocList = 0;
if (isset($_GET['pageNum_rstDelDocList'])) {
  $pageNum_rstDelDocList = $_GET['pageNum_rstDelDocList'];
}
$startRow_rstDelDocList = $pageNum_rstDelDocList * $maxRows_rstDelDocList;
 
$userPK_rstDelDocList = "1";
if (isset($_SESSION['MM_Username'])) {
  $userPK_rstDelDocList = $_SESSION['MM_Username'];
}
mysql_select_db($database_RED_links, $RED_links);
$query_rstDelDocList = sprintf("SELECT doc_pk, docTitle, docFilename, docFileType, docRevision, docZone_id, zoneTitle, docArchived, user_pk FROM document LEFT JOIN docRevision ON docRevision_id = docRevision_pk LEFT JOIN docFileType ON docFileType_id = docFileType_pk LEFT JOIN zone ON docZone_id = zone_pk LEFT JOIN user ON %s = user_pk WHERE docOwnerPK = %s AND docCheckedOut = 0 ORDER BY docTitle ASC, docRevision DESC, zoneTitle ASC", GetSQLValueString($userPK_rstDelDocList, "int"),GetSQLValueString($userPK_rstDelDocList, "int"));
$query_limit_rstDelDocList = sprintf("%s LIMIT %d, %d", $query_rstDelDocList, $startRow_rstDelDocList, $maxRows_rstDelDocList);
$rstDelDocList = mysql_query($query_limit_rstDelDocList, $RED_links) or die(mysql_error());
$row_rstDelDocList = mysql_fetch_assoc($rstDelDocList);
 
if (isset($_GET['totalRows_rstDelDocList'])) {
  $totalRows_rstDelDocList = $_GET['totalRows_rstDelDocList'];
} else {
  $all_rstDelDocList = mysql_query($query_rstDelDocList);
  $totalRows_rstDelDocList = mysql_num_rows($all_rstDelDocList);
}
$totalPages_rstDelDocList = ceil($totalRows_rstDelDocList/$maxRows_rstDelDocList)-1;
 
$postVal_rstDownloadFile = "1";
if (isset($_POST['checkoutRadio'])) {
  $postVal_rstDownloadFile = $_POST['checkoutRadio'];
}
mysql_select_db($database_RED_links, $RED_links);
$query_rstDownloadFile = sprintf("SELECT doc_pk, docFilename, docFileType FROM document LEFT JOIN docFileType ON docFileType_id = docFileType_pk WHERE doc_pk = %s", GetSQLValueString($postVal_rstDownloadFile, "int"));
$rstDownloadFile = mysql_query($query_rstDownloadFile, $RED_links) or die(mysql_error());
$row_rstDownloadFile = mysql_fetch_assoc($rstDownloadFile);
$totalRows_rstDownloadFile = mysql_num_rows($rstDownloadFile);
 
mysql_select_db($database_RED_links, $RED_links);
$query_rstHelpTextCheckout = "SELECT helpText FROM helpText WHERE helpText_pk = 100";
$rstHelpTextCheckout = mysql_query($query_rstHelpTextCheckout, $RED_links) or die(mysql_error());
$row_rstHelpTextCheckout = mysql_fetch_assoc($rstHelpTextCheckout);
$totalRows_rstHelpTextCheckout = mysql_num_rows($rstHelpTextCheckout);
 
$maxRows_rstArchivedDocList = 5;
$pageNum_rstArchivedDocList = 0;
if (isset($_GET['pageNum_rstArchivedDocList'])) {
  $pageNum_rstArchivedDocList = $_GET['pageNum_rstArchivedDocList'];
}
$startRow_rstArchivedDocList = $pageNum_rstArchivedDocList * $maxRows_rstArchivedDocList;
 
$userPK_rstArchivedDocList = "1";
if (isset($_SESSION['MM_Username'])) {
  $userPK_rstArchivedDocList = $_SESSION['MM_Username'];
}
mysql_select_db($database_RED_links, $RED_links);
$query_rstArchivedDocList = sprintf("SELECT doc_pk, docTitle, docFilename, docApplication, docRevision, docFileType, zoneTitle, docOwnerPK, docPassword FROM document  LEFT JOIN docRevision ON docRevision_id = docRevision_pk LEFT JOIN docFileType ON docFileType_id = docFileType_pk  LEFT JOIN adminGroup ON adminGroup_pk = docAdminGroup LEFT JOIN zone ON docZone_id = zone_pk LEFT JOIN user ON user_pk = %s WHERE docArchived = 1 AND docTRL = 0 AND (((docOwnerPK = %s) OR (docAdminGroup = adminGroupA) OR (docAdminGroup = adminGroupB) OR (docAdminGroup = adminGroupC) OR (docAdminGroup = adminGroupD) OR (docAdminGroup = adminGroupE) OR (docAdminGroup = adminGroupF) OR (docAdminGroup = adminGroupG) OR (docAdminGroup = adminGroupH) OR (docAdminGroup = adminGroupI) OR (docAdminGroup = adminGroupJ) OR (docAdminGroup = adminGroupK) OR (docAdminGroup = adminGroupL) OR (docAdminGroup = adminGroupM))) ORDER BY docTitle ASC, docRevision DESC", GetSQLValueString($userPK_rstArchivedDocList, "int"),GetSQLValueString($userPK_rstArchivedDocList, "int"));
$query_limit_rstArchivedDocList = sprintf("%s LIMIT %d, %d", $query_rstArchivedDocList, $startRow_rstArchivedDocList, $maxRows_rstArchivedDocList);
$rstArchivedDocList = mysql_query($query_limit_rstArchivedDocList, $RED_links) or die(mysql_error());
$row_rstArchivedDocList = mysql_fetch_assoc($rstArchivedDocList);
 
if (isset($_GET['totalRows_rstArchivedDocList'])) {
  $totalRows_rstArchivedDocList = $_GET['totalRows_rstArchivedDocList'];
} else {
  $all_rstArchivedDocList = mysql_query($query_rstArchivedDocList);
  $totalRows_rstArchivedDocList = mysql_num_rows($all_rstArchivedDocList);
}
$totalPages_rstArchivedDocList = ceil($totalRows_rstArchivedDocList/$maxRows_rstArchivedDocList)-1;
 
mysql_select_db($database_RED_links, $RED_links);
$query_rstHelpTextAddRevised = "SELECT helpText FROM helpText WHERE helpText_pk = 101";
$rstHelpTextAddRevised = mysql_query($query_rstHelpTextAddRevised, $RED_links) or die(mysql_error());
$row_rstHelpTextAddRevised = mysql_fetch_assoc($rstHelpTextAddRevised);
$totalRows_rstHelpTextAddRevised = mysql_num_rows($rstHelpTextAddRevised);
 
mysql_select_db($database_RED_links, $RED_links);
$query_rstHelpTextAddNew = "SELECT helpText FROM helpText WHERE helpText_pk = 103";
$rstHelpTextAddNew = mysql_query($query_rstHelpTextAddNew, $RED_links) or die(mysql_error());
$row_rstHelpTextAddNew = mysql_fetch_assoc($rstHelpTextAddNew);
$totalRows_rstHelpTextAddNew = mysql_num_rows($rstHelpTextAddNew);
 
mysql_select_db($database_RED_links, $RED_links);
$query_rstHelpTextDrop = "SELECT helpText FROM helpText WHERE helpText_pk = 105";
$rstHelpTextDrop = mysql_query($query_rstHelpTextDrop, $RED_links) or die(mysql_error());
$row_rstHelpTextDrop = mysql_fetch_assoc($rstHelpTextDrop);
$totalRows_rstHelpTextDrop = mysql_num_rows($rstHelpTextDrop);
 
mysql_select_db($database_RED_links, $RED_links);
$query_rstHelpTextArchive = "SELECT helpText FROM helpText WHERE helpText_pk = 104";
$rstHelpTextArchive = mysql_query($query_rstHelpTextArchive, $RED_links) or die(mysql_error());
$row_rstHelpTextArchive = mysql_fetch_assoc($rstHelpTextArchive);
$totalRows_rstHelpTextArchive = mysql_num_rows($rstHelpTextArchive);
 
$userPK_rstAdminGroups = "1";
if (isset($_SESSION['MM_Username'])) {
  $userPK_rstAdminGroups = $_SESSION['MM_Username'];
}
mysql_select_db($database_RED_links, $RED_links);
$query_rstAdminGroups = sprintf("SELECT adminGroup_pk, agMembers FROM adminGroup LEFT JOIN user ON user_pk = %s WHERE (isDirector = 1 AND agMember1_id = 99) OR (agMember1_id = %s OR agMember2_id = %s OR agMember3_id = %s OR agMember4_id = %s OR agMember5_id = %s OR agMember6_id = %s OR agMember7_id = %s OR agMember8_id = %s OR agMember9_id = %s) ORDER BY agMembers ASC", GetSQLValueString($userPK_rstAdminGroups, "int"),GetSQLValueString($userPK_rstAdminGroups, "int"),GetSQLValueString($userPK_rstAdminGroups, "int"),GetSQLValueString($userPK_rstAdminGroups, "int"),GetSQLValueString($userPK_rstAdminGroups, "int"),GetSQLValueString($userPK_rstAdminGroups, "int"),GetSQLValueString($userPK_rstAdminGroups, "int"),GetSQLValueString($userPK_rstAdminGroups, "int"),GetSQLValueString($userPK_rstAdminGroups, "int"),GetSQLValueString($userPK_rstAdminGroups, "int"));
$rstAdminGroups = mysql_query($query_rstAdminGroups, $RED_links) or die(mysql_error());
$row_rstAdminGroups = mysql_fetch_assoc($rstAdminGroups);
$totalRows_rstAdminGroups = mysql_num_rows($rstAdminGroups);
 
mysql_select_db($database_RED_links, $RED_links);
$query_rstPMSZones = "SELECT * FROM zone ORDER BY zoneTitle ASC";
$rstPMSZones = mysql_query($query_rstPMSZones, $RED_links) or die(mysql_error());
$row_rstPMSZones = mysql_fetch_assoc($rstPMSZones);
$totalRows_rstPMSZones = mysql_num_rows($rstPMSZones);
 
mysql_select_db($database_RED_links, $RED_links);
$query_rstDocumentType = "SELECT * FROM docType ORDER BY docType ASC";
$rstDocumentType = mysql_query($query_rstDocumentType, $RED_links) or die(mysql_error());
$row_rstDocumentType = mysql_fetch_assoc($rstDocumentType);
$totalRows_rstDocumentType = mysql_num_rows($rstDocumentType);
 
mysql_select_db($database_RED_links, $RED_links);
$query_rstDocumentSubject = "SELECT * FROM docSubjectRED ORDER BY docSubjectRED";
$rstDocumentSubject = mysql_query($query_rstDocumentSubject, $RED_links) or die(mysql_error());
$row_rstDocumentSubject = mysql_fetch_assoc($rstDocumentSubject);
$totalRows_rstDocumentSubject = mysql_num_rows($rstDocumentSubject);
 
mysql_select_db($database_RED_links, $RED_links);
$query_rstOffices = "SELECT office_pk, location FROM office ORDER BY office_pk";
$rstOffices = mysql_query($query_rstOffices, $RED_links) or die(mysql_error());
$row_rstOffices = mysql_fetch_assoc($rstOffices);
$totalRows_rstOffices = mysql_num_rows($rstOffices);
 
$userPK_rstUserSector4 = "1";
if (isset($_SESSION['MM_Username'])) {
  $userPK_rstUserSector4 = $_SESSION['MM_Username'];
}
mysql_select_db($database_RED_links, $RED_links);
$query_rstUserSector4 = sprintf("SELECT sector_pk, sectorTitle, director_sector4_id FROM sector LEFT JOIN user ON sector_pk = director_sector4_id WHERE user_pk = %s", GetSQLValueString($userPK_rstUserSector4, "int"));
$rstUserSector4 = mysql_query($query_rstUserSector4, $RED_links) or die(mysql_error());
$row_rstUserSector4 = mysql_fetch_assoc($rstUserSector4);
$totalRows_rstUserSector4 = mysql_num_rows($rstUserSector4);
 
$userPK_rstUserSector5 = "1";
if (isset($_SESSION['MM_Username'])) {
  $userPK_rstUserSector5 = $_SESSION['MM_Username'];
}
mysql_select_db($database_RED_links, $RED_links);
$query_rstUserSector5 = sprintf("SELECT sector_pk, sectorTitle, director_sector5_id FROM sector LEFT JOIN user ON sector_pk = director_sector5_id WHERE user_pk = %s", GetSQLValueString($userPK_rstUserSector5, "int"));
$rstUserSector5 = mysql_query($query_rstUserSector5, $RED_links) or die(mysql_error());
$row_rstUserSector5 = mysql_fetch_assoc($rstUserSector5);
$totalRows_rstUserSector5 = mysql_num_rows($rstUserSector5);
 
$maxRows_rstVisDocList = 5;
$pageNum_rstVisDocList = 0;
if (isset($_GET['pageNum_rstVisDocList'])) {
  $pageNum_rstVisDocList = $_GET['pageNum_rstVisDocList'];
}
$startRow_rstVisDocList = $pageNum_rstVisDocList * $maxRows_rstVisDocList;
 
$userPK_rstVisDocList = "1";
if (isset($_SESSION['MM_Username'])) {
  $userPK_rstVisDocList = $_SESSION['MM_Username'];
}
mysql_select_db($database_RED_links, $RED_links);
$query_rstVisDocList = sprintf("SELECT doc_pk, docTitle, docRevision, docZone_id, zoneTitle, docArchived, user_pk, docVisible FROM document LEFT JOIN docRevision ON docRevision_id = docRevision_pk LEFT JOIN zone ON docZone_id = zone_pk LEFT JOIN user ON %s = user_pk WHERE docOwnerPK = %s AND docCheckedOut = 0 ORDER BY docTitle ASC, docRevision DESC, zoneTitle ASC", GetSQLValueString($userPK_rstVisDocList, "int"),GetSQLValueString($userPK_rstVisDocList, "int"));
$query_limit_rstVisDocList = sprintf("%s LIMIT %d, %d", $query_rstVisDocList, $startRow_rstVisDocList, $maxRows_rstVisDocList);
$rstVisDocList = mysql_query($query_limit_rstVisDocList, $RED_links) or die(mysql_error());
$row_rstVisDocList = mysql_fetch_assoc($rstVisDocList);
 
if (isset($_GET['totalRows_rstVisDocList'])) {
  $totalRows_rstVisDocList = $_GET['totalRows_rstVisDocList'];
} else {
  $all_rstVisDocList = mysql_query($query_rstVisDocList);
  $totalRows_rstVisDocList = mysql_num_rows($all_rstVisDocList);
}
$totalPages_rstVisDocList = ceil($totalRows_rstVisDocList/$maxRows_rstVisDocList)-1;
 
mysql_select_db($database_RED_links, $RED_links);
$query_rstHelpTextVisibility = "SELECT helpText FROM helpText WHERE helpText_pk = 102";
$rstHelpTextVisibility = mysql_query($query_rstHelpTextVisibility, $RED_links) or die(mysql_error());
$row_rstHelpTextVisibility = mysql_fetch_assoc($rstHelpTextVisibility);
$totalRows_rstHelpTextVisibility = mysql_num_rows($rstHelpTextVisibility);
 
$userPK_rstDocListing = "1";
if (isset($_SESSION['MM_Username'])) {
  $userPK_rstDocListing = $_SESSION['MM_Username'];
}
mysql_select_db($database_RED_links, $RED_links);
$query_rstDocListing = sprintf("SELECT docListing_pk, docListingTitle FROM docListing LEFT JOIN user ON user_pk = %s WHERE docListing_pk = 1 OR (docListingMember1 = 99 AND isDirector = 1) OR docListingMember2 = %s ORDER BY docListing_pk ASC", GetSQLValueString($userPK_rstDocListing, "int"),GetSQLValueString($userPK_rstDocListing, "int"));
$rstDocListing = mysql_query($query_rstDocListing, $RED_links) or die(mysql_error());
$row_rstDocListing = mysql_fetch_assoc($rstDocListing);
$totalRows_rstDocListing = mysql_num_rows($rstDocListing);
 
$queryString_rstCheckoutDocList = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_rstCheckoutDocList") == false && 
        stristr($param, "totalRows_rstCheckoutDocList") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_rstCheckoutDocList = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_rstCheckoutDocList = sprintf("&totalRows_rstCheckoutDocList=%d%s", $totalRows_rstCheckoutDocList, $queryString_rstCheckoutDocList);
 
$queryString_rstAddRevisedDocList = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_rstAddRevisedDocList") == false && 
        stristr($param, "totalRows_rstAddRevisedDocList") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_rstAddRevisedDocList = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_rstAddRevisedDocList = sprintf("&totalRows_rstAddRevisedDocList=%d%s", $totalRows_rstAddRevisedDocList, $queryString_rstAddRevisedDocList);
 
$queryString_rstVisDocList = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_rstVisDocList") == false && 
        stristr($param, "totalRows_rstVisDocList") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_rstVisDocList = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_rstVisDocList = sprintf("&totalRows_rstVisDocList=%d%s", $totalRows_rstVisDocList, $queryString_rstVisDocList);
 
$queryString_rstArchivedDocList = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_rstArchivedDocList") == false && 
        stristr($param, "totalRows_rstArchivedDocList") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_rstArchivedDocList = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_rstArchivedDocList = sprintf("&totalRows_rstArchivedDocList=%d%s", $totalRows_rstArchivedDocList, $queryString_rstArchivedDocList);
 
$queryString_rstDelDocList = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_rstDelDocList") == false && 
        stristr($param, "totalRows_rstDelDocList") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_rstDelDocList = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_rstDelDocList = sprintf("&totalRows_rstDelDocList=%d%s", $totalRows_rstDelDocList, $queryString_rstDelDocList);
 
$queryString_rstDocOwnerList = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_rstDocOwnerList") == false && 
        stristr($param, "totalRows_rstDocOwnerList") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_rstDocOwnerList = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_rstDocOwnerList = sprintf("&totalRows_rstDocOwnerList=%d%s", $totalRows_rstDocOwnerList, $queryString_rstDocOwnerList);
?>
<?php
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != ""))
{
  $logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true"))
{
  //to fully log out a visitor we need to clear the session varialbles
  unset($_SESSION['MM_Username']);
  unset($_SESSION['MM_UserGroup']);
  $logoutGoTo = "../index.php";
  if ($logoutGoTo) {
    header("Location: $logoutGoTo");
    exit;
  }
}
 
// Helper function to pad a string with a specific number of zeros
function padNumberWithZeros ($number,$n) 
{
	return str_pad((int) $number,$n,"0",STR_PAD_LEFT);
}
 
// Function to rev-up the drawing being checked out so that it can be added back without undertaking a file name change
function revUp($filename, $currentRevision)
{
	// Get the filename without the revision number (after '_')
	$abridgedFilename = substr($filename,0,15);
	// Increment the current revision number
	$newRevisionNum = $currentRevision + 1;
	// Pad out the revision number if necessary
	$newRevisionNum = padNumberWithZeros($newRevisionNum,2);
	// Convert new revision number to a string
	$newRevisionStr = (string)$newRevisionNum;
	// Create the new filename
	$newFilename = $abridgedFilename.$newRevisionStr;
	
	return $newFilename;
}
 
function dropFile($currentFilename, $newFilename)
{
	$sourceFolder = "../docsRED/";
	$destinationFolder = "../docsRED/dropped/";
	$current = $sourceFolder.$currentFilename;
	$new = $destinationFolder.$newFilename;
	rename($current, $new);
}
 
// Control of default Spry tabbed panel
if (isset($_GET['tab'])) 
	$tab = $_GET['tab'];
else if (isset($_POST['tab']))
	$tab = $_POST['tab'];
else $tab = 0;
 
// the IE7 script is only required to be loaded once
require('../includes/php/loadIE7.php'); 
include('../includes/php/lib.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>RED Practice Management System</title>
<link href="../css/common.css" rel="stylesheet" type="text/css" />
<link href="../css/docZone.css" rel="stylesheet" type="text/css" /><!-- menu navigation only -->
<link href="../css/mgtZone.css" rel="stylesheet" type="text/css" />
<link href="../css/mgtHelpAccordion.css" rel="stylesheet" type="text/css" />
<link href="../css/SpryTabbedPanels.css" rel="stylesheet" type="text/css" />
<link href="../css/SpryAccordion.css" rel="stylesheet" type="text/css" />
<link href="../css/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
<link href="../css/SpryValidationSelect.css" rel="stylesheet" type="text/css" />
 
<script type="text/javascript" src="../includes/js/lib.js"></script>
<script type="text/javascript" src="../includes/js/jQuery.js"></script>
<script type="text/javascript" src="../includes/Spry/SpryTabbedPanels.js"></script>
<script type="text/javascript" src="../includes/Spry/SpryAccordion.js"></script>
<script type="text/javascript" src="../includes/Spry/SpryValidationTextField.js"></script>
<script type="text/javascript" src="../includes/Spry/SpryValidationSelect.js"></script>
<script type="text/javascript">
// jQuery functions
$(document).ready(function()
{
	$('#uploadFile').click(function()
	{
		// Clear text field
		$('#title').val('');
		// Set doc sector to None
		$('#selectDocSector :eq(0)').attr('checked','checked');
		// Set the document zone to zero option
		$('#selectDocZone option:nth(0)').attr('selected','selected');
		// Set the administration group to zero option
		$('#selectAdminGroup option:nth(0)').attr('selected','selected');
	});
	
	$('#delete').click(function()
	{
		// Cause the confirm delete button to appear and post a warning
		$('#delete').removeClass('boldRed').attr('disabled', 'disabled');
		$('#confirm').removeClass('noShow').addClass('boldRed');
		alert('To permanently delete the file click the confirm button');
	});		
});
</script>
</head>
<body onload="startTime()">
<?php
 
$user = $_SESSION['MM_Username'];
 
// Create an array of user names to use in finding persons who have checked out documents
@ $db = new mysqli('host', 'user', 'pw', 'db');
if (!$db) die ('Could not connect to the database: '.mysql_error());
// Get the list of all users for use in finding out the name of the person who has checked out a document
$query = "SELECT user_pk, firstName, lastName FROM user";
$result = $db->query($query);
$num_results = $result->num_rows;
$user = array();
for ($i = 0; $i < $num_results; $i++)
{
	$row = $result->fetch_assoc();
	$name = $row['firstName'].' '.$row['lastName'];
	$user[$i][0] = $row['user_pk'];
	$user[$i][1] = $name;
}
// free up the resultset
$result->free();
?>
<div id="header">
	<div id="clock"></div>
</div>
<div id="content">
	<h1>Practice Management System<span style="font-size:9px; color: #CCC;">&nbsp;&nbsp;Phase 1</span></h1>
	<h2>Manage RED Documents</h2>
	<div id="TabbedPanels1" class="TabbedPanels">
		<ul class="TabbedPanelsTabGroup">
			<li class="TabbedPanelsTab">Checkout</li>
			<li class="TabbedPanelsTab">Add Revised</li>
			<li class="TabbedPanelsTab">Add New</li>
			<li class="TabbedPanelsTab">Visibility</li>
			<li class="TabbedPanelsTab">Retrieve</li>
			<li class="TabbedPanelsTab">Delete</li>
			<li class="TabbedPanelsTab"><span class="boldRed">Help</span></li>
		</ul>
		<div class="TabbedPanelsContentGroup">
			<div id="TabbedPanel1" class="TabbedPanelsContent">
				<h4 class="bold">Checkout and download documents for revision</h4>
				<table class="docList">
					<tr>
						<th class="revDocListTitle">Document title</th>
						<th class="revDocListRevision">Revision</th>
						<th class="revDocListApplication">Application</th>
						<th class="revDocListOwner">Owner</th>
						<th class="revDocListZone">PMS Zone</th>
						<th class="revDocListPassword">Password</th>
					</tr>
					<tr>
						<td class="docNumbers" colspan="6">
							<?php 
							if ($totalRows_rstCheckoutDocList == 0) echo 'There are no documents';
							else if ($totalRows_rstCheckoutDocList == 1) echo 'There is one document';
							else echo 'There are '.$totalRows_rstCheckoutDocList.' documents';
							echo ' in your check out list';
							if ($totalRows_rstCheckoutDocList > $maxRows_rstCheckoutDocList)
							{
								if (min($startRow_rstCheckoutDocList + $maxRows_rstCheckoutDocList, $totalRows_rstCheckoutDocList) == $totalRows_rstCheckoutDocList) echo '.  Showing final document(s) in results set.';
								else echo '. Showing documents '.($startRow_rstCheckoutDocList + 1).' to '.min($startRow_rstCheckoutDocList + $maxRows_rstCheckoutDocList, $totalRows_rstCheckoutDocList).'.';
							}
						?>
						</td>
					</tr>
					<?php
					// Only show the rows if there is at least one document available
					if ($totalRows_rstCheckoutDocList > 0)
					{ ?>
						<form action="checkout.php" method="post" name="checkoutDoc" id="checkoutDoc">
							<?php 
							// Create the repeat region
							do { ?>
							<tr>
								<?php
								// Find the name of the document owner
								$docOwner = '';
										
								// Walk the user array 
								for ($j = 0; $j < sizeof($user); $j++) if ($user[$j][0] == $row_rstCheckoutDocList['docOwnerPK']) $docOwner = $user[$j][1];
						
								// Display changes according to whether the item has been checked out or not and to whom
								if ($row_rstCheckoutDocList['docCheckedOut'] == 0)
								{ 
									// The document has not been checked out and is available for checking out
									?>        
									<td class="revDocListTitle">
										<input name="checkoutRadio" id="checkoutRadio" type="radio" class="checkout" 
										onclick="$('#checkoutButton').removeAttr('disabled').addClass('boldRed');"
										value="<?php echo $row_rstCheckoutDocList['doc_pk']; ?>" 
										/><?php echo ' '.$row_rstCheckoutDocList['docTitle']; ?>
									</td>
									<td class="revDocListRevision"><?php 
										if (!strcmp($row_rstCheckoutDocList['docRevision'],"")) 
											echo '-';
										else
											echo $row_rstCheckoutDocList['docRevision']; ?>
									</td>
									<td class="revDocListApplication"><?php echo $row_rstCheckoutDocList['docApplication']; ?></td>
									<td class="revDocListOwner"><?php echo $docOwner; ?></td>
									<td class="revDocListZone"><?php echo $row_rstCheckoutDocList['zoneTitle']; ?></td>
									<?php 
									if ($row_rstCheckoutDocList['docFileType_id'] == 7 || $row_rstCheckoutDocList['docFileType_id'] == 8)
										echo '<td class="revDocListPassword">---</td>';
									else if ($row_rstCheckoutDocList['docFileType_id'] == 2) 
										echo '<td class="revDocListPasswordNone">Non-editable</td>';
									else echo '<td class="revDocListPassword">'.$row_rstCheckoutDocList['docPassword'].'</td>';
									?>				
									<input type="hidden" name="s" id="s" value="RED" />
								<?php }
								else
								{ 
									// The document has been checked out so find the name of the person who checked it out
									$checkedOutBy = '';
													
									// Walk the array 
									for ($k = 0; $k < sizeof($user); $k++) if ($user[$k][0] == $row_rstCheckoutDocList['docCheckedOutBy']) $checkedOutBy = $user[$k][1];
									?>
									<td class="revDocListTitleCheckedOut"><input name="checkoutDoc" type="radio" value="<?php echo $row_rstCheckoutDocList['doc_pk']; ?>" disabled="disabled">
										<a class="menuCheckedOut" href="#" title="<?php 
										if ($row_rstCheckoutDocList['docCheckedOutBy'] == $_SESSION['MM_Username'])
											echo 'This document is currently checked out to you';
										else	
											echo 'This document is currently checked out to '.$checkedOutBy; ?>"><?php echo $row_rstCheckoutDocList['docTitle']; ?>
										</a>
									</td>
									<td class="revDocListRevisionCheckedOut"><?php 
										if (!strcmp($row_rstCheckoutDocList['docRevision'],"")) 
											echo '-';
										else
											echo $row_rstCheckoutDocList['docRevision']; ?>
									</td>
									<td class="revDocListApplicationCheckedOut"><?php echo $row_rstCheckoutDocList['docApplication']; ?></td>
									<td class="revDocListOwnerCheckedOut"><?php echo $docOwner; ?></td>
									<td class="revDocListZoneCheckedOut"><?php echo $row_rstCheckoutDocList['zoneTitle']; ?></td>
									<?php 
									if ($row_rstCheckoutDocList['docFileType_id'] == 7 || $row_rstCheckoutDocList['docFileType_id'] == 8)
										echo '<td class="revDocListPasswordCheckedOut">---</td>';
									else if ($row_rstCheckoutDocList['docFileType_id'] == 2) 
										echo '<td class="revDocListPasswordNoneCheckedOut">Non-editable</td>';
									else echo '<td class="revDocListPasswordCheckedOut">'.$row_rstCheckoutDocList['docPassword'].'</td>';
									?>					
								<?php } ?>
							</tr>
							<?php } while ($row_rstCheckoutDocList = mysql_fetch_assoc($rstCheckoutDocList)); ?>
							<tr>
								<td class="revDocListTitle" colspan="6">
									<input name="checkoutButton" id="checkoutButton" type="submit" disabled="disabled" value="Checkout" />
								</td>							
							</tr>
							<input type="hidden" name="tab" id="tab" value="0" />
						</form>
					<?php } // end if ?>
				</table>
				<?php // Only show the navigation table if it is required
				if  ($totalRows_rstCheckoutDocList > $maxRows_rstCheckoutDocList) 
				{ ?>
					<table class="navigation">
						<tr>
							<td class="navigation">
								<a <?php 
									if ($pageNum_rstCheckoutDocList > 0) 
										echo ' class="searchNavVisible" ';
									else
										echo ' class="searchNavInvisible" ';
								?> href="<?php printf("%s?pageNum_rstCheckoutDocList=%d%s%s", $currentPage, 0, $queryString_rstCheckoutDocList, '&tab=0'); ?>">First page</a>
							</td>
							<td class="navigation">
								<a <?php
									if ($pageNum_rstCheckoutDocList > 1) 
										echo ' class="searchNavVisible" ';
									else
										echo ' class="searchNavInvisible" ';
								?> href="<?php printf("%s?pageNum_rstCheckoutDocList=%d%s%s", $currentPage, max(0, $pageNum_rstCheckoutDocList - 1), $queryString_rstCheckoutDocList, '&tab=0'); ?>">Previous page</a></td>
							<td class="navigation">navigation</td>
							<td class="navigation">
								<a <?php 
									if ($pageNum_rstCheckoutDocList < $totalPages_rstCheckoutDocList - 1)
										echo ' class="searchNavVisible" ';
									else
										echo ' class="searchNavInvisible" ';
								?> href="<?php printf("%s?pageNum_rstCheckoutDocList=%d%s%s", $currentPage, min($totalPages_rstCheckoutDocList, $pageNum_rstCheckoutDocList + 1), $queryString_rstCheckoutDocList, '&tab=0'); ?>">Next page</a> 
							</td>
							<td class="navigation">
								<a <?php 
									if ($pageNum_rstCheckoutDocList < $totalPages_rstCheckoutDocList)
										echo ' class="searchNavVisible" ';
									else
										echo ' class="searchNavInvisible" ';
								?> href="<?php printf("%s?pageNum_rstCheckoutDocList=%d%s%s", $currentPage, $totalPages_rstCheckoutDocList, $queryString_rstCheckoutDocList, '&tab=0'); ?>">Last page</a> 
							</td>
						</tr>
					</table>	
				<?php } ?>
			</div>		
			<div id="TabbedPanel2" class="TabbedPanelsContent">
				<h4 class="bold">Add a new revision of a document in your ownership</h4>
					<form enctype="multipart/form-data" action="upload.php" method="post" name="addRevisedDoc" id="addrevisedDoc">
						<input type="hidden" name="MAX_FILE_SIZE" value="25000000">
						<input type="hidden" name="fileSource" id="fileSource" value="RED" />
						<input type="hidden" name="docStatus" id="docStatus" value="Revised" />
						<table class="docList">
							<tr>
								<th class="addRevDocListTitle">Document title</th>
								<th class="addRevDocListRevision">New Revision</th>
								<th class="addRevDocListApplication">Application</th>
								<th class="addRevDocListZone">Zone</th>
								<th class="addRevDocListSector">Sector</th>
								<th class="addRevDocListPassword">Password</th>
							</tr>
							<?php 
							if ($totalRows_rstAddRevisedDocList == 0)
							{
								// Nothing is currently checked out to this person
								?>
								<tr>
									<td class="docNumbers" colspan="6">There are no documents in your ownership currently checked out for revision</td>
								</tr>
							<?php }
							else
							{ 
								do { ?>
								<tr>
									<td class="addRevDocListTitle">
										<input name="addRevisedRadio" id ="addRevisedRadio" type="radio" 
											value="<?php echo $row_rstAddRevisedDocList['doc_pk']; ?>"	
											onclick="$('#file').removeAttr('disabled'); $('#uploadFile').attr('disabled', 'disabled')" 
										/><?php echo ' '.$row_rstAddRevisedDocList['docTitle']; ?>
									</td>
									<td class="addRevDocListRevision"><?php echo $row_rstAddRevisedDocList['docRevision']; ?></td>
									<td class="addRevDocListApplication"><?php echo $row_rstAddRevisedDocList['docApplication']; ?></td>
									<td class="addRevDocListZone"><?php echo $row_rstAddRevisedDocList['zoneTitle']; ?></td>
									<td class="addRevDocListSector">
										<?php 
										if (!strcmp($row_rstAddRevisedDocList['sectorTitle'], "")) echo 'None';
										else echo $row_rstAddRevisedDocList['sectorTitle']; 
										?>
									</td>
									<?php 
									if ($row_rstAddRevisedDocList['docFileType_id'] == 7 || $row_rstAddRevisedDocList['docFileType_id'] == 8)
										echo '<td class="addRevDocListPassword">---</td>';
									else if ($row_rstAddRevisedDocList['docFileType_id'] == 2) 
										echo '<td class="addRevDocListPasswordNone">Non-editable</td>';
									else echo '<td class="addRevDocListPassword">'.$row_rstAddRevisedDocList['docPassword'].'</td>';
									?>
								</tr>
								<?php } while ($row_rstAddRevisedDocList = mysql_fetch_assoc($rstAddRevisedDocList)); ?>
								<tr>
									<td class="addRevDocListTitle" colspan="6">
									<input type="file" name="file" id="file" disabled="disabled" onclick="$('#uploadFile').removeAttr('disabled')" />
									<input name="uploadFile" id="uploadFile" type="submit" value="Upload" disabled="disabled" />
									</td>							
								</tr>
							<?php } // end else ?>
						</table>
						<input type="hidden" name="tab" id="tab" value="1" />
					</form>
					<?php // Only show the navigation table if it is required
					if  ($totalRows_rstAddRevisedDocList > $maxRows_rstAddRevisedDocList) 
					{ ?>
						<table class="navigation">
							<tr>
								<td class="navigation">
									<a <?php
									if ($pageNum_rstAddRevisedDocList > 0) 
											echo ' class="searchNavVisible" ';
										else
											echo ' class="searchNavInvisible" ';								
									?> href="<?php printf("%s?pageNum_rstAddRevisedDocList=%d%s%s", $currentPage, 0, $queryString_rstAddRevisedDocList, '&tab=1'); ?>">First page
									</a>
								</td>
								<td class="navigation">
									<a <?php
									if ($pageNum_rstAddRevisedDocList > 1) 
											echo ' class="searchNavVisible" ';
										else
											echo ' class="searchNavInvisible" ';
									?> href="<?php printf("%s?pageNum_rstAddRevisedDocList=%d%s%s", $currentPage, max(0, $pageNum_rstAddRevisedDocList - 1), $queryString_rstAddRevisedDocList, '&tab=1'); ?>">Previous page
									</a>
								</td>
								<td class="navigation">navigation</td>
								<td class="navigation">
									<a <?php 
									if ($pageNum_rstAddRevisedDocList < $totalPages_rstAddRevisedDocList - 1)
											echo ' class="searchNavVisible" ';
										else
											echo ' class="searchNavInvisible" ';								
									?> href="<?php printf("%s?pageNum_rstAddRevisedDocList=%d%s%s", $currentPage, min($totalPages_rstAddRevisedDocList, $pageNum_rstAddRevisedDocList + 1), $queryString_rstAddRevisedDocList, '&tab=1'); ?>">Next page
									</a>
								</td>
								<td class="navigation">
									<a <?php 
									if ($pageNum_rstAddRevisedDocList < $totalPages_rstAddRevisedDocList)
											echo ' class="searchNavVisible" ';
										else
											echo ' class="searchNavInvisible" ';
									?>href="<?php printf("%s?pageNum_rstAddRevisedDocList=%d%s%s", $currentPage, $totalPages_rstAddRevisedDocList, $queryString_rstAddRevisedDocList, '&tab=1'); ?>">Last page
									</a>
								</td>
							</tr>
						</table>	
					<?php } ?>
				</div>
			<div id="TabbedPanel3" class="TabbedPanelsContent">
				<h4 class="bold">Add a new document to the intranet</h4>
				<form enctype="multipart/form-data" action="upload.php" method="post" name="addDocForm" id="addDocForm">
					<input type="hidden" name="MAX_FILE_SIZE" value="25000000">
					<input type="hidden" name="fileSource" id="fileSource" value="RED" />
					<input type="hidden" name="docStatus" id="docStatus" value="New" />
					<?php
					// Generate a random password
					$password = generatePassword(8);
					?>
					<table class="addDoc">					
						<tr>
							<td class="addDocListHeader">Document Title (10-128 characters)</td>
							<td class="addDocListTitle" colspan="4">
								<span id="sprytextfield1">
									<input name="docTitle" id="docTitle" type="text" class="title" maxlength="128" tabindex=1 />
									<span class="textfieldRequiredMsg">The document must have a title</span>
									<span class="textfieldMinCharsMsg">The title length must be at least 10 characters</span>
									<span class="textfieldMaxCharsMsg">The title length cannot exceed 128 characters</span>
								</span>
							</td>
							<td class="fifteen">&nbsp;</td>
						</tr>
						<tr>
							<td class="addDocListHeader">PMS Zone / Admin Group</td>
							<td class="addDocListZone" colspan="2">
								<span id="spryselect1">
									<select name="docZoneID" id="docZoneID" class="selectZone" tabindex=2>
										<option value="0">Select a PMS Zone...</option>
										<?php do { ?>
											<option value="<?php echo $row_rstPMSZones['zone_pk']; ?>"><?php echo $row_rstPMSZones['zoneTitle']; ?></option>
										<?php } while ($row_rstPMSZones = mysql_fetch_assoc($rstPMSZones)); ?>
									</select>
									<span class="selectInvalidMsg">Please select a PMS zone for the document</span>
									<span class="selectRequiredMsg">Please select a PMS zone for the document</span>
								</span>
							</td>
							<td class="addDocListAdminGroup" colspan="2">
								<span id="spryselect2">
									<select name="adminGroupID" id="adminGroupID" class="selectAdminGroup" tabindex=3>
										<option value="0">Select an admin group...</option>
										<?php do { ?>
											<option value="<?php echo $row_rstAdminGroups['adminGroup_pk']; ?>"><?php echo $row_rstAdminGroups['agMembers']; ?></option>
										<?php } while ($row_rstAdminGroups = mysql_fetch_assoc($rstAdminGroups)); ?>
									</select>
									<span class="selectInvalidMsg">Please select an administration group responsible for the document</span>
									<span class="selectRequiredMsg">Please select an administration group responsible for the document</span>
								</span>
							</td>
							<td class="fifteen">&nbsp;</td>
						</tr>
						<tr>
							<td class="addDocListHeader">Document Type / Subject</td>
							<td class="addDocListDocType" colspan="2">
								<span id="spryselect3">
									<select name="docTypeID" id="docTypeID" class="selectDocType" tabindex=4>
										<option value="0">Select a Document Type...</option>
										<?php do { ?>
											<option value="<?php echo $row_rstDocumentType['docType_pk']; ?>"><?php echo $row_rstDocumentType['docType']; ?></option>
										<?php } while ($row_rstDocumentType = mysql_fetch_assoc($rstDocumentType)); ?>
									</select>
									<span class="selectInvalidMsg">Please select a document type</span>
									<span class="selectRequiredMsg">Please select a document type</span>
								</span>
							</td>
							<td class="addDocListDocSubject" colspan="2">
								<span id="spryselect4">
									<select name="docSubjectID" id="docSubjectID" class="selectDocSubject" tabindex=5>
										<option value="0">Select a Document Subject...</option>
										<?php do { ?>
											<option value="<?php echo $row_rstDocumentSubject['docSubjectRED_pk']; ?>"><?php echo $row_rstDocumentSubject['docSubjectRED']; ?></option>
										<?php } while ($row_rstDocumentSubject = mysql_fetch_assoc($rstDocumentSubject)); ?>
									</select>
									<span class="selectInvalidMsg">Please select a document subject</span>
									<span class="selectRequiredMsg">Please select a document subject</span>
								</span>
							</td>
							<td class="fifteen">&nbsp;</td>
						</tr>
						<tr>
							<td class="addDocListHeader">Relevant Office(s) / Listing</td>
							<td class="addDocListDocType" colspan="2">
								<span id="spryselect5">
									<select name="officeID" id="officeID" class="selectOffice" tabindex=6>
										<option value="0">Select relevant office(s)...</option>
										<?php do { ?>
											<option value="<?php echo $row_rstOffices['office_pk']; ?>"><?php echo $row_rstOffices['location']; ?></option>
										<?php } while ($row_rstOffices = mysql_fetch_assoc($rstOffices)); ?>
									</select>
									<span class="selectInvalidMsg">Please select which office(s) the document relates to</span>
									<span class="selectRequiredMsg">Please select which office(s) the document relates to</span>
								</span>
							</td>
							<td class="addDocListDocListing" colspan="2">
								<span id="spryselect6">
									<select name="docListingID" id="docListingID" class="selectListing" tabindex=7>
										<option value="0">Select document listing...</option>
										<?php do { ?>
											<option value="<?php echo $row_rstDocListing['docListing_pk']; ?>"><?php echo $row_rstDocListing['docListingTitle']; ?></option>
										<?php } while ($row_rstDocListing = mysql_fetch_assoc($rstDocListing)); ?>
									</select>
									<span class="selectInvalidMsg">Please select the person(s) who will be able to download/view the document</span>
									<span class="selectRequiredMsg">Please select the person(s) who will be able to download/view the document</span>
								</span>
							</td>
						</tr>
						<tr>
							<td class="addDocListHeader">Relevant business sector</td>
							<td class="addDocListSector">
								<input class="sector" name="docSectorID" id="docSectorID" type="radio" checked="checked" value="1"  tabindex=8 />None
							</td>
						</tr>
						<?php
						if ($row_rstUserSector1['isDirector'] == 1)
						{ ?>
						<tr>
							<td class="addDocListHeader">&nbsp;</td>
							<?php
							if ($row_rstUserSector1['director_sector1_id'] > 0)
							{ ?>
								<td class="addDocListSector">
									<input class="sector" name="docSectorID" id="docSectorID" type="radio" tabindex=9
										value="<?php echo $row_rstUserSector1['director_sector1_id']; ?>" /><?php echo $row_rstUserSector1['sectorTitle']; ?>
								</td>
								<?php 
								if ($row_rstUserSector2['director_sector2_id'] > 0) 
								{ ?>
									<td class="addDocListSector">
										<input class="sector" name="docSectorID" id="docSectorID" type="radio" tabindex=10
											value="<?php echo $row_rstUserSector2['director_sector2_id']; ?>" /><?php echo $row_rstUserSector2['sectorTitle']; ?>
									</td>
									<?php								
									if ($row_rstUserSector3['director_sector3_id'] > 0) 
									{ ?>
										<td class="addDocListSector">
											<input class="sector" name="docSectorID" id="docSectorID" type="radio" tabindex=11 
												value="<?php echo $row_rstUserSector3['director_sector3_id']; ?>" /><?php echo $row_rstUserSector3['sectorTitle']; ?>
										</td>
										<?php								
										if ($row_rstUserSector4['director_sector4_id'] > 0) 
										{ ?>
											<td class="addDocListSector">
											<input class="sector" name="docSectorID" id="docSectorID" type="radio" tabindex=12 
												value="<?php echo $row_rstUserSector4['director_sector4_id']; ?>" /><?php echo $row_rstUserSector4['sectorTitle']; ?>
											</td>
											<?php								
											if ($row_rstUserSector5['director_sector5_id'] > 0) 
											{ ?>
												<td class="addDocListSector">
												<input class="sector" name="docSectorID" id="docSectorID" type="radio" tabindex=13 
													value="<?php echo $row_rstUserSector5['director_sector5_id']; ?>" /><?php echo $row_rstUserSector5['sectorTitle']; ?>
												</td>
											<?php }
											else
											{ ?>
												<td class="fifteen">&nbsp;</td>
											<?php }
										}
										else
										{ ?>
										<td class="thirty" colspan="2">&nbsp;</td>
										<?php }
									}
									else
									{ ?>
										<td class="fortyFive" colspan="3">&nbsp;</td>
									<?php }
								}
								else
								{ ?>
									<td class="sixty" colspan="4">&nbsp;</td>
								<?php }
							}
							else
							{ ?>
								<td class="seventyFive" colspan="5">&nbsp;</td>
							<?php }
						} ?>
						</tr>
						<tr>
							<td class="addDocListHeader">Password</td>
							<td class="addDocListPassword">
								<input name="pw" id="pw" class="pw" type="text" size="25" maxlength="8" readonly="true" value="<?php echo $password; ?>"/>
							</td>
							<td class="sixty" colspan="4">&nbsp;</td>
						</tr>
						<tr>
							<td class="addDocListHeader">Select the file to upload</td>
							<td class="addDocListFile" colspan="2"><input class="file" name="file" id="file" type="file" tabindex=14 
								onclick="$('#uploadFile').removeAttr('disabled')"/>
							</td>
							<td class="fortyFive" colspan="3">&nbsp;</td>
						</tr>
						<tr>
							<td class="addDocListHeader">&nbsp;</td>
							<td class="addDocListUpload" colspan="2">
								<input name="uploadFile" id="uploadFile" type="submit" value="Upload" disabled="disabled" />
							</td>
							<td class="fortyFive" colspan="3">&nbsp;</td>
						</tr>	
					</table>
					<input type="hidden" name="tab" id="tab" value="4" />
				</form>
			</div>
			<div id="TabbedPanel4" class="TabbedPanelsContent">
				<h4 class="bold">Set the visibility of documents in your ownership</h4>
				<table class="docList">
					<tr>
						<th class="visDocListTitle">Document title</th>
						<th class="visDocListRevision">Revision</th>
						<th class="visDocListZone">PMS Zone</th>
					</tr>
					<?php
					if ($totalRows_rstVisDocList == 0)
					{
						// Nothing is currently owned by this person
						?>
						<tr>
							<td class="docNumbers" colspan="3">
								<span style="color: #900;">There are no documents currently in your ownership</span>
							</td>
						</tr>
					<?php }
					else
					{ ?>
					<tr>
						<td class="docNumbers" colspan="3">
						<?php 
							if ($totalRows_rstVisDocList == 1) 
								echo 'There is one document';
							else 
								echo 'There are '.$totalRows_rstVisDocList.' documents';
							echo ' currently in your ownership';
							if ($totalRows_rstVisDocList > $maxRows_rstVisDocList)
							{
								if (min($startRow_rstVisDocList + $maxRows_rstVisDocList, $totalRows_rstVisDocList) == $totalRows_rstVisDocList) echo '.  Showing final document(s) in results set.';
								else echo '. Showing documents '.($startRow_rstVisDocList + 1).' to '.min($startRow_rstVisDocList + $maxRows_rstVisDocList, $totalRows_rstVisDocList).'.';
							}
						?>
						</td>
					</tr>
					<form method="post" name="setDocVisibility" id="setDocVisibility">
						<?php 
						do 
						{ ?>
							<tr>
								<td class="visDocListTitle">
									<input type="checkbox" name="checkbox[]" id="checkbox"
										<?php if ($row_rstVisDocList['docVisible'] == 1) echo 'checked="checked"'; ?>
										onclick="$('#setVisButton').removeAttr('disabled').addClass('boldRed');"
										value="<?php echo $row_rstVisDocList['doc_pk']; ?>"
									/>
									<?php echo $row_rstVisDocList['docTitle']; ?>
								</td>
								<td class="visDocListRevision"><?php
								if (!strcmp($row_rstVisDocList['docRevision'],"")) 
									echo '-';
								else
									echo $row_rstVisDocList['docRevision']; ?></td>
								<td class="visDocListZone"><?php echo $row_rstVisDocList['zoneTitle']; ?></td>
							</tr>
						<?php } while ($row_rstVisDocList = mysql_fetch_assoc($rstVisDocList)); 
						?>
						<tr>
							<td class="visDocListTitle" colspan="4">
								<input name="setVisButton" id="setVisButton" type="submit" disabled="disabled" value="Update" />
							</td>							
						</tr>
						<input type="hidden" name="tab" id="tab" value="2" />
					</form>
					<?php } 
					// Manually update the database - THIS DOES NOT WORK AT PRESENT BECAUSE OF NEED TO GET CHECKBOX ID AND VALUE FOR CHECKED AND UNCHECKED BOXES
					/*
					if (isset($_POST['setVisButton']))
					{
						// Create an array of user names to use in finding persons who have checked out documents
						//@ $db = new mysqli('localhost', 'kcalder', 'kC->RED%zERO', 'intranet');
						@ $db = new mysqli('localhost', 'root', 'hpfHPF840', 'intranet');
						if (!$db) die ('Could not connect to the database: '.mysql_error());
						// Update the database with all 
						foreach($_POST['checkbox'] as $id)
						{
							$query = sprintf("UPDATE document SET docVisible=%d WHERE doc_pk=%s", $checked, $id);
							$result = $db->query($query);
						}
					}
					*/
					?>
				</table>
				<?php // Only show the navigation table if it is required
				if  ($totalRows_rstVisDocList > $maxRows_rstVisDocList) 
				{ ?>
					<table class="navigation">
						<tr>
							<td class="navigation">
								<a <?php
									if ($pageNum_rstVisDocList > 0)
										echo ' class="searchNavVisible" ';
									else
										echo ' class="searchNavInvisible" ';	
								?> href="<?php printf("%s?pageNum_rstVisDocList=%d%s%s", $currentPage, 0, $queryString_rstVisDocList, '&tab=2'); ?>">First page
								</a>
							</td>
							<td class="navigation">
								<a <?php
									if ($pageNum_rstVisDocList > 1)
										echo ' class="searchNavVisible" ';
									else
										echo ' class="searchNavInvisible" ';	
								?> href="<?php printf("%s?pageNum_rstVisDocList=%d%s%s", $currentPage, max(0, $pageNum_rstVisDocList - 1), $queryString_rstVisDocList, '&tab=2'); ?>">Previous page
								</a>
							</td>
							<td class="navigation">navigation</td>
							<td class="navigation">
								<a <?php
									if ($pageNum_rstVisDocList < $totalPages_rstVisDocList - 1)
										echo ' class="searchNavVisible" ';
									else
										echo ' class="searchNavInvisible" ';	
								?> href="<?php printf("%s?pageNum_rstVisDocList=%d%s%s", $currentPage, min($totalPages_rstVisDocList, $pageNum_rstVisDocList + 1), $queryString_rstVisDocList, '&tab=2'); ?>">Next page
								</a>
							</td>
							<td class="navigation">
								<a <?php 
									if ($pageNum_rstVisDocList < $totalPages_rstVisDocList)
										echo ' class="searchNavVisible" ';
									else
										echo ' class="searchNavInvisible" ';								
								?> href="<?php printf("%s?pageNum_rstVisDocList=%d%s%s", $currentPage, $totalPages_rstVisDocList, $queryString_rstVisDocList, '&tab=2'); ?>">Last page
								</a>
							</td>
						</tr>
					</table>	
				<?php } ?>		
			</div>
			<div id="TabbedPanel5" class="TabbedPanelsContent">
				<h4 class="bold">Retrieve a superseded document from the archive</h4>
				<form action="../common/php/download.php" name="downloadForm" id="downloadForm" method="get">
				<table class="docList">
					<tr>
						<th class="arcDocListTitle">Document title</th>
						<th class="arcDocListRevision">Revision</th>
						<th class="arcDocListApplication">Application</th>
						<th class="arcDocListZone">PMS Zone</th>
					</tr>
					<?php 
					if ($totalRows_rstArchivedDocList == 0)
					{
						// There is nothing available to this user is in the archive
						?>
						<tr>
							<td class="addRevDocListTitle" colspan="6">
								<span style="color: #900;">There are no archived documents either owned by you or associated with your administration group(s)</span>
							</td>
						</tr>
					<?php }
					else
					{ ?>
						<?php do { ?>
						<tr>
							<td class="arcDocListTitle">
								<?php 
								$fileName = 'ARCHIVE - ';
								if (!strcmp($row_rstArchivedDocList['docRevision'],"")) 
									$fileName .= $row_rstArchivedDocList['docTitle'].'.'.$row_rstArchivedDocList['docFileType'];
								else
									$fileName .= $row_rstArchivedDocList['docTitle'].' - Revision '.$row_rstArchivedDocList['docRevision'].'.'.$row_rstArchivedDocList['docFileType']; 
									?>
								<a class="menu" href="../common/php/download.php?s=RED&c=Archive&f=<?php echo $fileName; ?>&fc=<?php echo $fileName; ?>" 
									title="<?php echo 'Click to download this document' ?>">
									<?php 
										if (!strcmp($row_rstArchivedDocList['docRevision'],"")) 
											echo $row_rstArchivedDocList['docTitle'];
										else
											echo $row_rstArchivedDocList['docTitle'].' - Revision '.$row_rstArchivedDocList['docRevision'];
									?>
								</a>
							</td>
							<td class="arcDocListRevision"><?php 
								if (!strcmp($row_rstArchivedDocList['docRevision'],"")) 
									echo '-';
								else
									echo $row_rstArchivedDocList['docRevision']; ?>
							</td>
							<td class="arcDocListApplication"><?php echo $row_rstArchivedDocList['docApplication']; ?></td>
							<td class="arcDocListZone"><?php echo $row_rstArchivedDocList['zoneTitle']; ?></td>
						</tr>
						<?php } while ($row_rstArchivedDocList = mysql_fetch_assoc($rstArchivedDocList)); ?>
					<?php } ?>
				</table>
				<input type="hidden" name="tab" id="tab" value="5" />
			</form>
			<?php // Only show the navigation table if it is required
				if  ($totalRows_rstArchivedDocList > $maxRows_rstArchivedDocList) 
				{ ?>
					<table class="navigation">
						<tr>
							<td class="navigation">
								<a <?php
								if ($pageNum_rstArchivedDocList > 0) 
									echo ' class="searchNavVisible" ';
								else
									echo ' class="searchNavInvisible" ';			
								?> href="<?php printf("%s?pageNum_rstArchivedDocList=%d%s%s", $currentPage, 0, $queryString_rstArchivedDocList, '&tab=4'); ?>">First page
								</a>
							</td>
							<td class="navigation">
								<a <?php
								if ($pageNum_rstArchivedDocList > 1) 
									echo ' class="searchNavVisible" ';
								else
									echo ' class="searchNavInvisible" ';
								?> href="<?php printf("%s?pageNum_rstArchivedDocList=%d%s%s", $currentPage, max(0, $pageNum_rstArchivedDocList - 1), $queryString_rstArchivedDocList, '&tab=4'); ?>">Previous page
								</a>
							</td>
							<td class="navigation">navigation</td>
							<td class="navigation">
								<a <?php
								if ($pageNum_rstArchivedDocList < $totalPages_rstArchivedDocList - 1)
									echo ' class="searchNavVisible" ';
								else
									echo ' class="searchNavInvisible" ';				
								?> href="<?php printf("%s?pageNum_rstArchivedDocList=%d%s%s", $currentPage, min($totalPages_rstArchivedDocList, $pageNum_rstArchivedDocList + 1), $queryString_rstArchivedDocList, '&tab=4'); ?>">Next page
								</a>
							</td>
							<td class="navigation">
								<a <?php
								if ($pageNum_rstArchivedDocList < $totalPages_rstArchivedDocList)
									echo ' class="searchNavVisible" ';
								else
									echo ' class="searchNavInvisible" ';
								?> href="<?php printf("%s?pageNum_rstArchivedDocList=%d%s%s", $currentPage, $totalPages_rstArchivedDocList, $queryString_rstArchivedDocList, '&tab=4'); ?>">Last page
								</a>
							</td>
						</tr>
					</table>	
				<?php } ?>	
			</div>	
			<div id="TabbedPanel6" class="TabbedPanelsContent">
				<h4 class="bold">Delete a document in your ownership</h4>
				<table class="docList">
					<tr>
						<th class="delDocListTitle">Document title</th>
						<th class="delDocListRevision">Revision</th>
						<th class="delDocListZone">PMS Zone</th>
					</tr>
					<tr>
					<?php
					if ($totalRows_rstDelDocList == 0)
					{
						// Nothing is currently owned by this person
						?>
						<tr>
							<td class="docNumbers" colspan="3">
								<span style="color: #900;">There are no documents currently in your ownership</span>
							</td>
						</tr>
					<?php }
					else
					{ ?>
						<tr>
							<td class="docNumbers" colspan="3">
							<?php 
								if ($totalRows_rstDelDocList == 1) echo 'There is one document';
								else echo 'There are '.$totalRows_rstDelDocList.' documents';
								echo ' currently in your ownership';
								if ($totalRows_rstDelDocList > $maxRows_rstDelDocList)
								{
									if (min($startRow_rstDelDocList + $maxRows_rstDelDocList, $totalRows_rstDelDocList) == $totalRows_rstDelDocList) echo '.  Showing final document(s) in results set.';
									else echo '. Showing documents '.($startRow_rstDelDocList + 1).' to '.min($startRow_rstDelDocList + $maxRows_rstDelDocList, $totalRows_rstDelDocList).'.';
								}
							?>
							</td>
						</tr>
						<form action="mgtRED.php" method="post" name="delDoc" id="delDoc">
							<?php do { ?>
								<tr>
									<td class="delDocListTitle">
										<input name="deleteRadio" id="deleteRadio" type="radio" 
											onclick="$('#confirm').addClass('noShow');
													 $('#delete').removeAttr('disabled').addClass('boldRed');"
										value="<?php echo $row_rstDelDocList['doc_pk']; ?>" />
										<?php echo $row_rstDelDocList['docTitle']; ?>
									</td>
									<td class="delDocListRevision"><?php
										if (!strcmp($row_rstDelDocList['docRevision'],"")) 
											echo '-';
										else
											echo $row_rstDelDocList['docRevision']; ?>
									</td>
									<td class="delDocListZone"><?php echo $row_rstDelDocList['zoneTitle']; ?></td>
								</tr>
								<input type="hidden" name="fileName" id="fileName" value="<?php echo $row_rstDelDocList['fileName'].'.'.$row_rstDelDocList['fileType']; ?>" />
								<input type="hidden" name="title" id="title" value="<?php echo $row_rstDelDocList['docTitle']; ?>" />
								<input type="hidden" name="revision" id="revision" value="<?php echo $row_rstDelDocList['docRevision']; ?>" />
							<?php } while ($row_rstDelDocList = mysql_fetch_assoc($rstDelDocList)); ?>
							<tr>
								<td class="delDocListTitle" colspan="3">
									<input name="delete" id="delete" type="button" disabled="disabled" value="Delete" />
									<input name="confirm" id="confirm" type="submit" value="Confirm" class="noShow" />
								</td>							
							</tr>
							<input type="hidden" name="tab" id="tab" value="5" />
						</form>
						<?php
						if (isset($_POST['confirm']))
						{
							$currentFile = $_POST['fileName'];
							$newFile = 'DELETED - '.$_POST['title'].' Revision - '.$_POST['revision'];
							dropFile($currentFile, $newFile);
						}
					} ?>
				</table>
				<?php // Only show the navigation table if it is required
				if  ($totalRows_rstDelDocList > $maxRows_rstDelDocList) 
				{ ?>
					<table class="navigation">
						<tr>
							<td class="navigation">
								<a <?php 
								if ($pageNum_rstDelDocList > 0) 
									echo ' class="searchNavVisible" ';
								else
									echo ' class="searchNavInvisible" ';	
								?> href="<?php printf("%s?pageNum_rstDelDocList=%d%s%s", $currentPage, 0, $queryString_rstDelDocList, '&tab=5'); ?>">First page
								</a>
							</td>
							<td class="navigation">
								<a <?php 
								if ($pageNum_rstDelDocList > 1) 
									echo ' class="searchNavVisible" ';
								else
									echo ' class="searchNavInvisible" ';
								?> href="<?php printf("%s?pageNum_rstDelDocList=%d%s%s", $currentPage, max(0, $pageNum_rstDelDocList - 1), $queryString_rstDelDocList, '&tab=5'); ?>">Previous page
								</a>
							</td>
							<td class="navigation">navigation</td>
							<td class="navigation">
								<a <?php 
								if ($pageNum_rstDelDocList < $totalPages_rstDelDocList - 1)
									echo ' class="searchNavVisible" ';
								else
									echo ' class="searchNavInvisible" ';				
								?> href="<?php printf("%s?pageNum_rstDelDocList=%d%s%s", $currentPage, min($totalPages_rstDelDocList, $pageNum_rstDelDocList + 1), $queryString_rstDelDocList, '&tab=5'); ?>">Next page
								</a>
							</td>
							<td class="navigation">
								<a <?php
								if ($pageNum_rstDelDocList < $totalPages_rstDelDocList)
									echo ' class="searchNavVisible" ';
								else
									echo ' class="searchNavInvisible" ';
								?> href="<?php printf("%s?pageNum_rstDelDocList=%d%s%s", $currentPage, $totalPages_rstDelDocList, $queryString_rstDelDocList, '&tab=5'); ?>">Last page
								</a>
							</td>
						</tr>
					</table>	
				<?php } ?>		
			</div>
			<div id="TabbedPanel7" class="TabbedPanelsContent">
			<div id="Accordion1" class="Accordion">
					<div class="AccordionPanel">
							<div class="AccordionPanelTab">Checkout</div>
							<div class="AccordionPanelContent"> 
								<?php echo $row_rstHelpTextCheckout['helpText']; ?> 
							</div>
					</div>
					<div class="AccordionPanel">
							<div class="AccordionPanelTab">Add Revised</div>
							<div class="AccordionPanelContent">
								<?php echo $row_rstHelpTextAddRevised['helpText']; ?>
							</div>
					</div>
					<div class="AccordionPanel">
							<div class="AccordionPanelTab">Set Visibility</div>
							<div class="AccordionPanelContent">
								<?php echo $row_rstHelpTextVisibility['helpText']; ?>
							</div>
					</div>
					<div class="AccordionPanel">
							<div class="AccordionPanelTab">Add New</div>
							<div class="AccordionPanelContent">
								<?php echo $row_rstHelpTextAddNew['helpText']; ?>
							</div>
					</div>
					<div class="AccordionPanel">
							<div class="AccordionPanelTab">Retrieve from Archive</div>
							<div class="AccordionPanelContent">
								<?php echo $row_rstHelpTextArchive['helpText']; ?>
							</div>
					</div>
					<div class="AccordionPanel">
							<div class="AccordionPanelTab">Drop from Database</div>
							<div class="AccordionPanelContent">
								<?php echo $row_rstHelpTextDrop['helpText']; ?>
							</div>
					</div>
			</div>
		</div>
	</div> <?php // end TabbedPanels1 ?>
</div>
<p><a class="generalPageNav" href="../menu.php">Main menu</a></p>
<p><a class="generalPageNav" href="<?php echo $logoutAction ?>">Log out</a></p>
</div><!-- content -->
<script type="text/javascript">
<!--
var TabbedPanels1 = new Spry.Widget.TabbedPanels("TabbedPanels1", { defaultTab: <?php echo $tab; ?>  });
var Accordion1 = new Spry.Widget.Accordion("Accordion1");
var sprytextfield1 = new Spry.Widget.ValidationTextField("sprytextfield1", "none", {minChars:10, maxChars:128, validateOn:["blur"]});
var spryselect1 = new Spry.Widget.ValidationSelect("spryselect1", {invalidValue:"0", validateOn:["change"]});
var spryselect2 = new Spry.Widget.ValidationSelect("spryselect2", {invalidValue:"0", validateOn:["change"]});
var spryselect3 = new Spry.Widget.ValidationSelect("spryselect3", {invalidValue:"0", validateOn:["change"]});
var spryselect4 = new Spry.Widget.ValidationSelect("spryselect4", {invalidValue:"0", validateOn:["change"]});
var spryselect5 = new Spry.Widget.ValidationSelect("spryselect5", {invalidValue:"0", validateOn:["change"]});
var spryselect6 = new Spry.Widget.ValidationSelect("spryselect6", {invalidValue:"0", validateOn:["change"]});
//-->
</script>
<?php 
	// If the file has successfully uploaded then notify the user
	if ($_SESSION['fileUploadStatus'] == true)
	{ 
		echo '<script language="javascript" type="text/javascript">';
		echo 'alert("The file was added and is now visible on the Intranet")'; 
		echo '</script>';
		// Reset the session flag
		$_SESSION['fileUploadStatus'] = false;
	}
?>
</body>
</html>
<?php
mysql_free_result($rstCheckoutDocList);
mysql_free_result($rstZoneHelp);
mysql_free_result($rstDocOwner);
mysql_free_result($rstDocOwnerList);
mysql_free_result($rstAddRevisedDocList);
mysql_free_result($rstUserSector1);
mysql_free_result($rstUserSector2);
mysql_free_result($rstUserSector3);
mysql_free_result($rstUserSector4);
mysql_free_result($rstUserSector5);
mysql_free_result($rstDelDocList);
mysql_free_result($rstDownloadFile);
mysql_free_result($rstHelpTextCheckout);
mysql_free_result($rstArchivedDocList);
mysql_free_result($rstHelpTextAddRevised);
mysql_free_result($rstHelpTextAddNew);
mysql_free_result($rstHelpTextDrop);
mysql_free_result($rstHelpTextArchive);
mysql_free_result($rstAdminGroups);
mysql_free_result($rstPMSZones);
mysql_free_result($rstDocumentType);
mysql_free_result($rstDocumentSubject);
mysql_free_result($rstOffices);
mysql_free_result($rstVisDocList);
mysql_free_result($rstHelpTextVisibility);
mysql_free_result($rstDocListing);
?>

Select all Open in new window

by: kcalderPosted on 2009-09-09 at 11:44:31ID: 25294281

I have no intention of having anything like the full page code debugged, it doesn't need it. 99% of the page works very nicely. I am simply having difficulty with getting the checkbox routine working and that's what I needed help with. I appreciate you taking the time to provide me with some snippets and I'll work at trying to integrate the principles you have shown. Thanks.

by: kcalderPosted on 2009-09-09 at 11:49:16ID: 31626764

I have not managed to translate the code snippet based on a manual loop into my code. I am using Dreamweaver's repeat region behaviour for looping through the form and cannot work out how to tag the checkboxes both in terms of ID and 'checked' value. Once I get that sorted I know how to develop an appropriate MySQL update query. I do appreciate that experts do not always want merely to provide 'cut and paste' answers to problems but to help enquirers to think for themselves and that's good. Perhaps I need to go away and scratch my head a bit harder!

by: Ray_PaseurPosted on 2009-09-09 at 13:09:09ID: 25295085

@kcalder: No disrespect meant, but I think you got a lot of effort out of EE over a 125 point question, and I wonder if you expected me to rework your code in order to get a grade of "A"? If so, you might want to review the grading guidelines before you exercise someone else on such a big task for so little reward.

Question

Update multiple checkboxes (PHP/MySQL)

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

PHP

MySQL

PHP and Databases

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Need individual assistance?

Our experts are ready to help.

Want to learn from the best?

Read articles from industry experts.

Working on a long term project?

Store your work and research.

What Makes Experts Exchange Unique?

Trusted by the world's most respected brands.

Faithfully serving IT professionals since 1996.

Related Solutions

Free Tech Articles

Cloud Class Webinars

Join the Community

Give a Little. Get a Lot.

Answers

3 Ways to Join

The Experts

The Experts

Testimonials

Testimonials

Testimonials

Business Clients

Business Clients

In the Press

In the Press

In the Press