StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
6828767
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-07-26T10:38:34.863
FavoriteCount
0
LastActivityDate
2011-07-26T10:38:34.863
LastEditDate
LastEditorUserId
0
OwnerUserId
850710
ParentId
6775362
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
I have tried to follow your ideas as much as possible, so all the calls for the Counties, Towns and Postcodes are in the GeolocationMapper and the saving of the Image Data is in the ImageMapper. You asked of how I create my Form right now, here an example from my init() of the Form for the Counties etc... <pre><code> // Create Dropdown for Counties $county = new Zend_Form_Element_Select('county'); $county->setLabel('Select a County') ->setRegisterInArrayValidator(false) ->setDecorators(array( 'ViewHelper', 'Errors', array('Description', array('tag' => 'p', 'class'=>'description')), 'Label', array('HtmlTag', array('tag'=>'li','class'=>'county')) )) ->setRequired(false); // Create Dropdown for Town $town = new Zend_Form_Element_Select('town'); $town->setRegisterInArrayValidator(false) ->setDecorators(array( 'ViewHelper', 'Errors', array('Description', array('tag' => 'p', 'class' => 'description')), 'Label', array('HtmlTag',array('tag'=>'li','class'=>'town')) )); // Create Dropdown for Postcode $postcode = new Zend_Form_Element_Select('postcode'); $postcode->setRegisterInArrayValidator(false) ->setDecorators(array( 'ViewHelper', 'Errors', array('Description', array('tag' => 'p', 'class' => 'description')), 'Label', array('HtmlTag',array('tag'=>'li','class'=>'postcode')) )) ->setRegisterInArrayValidator(false); </code></pre> In my Controller I than get the Elements and fill them: <pre><code>$geolocationMapper = new Application_Model_GeolocationMapper(); $CountyOptions = $geolocationMapper->createCountyDropdown(); $form->getElement('county')->setMultiOptions($CountyOptions); </code></pre> In my GeolocationMapper I have the Methods to build my Array of Counties: <pre><code>/** =========================================================================== * Get Counties * @param * @return Object? of Counties * ========================================================================= */ public function getCountyList() { $table = $this->getDbTable(); $select = $table->select()->distinct() ->from(array('p' => 'geolocation'),'county') ->order('county'); $resultSet = $this->getDbTable()->fetchAll($select); $entries = array(); foreach ($resultSet as $row) { $entry = new Application_Model_Geolocation(); $entry->setId($row->county) ->setCounty($row->county); $entries[] = $entry; } return $entries; } /** =========================================================================== * Create Array which will be used for Dropdown * @param * @return Array of Counties * ========================================================================= */ public function createCountyDropdown() { // List of Counties does not exist in Cache, read from DB if(!$CountyList = $this->getFromCache('counties')) { $CountyList = $this->getCountyList(); $Counties[''] = "Please choose"; foreach($CountyList as $value) { $Counties[str_replace(' ','_',$value->getCounty())] = $value->getCounty(); } $CountyDropdown = $Counties; // Save DB Result in Cache $this->addToCache ('counties',$CountyDropdown); return $CountyDropdown; }else{ return $this->getFromCache('counties'); } } </code></pre> The Counties I read in my GeolocationMapper. The Towns and Postcodes get read when you choose a County, which than calls via Ajax the Geolocation Mapper and than createTownDropdown($county) and when a Town is choosen the same procedure but an Ajax call for loadPostcodes() and there createPostcodeDropdown($town). Does this all sounds correct or any suggestions how I could improve this? I am sorry but I would really like to add another question since I can't find an answer anywhere... I also have an Image Upload which works via Ajax and jQuery. When you choose an Image to upload, the Image gets straight displayed. For this I create dynamically an input Element with an image src. I have not found ny other way to add Images otherwise to Zend Form. Is there a possibility to add an Image to display the image as a normal ? It would be just a lot easier to have a img, since I would like to use jQuery Drag and Drop. Thanks so much for your help so far !!!
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POZend Framework Structure for Datamapper, Controller and Model
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USLuka
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

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.