Ejemplo n.º 1
0
 public function saveMeta(Meta $meta)
 {
     $id = (int) $meta->getMetaid();
     $row = 0;
     if ($id > 0) {
         //var_dump($meta);
         //exit;
         $requete = $this->dbGateway->prepare("\r\n                UPDATE meta SET meta_key= :key, meta_value= :value WHERE meta_id = :id\r\n            ") or die(print_r($this->dbGateway->errors_info()));
         $requete->bindParam(':value', $meta->getMetavalue(), \PDO::PARAM_STR);
         $requete->bindParam(':key', $meta->getMetakey(), \PDO::PARAM_STR);
         $requete->bindParam(':id', $id, \PDO::PARAM_INT);
         $requete->execute();
         $row = $requete->rowCount();
     } else {
         $requete = $this->dbGateway->prepare("INSERT into meta(meta_key, meta_value, rubrique_id) \r\n\t\tvalues(:key, :value, :rubid)") or die(print_r($this->dbGateway->error_info()));
         $requete->execute(array('key' => $meta->getMetakey(), 'value' => $meta->getMetavalue(), 'rubid' => $meta->getRubriqueId()));
         $row = $this->dbGateway->lastInsertId();
     }
     return $row;
 }
Ejemplo n.º 2
0
 function updatemetaajaxAction()
 {
     $id = (int) $this->params()->fromRoute('id', 0);
     $meta = new Meta();
     $this->translator = $this->getServiceLocator()->get('translator');
     $this->metaDao = new MetaDao();
     $request = $this->getRequest();
     if ($request->isPost()) {
         $utils = new Utils();
         //$meta->setMetakey($request->getPost()->set('metakey', $utils->stripTags_replaceHtmlChar_trim($request->getPost('metakey'), true, true, true)));
         //$meta->setMetavalue($request->getPost()->set('metavalue', $utils->stripTags_replaceHtmlChar_trim($request->getPost('metavalue'), true, true, true)));
         $meta->setMetakey($utils->stripTags_replaceHtmlChar_trim($request->getPost('metakey'), true, true, true));
         $meta->setMetavalue($utils->stripTags_replaceHtmlChar_trim($request->getPost('metavalue'), true, true, true));
         $meta->setMetaid($id);
         $meta->setRubriqueid((int) $request->getPost('rubriqueid'));
         //get number of row inserted
         $row = $this->metaDao->saveMeta($meta);
         $result = array();
         if ($row == 0 || $row > 1) {
             $result['error'] = $this->translator->translate("Un problème est survenu, veuillez recommencer");
         } else {
             if ($row == 1) {
                 $result['result'] = "OK";
             }
         }
         return new JsonModel($result);
     }
 }