URL parameter filters with where clauses
3 posts by 2 authors in: Forums > CMS Builder
Last Post: August 27, 2012 (RSS)
By InHouse - August 23, 2012
Hi,
Until recently I had a page which showed all the records for a given table. It also displayed a set of links which reloaded the same page but with parameters appented to the URL. i.e.:
Then these links were fired the page would reload and display only the records where the type was 'blue'.
But now I have to put a where clause on the page at all times. It's working to limit the display of the original records but it also seems to stop the in-url filtering from working.
Any ideas of why that is, and how I can work around it?
Cheers,
J.
Until recently I had a page which showed all the records for a given table. It also displayed a set of links which reloaded the same page but with parameters appented to the URL. i.e.:
mypage.php?type=blueThen these links were fired the page would reload and display only the records where the type was 'blue'.
But now I have to put a where clause on the page at all times. It's working to limit the display of the original records but it also seems to stop the in-url filtering from working.
Any ideas of why that is, and how I can work around it?
Cheers,
J.
Re: [InHouse] URL parameter filters with where clauses
By Jason - August 24, 2012
Hi,
If you already have a value in the 'where' option, whatever you put in the URL will be appended to that where clause.
One thing you could do is to check to see if there is a value for "type" in the URL. If there is, don't set a where clause.
For example:
You can then use $where in your where clause. If there's a value of type in the URL, $where will be blank, so just the automatic searching will occur.
Hope this helps
If you already have a value in the 'where' option, whatever you put in the URL will be appended to that where clause.
One thing you could do is to check to see if there is a value for "type" in the URL. If there is, don't set a where clause.
For example:
$where = "";
if (!@$_REQUEST['type']) {
$where = "put your where clause here";
}You can then use $where in your where clause. If there's a value of type in the URL, $where will be blank, so just the automatic searching will occur.
Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] URL parameter filters with where clauses
By InHouse - August 27, 2012
Many thanks Jason. That would seem to explain the change in behaviour. The solution you offer will work nicely I'm sure.
J.
J.