[Summary view] [Print] [Text view]

   1  <?php
   2  if ($script_name = basename($HTTP_SERVER_VARS["SCRIPT_NAME"]) == "all_camping_record.php" ) {
   3   print "<meta http-equiv=\"refresh\" content=\"0; URL=./index.php\">";
   4   exit;
   5  }
   6  
   7  print "<center><h3>All Scouts Activity Record</h3></center></center>";
   8  
   9  
  10  if ($add_date == "Y" && $user_group <=2) {
  11   $check_date = verifydate($activity_date);
  12   if ($check_date == '0000-00-00') {
  13    print "<center><h2>Invalid Date $activity_date</h2></center>\n<br>";
  14   } else {
  15    print "<center><h2>Adding $activity date $check_date for:</h2></center>";
  16    foreach ($attended as $rowid => $att_activity) {
  17     if ($att_activity = 'Y') {
  18      $sql_insert = mysql_query("insert into tbl_scout_activity
  19                                  (scout_key
  20                         ,activity
  21                       ,date
  22                      ) values
  23                      (\"$rowid\"
  24                      ,\"$activity\"
  25                      ,\"$check_date\"
  26                      )
  27                     ");
  28      $sql = mysql_query("select last_name, first_name from tbl_scout where record_key=$rowid");
  29      extract(mysql_fetch_assoc($sql));
  30      mysql_free_result($sql);
  31      print "$first_name $last_name<br>\n";
  32     }
  33    }
  34  
  35   }
  36  }
  37  
  38  if ($user_group < "2" ) {
  39      print "<form method=POST action=./index.php>";
  40      print "<input type=hidden name=all_activity_record value=Y>";
  41      print "<input type=hidden name=add_date value=Y>";
  42  }
  43  
  44  print "<table border=1 align=center class=white><tr align=center><td><h3>Scout</td><td><h3>Attended</td>";
  45  print "</tr>";
  46  
  47  $sql = mysql_query("select first_name,
  48                             last_name,
  49                 record_key as rowid
  50              from tbl_scout
  51              group by last_name, first_name
  52              order by birthdate");
  53  
  54  while ($row = mysql_fetch_assoc($sql)) {
  55      extract($row);
  56      print "<tr><td>$first_name $last_name</td>";
  57      print "<td align=center><input type=checkbox name=attended[$rowid] value=Y></td>";
  58      print "</tr>\n";
  59  
  60  }
  61  mysql_free_result($sql);
  62  
  63  print "</table>";
  64  if ($user_group < "2" ) {
  65   print "<center><hr width=50%>Activity Date: <input type=text name=activity_date size=10
  66         onChange=\"var box=document.forms[0].activity_date;var d=parseDate(box.value);
  67                           if(d==null){
  68                            alert('Date string not recognizable!');
  69                            box.value='';
  70                            box.focus();
  71                           } else {
  72                            box.value=formatDate(d,'yyyy-MM-dd');
  73                           }\"><br>
  74          Activity: <input type=text name=activity size=25<br>
  75          <input type=submit value=Submit></form>";
  76  }
  77  
  78  ?>