Category Archives: Symfony

You need this just once: _ sudo apt-get install php-pear _ sudo pear channel-discover plugins.symfony-project.com For every package: _ Create the file package.xml and put it on the root of the plugin _ launch:      pear package To update the repository, … Continue reading →

/** * Returns an associative array with the details of the database connection * * @param string $application the name of a valid application (i.e.: frontend) – used to get a Propel connection * @param string $environment the environment we … Continue reading →

public static function getHydratedCriteria() { $criteria = new Criteria(); $criteria->addSelectColumn(‘*’); $criteria->setPrimaryTableName(self::TABLE_NAME); $criteria->addJoin(self::COMPANY_ID, CompanyPeer::ID, Criteria::INNER_JOIN); $criteria->addJoin(self::CITY_ID, CityPeer::ID, Criteria::INNER_JOIN); $criteria->addJoin(self::REGION_ID, RegionPeer::ID, Criteria::INNER_JOIN); return $criteria; }

In the actions.class.php, you need to override the method buildCriteria, adding the criteria you need

Propel: $c = new Criteria(); $cton1 = $c->getNewCriterion(AuthorPeer::FIRST_NAME, “Leo”); $cton2 = $c->getNewCriterion(AuthorPeer::LAST_NAME, array(“Tolstoy”, “Dostoevsky”, “Bakhtin”), Criteria::IN); $cton1->addOr($cton2); // add to Criteria $c->add($cton1); $authors = AuthorPeer::doSelect($c);

$c = new Criteria(); $c->addAsColumn(‘total_views’, ‘SUM(‘ . self::VIEWS . ‘)’); $c->addAsColumn(‘yearAndMonth’, ‘SUBSTR(‘ . self::TIME . ‘, 1, 7)’); $c->add(self::OFFER_ID, $offer->getId()); $c->addGroupByColumn(‘yearAndMonth’); $c->addDescendingOrderByColumn(‘yearAndMonth’); $viewsForMonths = array(); $stmt = BasePeer::doSelect($c); while($result = $stmt->fetch(PDO::FETCH_ASSOC)) { list($year, $month) = explode(‘-’, $result['yearAndMonth']); $monthString = date(‘F’, … Continue reading →

$sf_environment = sfConfig::get(’sf_environment’);

This is very good for integrating the header of a web site powered with Symfony in a WordPress blog. That is just an example require_once(dirname(__FILE__).’/../config/ProjectConfigurat ion.class.php’); $configuration = ProjectConfiguration::getApplicationConfiguration(‘frontend’ , ‘dev’, true); sfContext::createInstance($configuration); // Remove the following lines if you … Continue reading →