コード例 #1
0
ファイル: Query.php プロジェクト: jasny/dbquery-mysql
 /**
  * Add criteria as HAVING expression to query statement.
  * @see Query::where()
  * 
  * @param mixed $column  Expression, column name, column number, expression with placeholders or array(column=>value, ...)
  * @param mixed $value   Value or array of values
  * @param int   $flag    Query::REPLACE, Query::PREPEND or Query::APPEND + Query::BACKQUOTE_%
  * @return Query  $this
  */
 public function having($column, $value = null, $flags = 0)
 {
     $where = QuerySplitter::buildWhere($column, $value, $flags);
     if (isset($where)) {
         $this->setPart('having', $where, $flags);
     }
     return $this;
 }
コード例 #2
0
 public function testBuildWhere_TwoParamsArray()
 {
     $where = QuerySplitter::buildWhere('foo IN ? AND bar LIKE %?%', array(array(10, 20), "blue"));
     $this->assertEquals('`foo` IN (10, 20) AND `bar` LIKE "%blue%"', $where);
 }