* @version 0.4.0, 2009-01-27 */ /** Zend_Db */ require_once 'Zend/Db.php'; /** Zend_Db_Table */ require_once 'Zend/Db/Table.php'; /** Setup database */ require_once 'db.inc.php'; // Create data source $departments = null; require_once 'departments.inc.php'; $createTables = ' CREATE TABLE departments ( Id INTEGER NOT NULL PRIMARY KEY, Name VARCHAR(100) ); '; $db->query($createTables); foreach ($departments as $department) { $db->insert('departments', (array) $department); } // DepartmentTable class class DepartmentTable extends Zend_Db_Table { protected $_name = 'departments'; // table name protected $_primary = 'Id'; } $departmentTable = new DepartmentTable(array('db' => $db)); $departmentTable->setRowClass('Department');