It would also be nice to extend the filtering options so that better subsets of data could be returned:
Example:
Example filter for Mondays Lunch menu: “WeekDay=Monday,Menu=Lunch”. But technically you could have only 2 designs, one for breakfast and lunch. You could use the following filter: “WeekDay=DayName(Now()),Menu=Lunch”. Of course the proper quotation has to be done by the user.
$filterPair = explode('=', $filterPair);
//Current code
//$where .= sprintf(" AND %s = '%s' ", $filterPair[0], $db->escape_string($filterPair[1]));
//Possible change
$where .= sprintf(" AND %s = %s ", $filterPair[0], $filterPair[1]);
It would also be nice to extend the filtering options so that better subsets of data could be returned:
Example:
Example filter for Mondays Lunch menu: “WeekDay= Monday, Menu=Lunch” . But technically you could have only 2 designs, one for breakfast and lunch. You could use the following filter: “WeekDay= DayName( Now()), Menu=Lunch” . Of course the proper quotation has to be done by the user.
$filterPair = explode('=', $filterPair);
//Current code
//$where .= sprintf(" AND %s = '%s' ", $filterPair[0], $db->escape_ string( $filterPair[ 1]));
//Possible change
$where .= sprintf(" AND %s = %s ", $filterPair[0], $filterPair[1]);