Advertisement
Guest User

Untitled

a guest
May 16th, 2019
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.98 KB | None | 0 0
  1. if (!empty($first_name) || !empty($password) || !empty($last_name) || !empty($email)) {
  2. $host = "localhost";
  3. $dbUsername = "root";
  4. $dbPassword = "";
  5. $dbname = "test1";
  6. //create connection
  7. $conn = new mysqli($host, $dbUsername, $dbPassword, $dbname);
  8. if (mysqli_connect_error()) {
  9. die('Connect Error('. mysqli_connect_errno().')'. mysqli_connect_error());
  10. } else {
  11. $hashed= hash('sha512', $password);
  12. $SELECT = "SELECT email From login Where email = ? Limit 1";
  13. $INSERT = "INSERT Into login (first, password, last, email) values(?, ?, ?, ?)";
  14. //Prepare statement
  15. $stmt = $conn->prepare($SELECT);
  16. $stmt->bind_param("s", $email);
  17. $stmt->execute();
  18. $stmt->bind_result($email);
  19. $stmt->store_result();
  20. $rnum = $stmt->num_rows;
  21. if ($rnum==0) {
  22. $stmt->close();
  23. $stmt = $conn->prepare($INSERT);
  24. $stmt->bind_param("ssss", $first_name, $hashed, $last_name, $email);
  25. $stmt->execute();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement