[Symfony]1.4 Propel pobieranie jednej kolumny z tabeli Opcje

[lDoran]

Trochę się naszukałem, popróbowałem jednak żaden ze sposobów przeze mnie znalezionych nie działa w SF 1.4.
http://gajdaw.pl/bd/propel-porady/print.html#R3

Domyślnie propel wyciąga wszystkie kolumny z tabeli, ale jest to mało optymalne.

[EDIT]

[PHP] pobierz, plaintext 
$oCriteria = new Criteria();
$oCriteria->clearSelectColumns();
$oCriteria->addSelectColumn(LmUsersGroupsPeer::NAME);
 
$rs	= LmUsersGroupsPeer::doSelect($oCriteria);
$this->groups = array();
 
while($rs->next()) {
    $tmp = array('imie' => $rs->get(1));
}
 
  $this->groups[] = $tmp;
[PHP] pobierz, plaintext 

Kod

Notice: Undefined offset: 1 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 630

Notice: Undefined offset: 2 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 631

Notice: Undefined offset: 3 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 632

Notice: Undefined offset: 4 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 633

Notice: Undefined offset: 5 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 634

Notice: Undefined offset: 6 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 635

Notice: Undefined offset: 7 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 636

Notice: Undefined offset: 8 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 637

Notice: Undefined offset: 9 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 638

Notice: Undefined offset: 10 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 639

Notice: Undefined offset: 11 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 640

Notice: Undefined offset: 12 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 641

Notice: Undefined offset: 1 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 630

Notice: Undefined offset: 2 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 631

Notice: Undefined offset: 3 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 632

Notice: Undefined offset: 4 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 633

Notice: Undefined offset: 5 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 634

Notice: Undefined offset: 6 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 635

Notice: Undefined offset: 7 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 636

Notice: Undefined offset: 8 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 637

Notice: Undefined offset: 9 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 638

Notice: Undefined offset: 10 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 639

Notice: Undefined offset: 11 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 640

Notice: Undefined offset: 12 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 641

Fatal error: Call to a member function next() on a non-object in C:\xampp\htdocs\phplivemessenger\apps\backend\modules\Users\actions\actions.class.php on line 32

Zmieniłem kod na:

[PHP] pobierz, plaintext 
  /* create new user */
  public function executeCreateUser() {
	$oGroups = new Criteria();
	$oGroups->clearSelectColumns();
	$oGroups->addSelectColumn(LmUsersGroupsPeer::NAME);
	$oGroups->addDescendingOrderByColumn(LmUsersGroupsPeer::NAME);			
	$this->groups = LmUsersGroupsPeer::doSelectStmt($oGroups); 
 
  }
[PHP] pobierz, plaintext 

template:

[PHP] pobierz, plaintext 
$groups = $sf_data->getRaw('groups');
$i = 0; 
foreach($groups->fetchAll() as $val) {
	echo $val[$i];
	$i++;
}
[PHP] pobierz, plaintext 

Problem polega na tym, że kod wyświetla tylko jeden rekord w bazie danych nie wiem za bardzo jak wczytać więcej rekordów.

[b][ROZWIĄZANIE][b]
Akcja:

[PHP] pobierz, plaintext 
  public function executeCreateUser() {
	$oGroups = new Criteria();
	$oGroups->clearSelectColumns();
	$oGroups->addSelectColumn(LmUsersGroupsPeer::NAME);
	$oGroups->addDescendingOrderByColumn(LmUsersGroupsPeer::NAME);
 
	$this->groups = array();
	$this->groups[] = LmUsersGroupsPeer::doSelectStmt($oGroups); 	
 
  }
[PHP] pobierz, plaintext 

Widok:

[PHP] pobierz, plaintext 
$groups = $sf_data->getRaw('groups');
$tmp = $groups[0]->fetchAll();
 
 
for($i = 0; $i < count($tmp); $i++) {
	echo $tmp[$i]['NAME'];
}
[PHP] pobierz, plaintext 

Ten post edytował lDoran 2.06.2011, 17:14:55