PageRenderTime 77ms CodeModel.GetById 51ms RepoModel.GetById 1ms app.codeStats 0ms

/admin/state/editCHO.php

https://github.com/damanlovett/SEAHO
PHP | 221 lines | 210 code | 10 blank | 1 comment | 66 complexity | e33108c672c64d45bd04978dabdc66b9 MD5 | raw file
  1. <?php require_once('../../Connections/Directory.php'); ?>
  2. <?php require_once('../includefiles/init.php'); ?>
  3. <?php require_once('../includefiles/AdminLogin.php'); ?>
  4. <?php
  5. if (!function_exists("GetSQLValueString")) {
  6. function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
  7. {
  8. $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  9. $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
  10. switch ($theType) {
  11. case "text":
  12. $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  13. break;
  14. case "long":
  15. case "int":
  16. $theValue = ($theValue != "") ? intval($theValue) : "NULL";
  17. break;
  18. case "double":
  19. $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
  20. break;
  21. case "date":
  22. $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  23. break;
  24. case "defined":
  25. $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
  26. break;
  27. }
  28. return $theValue;
  29. }
  30. }
  31. $editFormAction = $_SERVER['PHP_SELF'];
  32. if (isset($_SERVER['QUERY_STRING'])) {
  33. $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
  34. }
  35. if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
  36. $updateSQL = sprintf("UPDATE cholist SET `State`=%s, College=%s, Location=%s, `Chief Housing Officer`=%s, Title=%s, `Email Address`=%s, `Mailing Address`=%s, `Address 2`=%s, Phone=%s WHERE id=%s",
  37. GetSQLValueString($_POST['State'], "text"),
  38. GetSQLValueString($_POST['College'], "text"),
  39. GetSQLValueString($_POST['Location'], "text"),
  40. GetSQLValueString($_POST['Chief_Housing_Officer'], "text"),
  41. GetSQLValueString($_POST['Title'], "text"),
  42. GetSQLValueString($_POST['Email_Address'], "text"),
  43. GetSQLValueString($_POST['Mailing_Address'], "text"),
  44. GetSQLValueString($_POST['Address_2'], "text"),
  45. GetSQLValueString($_POST['Phone'], "text"),
  46. GetSQLValueString($_POST['id'], "int"));
  47. mysql_select_db($database_Directory, $Directory);
  48. $Result1 = mysql_query($updateSQL, $Directory) or die(mysql_error());
  49. $updateGoTo = "choreviewindex.php?recordID=" . $row_rsEditCHO['rep_id'] . "";
  50. if (isset($_SERVER['QUERY_STRING'])) {
  51. $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
  52. $updateGoTo .= $_SERVER['QUERY_STRING'];
  53. }
  54. header(sprintf("Location: %s", $updateGoTo));
  55. }
  56. $colname_rsEditCHO = "-1";
  57. if (isset($_GET['recordID'])) {
  58. $colname_rsEditCHO = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']);
  59. }
  60. mysql_select_db($database_Directory, $Directory);
  61. $query_rsEditCHO = sprintf("SELECT * FROM cholist WHERE id = %s", GetSQLValueString($colname_rsEditCHO, "int"));
  62. $rsEditCHO = mysql_query($query_rsEditCHO, $Directory) or die(mysql_error());
  63. $row_rsEditCHO = mysql_fetch_assoc($rsEditCHO);
  64. $totalRows_rsEditCHO = mysql_num_rows($rsEditCHO);
  65. ?>
  66. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  67. <html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/adminTemplate.dwt.php" codeOutsideHTMLIsLocked="false" -->
  68. <head>
  69. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  70. <!-- InstanceBeginEditable name="doctitle" -->
  71. <title>CHO Page Manager</title>
  72. <!-- InstanceEndEditable -->
  73. <link href="../styles/mainStyle.css" rel="stylesheet" type="text/css" />
  74. <link href="../styles/table.css" rel="stylesheet" type="text/css" />
  75. <link href="../styles/navLeft.css" rel="stylesheet" type="text/css" />
  76. <!-- InstanceBeginEditable name="head" -->
  77. <script type="text/javascript">
  78. <!--
  79. function MM_goToURL() { //v3.0
  80. var i, args=MM_goToURL.arguments; document.MM_returnValue = false;
  81. for (i=0; i<(args.length-1); i+=2) eval(args[i]+".location='"+args[i+1]+"'");
  82. }
  83. //-->
  84. </script>
  85. <!-- InstanceEndEditable -->
  86. </head>
  87. <body>
  88. <div id="header"><?php require_once('../includefiles/userInfo.php'); ?></div>
  89. <div id="sidebar"><?php require_once('../includefiles/navPage.php'); ?></div>
  90. <div id="mainContent">
  91. <div id="mainText">
  92. <h2><!-- InstanceBeginEditable name="PageTitle" --><span class="pageHeadstate"><?php echo substr($row_rsStateInfo['position'],0,-4); ?> CHO List </span> <!-- InstanceEndEditable --></h2>
  93. <!-- InstanceBeginEditable name="PageContent" -->
  94. <div id="pageInformation">
  95. <input name="button" type="button" class="submitButton" id="button" onclick="MM_goToURL('parent','index.php');return document.MM_returnValue" value="Return to Menu" />
  96. </div>
  97. <div class="pageInformation">
  98. <p><form method="post" name="form1" action="<?php echo $editFormAction; ?>">
  99. <table border="0" align="left" cellpadding="5" cellspacing="0">
  100. <tr valign="baseline">
  101. <td nowrap align="right"><strong>Chief Housing Officer:</strong></td>
  102. <td><input type="text" name="Chief_Housing_Officer" value="<?php echo $row_rsEditCHO['Chief Housing Officer']; ?>" size="45"></td>
  103. </tr>
  104. <tr valign="baseline">
  105. <td nowrap align="right"><strong>Title:</strong></td>
  106. <td><input type="text" name="Title" value="<?php echo $row_rsEditCHO['Title']; ?>" size="45"></td>
  107. </tr>
  108. <tr valign="baseline">
  109. <td nowrap align="right"><strong>College:</strong></td>
  110. <td><input type="text" name="College" value="<?php echo $row_rsEditCHO['College']; ?>" size="45"></td>
  111. </tr>
  112. <tr valign="baseline">
  113. <td nowrap align="right"><strong>Email Address:</strong></td>
  114. <td><input type="text" name="Email_Address" value="<?php echo $row_rsEditCHO['Email Address']; ?>" size="32"></td>
  115. </tr>
  116. <tr valign="baseline">
  117. <td nowrap align="right"><strong>Location:</strong></td>
  118. <td><input type="text" name="Location" value="<?php echo $row_rsEditCHO['Location']; ?>" size="32"></td>
  119. </tr>
  120. <tr valign="baseline">
  121. <td nowrap align="right"><strong>Address 1:</strong></td>
  122. <td><input type="text" name="Mailing_Address" value="<?php echo $row_rsEditCHO['Mailing Address']; ?>" size="32"></td>
  123. </tr>
  124. <tr valign="baseline">
  125. <td nowrap align="right"><strong>Address 2:</strong></td>
  126. <td><input type="text" name="Address_2" value="<?php echo $row_rsEditCHO['Address 2']; ?>" size="32"></td>
  127. </tr>
  128. <tr valign="baseline">
  129. <td nowrap align="right"><strong>State:</strong></td>
  130. <td><select name="State" id="State">
  131. <option value="" selected="selected" <?php if (!(strcmp("", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Choose a State</option>
  132. <option value="AL" <?php if (!(strcmp("AL", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Alabama</option>
  133. <option value="AK" <?php if (!(strcmp("AK", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Alaska</option>
  134. <option value="AZ" <?php if (!(strcmp("AZ", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Arizona</option>
  135. <option value="AR" <?php if (!(strcmp("AR", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Arkansas</option>
  136. <option value="CA" <?php if (!(strcmp("CA", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>California</option>
  137. <option value="CO" <?php if (!(strcmp("CO", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Colorado</option>
  138. <option value="CT" <?php if (!(strcmp("CT", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Connecticut</option>
  139. <option value="DE" <?php if (!(strcmp("DE", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Delaware</option>
  140. <option value="DC" <?php if (!(strcmp("DC", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>District Of Columbia</option>
  141. <option value="FL" <?php if (!(strcmp("FL", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Florida</option>
  142. <option value="GA" <?php if (!(strcmp("GA", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Georgia</option>
  143. <option value="HI" <?php if (!(strcmp("HI", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Hawaii</option>
  144. <option value="ID" <?php if (!(strcmp("ID", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Idaho</option>
  145. <option value="IL" <?php if (!(strcmp("IL", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Illinois</option>
  146. <option value="IN" <?php if (!(strcmp("IN", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Indiana</option>
  147. <option value="IA" <?php if (!(strcmp("IA", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Iowa</option>
  148. <option value="KS" <?php if (!(strcmp("KS", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Kansas</option>
  149. <option value="KY" <?php if (!(strcmp("KY", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Kentucky</option>
  150. <option value="LA" <?php if (!(strcmp("LA", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Louisiana</option>
  151. <option value="ME" <?php if (!(strcmp("ME", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Maine</option>
  152. <option value="MD" <?php if (!(strcmp("MD", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Maryland</option>
  153. <option value="MA" <?php if (!(strcmp("MA", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Massachusetts</option>
  154. <option value="MI" <?php if (!(strcmp("MI", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Michigan</option>
  155. <option value="MN" <?php if (!(strcmp("MN", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Minnesota</option>
  156. <option value="MS" <?php if (!(strcmp("MS", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Mississippi</option>
  157. <option value="MO" <?php if (!(strcmp("MO", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Missouri</option>
  158. <option value="MT" <?php if (!(strcmp("MT", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Montana</option>
  159. <option value="NE" <?php if (!(strcmp("NE", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Nebraska</option>
  160. <option value="NV" <?php if (!(strcmp("NV", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Nevada</option>
  161. <option value="NH" <?php if (!(strcmp("NH", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>New Hampshire</option>
  162. <option value="NJ" <?php if (!(strcmp("NJ", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>New Jersey</option>
  163. <option value="NY" <?php if (!(strcmp("NY", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>New York</option>
  164. <option value="NC" <?php if (!(strcmp("NC", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>North Carolina</option>
  165. <option value="ND" <?php if (!(strcmp("ND", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>North Dakota</option>
  166. <option value="OH" <?php if (!(strcmp("OH", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Ohio</option>
  167. <option value="OK" <?php if (!(strcmp("OK", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Oklahoma</option>
  168. <option value="OR" <?php if (!(strcmp("OR", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Oregon</option>
  169. <option value="PA" <?php if (!(strcmp("PA", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Pennsylvania</option>
  170. <option value="OR" <?php if (!(strcmp("OR", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Oregon</option>
  171. <option value="RI" <?php if (!(strcmp("RI", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Rhode Island</option>
  172. <option value="SC" <?php if (!(strcmp("SC", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>South Carolina</option>
  173. <option value="SD" <?php if (!(strcmp("SD", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>South Dakota</option>
  174. <option value="TN" <?php if (!(strcmp("TN", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Tennessee</option>
  175. <option value="TX" <?php if (!(strcmp("TX", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Texas</option>
  176. <option value="UT" <?php if (!(strcmp("UT", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Utah</option>
  177. <option value="VT" <?php if (!(strcmp("VT", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Vermont</option>
  178. <option value="VA" <?php if (!(strcmp("VA", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Virginia</option>
  179. <option value="WA" <?php if (!(strcmp("WA", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Washington</option>
  180. <option value="WV" <?php if (!(strcmp("WV", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>West Virginia</option>
  181. <option value="WI" <?php if (!(strcmp("WI", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Wisconsin</option>
  182. <option value="WY" <?php if (!(strcmp("WY", $row_rsEditCHO['State']))) {echo "selected=\"selected\"";} ?>>Wyoming</option>
  183. </select></td>
  184. </tr>
  185. <tr valign="baseline">
  186. <td nowrap align="right"><strong>Phone:</strong></td>
  187. <td><input type="text" name="Phone" value="<?php echo $row_rsEditCHO['Phone']; ?>" size="32"></td>
  188. </tr>
  189. <tr valign="baseline">
  190. <td nowrap align="right">&nbsp;</td>
  191. <td><input type="submit" value="Update CHO"></td>
  192. </tr>
  193. </table>
  194. <input type="hidden" name="id" value="<?php echo $row_rsEditCHO['id']; ?>">
  195. <input type="hidden" name="MM_update" value="form1">
  196. <input type="hidden" name="id" value="<?php echo $row_rsEditCHO['id']; ?>">
  197. </form></p>
  198. <p class="cleartable"></p>
  199. </div>
  200. <p>&nbsp;</p>
  201. <!-- InstanceEndEditable --></div>
  202. </div>
  203. <div id="footer"><?php require_once('../includefiles/footer.php'); ?>
  204. </div>
  205. </body>
  206. <!-- InstanceEnd -->
  207. <p>&nbsp;</p>
  208. </html>
  209. <?php
  210. mysql_free_result($rsEditCHO);
  211. ?>