PHP SqlParser\Components Limit::build Examples

build() public static method

public static build ( Limit $component, array $options = [] ) : string
$component	Limit	The component to be built.
$options	array	Parameters for building.
return	string

Example #1

File: DeleteStatement.php Project: wp-cloud/phpmyadmin

 /**
  * @return string
  */
 public function build()
 {
     $ret = 'DELETE ' . OptionsArray::build($this->options);
     if ($this->columns != NULL && count($this->columns) > 0) {
         $ret .= ' ' . ExpressionArray::build($this->columns);
     }
     if ($this->from != NULL && count($this->from) > 0) {
         $ret .= ' FROM ' . ExpressionArray::build($this->from);
     }
     if ($this->using != NULL && count($this->using) > 0) {
         $ret .= ' USING ' . ExpressionArray::build($this->using);
     }
     if ($this->where != NULL && count($this->where) > 0) {
         $ret .= ' WHERE ' . Condition::build($this->where);
     }
     if ($this->order != NULL && count($this->order) > 0) {
         $ret .= ' ORDER BY ' . ExpressionArray::build($this->order);
     }
     if ($this->limit != NULL && count($this->limit) > 0) {
         $ret .= ' LIMIT ' . Limit::build($this->limit);
     }
     return $ret;
 }

Example #2

File: LimitTest.php Project: phpmyadmin/sql-parser

 public function testBuildWithOffset()
 {
     $component = new Limit(1, 2);
     $this->assertEquals(Limit::build($component), '2, 1');
 }