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);

* @param object Parent object

* @return void

*/

}

/**

*

* @return void

*/

$this->errorStatus = '';

$this->lastInsertedId = 0;

$this->lastAffectedRows = 0;

* @param array $fInfo Field configuration data

* @return mixed The processed input value

*/

$options = $this->parseFieldDef($fInfo['Type']);

switch(strtolower($options['fieldType'])) {

* @param array Field values as key=>value pairs.

* @return boolean TRUE on success and FALSE on failure (error is set internally)

*/

// Initialize

$this->resetStatusVars();

* @param array Field values as key=>value pairs.

* @return boolean TRUE on success and FALSE on failure (error is set internally)

*/

// Initialize:

$this->resetStatusVars();

* @param string WHERE clause

* @return boolean TRUE on success and FALSE on failure (error is set internally)

*/

// Initialize:

$this->resetStatusVars();

* @param string Optional LIMIT value ([begin,]max), if none, supply blank string.

* @return object Returns result object, but if errors, returns false

*/

// Initialize:

$this->resetStatusVars();

* @param string Query to execute

* @return object Result object or false if error

*/

$res = t3lib_div::makeInstance('t3lib_sqlengine_resultobj');

$res->result = array();

return $res;

*

* @return string Error message, if any

*/

return $this->errorStatus;

}

*

* @return integer Last unique id created.

*/

return $this->lastInsertedId;

}

*

* @return integer Last amount of affected rows.

*/

return $this->lastAffectedRows;

}

* @param string Input String

* @return string String, with quotes escaped

*/

return addslashes($str);

}

* @return array Tables in an array (tablename is in both key and value)

* @todo Should return table details in value! see t3lib_db::admin_get_tables()

*/

$whichTables = array();

return $whichTables;

}

* @param string Table name

* @return array Field information in an associative array with fieldname => field row

*/

$output = array();

return $output;

}

* @param string Table name

* @return array Key information in a numeric array

*/

$output = array();

return $output;

}

* @param string Query to execute

* @return pointer Result pointer

*/

return $this->sql_query($query);

}

* @return void

* @todo Table locking tools?

*/

$this->data[$table] = array();

}

* @return void

* @todo Table locking tools?

*/

debug($this->data[$table]);

}

* @param array Where clause parsed into array

* @return array Array of keys pointing to result rows in $this->data[$table]

*/

$output = array();

if (is_array($this->data[$table])) {

* @return void Data array passed by reference

* @see selectFromData()

*/

$neg = preg_match('/^AND[[:space:]]+NOT$/',trim($config['operator']));

if (is_array($config['sub'])) {

* @param string Fieldlist (commaseparated)

* @return array Result array with "rows"

*/

$fields = t3lib_div::trimExplode(',',$fieldList);

$output = array();

* @param array Result set array (array of rows)

* @return string HTML table

*/

if (count($array)) {

$tRows=array();

*

* @return integer

*/

return count($this->result);

}

*

* @return array Associative array

*/

$row = current($this->result);

next($this->result);

return $row;

*

* @return array Numerical array

*/

$resultRow = $this->sql_fetch_assoc();

if (is_array($resultRow)) {

* @param integer Position pointer.

* @return boolean Returns true on success

*/

reset($this->result);

for ($a=0;$a<$pointer;$a++) {

next($this->result);

*

* @return string Blank string, not supported (it seems)

*/

return '';

}

}