[Summary view] [Print] [Text view]

   1  <?php
   2  if ($script_name = basename($HTTP_SERVER_VARS["SCRIPT_NAME"]) == "admin_messages.php" ) {
   3   print "<meta http-equiv=\"refresh\" content=\"0; URL=../index.php\">";
   4   exit;
   5  }
   6  
   7  if ($action == "update") {
   8   if ($delete == "Y") {
   9    mysql_query("delete from tbl_messages where record_key=$record_key");
  10   } else {
  11    mysql_query("update tbl_messages set message='$message',view='$view',view_group='$view_group' where record_key=$record_key");
  12   }
  13  }
  14  
  15  if ($action == "insert") {
  16   mysql_query("insert into tbl_messages (message,view_group,view) values ('$message','$view_group','$view')");
  17  }
  18  
  19  print "<p>
  20    <center>
  21    <table class=white cellpadding=\"2\" cellspacing=\"0\" border=\"1\" >
  22      <tr align=center>
  23        <td>Message</td>
  24        <td>View Group</td>
  25        <td>View</td>
  26        <td>Delete</td>
  27      </tr>";
  28  
  29  $sql = mysql_query("select * from tbl_messages");
  30  
  31  while ($row = mysql_fetch_assoc($sql)) {
  32   extract($row);
  33   if ($view == "Y") {
  34     $checked = "checked";
  35   } else {
  36     $checked = "";
  37   }
  38   print "\n    <tr><form method=post>
  39     <input type=hidden name=action value=update>
  40     <input type=hidden name=modify_admin_messages value=Y>
  41     <input type=hidden name=record_key value=$record_key>
  42     <td><TEXTAREA NAME=message ROWS=3 COLS=35 WRAP=on>$message</TEXTAREA></td>
  43     <td><input type=text size=3 maxlength=3 name=view_group value=$view_group ></td>
  44     <td><input type=checkbox name=view value=Y $checked></td>
  45     <td><input type=checkbox name=delete value=Y></td>
  46     <td><input type=submit value=Submit /></td></form></td>\n    </tr>";
  47  }
  48  mysql_free_result($sql);
  49  print "<form method=post>
  50     <input type=hidden name=action value=insert>
  51     <input type=hidden name=modify_admin_messages value=Y>
  52     <td><TEXTAREA NAME=message ROWS=3 COLS=35 WRAP=on></TEXTAREA></td>
  53     <td><input type=text size=3 maxlength=3 name=view_group value='3' ></td>
  54     <td><input type=checkbox name=view value=Y checked></td>
  55     <td>&nbsp;</td><td><input type=submit value=Submit /></td></form>
  56  </table>";
  57  
  58  ?>