code_junkie

Zend Framework, run query without a view

Nov 14th, 2011
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. public function archiveNewsAction()
  2. {
  3.  
  4. //die(var_dump($this->_request->getParam('news_id')));
  5. $oNews = new news();
  6. $this->_request->getParam('news_id');
  7. $oNews->archiveNewsArticle($news_id);
  8. //die(var_dump($oNews));
  9. $this->_redirect('/admin/list-all');
  10. }
  11.  
  12. public function archiveNewsArticle($news_id)
  13. {
  14. //die($news_id);
  15. $db = Zend_Registry::get('db');
  16. $sql = "UPDATE $this->_name SET live = '0' WHERE news_id = '$news_id' LIMIT 1";
  17. die($sql);
  18. $query = $db->query($sql);
  19. $row = $query->fetch();
  20.  
  21. return $row;
  22. }
  23.  
  24. // Disable the main layout renderer
  25. $this->_helper->layout->disableLayout();
  26. // Do not even attempt to render a view
  27. $this->_helper->viewRenderer->setNoRender(true);
  28.  
  29. // code in your controller
  30. $this->_helper->viewRenderer->setNoRender(true);
  31. // the rest of the controller
  32.  
  33. $this->_redirect()
  34.  
  35. $this->_helper->viewRenderer->setNoRender();
  36.  
  37. $this->_helper->layout->disableLayout();
  38.  
  39. $this->_redirect();
Add Comment
Please, Sign In to add comment