[Summary view] [Print] [Text view]

   1  
   2  <?php
   3  //INCLUDES
   4  include_once ('header.php');
   5  include_once('config.php');
   6  
   7  //CONNECT TO DATABASE
   8  $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
   9  mysql_select_db($db) or die ("Unable to select database!");
  10  
  11  //RETRIEVE URL AND FORM VARIABLES
  12  $date=$_POST['date'];
  13  $checklistItemId = (int) $_POST['checklistItemId'];
  14  $checklistId = (int) $_GET['checklistId'];
  15  $checkedClis = $_POST['checkedClis'];
  16  $clear = $_POST['clear']{0};
  17  $date=date('Y-m-d');
  18  
  19  echo '<META HTTP-EQUIV="Refresh" CONTENT="1; url=checklistReport.php?checklistId='.$checklistId.'&checklistTitle='.$checklistTitle.'">';
  20  
  21  $query= "UPDATE checklistItems SET checked='n' where checklistId='$checklistId'";
  22  $result = mysql_query($query) or die ("Error in query");
  23  
  24  if ((isset($checkedClis))&&($clear!="y")) {
  25  
  26      foreach ($checkedClis as $Cli) {
  27          $query= "update checklistItems set checked='y' where checklistItemId='$Cli'";
  28          $result = mysql_query($query) or die ("Error in query");
  29          }
  30      }
  31  
  32          $query = "select checklistId from checklistItems where checklistItemId='$checklistItemId'";
  33          $result=mysql_query($query);
  34          $row=mysql_fetch_row($result);
  35          $checklistId=$row[0];
  36  
  37  
  38  mysql_close($connection);
  39  include_once ('footer.php');
  40  ?>
  41