Warning error: Trying to access array offset on value of type null php 7.4

Question

Hola buenos días estoy teniendo problemas con la version 7.4 en esta consulta que realizo

$consult = $mysqli->query("SELECT name FROM status WHERE id = '$oldstatus' ");
$register = $consult->fetch_assoc();
$oldstatus = $register['name'];

Ervin Santos · Answer

Buen día, para evitar este tipo de error, tiene que agregar una condición de isset para validar que exista la variable.
$consult = $mysqli->query("SELECT name FROM status WHERE id = '$oldstatus' ");
$register = $consult->fetch_assoc();
if(isset($register['name'])){
    $oldstatus = $register['name'];
}

Warning error: Trying to access array offset on value of type null php 7.4

One Answer

Add your own answers!

Ask a Question