Untitled


<?php
        $username = $_POST['username'];
        $password = $_POST['password'];
        $con = mysqli_connect('localhost','root','1234','sample');
        $result = mysqli_query($con, "SELECT * FROM `users` WHERE username='$username' AND password='$password'");

        if(mysqli_num_rows($result) == 0){
            echo 'Invalid username or password';}
        else {
            echo "<br><h1>Logged in</h1><p>This is text that should only be displayed when logged in with valid credentials.</p>";

            $result2 = mysqli_query($con,"SELECT * FROM books WHERE email='$username'");

            $row = mysqli_fetch_array($result2,MYSQLI_ASSOC);


            $bk = $row['bname'];

            echo "<html><body bgcolor='green'><br><br>Login successful for user: ".$username."<br>your Book assigned is=".$bk."</body></html>";
           }


?>