All right, or maybe I can use session (flash) ... ? 2009/2/9 Iltar <kja...@gmail.com>
> > Hey, > If I understand you correctly, you want to have the id like "3" > available in every part of your script? > > Try setting it as a config value: sfConfig::set('campaign_id', > $campaign->getId()); if I recall correctly. This is available > everywhere. Else I recommend either bridging to Zend Framework for a > registry, or build on yourself. > > On Feb 9, 11:52 am, Olivier Revollat <revol...@gmail.com> wrote: > > Hello ! > > On my application (e-commerce) I list the available products. For each > > products I call a filter that modify the product price according to > current > > price campaign (if any campaign is active) > > So for each products, I retrive the current campagne (SQL QUERY) : > > > > $query = sprintf("SELECT %s AS campagneid FROM %s WHERE NOW() BETWEEN %s > AND > > %s LIMIT 1", AmaCampagnePeer::ID, AmaCampagnePeer::TABLE_NAME, > > AmaCampagnePeer::DEBUT_VALIDITE, AmaCampagnePeer::FIN_VALIDITE); > > $statement = $connection->prepare($query); > > $statement->execute(); > > $campagneid = $statement->fetch(PDO::FETCH_OBJ); > > > > But as soon as I get the current's campagn ID this is not going to change > > during the current HTTP request ... so I don't have to execute this > request > > for each products... I want to use the same campagne ID for all the HTTP > > request and not recalculate it each time I filter a product (to retrive > the > > campagne price) ... some kind of singleton design pattern .. but I don't > > know exactly how to implement this (for example how do I know that I am I > > the same HTTP request ?) > > I don't know if i'm clear enougth ... :) > > > > Thanks for your help, ideas, suggestions !! > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---