TYPO3 Core

* @return array Result array with all the parts in - or error message string

* @see compileSQL(), debug_testSQL()

*/

// Prepare variables:

$parseString = $this->trimSQL($parseString);

$this->parse_error = '';

* @return mixed Returns array with components of SELECT query on success, otherwise an error message string.

* @see compileSELECT()

*/

// Removing SELECT:

$parseString = $this->trimSQL($parseString);

* @return mixed Returns array with components of UPDATE query on success, otherwise an error message string.

* @see compileUPDATE()

*/

// Removing UPDATE

$parseString = $this->trimSQL($parseString);

* @return mixed Returns array with components of INSERT query on success, otherwise an error message string.

* @see compileINSERT()

*/

// Removing INSERT

$parseString = $this->trimSQL($parseString);

* @return mixed Returns array with components of DELETE query on success, otherwise an error message string.

* @see compileDELETE()

*/

// Removing DELETE

$parseString = $this->trimSQL($parseString);

* @return mixed Returns array with components of EXPLAIN query on success, otherwise an error message string.

* @see parseSELECT()

*/

// Removing EXPLAIN

$parseString = $this->trimSQL($parseString);

* @return mixed Returns array with components of CREATE TABLE query on success, otherwise an error message string.

* @see compileCREATETABLE()

*/

// Removing CREATE TABLE

$parseString = $this->trimSQL($parseString);

* @return mixed Returns array with components of ALTER TABLE query on success, otherwise an error message string.

* @see compileALTERTABLE()

*/

// Removing ALTER TABLE

$parseString = $this->trimSQL($parseString);

* @param string SQL string starting with DROP TABLE

* @return mixed Returns array with components of DROP TABLE query on success, otherwise an error message string.

*/

// Removing DROP TABLE

$parseString = $this->trimSQL($parseString);

* @param string SQL string starting with CREATE DATABASE

* @return mixed Returns array with components of CREATE DATABASE query on success, otherwise an error message string.

*/

// Removing CREATE DATABASE

$parseString = $this->trimSQL($parseString);

* @return array If successful parsing, returns an array, otherwise an error string.

* @see compileFieldList()

*/

$stack = array(); // Contains the parsed content

* @return array If successful parsing, returns an array, otherwise an error string.

* @see compileFromTables()

*/

// Prepare variables:

$parseString = $this->trimSQL($parseString);

* @param string Regular expressing to STOP parsing, eg. '^(GROUP BY|ORDER BY|LIMIT)([[:space:]]*)'

* @return mixed If successful parsing, returns an array, otherwise an error string.

*/

// Prepare variables:

$parseString = $this->trimSQL($parseString);

* @param string Regular expressing to STOP parsing, eg. '^(GROUP BY|ORDER BY|LIMIT)([[:space:]]*)'

* @return mixed If successful parsing, returns an array, otherwise an error string.

*/

// Prepare variables:

$parseString = $this->trimSQL($parseString);

$this->lastStopKeyWord = '';

* @param boolean If set the full match of the regex is stripped of the beginning of the string!

* @return string The value of the first parenthesis level of the REGEX.

*/

$reg = array();

if (preg_match('/'.$regex.'/i',$parseString.' ', $reg)) { // Adding space char because [[:space:]]+ is often a requirement in regex's

$parseString = ltrim(substr($parseString,strlen($reg[$trimAll?0:1])));

* @param string The comparator used before. If "NOT IN" or "IN" then the value is expected to be a list of values. Otherwise just an integer (un-quoted) or string (quoted)

* @return mixed The value (string/integer). Otherwise an array with error message in first key (0)

*/

$value = '';

if (t3lib_div::inList('NOTIN,IN,_LIST',strtoupper(str_replace(array(' ',"\n","\r","\t"),'',$comparator)))) { // List of values:

* @param string The quote used; input either " or '

* @return string The value, passed through stripslashes() !

*/

$parts = explode($quote,substr($parseString,1));

$buffer = '';

* @param string Input string

* @return string Output string

*/

$search = array('\\\\', '\\\'', '\\"', '\0', '\n', '\r', '\Z');

$replace = array('\\', '\'', '"', "\x00", "\x0a", "\x0d", "\x1a");

* @param string Input string

* @return string Output string

*/

return $str;

$search = array('\\', '\'', '"', "\x00", "\x0a", "\x0d", "\x1a");

$replace = array('\\\\', '\\\'', '\\"', '\0', '\n', '\r', '\Z');

* @param string Remaining query to parse.

* @return string Error message.

*/

$this->parse_error = 'SQL engine parse ERROR: '.$msg.': near "'.substr($restQuery,0,50).'"';

return $this->parse_error;

}

* @param string Input string

* @return string Output string

*/

return trim(rtrim($str, "; \r\n\t")).' ';

}

* @return string SQL query

* @see parseSQL()

*/

switch($components['type']) {

case 'SELECT':

$query = $this->compileSELECT($components);

* @return string SQL SELECT query

* @see parseSELECT()

*/

// Initialize:

$where = $this->compileWhereClause($components['WHERE']);

* @return string SQL UPDATE query

* @see parseUPDATE()

*/

// Where clause:

$where = $this->compileWhereClause($components['WHERE']);

* @return string SQL INSERT query

* @see parseINSERT()

*/

if ($components['VALUES_ONLY']) {

// Initialize:

* @return string SQL DELETE query

* @see parseDELETE()

*/

// Where clause:

$where = $this->compileWhereClause($components['WHERE']);

* @return string SQL CREATE TABLE query

* @see parseCREATETABLE()

*/

// Create fields and keys:

$fieldsKeys = array();

* @return string SQL ALTER TABLE query

* @see parseALTERTABLE()

*/

// Make query:

$query = 'ALTER TABLE '.$components['TABLE'].' '.$components['action'].' '.($components['FIELD']?$components['FIELD']:$components['KEY']);

* @return string Select field string

* @see parseFieldList()

*/

// Prepare buffer variable:

$outputParts = array();

* @return string Table name string

* @see parseFromTables()

*/

// Prepare buffer variable:

$outputParts = array();

* @return string WHERE clause as string.

* @see explodeWhereClause()

*/

// Prepare buffer variable:

$output='';

* @param array Field definition parts

* @return string Field definition string

*/

// Set type:

$cfg = $fieldCfg['fieldType'];

* @param string SQL string to verify parsability of

* @return mixed Returns array with string 1 and 2 if error, otherwise false

*/

$retVal = false;

switch($part) {

* @param boolean If true, the strings are compared insensitive to case

* @return mixed Returns array with string 1 and 2 if error, otherwise false

*/

if ($caseInsensitive) {

$str1 = strtoupper($str);

$str2 = strtoupper($newStr);

* @param string SQL query

* @return string Query if all is well, otherwise exit.

*/

// Getting result array:

$parseResult = $this->parseSQL($SQLquery);