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 -~----------~----~----~----~------~----~------~--~---