"how can this be done with the same result using mysqli?" Code Answer

the function mysqli_fetch_field_direct returns an object, where as mysql_field_flags retuns a string. hence your direct use of strpos won't work.

if($field_flags == false) {
    for($j=0; $j<$num_fields; $j++) {
        $field_flags[$j] = mysqli_fetch_field_direct($result, $j);
        if(strpos($field_flags[$j]->flags, 'not_null') !== false) {
           //do something here
        } else {
           //do something else
    }
}

more here on php.net

By volkovik on September 10 2022