PHP - Fatal Error: Uncaught Error: Attempt to assign property on null and warning for reading property

Question

I'm coding in PHP and I'm getting some errors and it's also skipping my else statement

<?php
// put your code here


//    $select_query = "Select * from `user_table` where username='$user_username'";
//    $result = mysqli_query($con, $select_query);
    $sql = "Select * from `user_table` where username= ? "; // SQL with parameters
$stmt = $con->prepare($sql); 
$stmt->bind_param("s", $user_username);
$stmt->execute();
$result = $stmt->get_result();
$row_count = mysqli_num_rows($result);
$row_data = mysqli_fetch_assoc($result);
$user_ip = getIPAddress();


if ($_SESSION['attempt'] == 5) {
    $_SESSION['error'] = 'Attempt limit reach';
} else {
         
    if ($row_count > 0) {
        $_SESSION['username'] = $user_username; 
        $row = mysqli_fetch_object($result);
        if (password_verify($user_password, $row_data['user_password'])) {
                
             
//                if ($row_count == 1 and $row_count_cart == 0) {
//
//                    echo"<script>alert('Login Successfully')</script>";
//                    echo"<script>window.open('profile.php','_self')</script>";
//                } else {
//                    $_SESSION['username'] = $user_username;
//                    echo"<script>alert('Login Successfully')</script>";
//                    echo"<script>window.open('payment.php','_self')</script>";
//                }
                if ($row->is_tfa_enabled)
                {
                    $row->is_verified = false;
                    $_SESSION["username"] = $row;
 
                    $pin = rand(0, 9) . rand(0, 9) . rand(0, 9) . rand(0, 9) . rand(0, 9) . rand(0, 9);
                     
                    $sql = "UPDATE user_table SET pin = '$pin'  WHERE user_id = '" . $row->user_id . "'";
                    mysqli_query($con, $sql);
 

 
                    header("Location: enter_pin.php");
                } else {
                    $row->is_verified = true;
                    $_SESSION["username"] = $row;
 
                    header("Location: profile.php");
                }
            } else {
                
                echo"<script>alert('Invalid Credentials(Password Incorrect) " .$number ." attempt left  ') </script>";
              
                
              
                $_SESSION['error'] = 'Password incorrect  ';
                //this is where we put our 3 attempt limit
                $_SESSION['attempt'] += 1;
                //set the time to allow login if third attempt is reach
                if ($_SESSION['attempt'] == 5) {
                    $_SESSION['attempt_again'] = time() + (1 * 60);
                    //note 5*60 = 5mins, 60*60 = 1hr, to set to 2hrs change it to 2*60*60
                }
                 
            }
        } else {
            echo"<script>alert('Invalid Credentials')</script>";
        }
    }
}
?>

So when I run the code it shows 2 errors i.e.

1) Warning: Trying to read property "is_tfa_enabled" of null in C:xampphtdocsFinalYearProjectUsersuser_login.php on line 148

2) Fatal error: Uncaught Error: Trying to assign property 'is_verified' on null in C:xampphtdocsFinalYearProjectUsersuser_login.php:170 Stack trace: #0 {main} thrown in C:xampphtdocsFinalYearProjectUsersuser_login.php OK

Error 1 will be resolved when I change line 148 to $row_data['is_tfa_enabled']

Answer 1

The rows is_tfa_enabled and is_verified were not found in the table Also $row->is_verified = true; is not a valid commande. You cannot change column values ​​like this