Forum PHP.pl

[PHP] pobierz, plaintext 
<?php
games:
	id:		  ~
	title:	   varchar(255)
  categories:
	id:		  ~
	title:	   varchar(255)
  catgame:
	id:		  ~
	categories_id: ~
	games_id: ~
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$pager = new sfPropelPager('Games', 5);
		$c = new Criteria();
		$c->addDescendingOrderByColumn(GamesPeer::CREATED_AT);
		$c->add(CatgamePeer::CATEGORIES_ID, $this->getRequestParameter('id',1));
					   $c->addJoin(GamesPeer::ID,CatgamePeer::GAMES_ID, 'LEFT JOIN');
		$pager->setCriteria($c);
		$pager->setPage($this->getRequestParameter('page', 1));
		$pager->setPeerMethod('doSelect');
		$pager->init();
		$this->games_pager = $pager;
 
				foreach($this->games_pager->getResults() as $games) {
			     $catRefs = $games->getCatgamesJoinCategories();
			     $cat = null;
			      foreach($catRefs as $ref) {
				            $cat[] = $ref->getCategories(); 
			       }
			     $games->sth = $cat;
					}
 
		foreach($this->games_pager->getResults() as $games) {
						     print_r($games->sth);
					}
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
Notice: Undefined property: Games::$sth
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$pager = new sfPropelPager('Games', sfConfig::get('app_pager_homepage_max'));
		$c = new Criteria();
		$c->addDescendingOrderByColumn(GamesPeer::CREATED_AT);
		$c->add(CatgamePeer::CATEGORIES_ID, $this->getRequestParameter('id',1));
		$c->addJoin(GamesPeer::ID,CatgamePeer::GAMES_ID, 'LEFT JOIN');
		$pager->setCriteria($c);
		$pager->setPage($this->getRequestParameter('page', 1));
		$pager->setPeerMethod('doSelect');
		$pager->init();
		$this->games_pager = $pager;
 
		$games = $this->games_pager->getResults();
 
		foreach($games as $game) {
			$catRefs = $game->getCatgamesJoinCategories();
			$cats = null;
			foreach($catRefs as $ref) {
				$cats[] = $ref->getCategories(); 
			}
			$game->cats = $cats;
 
		}
		$this->games_list = $games;
?>
[PHP] pobierz, plaintext