Thanks a bunch djiize - I didn't know about serialize. The perfect
solution!
On Aug 21, 4:25 pm, djiize <[EMAIL PROTECTED]> wrote:
> complex way:
> create a table searches with fields for all conditions:
> id
> user_id
> bedrooms
> price
> area_id
> and its Model
>
> and save your condition:
> user_id = 2
> bedrooms = 3
> price = 'BETWEEN 500 AND 600'
> area_id = '000002,000003' // in string format, choose a separator
>
> and:
> // get user conditions from db
> $conditions = $this->Search->read(null, $search_id);
> // convert some fields, would be better in afterFind in Search Model
> $conditions['Search']['area_id'] = explode(',', $conditions['Search']
> ['area_id']); // to recover array from string
> // search properties with conditions
> $properties = $this->Property->findAll($conditions);
>
> I didn't tested this code, but you've the idea.
> Tell me if you have questions
>
> On 21 août, 17:12, djiize <[EMAIL PROTECTED]> wrote:
>
> > simple way:
> > you can serialize your conditions array in a new
> > fieldhttp://php.net/serialize
> > but beware of future DB modifications (field renaming, etc...)
>
> > On 21 août, 16:00, "[EMAIL PROTECTED]"
>
> > <[EMAIL PROTECTED]> wrote:
> > > I'm building a property site (trying anyway!)
>
> > > I've constructed my search $conditions from the data submitted in the
> > > search form - it gives me an array:
>
> > > Array ( [Letting] => Array ( [bedrooms] => 3 [price] => BETWEEN 500
> > > AND 600 [area_id] => Array ( [0] => 000002 [1] => 000003 ) ) )
>
> > > which in the SQL request gets converted by CAKE into:
>
> > > WHERE (`bedrooms` = 3) AND (`price` BETWEEN '500' AND '600') AND
> > > (`area_id` IN (000002, 000003) )
>
> > > but I want to offer the option for the user to save these search
> > > criteria so the site will email new property details to the user
> > > automagically.
>
> > > If I split the $conditions array apart I'll need to save four or more
> > > separate rows and build logic to reconstruct them when the time comes
> > > to check for new properties.
>
> > > Can I just grab the complete query (without running it) and cram it
> > > into a field?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
