API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 19th, 2017
133
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.33 KB | None | 0 0
raw download clone embed print report
  1. <?php require_once('Connections/localhost.php'); ?>
  2. <?php
  3. if (!function_exists("GetSQLValueString")) {
  4. function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
  5. {
  6. if (PHP_VERSION < 6) {
  7. $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  8. }
  9.  
  10. $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
  11.  
  12. switch ($theType) {
  13. case "text":
  14. $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  15. break;
  16. case "long":
  17. case "int":
  18. $theValue = ($theValue != "") ? intval($theValue) : "NULL";
  19. break;
  20. case "double":
  21. $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
  22. break;
  23. case "date":
  24. $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  25. break;
  26. case "defined":
  27. $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
  28. break;
  29. }
  30. return $theValue;
  31. }
  32. }
  33.  
  34. // *** Redirect if username exists
  35. $MM_flag="MM_insert";
  36. if (isset($_POST[$MM_flag])) {
  37. $MM_dupKeyRedirect="Register.php";
  38. $loginUsername = $_POST['UserName2'];
  39. $LoginRS__query = sprintf("SELECT Username FROM `user` WHERE Username=%s", GetSQLValueString($loginUsername, "text"));
  40. mysql_select_db($database_localhost, $localhost);
  41. $LoginRS=mysql_query($LoginRS__query, $localhost) or die(mysql_error());
  42. $loginFoundUser = mysql_num_rows($LoginRS);
  43.  
  44. //if there is a row in the database, the username was found - can not add the requested username
  45. if($loginFoundUser){
  46. $MM_qsChar = "?";
  47. //append the username to the redirect page
  48. if (substr_count($MM_dupKeyRedirect,"?") >=1) $MM_qsChar = "&";
  49. $MM_dupKeyRedirect = $MM_dupKeyRedirect . $MM_qsChar ."requsername=".$loginUsername;
  50. header ("Location: $MM_dupKeyRedirect");
  51. exit;
  52. }
  53. }
  54.  
  55. $editFormAction = $_SERVER['PHP_SELF'];
  56. if (isset($_SERVER['QUERY_STRING'])) {
  57. $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
  58. }
  59.  
  60. if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "RegisterForm")) {
  61. $insertSQL = sprintf("INSERT INTO ``user`` (Fname, Lname, Email, Username, Password) VALUES (%s, %s, %s, %s, %s)",
  62. GetSQLValueString($_POST['FName'], "text"),
  63. GetSQLValueString($_POST['LName'], "text"),
  64. GetSQLValueString($_POST['Email'], "text"),
  65. GetSQLValueString($_POST['UserName2'], "text"),
  66. GetSQLValueString($_POST['Password'], "text"));
  67.  
  68. mysql_select_db($database_localhost, $localhost);
  69. $Result1 = mysql_query($insertSQL, $localhost) or die(mysql_error());
  70.  
  71. $insertGoTo = "Login.php";
  72. if (isset($_SERVER['QUERY_STRING'])) {
  73. $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
  74. $insertGoTo .= $_SERVER['QUERY_STRING'];
  75. }
  76. header(sprintf("Location: %s", $insertGoTo));
  77. }
  78.  
  79. mysql_select_db($database_localhost, $localhost);
  80. $query_Register = "SELECT * FROM `user`";
  81. $Register = mysql_query($query_Register, $localhost) or die(mysql_error());
  82. $row_Register = mysql_fetch_assoc($Register);
  83. $totalRows_Register = mysql_num_rows($Register);
  84. ?>
  85. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  86. <html xmlns="http://www.w3.org/1999/xhtml">
  87. <head>
  88. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  89. <title>Untitled Document</title>
  90. <script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script><script src="SpryAssets/SpryValidationConfirm.js" type="text/javascript"></script>
  91. <script src="SpryAssets/SpryValidationPassword.js" type="text/javascript"></script>
  92. <link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
  93. <link href="SpryAssets/SpryValidationConfirm.css" rel="stylesheet" type="text/css" />
  94. <link href="SpryAssets/SpryValidationPassword.css" rel="stylesheet" type="text/css" />
  95. </head>
  96. <link href="CSS/layout.css" rel="stylesheet" type="text/css" />
  97. <link href="CSS/menu.css" rel="stylesheet" type="text/css" />
  98. <body>
  99. <div id="Holder"></div>
  100. <div id="Header"></div>
  101. <div id="NavBar">
  102. <nav>
  103. <ul>
  104.  
  105. <li><a href="Login.php">Login</a></li>
  106. <li><a href="Register.php">Register</a></li>
  107. <li><a href="ForgotPassword.php">Forgot Password</a></li>
  108. </ul>
  109.  
  110.  
  111. </nav>
  112.  
  113. </div>
  114. <div id="Content"></div>
  115. <div id="ContentLeft">
  116. <h1>Sign Up!</h1>
  117. </div>
  118. <div id="ContentRight">
  119. <form id="RegisterForm" name="RegisterForm" method="POST" action="<?php echo $editFormAction; ?>">
  120. <table width="400" border="1" align="center">
  121. <tr>
  122. <td><table border="1">
  123. <tr>
  124. <td><h6><span id="sprytextfield1">
  125. <label for="FName"></label>
  126. <input type="text" name="FName" id="FName" />
  127. <br />
  128. First Name: </span></h6>
  129. <span><span class="textfieldRequiredMsg">A value is required.</span></span></td>
  130. <td><h6><span id="sprytextfield2">
  131. <label for="LName"></label>
  132. <input type="text" name="LName" id="LName" />
  133. <br />
  134. Last Name: </span></h6>
  135. <span><span class="textfieldRequiredMsg">A value is required. </span></span></td>
  136. </tr>
  137. </table></td>
  138. </tr>
  139. <tr>
  140. <td><h6 class="StyleTxtField">Email:
  141. <input name="Email" type="text" id="Email" />
  142. </h6></td>
  143. </tr>
  144. <tr>
  145. <td><span id="sprytextfield3">
  146. <label for="Email"></label>
  147. <span class="textfieldRequiredMsg">A value is required.</span><span class="textfieldInvalidFormatMsg">Invalid format.</span></span></td>
  148. </tr>
  149. <tr>
  150. <td><h6 class="StyleTxtField">UserName:
  151. <input name="UserName2" type="text" id="UserName2" />
  152. </h6></td>
  153. </tr>
  154. <tr>
  155. <td><span id="sprytextfield4">
  156. <label for="UserName"></label>
  157. <span class="textfieldRequiredMsg">A value is required.</span></span> </td>
  158. </tr>
  159. <tr>
  160. <td>&nbsp;</td>
  161. </tr>
  162. <tr>
  163. <td><table border="1">
  164. <tr>
  165. <td><h6 class="StyleTxtField">Password:<span id="sprypassword1">
  166. <label for="Password"></label>
  167. <input name="Password" type="password" class="StyleTxtField" id="Password" />
  168. <span class="passwordRequiredMsg">A value is required.</span></span></h6></td>
  169. <td><h6><span class="StyleTxtField" id="spryconfirm1">
  170. <label for="PasswordConfirm"></label>
  171. <br />
  172. Confirm Password:<br />
  173. <input name="PasswordConfirm" type="password" class="StyleTxtField" id="PasswordConfirm" />
  174. <br />
  175. <br />
  176. : </span></h6>
  177. <span><span class="confirmRequiredMsg">A value is required.</span><span class="confirmInvalidMsg">The values don't match.</span></span></td>
  178. </tr>
  179. </table></td>
  180. </tr>
  181. <tr>
  182. <td>&nbsp;</td>
  183. </tr>
  184. <tr>
  185. <td><input type="submit" name="RegisterButton" id="RegisterButton" value="Register" /></td>
  186. </tr>
  187. <tr>
  188. <td>&nbsp;</td>
  189. </tr>
  190. <tr>
  191. <td>&nbsp;</td>
  192. </tr>
  193. <tr>
  194. <td height="25"><table border="1">
  195. <tr> </tr>
  196. </table></td>
  197. </tr>
  198. <tr> </tr>
  199. <tr> </tr>
  200. <tr>
  201. <td height="24"><table border="1">
  202. <tr> </tr>
  203. </table></td>
  204. </tr>
  205. </table>
  206. <input type="hidden" name="MM_insert" value="RegisterForm" />
  207. </form>
  208. </div>
  209.  
  210.  
  211. <div id="Footer"></div>
  212. </div>
  213. <script type="text/javascript">
  214. var sprytextfield4 = new Spry.Widget.ValidationTextField("sprytextfield4");
  215. var sprytextfield3 = new Spry.Widget.ValidationTextField("sprytextfield3", "email");
  216. var sprytextfield1 = new Spry.Widget.ValidationTextField("sprytextfield1");
  217. var sprytextfield2 = new Spry.Widget.ValidationTextField("sprytextfield2");
  218. var spryconfirm1 = new Spry.Widget.ValidationConfirm("spryconfirm1", "Password");
  219. var sprypassword1 = new Spry.Widget.ValidationPassword("sprypassword1");
  220. </script>
  221. </body>
  222. </html>
  223. <?php
  224. mysql_free_result($Register);
  225. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!