Apply for Zend Framework Certification Training

Zend Framework 2

< Login And Logout in Zend Framework 2 How to Edit Data in Zend Framework 2 using tableGateway >



In Model file 
 
    you need to include
       $sql = $this->tableGateway->getSql();
   and to print the query 
       echo $sql->getSqlstringForSqlObject($sqlSelect); die ;
    
<?php
namespace Application\Model;
use Zend\Db\TableGateway\TableGateway;
use Zend\Db\Sql\Where;
class HotelTable{
         protected $tableGateway;
         public function __construct(TableGateway $tableGateway){
                  $this->tableGateway=$tableGateway;
         }
 
         public function fetchAll(){
                  $sql = $this->tableGateway->getSql();
                  $sqlSelect = $this->tableGateway->getSql()->select();
                  $sqlSelect->columns(array('*'));
                  $sqlSelect->join('employee', 'employee.id = hotel.hotelId', array(), 'inner');
                  echo $sql->getSqlstringForSqlObject($sqlSelect); die ;
                 $resultSet= $this->tableGateway->selectWith($sqlSelect);
                  return $resultSet;
 
       }
}        

< Login And Logout in Zend Framework 2 How to Edit Data in Zend Framework 2 using tableGateway >



Ask a question



  • Question: 
    {{questionlistdata.blog_question_description}}
    • Answer:
      {{answer.blog_answer_description  }}
    Replay to Question

(+91)-9910699802
Become A Member     Become A Teacher
Back to Top