system/classes/Db_MySQL.php
protected function getArrayCondition($dataMember, $statementNum, $offset)
    {
        if (count($this->{$dataMember}[$statementNum][0][$offset]) >= 3) {
            $item = $this->{$dataMember}[$statementNum][0][$offset];
            $result = '';
            
            if ($item[1] == 'IN') {
                $searchArea = $item[2];
                
                // Check if searchArea is array...
                if (is_array($searchArea)) {
                    // Convert the array into a comma delimited string.
                    $str = "'";
                    $size = count($searchArea);
                    for($i=0; $i < $size; $i++) {
                        $str_item = $this->clean($searchArea[$i]);
                        $str = $str.$str_item;
                        if ($i < $size-1) {
                            $str = $str."', '";
                        }
                    }
                    $searchArea = $str."'";
                } else {
                    $searchArea = $this->clean($searchArea);
                }
                
                // Return string of form 'COLUMN IN (value1, value2, ...)'
                $result = $item[0].' '.$item[1]." (".$searchArea.")";
            }
            else {
                // Return string of form 'COLUMN >= VALUE'
                $column = $this->sanitize($item[0], $dataMember);
                if ($item[2] === 'NULL') {
                    $result = $column.' '.$item[1]." ".$item[2]; 
                }
                else {
                    $result = $column.' '.$item[1]." '".$this->clean($item[2])."'";
                }
            }
            return $result;
        }
        else {
            throw new \Exception("Cora's Query Builder class expects advanced query components to be in an array with form {column, operator, value [, conjunction]}");
        }
    }
protected function getArrayCondition($dataMember, $statementNum, $offset)
    {
        if (count($this->{$dataMember}[$statementNum][0][$offset]) >= 3) {
            $item = $this->{$dataMember}[$statementNum][0][$offset];
            $result = '';
            
            if ($item[1] == 'IN') {
                $searchArea = $item[2];
                
                // Check if searchArea is array...
                if (is_array($searchArea)) {
                    // Convert the array into a comma delimited string.
                    $str = "'";
                    $size = count($searchArea);
                    for($i=0; $i < $size; $i++) {
                        $str_item = $this->clean($searchArea[$i]);
                        $str = $str.$str_item;
                        if ($i < $size-1) {
                            $str = $str."', '";
                        }
                    }
                    $searchArea = $str."'";
                } else {
                    $searchArea = $this->clean($searchArea);
                }
                
                // Return string of form 'COLUMN IN (value1, value2, ...)'
                $result = $item[0].' '.$item[1]." (".$searchArea.")";
            }
            else {
                // Return string of form 'COLUMN >= VALUE'
                $column = $this->sanitize($item[0], $dataMember);
                if ($item[2] === 'NULL') {
                    $result = $column.' '.$item[1]." ".$item[2]; 
                }
                else {
                    $result = $column.' '.$item[1]." '".$this->clean($item[2])."'";
                }
            }
            return $result;
        }
        else {
            throw new \Exception("Cora's Query Builder class expects advanced query components to be in an array with form {column, operator, value [, conjunction]}");
        }
    }
protected function getArrayCondition ( $ dataMember , $ statementNum , $ offset ) { if ( count ( $ this -> { $ dataMember } [ $ statementNum ] [ 0 ] [ $ offset ] ) >= 3 ) { $ item = $ this -> { $ dataMember } [ $ statementNum ] [ 0 ] [ $ offset ] ; $ result = '' ; if ( $ item [ 1 ] == 'IN' ) { $ searchArea = $ item [ 2 ] ; // Check if searchArea is array... if ( is_array ( $ searchArea ) ) { // Convert the array into a comma delimited string. $ str = "'" ; $ size = count ( $ searchArea ) ; for ( $ i = 0 ; $ i < $ size ; $ i ++ ) { $ str_item = $ this -> clean ( $ searchArea [ $ i ] ) ; $ str = $ str . $ str_item ; if ( $ i < $ size - 1 ) { $ str = $ str . "', '" ; } } $ searchArea = $ str . "'" ; } else { $ searchArea = $ this -> clean ( $ searchArea ) ; } // Return string of form 'COLUMN IN (value1, value2, ...)' $ result = $ item [ 0 ] . ' ' . $ item [ 1 ] . " (" . $ searchArea . ")" ; } else { // Return string of form 'COLUMN >= VALUE' $ column = $ this -> sanitize ( $ item [ 0 ] , $ dataMember ) ; if ( $ item [ 2 ] === 'NULL' ) { $ result = $ column . ' ' . $ item [ 1 ] . " " . $ item [ 2 ] ; } else { $ result = $ column . ' ' . $ item [ 1 ] . " '" . $ this -> clean ( $ item [ 2 ] ) . "'" ; } } return $ result ; } else { throw new \ Exception ( "Cora's Query Builder class expects advanced query components to be in an array with form {column, operator, value [, conjunction]}" ) ; } }
When given an array of the following format:
[column, operator, value]
It returns a composite string of the variables.

If any of the three offsets are missing, it with throw an exception.
Some examples of this in use are:
[$column, '=', $value] when getting WHERE or HAVING clause.
[$column, 'IN', array()] when getting column IN array() clause.
When given an array of the following format : [ column operator value ] It returns a composite string of the variables .