[Summary view] [Print] [Text view]

   1  <?php
   2  if ($script_name = basename($HTTP_SERVER_VARS["SCRIPT_NAME"]) == "modify_counselor.php" ) {
   3   print "<meta http-equiv=\"refresh\" content=\"0; URL=../index.php\">";
   4   exit;
   5  }
   6  
   7  print "<center><h2>Modify Counselor List</h2></center>";
   8  
   9  if ($add_couns == 'Y') {
  10   $sql = mysql_query("insert into tbl_counselor 
  11                      (first_name
  12                      ,last_name
  13                      ,home_phone
  14                      ,email_addr
  15                      ,reg_date
  16                      ) values 
  17                      ('$first_name'
  18                      ,'$last_name'
  19                      ,'$home_phone'
  20                      ,'$email_addr'
  21                      ,'$reg-date'
  22                      )
  23                     ");
  24   print "<h3>$first_name $last_name Added to List</h3>";
  25   $sql = mysql_query("select max(record_key) as rowid from tbl_counselor");
  26   extract(mysql_fetch_assoc($sql));
  27   mysql_free_result($sql);
  28  }
  29  
  30  if ($update == 'Y' and $couns_delete != 'Y') {
  31   $sql = mysql_query("update tbl_counselor
  32                       set
  33                       first_name='$first_name'
  34                      ,last_name='$last_name'
  35                      ,home_phone='$home_phone'
  36                      ,email_addr='$email_addr'
  37                      ,reg_date=$reg_date
  38                      where record_key=$rowid
  39                      ");
  40   print "<h3>$first_name $last_name Updated</h3>";
  41  } else if ($couns_delete == 'Y') {
  42   $sql = mysql_query("delete from tbl_counselor where record_key=$rowid");
  43   $sql = mysql_query("delete from tbl_counselor_mb where couns=$rowid");
  44   print "$first_name $last_name Deleted from List";
  45  }
  46  
  47  if ($mb_delete !='') {
  48   foreach ($mb_delete as $mb_del_key => $mb_del) {
  49    if ($mb_del == "Y") {
  50     $sql = mysql_query("delete from tbl_counselor_mb where couns=$rowid and mb=$mb_del_key");
  51    }
  52   }
  53  }
  54  
  55  if ($add_mb != '') {
  56   $sql = mysql_query("insert into tbl_counselor_mb values ($add_mb,$rowid)");
  57  }
  58  
  59  print "<table class=white border=1>
  60         <tr align=center><td><h3>Remove MBC</td><td><h3>Counselor First Last Name</td><td><h3>Phone</td><td><h3>Email</td><td><h3>Reg. Date</td><td><h3>MB List</td></tr>";
  61  $sql = mysql_query("select * 
  62                       from tbl_counselor
  63                       order by last_name,first_name
  64                      ");
  65  
  66  while ($row = mysql_fetch_assoc($sql)) {
  67   extract($row);
  68   print "<tr>
  69           <td valign=top align=center><form method=POST action=./index.php><input type=checkbox value=Y name=couns_delete></td>
  70           <td valign=top ><input type=hidden name=modify_counselor value=Y>
  71                           <input type=hidden name=update value=Y>
  72                           <input type=hidden name=rowid value=$record_key>
  73                           <input type=text name=first_name size=15 maxlength=15 value=$first_name>&nbsp;
  74                           <input type=text name=last_name size=15 maxlength=25 value=$last_name></td>
  75           <td valign=top ><input type=text name=home_phone size=13 maxlength=13 value=$home_phone></td>
  76           <td valign=top ><input type=text name=email_addr size=15 maxlength=50 value=$email_addr></td>
  77           <td valign=top ><input type=text name=reg_date size=10 maxlength=10 value=$reg_date></td>
  78           <td><table width=100%><tr align=center><td><b>Merit Badge</td><td><b>Remove</td>";
  79   $mb_list = '';
  80   $sql_mb = mysql_query("select badge_name,mb
  81                           from tbl_counselor_mb as a, tbl_merit_badge as b
  82                           where a.mb = b.badge_number
  83                           and a.couns = $record_key
  84                           ORDER BY badge_name
  85                          ");
  86   while ($row2 = mysql_fetch_assoc($sql_mb)) {
  87    extract($row2, EXTR_PREFIX_ALL, 'mb');
  88    print "<tr><td>$mb_badge_name</td><td align=center><input type=checkbox value=Y name=mb_delete[$mb_mb] ></td></tr>";
  89    
  90    if ($mb_list == '') {
  91     $mb_list = $mb_mb;
  92    } else {
  93     $mb_list = $mb_list . ',' . $mb_mb;
  94    }
  95   }
  96   mysql_free_result($sql_mb);
  97   print "<tr><td><select name=add_mb><option value=>Select MB to add</option>";
  98   if ($mb_list != '') {
  99    $mb_list = "where a.badge_number not in ($mb_list)";
 100   }
 101  
 102   $sql_mb = mysql_query("select *
 103                           from tbl_merit_badge as a
 104                           $mb_list
 105                           ORDER BY badge_name
 106                          ");
 107   while ($row2 = mysql_fetch_assoc($sql_mb)) {
 108    extract($row2, EXTR_PREFIX_ALL, 'mb');
 109    print "<option value=$mb_badge_number>$mb_badge_name</option>";
 110   }
 111   mysql_free_result($sql_mb);
 112  
 113   print "</select></td></tr></table></td><td><input type=submit value=Modify></form></tr>";
 114  }
 115  mysql_free_result($sql);
 116  
 117  print "<tr><td></td>
 118       <td valign=top ><form method=POST action=./index.php>
 119                       <input type=hidden name=modify_counselor value=Y>
 120                       <input type=hidden name=add_couns value=Y>
 121                       <input type=text name=first_name size=15 maxlength=15 value=>&nbsp;
 122                       <input type=text name=last_name size=15 maxlength=25 value=></td>
 123       <td valign=top ><input type=text name=home_phone size=13 maxlength=13 value=></td>
 124       <td valign=top ><input type=text name=email_addr size=15 maxlength=50 value=></td>
 125       <td valign=top ><input type=text name=reg_date size=10 maxlength=10 value=></td>
 126       <td><table width=100%><tr align=center><td><b>Merit Badge</td><td><b>Remove</td>";
 127  
 128  print "<tr><td><select name=add_mb><option value=>Select MB to add</option>";
 129  $sql_mb = mysql_query("select *
 130                         from tbl_merit_badge as a
 131                         ORDER BY badge_name
 132                        ");
 133  
 134  while ($row = mysql_fetch_assoc($sql_mb)) {
 135   extract($row, EXTR_PREFIX_ALL, 'mb');
 136   print "<option value=$mb_badge_number>$mb_badge_name</option>";
 137  }
 138  mysql_free_result($sql_mb);
 139  
 140  print "</select></td></table><td><input type=submit value=Add MBC></form></tr></tr></table>";
 141  
 142  ?>