function resourcesToDb($resources, $template_id) { $resource_class = new Resources(); foreach ($resources as $resource) { $select = $resource_class->select()->where('name = ?', $resource)->where('template_id = ?', $template_id); $existing_resource = $resource_class->fetchAll($select); if (sizeof($existing_resource) == 0) { $row = $resource_class->createRow(); $row->name = $resource; $row->template_id = $template_id; $row->save(); } } }
function showResourceAction() { $id = (int) $this->_request->getParam('id'); $resource_class = new Resources(); $resource = $resource_class->fetchRow($resource_class->select()->where('id=' . $id)); $this->viewRenderer->setNoRender(); $this->_helper->layout->disableLayout(); $this->getResponse()->setHeader('Content-Type', $resource->file_type)->appendBody($resource->file_type); }