StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
15718676
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
4
CommunityOwnedDate
CreationDate
2013-03-30T12:46:47.070
FavoriteCount
0
LastActivityDate
2013-03-31T09:51:29.410
LastEditDate
2013-03-31T09:51:29.410
LastEditorUserId
1053820
OwnerUserId
1053820
ParentId
15718188
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
Instead of using the form filter from the entity which you gathered from the table you should instantiate a new entity via the service manager to use the database adapter. You have a few options: <ol> <li>Move the input filter to its own class and instantiate via the service manager so your database adapter is injected.</li> <li>Change the prototype object in the table gateway factory to be instantiated via the service manager factory.</li> <li>Instantiate a separate entity via the service manager and get the input filter from there.</li> </ol> I personally would go for option 1 as it separates the code better. Some examples: Option 1 (my choice): This involves moving the filter to its own file and class, creating a factory for it whilst injecting the database adapter. We will then, in the controller, get the filter via the service manager and apply the filter to the form. So first move your filter to a file in ModName\src\ModName\Form\RegionFilter.php, obviosly replacing ModName with your module name. and change the code to like so: <pre class="lang-php prettyprint-override"><code><?php namespace Region\Form; use Zend\InputFilter\Factory as InputFactory; use Zend\InputFilter\InputFilter; use Zend\InputFilter\InputFilterAwareInterface; use Zend\InputFilter\InputFilterInterface; use Zend\Db\Adapter\Adapter; class RegionFilter implements InputFilterAwareInterface { /** * @var inputFilter */ protected $inputFilter; /** * @var Database Adapter */ protected $dbAdapter; /** * @param \Zend\InputFilter\InputFilterInterface $inputFilter * @throws \Exception */ public function setInputFilter(InputFilterInterface $inputFilter) { throw new \Exception("Not used"); } /** * @param \Zend\Db\Adapter $dbAdapter */ public function __construct(Adapter $dbAdapter) { $this->dbAdapter = $dbAdapter; } /** * * @return Zend\Db\Adapter */ public function getDbAdapter() { return $this->dbAdapter; } /** * @return \Zend\InputFilter\InputFilter * * Get the input filter (build it first) */ public function getInputFilter() { if (!$this->inputFilter) { $inputFilter = new InputFilter(); $factory = new InputFactory(); $inputFilter->add($factory->createInput(array( 'name' => 'name', 'required' => true, 'filters' => $this->_filters, 'validators' => array( array( 'name' => 'StringLength', 'options' => array( 'encoding' => 'UTF-8', 'min' => 1, 'max' => 30, ), ), array( 'name' => 'Db\NoRecordExists', 'options' => array( 'table' => $this->table, 'field' => 'name', //'exclude' => array( // 'field' => 'id', // 'value' => $this->id //), 'adapter' => $this->getDbAdapter(), ), ), ), ))); $this->inputFilter = $inputFilter; } return $this->inputFilter; } } ?> </code></pre> You would then create a factory like so in Module.php: <pre class="lang-php prettyprint-override"><code>public function getServiceConfig() { return array( 'factories' => array( 'ModName\Form\RegionFilter' => function($sm) { $dbAdapter = $sm->get('Zend\Db\Adapter\Adapter'); return new RegionFilter($dbAdapter); }, ), ); } </code></pre> And finally in your controller, just do the following: <pre class="lang-php prettyprint-override"><code>if ($request->isPost()) { $filter = $this->getServiceLocator()->get('ModName\Form\RegionFilter'); $form->setInputFilter($filter->getInputFilter()); $form->setData($request->getPost()); if ($form->isValid()) { $this->getRegionTable()->save($form->getData()); return $this->redirect()->toRoute('zfcadmin/regions'); } } </code></pre> Option 2: This involves constructing your table with an instance of <code>Region</code> injected. Then you can set the prototype to this. So in your table construct: <pre class="lang-php prettyprint-override"><code>public function __construct(Adapter $adapter, Region $region) { $this->adapter = $adapter; $this->resultSetPrototype = new ResultSet(); $this->resultSetPrototype->setArrayObjectPrototype($region); $this->initialize(); } </code></pre> And then your factory: <pre class="lang-php prettyprint-override"><code>public function getServiceConfig() { return array( 'invokables' => array( 'RegionModel' => 'FcLibraries\Model\Region', ), 'factories' => array( 'FcLibraries\Model\RegionTable' => function ($sm) { $region = $sm->get('RegionModel'); $dbAdapter = $sm->get('Zend\Db\Adapter\Adapter'); $table = new RegionTable($dbAdapter,$region); return $table; }, ), ); } </code></pre> You should be able to leave the rest of the code as is. Eg the controller. Now I have not tested this method so I'm not 100% it will work, but I think it should. The other two methods I have used previously myself. Option 3 (the simplest): This involves getting a separate region model via the service manager and using that to apply the input filter to the form. <pre class="lang-php prettyprint-override"><code>public function editAction() { $id = (int)$this->params()->fromRoute('id', 0); if (!$id) { return $this->redirect()->toRoute('zfcadmin/region', array( 'action' => 'add' )); } $data = $this->getRegionTable()->get($id); $form = new RegionForm(); $form->bind($data); $form->get('submitBtn')->setAttribute('value', 'Save'); $request = $this->getRequest(); if ($request->isPost()) { $region = $this->getServiceLocator()->get('RegionModel'); $form->setInputFilter($region->getInputFilter()); $form->setData($request->getPost()); if ($form->isValid()) { $this->getRegionTable()->save($form->getData()); return $this->redirect()->toRoute('zfcadmin/regions'); } } return array( 'id' => $id, 'form' => $form, ); } </code></pre> I have not tested the code but you should get the gist. Any questions just ask.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to set db adapter to Validator NoRecordExists and use it in controller?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USAydin Hassan
UserOwnerUserId
1. USAydin Hassan
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHow to set db adapter to Validator NoRecordExists and use it in controller?
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.