PHP Pages::fetchRow方法代码示例

 function deleteAction()
 {
     $this->view->title = "Supprimer une page";
     // retrieve the ID of the parent page
     $PageID = $this->_getParam('ID');
     if (Cible_ACL::hasAccess($PageID)) {
         // generates tree by Language and send the result to the view
         Zend_Registry::set('baseUrl', $this->view->baseUrl());
         $this->view->TreeView = $this->view->getTreeView();
         if ($this->_request->isPost()) {
             //$PageID = (int)$this->_request->getPost('PageID');
             // if is set delete, then delete
             $delete = isset($_POST['delete']);
             if ($delete && $PageID > 0) {
                 Cible_FunctionsPages::deleteAllChildPage($PageID);
                 Cible_FunctionsPages::deleteAllBlock($PageID);
                 $pageSelect = new PagesIndex();
                 $select = $pageSelect->select()->where('PI_PageID = ?', $PageID);
                 $pageData = $pageSelect->fetchAll($select)->toArray();
                 foreach ($pageData as $page) {
                     $indexData['moduleID'] = 0;
                     $indexData['contentID'] = $PageID;
                     $indexData['languageID'] = $page['PI_LanguageID'];
                     $indexData['action'] = 'delete';
                     Cible_FunctionsIndexation::indexation($indexData);
                 }
                 $Page = new Pages();
                 $Where = 'P_ID = ' . $PageID;
                 $Page->delete($Where);
                 $PageIndex = new PagesIndex();
                 $Where = 'PI_PageID = ' . $PageID;
                 $PageIndex->delete($Where);
                 if (!$this->_request->isXmlHttpRequest()) {
                     $this->_redirect('/');
                 }
             } else {
                 if (!$this->_isXmlHttpRequest) {
                     $this->_redirect('/page/edit/ID/' . $PageID);
                 }
             }
         } else {
             if ($PageID > 0) {
                 $Page = new Pages();
                 $this->view->page = $Page->fetchRow('P_ID=' . $PageID);
                 $PageIndex = new PagesIndex();
                 $Select = $PageIndex->select()->where("PI_PageID = ?", $PageID)->where("PI_LanguageID = ?", $this->_defaultEditLanguage);
                 $this->view->pageindex = $PageIndex->fetchRow($Select);
             }
         }
     }
 }

 public static function getHomePageDetails()
 {
     $pagesSelect = new Pages();
     $select = $pagesSelect->select()->setIntegrityCheck(false)->from('Pages')->join('PagesIndex', 'PI_PageID = P_ID')->where('PI_LanguageID = ?', Zend_Registry::get('languageID'))->where('P_Home = 1');
     return $pagesSelect->fetchRow($select)->toArray();
 }

 function deleteAction()
 {
     $this->view->title = "Delete Pages";
     $pages = new Pages();
     if ($this->_request->isPost()) {
         Zend_Loader::loadClass('Zend_Filter_Alpha');
         $filter = new Zend_Filter_Alpha();
         $id = (int) $this->_request->getPost('id');
         $del = $filter->filter($this->_request->getPost('del'));
         if ($del == 'Yes' && $id > 0) {
             $where = 'id = ' . $id;
             $rows_affected = $pages->delete($where);
         }
     } else {
         $id = (int) $this->_request->getParam('id');
         if ($id > 0) {
             // only render if we have an id and can find the pages.
             $this->view->pages = $pages->fetchRow('id=' . $id);
             if ($this->view->pages->id > 0) {
                 // render template automatically
                 return;
             }
         }
     }
     // redirect back to the pages list unless we have rendered the view
     $this->_redirect('/admin');
 }

 public function deleteBlockAction()
 {
     // variables
     $_pageID = (int) $this->_getParam('ID');
     $_blockID = (int) $this->_getParam('blockID');
     if (Cible_ACL::hasAccess($_pageID)) {
         if ($this->_request->isPost()) {
             // if is set delete, then delete
             $delete = isset($_POST['delete']);
             if ($delete && $_blockID > 0) {
                 // never remove the news themselves
                 /* DELETE ROW IN BLOCK TABLE(S)   */
                 if (method_exists($this, 'delete')) {
                     $this->delete($_blockID);
                 }
                 $this->deleteBlock($_blockID);
                 if ($this->_isXmlHttpRequest) {
                     $this->disableView();
                     echo Zend_Json::encode(array('result' => true));
                     return;
                 }
             }
             $this->_redirect('/page/manage/index/ID/' . $_pageID);
         } else {
             if ($_pageID > 0) {
                 // get page information
                 $page = new Pages();
                 $this->view->page = $page->fetchRow('P_ID=' . $_pageID);
                 $pageIndex = new PagesIndex();
                 $select = $pageIndex->select()->where("PI_PageID = ?", $_pageID)->where("PI_LanguageID = ?", Zend_Registry::get("languageID"));
                 $this->view->pageIndex = $pageIndex->fetchRow($select);
                 // get block information
                 $blockIndex = new BlocksIndex();
                 $select = $blockIndex->select()->where('BI_BlockID = ?', $_blockID)->where('BI_LanguageID = ?', Zend_Registry::get("languageID"));
                 $this->view->blockIndex = $blockIndex->fetchRow($select);
             }
         }
     }
 }