Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if (!empty($first_name) || !empty($password) || !empty($last_name) || !empty($email)) {
- $host = "localhost";
- $dbUsername = "root";
- $dbPassword = "";
- $dbname = "test1";
- //create connection
- $conn = new mysqli($host, $dbUsername, $dbPassword, $dbname);
- if (mysqli_connect_error()) {
- die('Connect Error('. mysqli_connect_errno().')'. mysqli_connect_error());
- } else {
- $hashed= hash('sha512', $password);
- $SELECT = "SELECT email From login Where email = ? Limit 1";
- $INSERT = "INSERT Into login (first, password, last, email) values(?, ?, ?, ?)";
- //Prepare statement
- $stmt = $conn->prepare($SELECT);
- $stmt->bind_param("s", $email);
- $stmt->execute();
- $stmt->bind_result($email);
- $stmt->store_result();
- $rnum = $stmt->num_rows;
- if ($rnum==0) {
- $stmt->close();
- $stmt = $conn->prepare($INSERT);
- $stmt->bind_param("ssss", $first_name, $hashed, $last_name, $email);
- $stmt->execute();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement