I was checking out the book on complex queries and not really finding what
I'm looking for.
I'm trying to create a query that covers both a basic and advanced search.
The form may be submitting all or just some of the options available on the
page depending on what the user chooses.
Once the form has been submitted clicking any one of the query results would
navigate the user away from the 'results page'.
To avoid getting hit with the "form submission" dialogue when the users
clicks the back button to return to the search results page
and to cover the 'conditional query' ... I used to use a combo of $_GET and
if(isset.
ie:
$query= " SELECT something FROM somewhere WHERE etc. etc. etc. AND ";
if (isset($_GET['some_value']) && $_GET['some_value'] != '' )
{
$value = $_GET['some_value'];
$query .= "AND something = '".addslashes($value)."'";
}
And so on.
I'm not familiar with using cache for anything. To avoid using get and the
ugly urls would I be able to use post and cache the results also avoiding
the "form submission" dialogue when returning to the results page?
Also, what is the best approach to setting up a 'conditional' query similar
to what I posted above?
I'll spend some more time digging through the book and experimenting if
someone can point me in the right direction.
Thanks,
- Ed
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
