PHP 클래스 phprs\ezsql\rules\select\HavingRule

상속: extends OrderByRule
파일 보기 프로젝트 열기: caoym/phprs-restful

공개 메소드들

메소드 설명
having ( string $expr, string $_ = null ) : OrderByRule having('SUM(a)=?', 1) => "HAVING SUM(a)=1" having('a>?', Sql::native('now()')) => "HAVING a>now()" having('a IN (?)', [1, 2]) => "HAVING a IN (1,2)"
havingArgs ( array $args ) : OrderByRule havingArgs([ 'a'=>1, 'b'=>['IN'=>[1,2]] 'c'=>['BETWEEN'=>[1,2]] 'd'=>['<>'=>1] ])

메소드 상세

having() 공개 메소드

having('SUM(a)=?', 1) => "HAVING SUM(a)=1" having('a>?', Sql::native('now()')) => "HAVING a>now()" having('a IN (?)', [1, 2]) => "HAVING a IN (1,2)"
public having ( string $expr, string $_ = null ) : OrderByRule
$expr string
$_ string
리턴 OrderByRule

havingArgs() 공개 메소드

=> "HAVING a=1 AND b IN(1,2) AND c BETWEEN 1 AND 2 AND d<>1"
public havingArgs ( array $args ) : OrderByRule
$args array
리턴 OrderByRule