Here is my issue: I want only one session to run at a time. Consider the following query:
$get_crs_mysqli .= (!empty($_SESSION['userSearch']))?(" AND (course_title like '%".$_SESSION['userSearch']."%') OR (course_title like '%" . $_SESSION['userCategory'] . "%') ") : '';
and
//getting the providers
function getProviders(){
if(isset($_GET['user_query']))
{
$search_query = $_GET['user_query'];
global $con;
$get_providers = "select DISTINCT course_provider from courses where (course_title like '%$search_query%' ) AND course_date1 >= CURRENT_DATE() LIMIT 5";
$run_providers = mysqli_query($con, $get_providers);
while ($row_providers=mysqli_fetch_array($run_providers)){
$provider_title = $row_providers['course_provider'];
$numberIncrease = 0;
echo '<a href="" id="liSpacing"><label id="labelSearch"><input class="filter" name="provider' . ++$numberIncrease . '" type="checkbox" value="' . $provider_title . '"> ' . $provider_title . '</label></a> <br />';
}
}
else if(isset( $_GET['crs_category']))
{
$search_query2 = $_GET['crs_category'];
global $con;
$get_providers = "select DISTINCT course_provider from courses where (course_title like '%$search_query2%' ) AND course_date1 >= CURRENT_DATE() LIMIT 5";
$run_providers = mysqli_query($con, $get_providers);
while ($row_providers=mysqli_fetch_array($run_providers)){
$provider_title = $row_providers['course_provider'];
$numberIncrease = 0;
}
}
}
Below is the section that deals with session variables:
<?php
if(isset($_GET['user_query']))
{
$search_query = $_GET['user_query'];
$_SESSION['userSearch'] = $search_query;
$paginationresults = mysqli_query($con,"SELECT COUNT(*) FROM courses where course_title like '%$search_query%' AND course_date1 >= CURRENT_DATE() ORDER BY course_date1 ASC");
$get_total_rows = mysqli_fetch_array($paginationresults); //total records
$item_per_page = 10;
//break total records into pages
$pages = ceil($get_total_rows[0]/$item_per_page);
}
if(isset($_GET['crs_category']))
{
$search_query_category = $_GET['crs_category'];
$_SESSION['userCategory'] = $search_query_category;
$paginationresults = mysqli_query($con,"SELECT COUNT(*) FROM courses where course_title like '%$search_query_category%' AND course_date1 >= CURRENT_DATE() ORDER BY course_date1 ASC");
$get_total_rows = mysqli_fetch_array($paginationresults); //total records
$item_per_page = 10;
//break total records into pages
$pages = ceil($get_total_rows[0]/$item_per_page);
}
?>
The challenge arises when trying to have two sessions running simultaneously, causing conflicts and errors. I need to modify it so that only one active session is accessed. For example, if a user searches for a category, the URL appears as searchPage.php?crs_category, and if they look for a specific item, it shows as searchPage.php?user_query=html. The problem occurs because the previous session remains active and interferes with the search results.
I hope this explanation is clear. Please let me know if you need further clarification.