Welcome, Guest. Register Now!
08-18-2007, 02:16 PM
|
|||
|
|||
how to join tables?
hi,
im trying to learn zend framework a bit, because next work i will start working on big project based on zend framework. i have created these tables: Code:
employee: idemployee, name, age Code:
project: idproject, info, responsible_employee_id i managed to create models and reference map: Code:
class Employee extends Zend_Db_Table_Abstract {
protected $_name = "employee";
protected $_primary = "idemployee";
protected $_dependentTables = array("Projects");
}
class Project extends Zend_Db_Table_Abstract {
protected $_name = "project";
protected $_primary = "idproject";
protected $_referenceMap = array(
'ResponsibleEmployee' => array(
'columns' => 'responsible_employee_id',
'refTableClass' => 'Employee',
'refColumns' => 'idemployee'
)
);
}
id like to select all projects, but i don't want to select responsible_employee_id, but his name (classic join) i don't feel like being able to use referenceMap (which can be really hard work to create on big project) to automatically join these tables. It wouldn't be so bad, if i could just add JOIN to fetchAll... look: Code:
(class Projects - model)
public function listing(){
return $this->fetchAll()->toArray(); // I WANT TO ADD [JOIN] RIGHT HERE!
}
Code:
$sql = $this->getAdapter()->select()->from("project")->join("employee", "project.responsible_employee = employee.idemployee", array("responsible_employee" => "name"));
return $this->getAdapter()->query($sql)->fetchAll();
zero0x     
|
 |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
