PHP RBM\SqlQuery\Selectの例

コード例 #1

ファイル: selectAsColumn.php プロジェクト: romainbessugesmeusy/php-sql-query

<?php

require '../vendor/autoload.php';
$client = new \RBM\SqlQuery\Select('client');
$client->filter()->eq('id', 2);
$select = new \RBM\SqlQuery\Select('projet');
$select->filter()->eq($client, 2);
$r = new RBM\SqlQuery\Renderer\SqlServer();
echo $r->render($select);

コード例 #2

ファイル: having.php プロジェクト: romainbessugesmeusy/php-sql-query

<?php

/**
 * Created by JetBrains PhpStorm.
 * User: rbm
 * Date: 28/04/13
 * Time: 17:19
 * To change this template use File | Settings | File Templates.
 */
require 'bootstrap.php';
$select = new \RBM\SqlQuery\Select("Project");
$select->cols("project_id", "name");
$select->setGroup(["project_id", "name"]);
$messages = $select->join("ProjectMessages", "project_id");
$messages->having()->greaterThanEquals(new \RBM\SqlQuery\Func("COUNT", [new \RBM\SqlQuery\Column("message_id", $messages->getTable())]), 0);
$renderer = new \RBM\SqlQuery\Renderer\Generic();
echo $renderer->format($select);