ZF-7216: inner join on multiple tables

Issue Type: Bug Created: 2009-07-07T06:15:52.000+0000 Last Updated: 2010-11-20T05:41:12.000+0000 Status: Resolved Fix version(s): Reporter: prashant ingale (iprashant) Assignee: Ryan Mauger (bittarman) Tags: - Zend_Db

Related issues: Attachments: - error.JPG


I am new to zend framework and trying to use Zend_Db

below code i wrote for acl. I have XAMPP

public function _construct() { $this->acl = new Zend_Acl(); $config = new Zend_Config_Ini(path/to/ini); $this->db = Zend_Db:$config->database-<adapter,$config->database->params); }

public function setResources() { $result = $this->db->query("select tbl1.fld1, tbl2.fld2, tbl3.fld3 from tbl1 inner join tbl2 on tbl1.fld1=tbl2.fld2 inner join tbl3 on tbl2.fld2=tbl3.fld3"); while($row = $result->fetchObject()) { echo $row->fld1; }

I have wrote query in other way as follows as well.

$select = $this->db->select() ->from(array('a'=>'tbla1')) ->join(array('b'=>'tbl2'),'a.fld1=b.fld2') ->join(array('c'=>'tbl3'),'b.fld2=c.fld3');

$stmt = $this->db->query($select); $result = $stmt->fetchAll();

I get Apache HTTP Server error window which says "Apache HTTP Server has encountered a problem and need to close."


Posted by prashant ingale (iprashant) on 2009-07-07T06:16:38.000+0000

this is error window which i get

Posted by Ralph Schindler (ralph) on 2010-06-18T15:19:39.000+0000

Can you please provide your schema and a minimal reproduction script to demonstrate the issue. Please see… for details on how to write a good reproduction script.

Posted by Ryan Mauger (bittarman) on 2010-11-20T05:41:11.000+0000

This issue is over a year old, and no reproduce code has been presented as requested, so I am closing as Cannot Reproduce.

Have you found an issue?

See the Overview section for more details.


© 2006-2016 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.