* JOIN [#i32c2190]
class GoodsPeer extends BaseGoodsPeer
{
public static function doSelectDetail($criteria, $con = null) {
parent::addSelectColumns($criteria);
$criteria->addSelectColumn(CategoryPeer::CATEGORY_NAME);
return GoodsPeer::populateDetailObjects(GoodsPeer::doSelectStmt($criteria, $con));
}
public static function populateDetailObjects($stmt) {
$results = array();
$class = GoodsPeer::getOMClass();
$class = Propel::importClass($class);
$classDetail = $class."Detail";
while($row = $stmt->fetch(PDO::FETCH_NUM)) {
$obj = new $classDetail();
$obj->hydrate($row);
}
return $obj;
}
}
$c = new Criteria();
$c->add(GoodsPeer::ID, 123);
$c->addJoin(GoodsPeer::CATEGORY_ID, CategoryPeer::ID, Criteria::INNER_JOIN);
$rows = GoodsPeer::doSelectDetail($c, $this->con);
** 参考 [#n8cd8a3f]
- http://www.centsys.jp/service/technical_information/symfony/detabase/20080214.html
- http://www.propelorm.org/wiki/Documentation/1.3/Upgrading
