using doctrine 2.0 for the first time with zend framework..<\/p>\n
i am just adding one event and the function is as follows..<\/p>\n
public function suggesteventAction(){\n $form = new Application_Form_Events();\n $form->setAction($this->view->url(array('controller' => 'events', 'action' => 'suggestevent')));\n \/\/$form->area_of_interest_id->addMultiOptions($this->getInterestListAction());\n\n $this->view->form = $form;\n if($this->_request->isPost()){\n $formData = $this->getRequest()->getPost();\n\n if($form->isValid($formData)){\n $title = $form->getValue('title');\n $area_of_interest_id = $form->getValue('area_of_interest_id');\n $date_from = $form->getValue('date_from');\n $date_to = $form->getValue('date_to');\n $venue = $form->getValue('venue');\n $company_logo = $form->getValue('logo');\n $website = $form->getValue('website');\n $email = $form->getValue('email');\n $address = $form->getValue('address');\n $city = $form->getValue('city');\n $state = $form->getValue('state');\n $zip = $form->getValue('zip');\n $phone = $form->getValue('phone_number');\n $short_description = $form->getValue('short_description');\n $long_description = $form->getValue('long_description');\n\n $event = new Default_Model_Event;\n\n $event->setTitle($title);\n $event->setUser_id(1);\n $event->setArea_of_interest_id(1);\n $event->setDate_from($date_from);\n $event->setDate_to($date_to);\n $event->setVenue($venue);\n $event->setAddress($address);\n $event->setCity($city);\n $event->setState($state);\n $event->setZip($zip);\n $event->setCountry($country);\n $event->setCompany_logo($company_logo);\n $event->setWebsite($website);\n $event->setEmail($email);\n $event->setPhone_number($phone);\n $event->setStatus('pending');\n $event->setShort_description($short_description);\n $event->setLong_description($long_description);\n\n $this->_em->persist($event);\n $this->_em->flush();\n Zend_Debug::dump($this->_em);\n die;\n $this->view->alert = 'Record saved successfully';\n } else {\n $form->populate($formData);\n }\n } \n }\/\/end fucntion\n<\/code><\/pre>\nnow on flush i am getting error.. there is one table for user and area of interest so these two are foreign keys…<\/p>\n
\/**\n * @Entity\n * @Table(name=\"events\")\n *\/\nclass Default_Model_Event\n{\n \/**\n * @Id @Column(name=\"id\", type=\"integer\")\n * @GeneratedValue(strategy=\"AUTO\")\n *\/\n private $id;\n\n \/** \n * @Column(name=\"user_id\", type=\"integer\") \n *\/\n private $user_id;\n\n \/** \n * @Column(name=\"title\", type=\"string\") \n *\/\n private $title;\n\n \/** \n * @Column(name=\"area_of_interest_id\", type=\"integer\") \n *\/\n private $area_of_interest_id;\n\n \/** \n * @Column(name=\"date_from\", type=\"string\") \n *\/\n private $date_from;\n<\/code><\/pre>\nColumn not found: 1054 Unknown column ‘area_of_interest_id’ in ‘field list’<\/p>\n
in everything is fine but dont know data is not getting inserted..<\/p>\n
Originally posted 2013-11-09 23:10:47. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
using doctrine 2.0 for the first time with zend framework.. i am just adding one event and the function is as follows.. public function suggesteventAction(){ $form = new Application_Form_Events(); $form->setAction($this->view->url(array(‘controller’ => ‘events’, ‘action’ => ‘suggestevent’))); \/\/$form->area_of_interest_id->addMultiOptions($this->getInterestListAction()); $this->view->form = $form; if($this->_request->isPost()){ $formData = $this->getRequest()->getPost(); if($form->isValid($formData)){ $title = $form->getValue(‘title’); $area_of_interest_id = $form->getValue(‘area_of_interest_id’); $date_from = $form->getValue(‘date_from’); $date_to = […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,8],"tags":[],"class_list":["post-984","post","type-post","status-publish","format-standard","hentry","category-uncategorized","category-zend-framework"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/984","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=984"}],"version-history":[{"count":1,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/984\/revisions"}],"predecessor-version":[{"id":8915,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/984\/revisions\/8915"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=984"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=984"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=984"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}