php $this->tablegateway sql语句,php – 具有多个FROM表的TableGateway

我希望这会对你的旅程有所帮助,因为这是我的一个有效例子：

namespace Pool\Model;

use Zend\Db\TableGateway\AbstractTableGateway;

use Zend\Db\Sql\Select;

class IpaddressPool extends AbstractTableGateway

{

public function __construct($adapter)

{

$this->table = 'ipaddress_pool';

$this->adapter = $adapter;

$this->initialize();

}

public function Leases($poolid)

{

$result = $this->select(function (Select $select) use ($poolid) {

$select

->columns(array(

'ipaddress',

'accountid',

'productid',

'webaccountid'

))

->join('account', 'account.accountid = ipaddress_pool.accountid', array(

'firstname',

'lastname'

))

->join('product_hosting', 'product_hosting.hostingid = ipaddress_pool.hostingid', array(

'name'

))

->join('webaccount', 'webaccount.webaccountid = ipaddress_pool.webaccountid', array(

'domain'

))->where->equalTo('ipaddress_pool.poolid', $poolid);

});

return $result->toArray();

}

}