CODEWITHSUNDEEP
phpmysqlzend-framework2
Chirag Shah
Chirag Shah

Reputation: 1474

Order By Condition For ResultSet Zend Framework 2?

I have one tabel 'cms' when i call fetchAll() function which fetch all data fetch data with order by id desc means i want to pass orderby condition with fetchAll() function.

My Cms.php page is:

    <?php
    namespace Front\Model;
    use Zend\Db\TableGateway\AbstractTableGateway;

    class Cms extends AbstractTableGateway {

        public function __construct($adapter) {
            $this->table = 'cms';
            $this->adapter = $adapter;
        } 
        public function fetchAll($id) {
               return $this->select();
        }
        public function getCmsContent($id){
            $id  = (int) $id;
            $rowset = $this->select(array('id'=>$id));
            if (!$row = $rowset->current()){
                throw new \Exception ('Row not found');
            }
            return $row;
        }
    }

My Controller is :FrontController.php is: 

use Zend\Mvc\Controller\AbstractActionController;
use Zend\View\Model\ViewModel;
use Front\Model\Cms;
use Front\Model\Setting;
use Front\Model\Slider;
class FrontController extends AbstractActionController
{
    public function indexAction()
    {   

        return        array('cms_data'=>$this->getCms()->fetchAll('1'));             
    }

    public function getCms(){
        return $this->getServiceLocator()->get('Front\Model\Cms');
    }

}

My Model is: 

namespace Front;

class Module
{
    public function getAutoloaderConfig()
    {
        return array('Zend\Loader\StandardAutoloader' =>
            array('namespaces' =>
                array(__NAMESPACE__ => __DIR__ . '/src/' . __NAMESPACE__,),
            ),
        );
    }

    public function getConfig()
    {
        return include __DIR__ . '/config/module.config.php';
    }
    // Add this method:
    public function getServiceConfig()
    {
        return array(
            'factories' => array(

                'Front\Model\Cms' =>  function($sm) {
                    $dbAdapter = $sm->get('Zend\Db\Adapter\Adapter');
                    $table     = new \Front\Model\Cms($dbAdapter);
                    return $table;
                },

            ),
        );
    }
}
?>

My View:index.php Page is:

 <?php print_R($cms_data); ?>

Upvotes: 0

Views: 2110

Answers (1)

akond
akond

Reputation: 16035

An excerpt from the manual:

$select = new Select;
$select->order('id DESC'); // produces 'id' DESC

$select = new Select;
$select->order('id DESC')
     ->order('name ASC, age DESC'); // produces 'id' DESC, 'name' ASC, 'age' DESC

$select = new Select;
$select->order(array('name ASC', 'age DESC')); // produces 'name' ASC, 'age' DESC

The same method order applies to table gateway.

Upvotes: 1

Related Questions