I have followed the directions in this post: https://www.interactivetools.com/forum/forum-posts.php?postNum=2232462#post2232462

I have created a section editor for Documents where I can create a document and assign it to a particular Client and then using "Get Options From MySQL Query" I can then select which Facility (of that client) that this document is meant for. It works just like the Make, Model, Bike example described in that other post.

My Get Options From MySQL Query code reads as follows...

SELECT num, title FROM `<?php echo $TABLE_PREFIX ?>facilities` WHERE clientname = '<?php echo $ESCAPED_FILTER_VALUE ?>'

This setup works perfect when I am running on PHP 7.4 but when I switch to PHP 8.1 it fails.

The PHP 8.1 error message I see on the screen is...

Error: in_array(): Argument #2 ($haystack) must be of type array, string given
in /home1/XXXXX/public_html/cmsb/lib/menus/default/actionHandler.php on line 115.

Is there a fix I can use for this particular issue?

Cheers,

Dave

That worked perfectly!

Cheers,
Dave

When using PHP 8.0, when a user logs out of the website the following message appears...

<START>
Warning: Trying to access array offset on value of type bool in /home1/XXXXX/public_html/client-area.php on line 18 Fatal error: setPrefixedCookie: Can't set cookie(lastUrl, https://www.XXXXX.com/client-area.php), headers already sent! Output started in /home1/XXXXX/public_html/client-area.php line 18. in /home1/XXXXX/public_html/cmsb/lib/http_functions.php on line 292
<END>

The code on the top of the page is as follows:

<START>

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
// load viewer library
$libraryPath = 'cmsb/lib/viewer_functions.php';
$dirsToCheck = array('/home/eeltd3/public_html/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }
if (!@$GLOBALS['WEBSITE_MEMBERSHIP_PLUGIN']) { die("You must activate the Website Membership plugin before you can access this page."); }

// error checking
$errorsAndAlerts = alert();
if (@$CURRENT_USER) { $errorsAndAlerts .= "You are already logged in! <a href='https://www.XXXXXX.com/client-area.php'>Click here to continue</a> or <a href='?action=logoff'>Logoff</a>.<br/>\n"; }
if (!$CURRENT_USER && @$_REQUEST['loginRequired']) { $errorsAndAlerts .= "Please login to continue.<br/>\n"; }

// save url of referring page so we can redirect user there after login
// if (!getPrefixedCookie('lastUrl')) { setPrefixedCookie('lastUrl', @$_SERVER['HTTP_REFERER'] ); }

$CompName = $CURRENT_USER['fullname'];

// load records from 'documents'
list($documentsRecords, $documentsMetaData) = getRecords(array(
'tableName' => 'documents',
'loadUploads' => true,
'allowSearch' => false,
'where' => "title = '$CompName'",
));

?>
<?php if (!$CURRENT_USER) { websiteLogin_redirectToLogin(); } ?>

<END>

Hopefully that is enough to go on for you to help me fix this issue.

Thanks,
Dave