How to write this query with Zend Framework?

Question

How can I write this query with Zend Framework?

select
    log.log_date,
    log.user_id,
    log.task,
    log.work_desc,
    log.hours,
    log.user2project,
    project.title as title,
    project.id
from 
    log,
    project
where
    log.user2project = project.id

Unihedron · Accepted Answer · 2015-08-02 08:51:56Z

3

This is pretty much what you want.

$select = $this->select()
                ->setIntegrityCheck(false)
                ->from('log', array('log_date', 'user_id', 'task', 'work_desc', 'hours', 'user2project'))
                ->join('project', 'log.user2project = project.id', array('title' => 'title', 'id'));

The code above just creates the Zend_Db_Table_Select object, it doesn't run the query. To run the query you will have to do the following:

$result = $this->fetchAll($select); //this results in a Zend_Db_Table_Rowset
//if you want to return an array, just do
return $result->toArray();
//if you want the rowset object just
return $result;

edited Aug 2, 2015 at 8:51

Unihedron

11.1k13 gold badges65 silver badges72 bronze badges

answered Mar 31, 2011 at 10:55

Bogdan Constantinescu

5,3864 gold badges42 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Awais Qarni Over a year ago

its returned me a huge array that is describing about whole schema.... But where are the values that this query should returned

Bogdan Constantinescu Over a year ago

@Awais Qarni : that's the object. If you want an array and not an object you have to call toArray() method on your result

Bogdan Constantinescu Over a year ago

@Awais Qarni: toArray() is a method you can call on a Zend_Db_Table_Rowset (aka a result object).

Collectives™ on Stack Overflow

How to write this query with Zend Framework?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related