Блог ant-а

<?php
 
class IndexController extends Zend_Controller_Action
{
 
    public function init()
    {
		$view = new Zend_View();
    }
 
    public function indexAction()
    {
 
        Zend_View_Helper_PaginationControl::setDefaultViewPartial('/pagination.phtml');
        $pages = new Application_Model_DbTable_Pages();
 
        $num = 10;
        $page = $this->_getParam('page');
 
        $select = $pages->select();
        $result = $this->view->table = $pages->fetchAll($select)->toArray();
        $paginator = new Zend_Paginator(new Zend_Paginator_Adapter_Array($result));
        $paginator->setItemCountPerPage($num);
        $paginator->setCurrentPageNumber($page);
        $paginator->setView($this->view);
        $this->view->paginator = $paginator;
 
    }
 
 
 
 
 
 
    public function addAction()
    {
        // action body
		$this->view->pageTitle = "Add";
		$this->view->pageKeywords = "keywords";
		$this->view->pageDescription = "description";
 
 
		$form = new Application_Form_Page();
		$form->submit->setLabel('Add');
		$this->view->form = $form;
 
 
		if ($this->getRequest()->isPost()) {
		$formData = $this->getRequest()->getPost();
		if ($form->isValid($formData)) {
		$artist = $form->getValue('artist');
		$title = $form->getValue('title');
		$creation_date = $form->getValue('creation_date');
		$pages = new Application_Model_DbTable_Pages();
		$pages->addPage($artist, $title,$creation_date);
		$this->_helper->redirector('index');
		} else {
		$form->populate($formData);
		}
		}
 
 
    }
 
    public function editAction()
    {
        // action body
 
			$this->view->pageTitle = "Edit";
 
			$form = new Application_Form_Page();
			$form->submit->setLabel('Save');
			$this->view->form = $form;
 
			if ($this->getRequest()->isPost()) {
				$formData = $this->getRequest()->getPost();
			if ($form->isValid($formData)) {
 
				$id = (int)$form->getValue('id');
				$artist = $form->getValue('artist');
				$title = $form->getValue('title');
		        $creation_date = $form->getValue('creation_date');
 
				$pages = new Application_Model_DbTable_Pages();
				$pages->updatePage($id, $artist, $title,$creation_date);
				$this->_helper->redirector('index');
			} else {
			$form->populate($formData);
			}
			} else {
			$id = $this->_getParam('id', 0);
			if ($id > 0) {
			$pages = new Application_Model_DbTable_Pages();
			$form->populate($pages->getPage($id));
			}
			}
 
 
 
    }
 
 
 
    public function deleteAction()
    {
 
		$this->view->pageTitle = "Delete";
 
 
		if ($this->getRequest()->isPost()) {
			$del = $this->getRequest()->getPost('del');
		if ($del == 'Yes') {
			$id = $this->getRequest()->getPost('id');
			$pages = new Application_Model_DbTable_Pages();
			$pages->deletePage($id);
		}
			$this->_helper->redirector('index');
		} else {
			$id = $this->_getParam('id', 0);
			$pages = new Application_Model_DbTable_Pages();
			$this->view->page = $pages->getPage($id);
		}
    }
}

<?php if ($this->pageCount) { ?>
<div class="paginationControl">
<?php if (isset($this->previous)) { ?>
    <a href="<?= $this->url(array('page' => $this->previous)); ?>">&lt;</a> |
<?php } else { ?>
    <span class="disabled">&lt;</span> |
<?php }
    foreach ($this->pagesInRange as $page) {
        if ($page != $this->current) { ?>
    <a href="<?= $this->url(array('page' => $page)); ?>"><?= $page; ?></a> |
<?php } else { ?>
<?= $page; ?> |
<?php }
}  if (isset($this->next)) { ?>
<a href="<?= $this->url(array('page' => $this->next)); ?>">
&gt;
</a>
<?php } else { ?>
<span class="disabled">&gt;</span>
<?php } ?>
</div>
<?php } ?>

<?php
 
class Application_Model_DbTable_Pages extends Zend_Db_Table_Abstract
{
 
    protected $_name = 'pages';
 
 
			public function getPage($id)
			{
                $id = (int)$id;
                $row = $this->fetchRow('id = ' . $id);
                if (!$row) {
                throw new Exception("Could not find row $id");
                }
 
    			return $row->toArray();
			}
 
			public function addPage($artist, $title, $creation_date)
			{
                $data = array(
                'artist' => $artist,
                'title' => $title,
                'creation_date' => $creation_date,
                );
    			$this->insert($data);
			}
 
			public function updatePage($id, $artist, $title,$creation_date)
			{
                $data = array(
                'artist' => $artist,
                'title' => $title,
                'creation_date' => $creation_date,
			);
			    $this->update($data, 'id = '. (int)$id);
			}
 
			public function deletePage($id)
			{
			    $this->delete('id =' . (int)$id);
			}
 
 
 
 
}

<?php
$this->title = "My pages";
$this->headTitle($this->title);
?>
<p><a href="<?= $this->url(array('controller'=>'index','action'=>'add'));?>">Add new page</a></p>
<table>
<tr>
<th>Title</th>
<th>Artist</th>
<th>Date</th>
<th>&nbsp;</th>
</tr>
 
<?php
    if (count($this->paginator)) { ?>
    <?php foreach ($this->paginator as $item) {?>
<tr>
        <td><?= $item['title']; ?></td>
        <td><?= $item['artist']; ?></td>
        <td><?= $item['creation_date']; ?></td>
        <td>
        <a href="<?= $this->baseUrl; ?>/index/edit/id/<?= $item['id'];?>">Edit</a>
        <a href="<?= $this->baseUrl; ?>/index/delete/id/<?= $item['id'];?>">Delete</a>
        </td>
</tr>
        <?php
        }
    }
    ?>
</table>
<?= $this->paginationControl($this->paginator); ?>