register.php

<?php


include 'connect.php';

if(isset($_POST["signup"])){
    $name=$_POST['pname'];
    $email=$_POST['email'];
    $password=$_POST['password'];
    $password=md5($password);

     $checkemail="SELECT * From users where email='$email'";
     $result=$conn->query($checkemail);
     if($result->num_rows>0){
        echo "<script>alert('Your email address is already Registered!'); window.location.href='login.html';</script>";
     }
     else{
        $insertQuery ="INSERT INTO `users`(fullname,email,password)
                        VALUES ('$name','$email','$password')";
            if($conn->query($insertQuery)==TRUE){
                echo "<script>alert('Registered!'); window.location.href='login.html';</script>";
            }
            else{
                echo "Error:".$conn->error;
            }
     }

}
if(isset($_POST['signin'])){
    $email=$_POST['email'];
    $password=$_POST['password'];
    $password=md5($password) ;

    $sql="SELECT * FROM users WHERE email='$email' and password='$password'";
    $result=$conn->query($sql);
    if($result->num_rows>0){
        session_start();
        $row=$result->fetch_assoc();
        $_SESSION['email']=$row['email'];
        header("Location: HomeL.php");
        exit();
    }
    else{
        echo "<script>alert('Incorrect email or password!'); window.location.href='login.html';</script>";

    }

}
?>