Advertisement
Guest User

Untitled

a guest
Feb 14th, 2016
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.75 KB | None | 0 0
  1. public function storeUser($name, $surname, $email,$age, $sex, $status, $password)
  2. {
  3. try{
  4. $uuid = uniqid('', true);
  5.  
  6. $hash = $this->hashSSHA($password);
  7. $encrypted_password = $hash["encrypted"]; // encrypted password
  8. $salt = $hash["salt"]; // salt
  9. $stmt = $this->conn->prepare("INSERT INTO users(unique_id, name, surname, email, encrypted_password, age, sex, status, salt, created_at) VALUES(?,?,?,?,?,?,?,?,?,NOW())");
  10. $stmt->bind_param("sssssssss", $uuid, $name, $surname, $email, $encrypted_password, $age, $sex, $status, $salt);
  11. $result = $stmt->execute();
  12. $stmt->close();
  13.  
  14. // check for successful store
  15. if ($result)
  16. {
  17. $stmt = $this->conn->prepare("SELECT * FROM users WHERE email = ?");
  18. $stmt->bind_param("ssssssssssss", $row_user_id, $row_user_name, $row_surname, $row_user_email, $row_user_encryptedpass, $row_user_salt, $row_age, $row_sex, $row_status , $row_user_createdat, $row_user_uniqueid, $row_user_updatedat);
  19. $stmt->execute();
  20. $user = $stmt->get_result()->fetch_assoc();
  21.  
  22. $user = array(
  23. 'id' => $row_user_id,
  24. 'name' => $row_user_name,
  25. 'surname' => $row_surname,
  26. 'email' => $row_user_email,
  27. 'encrypted_password' => $row_user_encryptedpass,
  28. 'salt' => $row_user_salt,
  29. 'age' => $row_age,
  30. 'sex' => $row_sex,
  31. 'status' => $row_status,
  32. 'created_at'=>$row_user_createdat,
  33. 'unique_id' => $row_user_uniqueid,
  34. 'updated_at' => $row_user_updatedat,
  35. );
  36. $stmt->close();
  37. return $user;
  38. }
  39. else
  40. {
  41. return false;
  42. }
  43. }
  44. catch(Exception $e)
  45. {
  46. System.out.println("Exception : " + $e.getMessage());
  47. }
  48.  
  49. }//end of storeUser
  50.  
  51. /**
  52. * Get user by email and password
  53. */
  54. public function getUserByEmailAndPassword($email, $password)
  55. {
  56.  
  57. $stmt = $this->conn->prepare("SELECT * FROM users WHERE email = ?");
  58.  
  59. $stmt->bind_param("s", $email);
  60.  
  61. if ($stmt->execute())
  62. {
  63. $stmt->bind_result($row_user_id, $row_user_name, $row_surname, $row_user_email, $row_user_encryptedpass, $row_user_salt, $row_age, $row_sex, $row_status , $row_user_createdat, $row_user_uniqueid, $row_user_updatedat);
  64. $stmt->fetch();
  65.  
  66. $user = array(
  67. 'id' => $row_user_id,
  68. 'name' => $row_user_name,
  69. 'surname' => $row_surname,
  70. 'email' => $row_user_email,
  71. 'encrypted_password' => $row_user_encryptedpass,
  72. 'salt' => $row_user_salt,
  73. 'age' => $row_age,
  74. 'sex' => $row_sex,
  75. 'status' => $row_status,
  76. 'created_at'=>$row_user_createdat,
  77. 'unique_id' => $row_user_uniqueid,
  78. 'updated_at' => $row_user_updatedat,
  79. );
  80. $stmt->close();
  81. return $user;
  82. }
  83. else
  84. {
  85. return NULL;
  86. }
  87. }
  88.  
  89. require_once 'include/Functions-reg-log.php';
  90. $db = new DB_Functions();
  91.  
  92. // json response array
  93. try{
  94. $response = array("error" => FALSE);
  95. if (isset($_POST['first_name']) && isset($_POST['last_name']) && isset($_POST['email']) && isset($_POST['Age']) && isset($_POST['gender']) && isset($_POST['status']) && isset($_POST['password']) && isset($_POST['t_and_c']))
  96. {
  97.  
  98. // receiving the post params
  99. $name = $_POST['name'];
  100. $surname = $_POST['surname'];
  101. $email = $_POST['email'];
  102. $age = $_POST['age'];
  103. $sex = $_POST['sex'];
  104. $status = $_POST['status'];
  105. $password = $_POST['password'];
  106.  
  107.  
  108. // check if user is already existed with the same email
  109. if ($db->isUserExisted($email)) {
  110. // user already existed
  111. $response["error"] = TRUE;
  112. $response["error_msg"] = "User already existed with " . $email;
  113. echo json_encode($response);
  114. }
  115. else
  116. {
  117. // create a new user
  118. $user = $db->storeUser($name,$surname, $email, $age, $sex, $status, $password);
  119. if ($user) {
  120. // user stored successfully
  121. $response["error"] = FALSE;
  122. $response["uid"] = $user["unique_id"];
  123. $response["user"]["name"] = $user["name"];
  124. $response["user"]["surname"] = $user["surname"];
  125. $response["user"]["email"] = $user["email"];
  126. $response["user"]["age"] = $user["age"];
  127. $response["user"]["sex"] = $user["sex"];
  128. $response["user"]["status"] = $user["status"];
  129. $response["user"]["created_at"] = $user["created_at"];
  130. $response["user"]["updated_at"] = $user["updated_at"];
  131. echo json_encode($response);
  132. } else {
  133. // user failed to store
  134. $response["error"] = TRUE;
  135. $response["error_msg"] = "Unknown error occurred in registration!";
  136. echo json_encode($response);
  137. }
  138. }
  139. } else {
  140. $response["error"] = TRUE;
  141. $response["error_msg"] = "Required parameters is missing!";
  142. $response["name"] = $_Post["name"];
  143. echo json_encode($response);
  144. }
  145. }catch (Exception $e) {
  146. System.out.println("Exception : " + $e.getMessage());
  147. }
  148. ?>
  149.  
  150. <div class="row">
  151. <div class="col-xs-6 col-sm-6 col-md-6">
  152. <div class="form-group form-actions">
  153. <input type="text" name="first_name" id="first_name" class="form-control input-lg" placeholder="First Name" tabindex="1">
  154. </div>
  155. </div>
  156. <div class="col-xs-6 col-sm-6 col-md-6">
  157. <div class="form-group">
  158. <input type="text" name="last_name" id="last_name" class="form-control input-lg" placeholder="Last Name" tabindex="2">
  159. </div>
  160. </div>
  161. </div>
  162. <div class="form-group">
  163. <input type="email" name="email" id="email" class="form-control input-lg" placeholder="Email Address" tabindex="3">
  164. </div>
  165. <div class="form-group">
  166. <input type="age" name="Age" id="Age" class="form-control input-lg" placeholder="Age" tabindex="4" >
  167.  
  168. </div>
  169. <div class="col-xs-2 col-sm-2 col-md-2"> <span class="radio">
  170. <input type="radio" name="gender" id="male" class="o-hidden" value="1" tabindex="5" align="middle">Male
  171. </span> </div>
  172. <div class="col-xs-10 col-sm-10 col-md-10"> <span class="radio">
  173. <input type="radio" name="gender" id="female" class="o-hidden" value="0" tabindex="6" align="middle">Female
  174. </span> </div>
  175. <div class="col-xs-2 col-sm-2 col-md-2"> <span class="radio">
  176. <input type="radio" name="status" id="female" class="o-hidden" value="1" tabindex="7" >Enduser
  177. </span> </div>
  178. <div class="col-xs-3 col-sm-3 col-md-3"> <span class="radio">
  179. <input type="radio" name="status" id="female" class="o-hidden" value="0" tabindex="8" >Company
  180. </span> </div>
  181. <div class="col-xs-2 col-sm-2 col-md-2"> <span class="radio">
  182. <input type="radio" name="status" id="female" class="o-hidden" value="10" tabindex="9" >Both
  183. </span> </div>
  184. <div class="row">
  185. <div class="col-xs-6 col-sm-6 col-md-6">
  186. <div class="form-group">
  187. <input type="password" name="password" id="password" class="form-control input-lg" placeholder="Password" tabindex="10">
  188. </div>
  189. </div>
  190. <div class="col-xs-6 col-sm-6 col-md-6">
  191. <div class="form-group">
  192. <input type="password" name="password_confirmation" id="password_confirmation" class="form-control input-lg" placeholder="Confirm Password" tabindex="11">
  193. </div>
  194. </div>
  195. </div>
  196. <div class="row">
  197. <div class="col-xs-1 col-sm-1 col-md-1"> <span class="button-checkbox">
  198. <input type="checkbox" name="t_and_c" id="t_and_c" class="o-hidden" value="1" tabindex="12" >
  199. </span> </div>
  200. <div class="col-xs-11 col-sm-11 col-md-11">
  201. <p>By clicking <strong class="label label-primary">Register</strong>, you agree to the <a href="#" data-toggle="modal" data-target="#t_and_c_m">Terms and Conditions</a> set out by this site, including our Cookie Use.</p>
  202. </div>
  203. </div>
  204. <hr class="colorgraph">
  205. <div class="row">
  206. <div class="col-xs-6 col-md-6">
  207. <input type="submit" value="Register" class="btn btn-primary btn-block btn-lg" tabindex="13">
  208. </div>
  209. <div class="col-xs-6 col-md-6"><a href="#" class="btn btn-success btn-block btn-lg" tabindex="14" >Sign In</a></div>
  210. </div>
  211. </form>
  212. </div>
  213. </div>
  214.  
  215. {"error":true,"error_msg":"Unknown error occurred in registration!"}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement