Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $email = $_POST['email'];
- $password = $_POST['password'];
- if (!empty($username) || !empty($password) || !empty($contact) || !empty($email)) {
- $host = "localhost";
- $dbUsername = "root";
- $dbPassword = "";
- $dbname = "test";
- //create connection
- $conn = new mysqli($host, $dbUsername, $dbPassword, $dbname);
- if (mysqli_connect_error()) {
- die('Connect Error('. mysqli_connect_errno().')'. mysqli_connect_error());
- } else {
- $SELECT = "SELECT email From login Where email = ? Limit 1";
- $INSERT = "INSERT Into login (email, password) 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("ss", $email, $password);
- $stmt->execute();
- echo "New record inserted sucessfully";
- } else {
- echo "Someone has already logged-in using this email";
- }
- $stmt->close();
Add Comment
Please, Sign In to add comment