pagination through Zend Paginator giving error

Question

i am using zend paginator for pagination in my app here is the action that is doing so

public function listAction(){
      $registry = Zend_Registry::getInstance();  
      $DB = $registry['DB'];
      $sql = "SELECT * FROM `task` ORDER BY task_name ASC";
      $result = $DB->fetchAll($sql);
      $page=$this->_getParam('page',1);
      $paginator = Zend_Paginator::factory($result);
      $paginator->setItemCountPerPage(3);
      $paginator->setCurrentPageNumber($page);
      $this->view->paginator=$paginator;
  }

and this is the view for this action

 <table border="1" align="center">
<tr>
  <th>Task Name</th>      
  <th>Task Assign To</th>  
  <th>Action</th>     
</tr>
   <?php
    foreach($this->paginator as $record){ ?>
    <tr> 
   <td><?php echo $record['task_name']?></td>
  <td><?php echo $record['task_assign']?></td>  

  <td>
    <a href="edit/id/<?php echo $record['id']?>">Edit</a>
    |
    <a href="del/id/<?php echo $record['id']?>">Delete</a>      
  </td>   
</tr> 
   <?php } ?>
  </table>
   <?php echo $this->paginationControl($this->paginator, 'Sliding', 'pagination.phtml'); ?>

by doing so it giving me this error

Fatal error: Cannot use object of type stdClass as array in C:\xampp\htdocs\zend_login\application\views\scripts\task\list.phtml on line 47

line 47 refers to

 <td><?php echo $record['task_name']?></td>

than i used this function to convert object to array

function objectToArray( $object ){
 if( !is_object( $object ) && !is_array( $object ) ){
  return $object;}
 if( is_object( $object ) ){
 $object = get_object_vars( $object );}
return array_map( 'objectToArray', $object );}
$paginator = objectToArray($this->paginator);

now i change this in my code

foreach($paginator as $record){

and also this

   <?php echo $this->paginationControl($paginator, 'Sliding', 'pagination.phtml'); ?>

but its giving me this error now

 Catchable fatal error: Argument 1 passed to Zend_View_Helper_PaginationControl::paginationControl() must be an instance of Zend_Paginator, array given in C:\xampp\htdocs\zend_login\library\Zend\View\Helper\PaginationControl.php on line 88

can you please tell what i am missing i am new to zend so please dont mind my awkward question this is my ErrorController.php

class ErrorController extends Zend_Controller_Action{
public function errorAction()
{
    $errors = $this->_getParam('error_handler');

    switch ($errors->type) {
        case Zend_Controller_Plugin_ErrorHandler::EXCEPTION_NO_ROUTE:
        case Zend_Controller_Plugin_ErrorHandler::EXCEPTION_NO_CONTROLLER:
        case Zend_Controller_Plugin_ErrorHandler::EXCEPTION_NO_ACTION:

            // 404 error -- controller or action not found
            $this->getResponse()->setHttpResponseCode(404);
            $this->view->message = 'Page not found';
            break;
        default:
            // application error
            $this->getResponse()->setHttpResponseCode(500);
            $this->view->message = 'Application error';
            break;
    }

    // Log exception, if logger available
    if ($log = $this->getLog()) {
        $log->crit($this->view->message, $errors->exception);
    }

    // conditionally display exceptions
    if ($this->getInvokeArg('displayExceptions') == true) {
        $this->view->exception = $errors->exception;
    }

    $this->view->request   = $errors->request;
}

public function getLog()
{
    $bootstrap = $this->getInvokeArg('bootstrap');
    if (!$bootstrap->hasPluginResource('Log')) {
        return false;
    }
    $log = $bootstrap->getResource('Log');
    return $log;
}
}

Answer 1

You just need to call it as an object:

<td><?php echo $record->task_name; ?></td>

UPDATE: all other errors resolved in chat