Zend Framework : Difference ways to redirect from controller

Zend Framework 1.8 Web Application Development

1. $this->_helper->redirector('index','profile');
2. $url = $this->_helper->url('index','profile','',array('smsg'=>'moved'));
$this->_helper->redirector->goToUrl($url);
3. $this->_forward('index','profile');
PHP Zend Studio 5 - Instructor-based Video Training

Perform action with out view page in Zend Framework

$this->_helper->viewRenderer->setNoRender()

OR

$this->getHelper('viewRenderer')->setNoRender()

How to add OR condition in select query

$selectQry = $this->db->select()->where('fieldname = ?','value')
->orWhere('fieldname = ?','value);

Zend Framework select query with limit and order clause

$selectQry = $this->db->select()->from(array('MedA'=>TBL_NAME),array('answer_id','didTake','dateRecorded'))
->join(array('Med'=>TBL_NAME),
'Med.medication_id = MedA.medication_id',
array('nick_name'))
->where('MedA.is_deleted = ?',0)
->where('MedA.medication_id = ?',$medId)
->where('MedA.time_slot_id = ?',$timeSlotId)
->where('MedA.user_id = ?',$idValue)
->order('MedA.dateRecorded DESC');

if(!empty($limit))
$selectQry->limit($offset,$limit)

Create Select query with join using Zend Framework

$this->db->select()->from(array('T1'=>'TBL_1'),array('table1_id'))
->join(array('T2'=>'TBL_2'),
'T1.site_id = T2.site_id',
array('GROUP_CONCAT( T2.name) as site_name'))
->where('T1.table1_id = ?',mysql_escape_string($tableId))

Set common view file in controller for using in different actions

We can use the same view file for different actions by using the view render helper.
If we want to use the same view file for Add and Edit pages, Create a view file for Add and use the below code in the Edit action function
$this->_helper->viewRenderer->setRender('add');

How to change the default Index controller in Zend Framework

Add the following code in the bootstrap init function
$frontController = $this->getResource('FrontController');
$frontController->setDefaultControllerName('controllerName');