I am trying to pass my $_SESSION variables into a database query function for WordPress. If I define the $_SESSION variables within the function it works fine. But when I define them on a global level and try to pass them in, they do not pass through. Please view below for examples.
This will pass through to the function below
$_SESSION['pages'] = $_POST['pages'];
But when I add
$pages = $_SESSION['pages'];
$pages will not pass through to the function.
$_SESSION['pages'] = $_POST['pages']; //passes
$pages = $_SESSION['pages']; //does not pass
function insertLocalBusinessSchema()
{
//include global config
include_once($_SERVER['DOCUMENT_ROOT'].'/stage/wp-config.php' );
global $wpdb;
// if I try to define this outside of the function it doesn't pass through.
$pages = implode(',', $_SESSION['pages']);
$paymentAccepted = implode(',', $_SESSION['paymentAccepted']);
$table_name = $wpdb->prefix . "schemaLocalBusiness";
$insert = "UPDATE ".$table_name." SET addressLocality = '".$_SESSION['addressLocality']."', addressRegion = '".$_SESSION['addressRegion']."', postalCode = '".$_SESSION['postalCode']."', streetAddress = '".$_SESSION['streetAddress']."', pages = '".$pages."', paymentAccepted = '".$paymentAccepted."' WHERE id = 1";
$wpdb->query($insert);
}
Thank you for the help in advance!