CODEWITHSUNDEEP
phpmysqlzend-frameworkpagination
Farzan Najipour
Farzan Najipour

Reputation: 2503

select specific column Zend Framework

I want to change below controller to that can select from two column (id , number)

public function invalidcustomersAction()
    {
        $smsModel = new Model_SimInCust(); 
        $select = $smsModel->select();
        $paginator = new Zend_Paginator(new Zend_Paginator_Adapter_DbTableSelect($select));
        $paginator ->setItemCountPerPage(5)
        ->setCurrentPageNumber($this->_getParam('page',1));
        $this->view->paginator = $paginator;
    }

I already have this in my model 

<?php
class Model_SimInCust extends Zend_Db_Table_Abstract
{
    protected $_name = 'invalid';
    protected $_schema  = 'invalid_sim';

}

Upvotes: 0

Views: 926

Answers (1)

user3970657
user3970657

Reputation:

Edit your select to this :

$select = $smsModel->select()->from($smsModel, array('id','number'));

Upvotes: 1

Related Questions