checklogin.php

<html>

<?php

	$u = $_POST["email"];
    $p = $_POST["passward"];
    //echo "email is : $u"."<br>";
    //echo "password is: $p"."<br>";

    $user = "root";
    $pass = "";
    $db = "online_auction_system";
    
    $db_connect = mysqli_connect('localhost',$user,$pass,$db) or die('no database found');
    
    //echo 'connection successful'."<br>";
        
    $qry = "SELECT user_ID FROM userinfo WHERE Email = '$u' and Passward = '$p'";

    $res = mysqli_query($db_connect, $qry);
    $row = mysqli_num_rows($res);
    if($row >= 1){
        echo 'login successful'."<br>";
		header("Location: startpage.php");
    }
    else{
        echo 'you must signup first'."<br>";
		echo '<form method = "post" action = "login.php"><button type = "submit">Log In Again</button></form>';
    }

?>



</html>