Trying to access array offset on value of type bool in PHP 7.4 [duplicate]

Question

I just upgraded my server's PHP version to PHP 7.4.1 and now getting this error:

Notice: Trying to access array offset on value of type bool in

public static function read($id)
{
    $Row = MySQL::query("SELECT `Data` FROM `cb_sessions` WHERE `SessionID` = '$id'", TRUE);
    
    # http://php.net/manual/en/function.session-start.php#120589
    //check to see if $session_data is null before returning (CRITICAL)
    if(is_null($Row['Data']))
    {
        $session_data = '';
    }
    else
    {
        $session_data = $Row['Data'];
    }
    
    return $session_data;
}

What is the fix for PHP 7.4 ?

if($Row['Data'] == false || is_null($Row['Data'])) fixed it but am wondering if this is the right fix. — anjanesh
– anjanesh, Commented Jan 10, 2020 at 2:58
Depends on what MySQL::query() returns when no results were found. — Triby
– Triby, Commented Jan 10, 2020 at 3:01
If no results are found then it returns false , if there is a result then it returns the first row as an assoc array, public static function query($sql, $returnRow = FALSE) - the 2nd parameter is TRUE in this case. — anjanesh
– anjanesh, Commented Jan 10, 2020 at 3:13
So, you should check if $Row is false first, only then try to access any other value. — Triby
– Triby, Commented Jan 10, 2020 at 3:15
Just a heads up, Collection from at least Laravel 5.4 - 5.8 are incompatible with PHP 7.4, and crashes with this error. — Henk Poley
– Henk Poley, Commented Mar 31, 2020 at 14:48

Dharman · Accepted Answer · 2020-08-16 00:24:16Z

87

Easy with PHP ?? null coalescing operator

return $Row['Data'] ?? 'default value';

Or you can use as such

$Row['Data'] ??= 'default value';
return $Row['Data'];

edited Aug 16, 2020 at 0:24

Dharman♦

34k27 gold badges106 silver badges158 bronze badges

answered Jan 10, 2020 at 19:19

dılo sürücü

4,2792 gold badges31 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

F. Müller Over a year ago

For PHP versions < 7 you can also use a ternary statement: $Row['data'] = isset($Row['data']) ? $Row['data'] : 'default';

Lisan E Over a year ago

Wow, It's working... $Row['data'] = isset($Row['data']) ? $Row['data'] : 'default';

raul dev br · Accepted Answer · 2020-01-10 18:45:19Z

13

If your query does not return a row, then your variable $Row will be filled with false, so you can test if the variable has a value before try to access any index inside it:

if($Row){
  if(is_null($Row['Data']))
  {
      $session_data = '';
  }...

answered Jan 10, 2020 at 18:45

raul dev br

1312 bronze badges

Collectives™ on Stack Overflow

Trying to access array offset on value of type bool in PHP 7.4 [duplicate]

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related