zend 2.2 db select 使用例子
use
= ->from('foo'
= ->from( TableIdentifier('foo', 'bar'
= ->from(('f' => 'foo'
= ->from(('f' => TableIdentifier('foo'
= ->from('foo')->columns(('bar', 'baz'
= ->from('foo')->columns(('bar' => 'baz'
= ->from('foo')->columns(('bar' => 'baz', 'bam'
= ->from('foo')->columns(('bar' => Expression('COUNT(some_column)'
= ->from('foo')->columns(( Expression('COUNT(some_column) AS bar'
= ->from('foo')->'(COUNT(?) + ?) AS ?',
('some_column', 5, 'bar'),
(Expression::TYPE_IDENTIFIER, Expression::TYPE_VALUE, Expression::
= ->from('foo')->('zac', 'm = n'
= ->from('foo')->('zac', 'm = n', ('bar', 'baz'
= ->from('foo')->('zac', 'm = n', ('bar', 'baz'), Select::
= ->from('foo')->('zac', 'm = n', ('BAR' => 'bar', 'BAZ' => 'baz'
= ->from('foo')->(('b' => 'bar'), 'b.foo_id = foo.foo_id'
= ->from('foo')->where('x = 5'
= ->from('foo')->where(('x = ?' => 5
= ->from('foo')->group(('col1', 'col2'
= ->from('foo')->group('col1')->group('col2'
= ->from('foo')->group( Expression('DAY(?)', ('col1'), (Expression::
= ->from('foo')->having('x = 5'
= ->from('foo')->having(('x = ?' => 5
= ->from('foo')->order('c1'
= ->from('foo')->order(('c1', 'c2'
= ->from('foo')->order(('c1' => 'DESC', 'c2' => 'Asc'));
= ->from('foo')->order(('c1' => 'asc'))->order('c2 desc');
= ->from('foo')->limit(5
= ->from('foo')->limit(5)->offset(10
= ->from('foo')->('zac', '(m = n AND c.x) BETWEEN x AND y.z'
= ->from('foo')->order('c1.d2'