API tools faq
paste
Advertisement
Rowenmicallef

register

Rowenmicallef
Jul 3rd, 2016
336
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.26 KB | None | 0 0
raw download clone embed print report
  1. <?php require_once('Connections/MaltaShopping.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['Username'];
  39. $LoginRS__query = sprintf("SELECT Username FROM `user` WHERE Username=%s", GetSQLValueString($loginUsername, "text"));
  40. mysql_select_db($database_MaltaShopping, $MaltaShopping);
  41. $LoginRS=mysql_query($LoginRS__query, $MaltaShopping) 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`` (FirstName, LastName, Email, Username, Password) VALUES (%s, %s, %s, %s, %s)",
  62. GetSQLValueString($_POST['FirstName'], "text"),
  63. GetSQLValueString($_POST['LastName'], "text"),
  64. GetSQLValueString($_POST['Email'], "text"),
  65. GetSQLValueString($_POST['Username'], "text"),
  66. GetSQLValueString($_POST['Password'], "text"));
  67.  
  68. mysql_select_db($database_MaltaShopping, $MaltaShopping);
  69. $Result1 = mysql_query($insertSQL, $MaltaShopping) 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_MaltaShopping, $MaltaShopping);
  80. $query_Register = "SELECT * FROM `user`";
  81. $Register = mysql_query($query_Register, $MaltaShopping) or die(mysql_error());
  82. $row_Register = mysql_fetch_assoc($Register);
  83. $totalRows_Register = mysql_num_rows($Register);
  84. $query_Register = "SELECT * FROM `user`";
  85. $Register = mysql_query($query_Register, $MaltaShopping) or die(mysql_error());
  86. $row_Register = mysql_fetch_assoc($Register);
  87. $totalRows_Register = mysql_num_rows($Register);
  88. ?>
  89. <!DOCTYPE html>
  90. <html>
  91.  
  92. <head>
  93. <link href="CSS/Layout.CSS" rel="stylesheet" type="text/css" />
  94. <link href="CSS/Menu.CSS" rel="stylesheet" type="text/css" />
  95. <link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css">
  96. <link href="SpryAssets/SpryValidationPassword.css" rel="stylesheet" type="text/css">
  97. <link href="SpryAssets/SpryValidationConfirm.css" rel="stylesheet" type="text/css">
  98. <title>Template</title>
  99. <script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
  100. <script src="SpryAssets/SpryValidationPassword.js" type="text/javascript"></script>
  101. <script src="SpryAssets/SpryValidationConfirm.js" type="text/javascript"></script>
  102. </head>
  103.  
  104. <body>
  105. <div id="Holder">
  106. <div id="Header"></div>
  107. <div id="NavBar">
  108. <nav>
  109. <ul>
  110. <li><a href="#">Login</a></li>
  111. <li><a href="#">Register</a></li>
  112. <li><a href="#">Forgot Passord</a></li>
  113. </ul>
  114. </nav>
  115. </div>
  116. <div id="Content">
  117. <div id="PageHeading">
  118. <h1>Register</h1>
  119. </div>
  120. <div id="ContentLeft">
  121. <h2>Lorum Ipsum</h2>
  122. </div>
  123. <div id="ContentRight">
  124. <form action="<?php echo $editFormAction; ?>" method="POST" name="Register" id="Register">
  125. <table width="400" border="0" id="bleh">
  126. <tr>
  127. <td><table border="0">
  128. <tr>
  129. <td><h6><span id="sprytextfield1">
  130. <label for="FirstName"></label>
  131. First Name:<br>
  132. <br>
  133. <input name="FirstName" type="text" class="styleTxtField" id="FirstName">
  134. </span></h6>
  135. <span><span class="textfieldRequiredMsg">A value is required.</span></span></td>
  136. <td><h6><span id="sprytextfield2">
  137. <label for="LastName"></label>
  138. Last Name:<br>
  139. <br>
  140. <input name="LastName" type="text" class="styleTxtField" id="LastName">
  141. </span></h6>
  142. <span><span class="textfieldRequiredMsg">A value is required.</span></span></td>
  143. </tr>
  144. </table></td>
  145. </tr>
  146. <tr>
  147. <td>&nbsp;</td>
  148. </tr>
  149. <tr>
  150. <td><h6><span id="sprytextfield3">
  151. <label for="Email"></label>
  152. Email:<br>
  153. <br>
  154. <input name="Email" type="text" class="styleTxtField" id="Email">
  155. </span></h6>
  156. <span><span class="textfieldRequiredMsg">A value is required.</span><span class="textfieldInvalidFormatMsg">Invalid format.</span></span></td>
  157. </tr>
  158. <tr>
  159. <td>&nbsp;</td>
  160. </tr>
  161. <tr>
  162. <td><h6><span id="sprytextfield4">
  163. <label for="Username"></label>
  164. Username:<br>
  165. <br>
  166. <input name="Username" type="text" class="styleTxtField" id="Username">
  167. </span></h6>
  168. <span><span class="textfieldRequiredMsg">A value is required.</span></span></td>
  169. </tr>
  170. <tr>
  171. <td>&nbsp;</td>
  172. </tr>
  173. <tr>
  174. <td><table border="0">
  175. <tr>
  176. <td><h6><span id="sprypassword1">
  177. <label for="Password"></label>
  178. Password:<br>
  179. <br>
  180. <input name="Password" type="password" class="styleTxtField" id="Password">
  181. </span></h6>
  182. <span><span class="passwordRequiredMsg">A value is required.</span></span></td>
  183. <td><h6><span id="spryconfirm1">
  184. <label for="PasswordConfirm"></label>
  185. Confirm Password:<br>
  186. <br>
  187. <input name="PasswordConfirm" type="password" class="styleTxtField" id="PasswordConfirm">
  188. </span></h6>
  189. <span><span class="confirmRequiredMsg">A value is required.</span><span class="confirmInvalidMsg">The values don't match.</span></span></td>
  190. </tr>
  191. </table></td>
  192. </tr>
  193. <tr>
  194. <td>&nbsp;</td>
  195. </tr>
  196. <tr>
  197. <td><input type="submit" name="RegisterButton" id="RegisterButton" value="Register"></td>
  198. </tr>
  199. <tr>
  200. <td>&nbsp;</td>
  201. </tr>
  202. <tr>
  203. <td>&nbsp;</td>
  204. </tr>
  205. </table>
  206. <input type="hidden" name="MM_insert" value="RegisterForm">
  207. </form>
  208. </div>
  209. </div>
  210. <div id="Footer"></div>
  211. </div>
  212. <script type="text/javascript">
  213. var sprytextfield1 = new Spry.Widget.ValidationTextField("sprytextfield1");
  214. var sprytextfield2 = new Spry.Widget.ValidationTextField("sprytextfield2");
  215. var sprytextfield3 = new Spry.Widget.ValidationTextField("sprytextfield3", "email");
  216. var sprytextfield4 = new Spry.Widget.ValidationTextField("sprytextfield4");
  217. var sprypassword1 = new Spry.Widget.ValidationPassword("sprypassword1");
  218. var spryconfirm1 = new Spry.Widget.ValidationConfirm("spryconfirm1", "Password");
  219. </script>
  220. </body>
  221.  
  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!