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']
P粉2421267862024-01-07 18:22:28
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