Skip to content

Instantly share code, notes, and snippets.

@samsonasik
Last active August 29, 2015 14:01
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 samsonasik/514cb5333e7ed12875fe to your computer and use it in GitHub Desktop.
Save samsonasik/514cb5333e7ed12875fe to your computer and use it in GitHub Desktop.
abstract sql object
<?php
use Zend\Db\Sql\Sql;
$sql = new Sql($adapter);
$oSelect = $sql->select('table_test');
$oSelect->columns(array('*'))->where(array('test' => 'ok')->limit(1);
$sqlString = $sql->getSqlStringForSqlObject($oSelect);
//see https://github.com/zendframework/zf2/issues/3224
in Model Table class :
$sql = $this->tableGateway->getSql();
$select = $sql->select();
$select->where(array('column_name' => 'some value'));
$sql->getSqlstringForSqlObject($select);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment