Skip to content

Instantly share code, notes, and snippets.

@matstani

matstani/zf2-select.php

Created March 9, 2014 09:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save matstani/9445275 to your computer and use it in GitHub Desktop.
Save matstani/9445275 to your computer and use it in GitHub Desktop.
Download ZIP
ZF2 TableGatewayを使わない検索
Raw
zf2-select.php
<?php
$sm = $this->getServiceLocator();
$adapter = $sm->get('Zend\Db\Adapter\Adapter');
$sql = new \Zend\Db\Sql\Sql($adapter);
$select = $sql->select();
$select->from('album');
//echo $select->getSqlString($adapter->getPlatform());
$statement = $sql->prepareStatementForSqlObject($select);
$resultSet = $statement->execute();
//SELECT `album`.* FROM `album`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment