';
$words['clauseG'] = ' (SELECT|FROM|WHERE|ORDER BY|GROUP BY|LIMIT|INSERT INTO|VALUES|UPDATE|SET) ';
$words['clauseL'] = ' (AND|INNER JOIN|OR|OUTER JOIN|LEFT JOIN|RIGHT JOIN) ';
$words['clauseI'] = ' (AS|ON|DESC|DISTINCT|SQL_CALC_FOUND_ROWS) ';
$words['function'] = ' (AVG|MAX|IF|CONCAT|DATE_FORMAT|SUBSTRING) ';
$words['operator'] = '([^<>]=|!=|<>|>[^=]|<[^=]|>=|<=|\+|-|\/)';
$words['numeric'] = '([0-9]+)';
$words['string'] = '(\'[^\']*\')';
$words['comma'] = '(,)';
$words['period'] = '(\.)';
$words['asterix'] = '(\*)';
$words['open'] = '(\()';
$words['close'] = '(\))';
$array = preg_split('/'.implode('|', $words).'/is', $input, -1, PREG_SPLIT_DELIM_CAPTURE | PREG_SPLIT_NO_EMPTY);
$functionDepth = 0;
$lastType = NULL;
$nextSpaceBefore = false;
$level = 0;
$code = NULL;
foreach($array as $key => $value) {
if(trim($value) != '') {
$value = trim($value);
$thisType = NULL;
$prefix = NULL;
$suffix = NULL;
$levelResetBefore = false;
$levelUpBefore = false;
$levelDownBefore = false;
$levelResetAfter = false;
$levelUpAfter = false;
$levelDownAfter = false;
$newLineBefore = false;
$newLineAfter = false;
$spaceBefore = false;
$spaceAfter = false;
$uppercase = false;
foreach($words as $tkey => $tvalue) {
if(preg_match('/'.$tvalue.'/is', ' '.$value.' ')) $thisType = $tkey;
}
if($thisType) {
switch($thisType) {
case 'clauseG':
$levelResetBefore = true;
$levelUpAfter = true;
$newLineAfter = true;
$newLineBefore = true;
$uppercase = true;
break;
case 'clauseL':
$newLineBefore = true;
$spaceAfter = true;
$uppercase = true;
break;
case 'clauseI':
$spaceBefore = true;
$spaceAfter = true;
$uppercase = true;
break;
case 'function':
if($expandFunctions)
$newLineBefore = true;
$uppercase = true;
break;
case 'operator':
$spaceBefore = true;
$spaceAfter = true;
break;
case 'comma':
if(!$functionDepth || $expandFunctions)
$newLineAfter = true;
else
$spaceAfter = true;
break;
case 'open':
if($lastType == 'function')
$functionDepth++;
if(!$functionDepth || $expandFunctions) {
$levelUpAfter = true;
$newLineBefore = true;
$newLineAfter = true;
}
break;
case 'close':
if(!$functionDepth || $expandFunctions) {
$levelDownBefore = true;
$newLineBefore = true;
$newLineAfter = true;
}
if($functionDepth)
$functionDepth--;
break;
}
if(!$nextSpaceBefore)
$spaceBefore = false;
}
$value = htmlentities($value);
if($uppercase)
$value = strtoupper($value);
if($levelResetBefore) $level = 0;
if($levelUpBefore) $level++;
if($levelDownBefore) $level--;
if($newLineBefore) $code.= '
'.str_repeat("\t", $level);
if($spaceBefore) $code.= ' ';
if($thisType) $value = '
'.$value.'';
$code .= $value;
if($spaceAfter) $code.= ' ';
if($levelResetAfter) $level = 0;
if($levelUpAfter) $level++;
if($levelDownAfter) $level--;
if($newLineAfter) $code.= '
'.str_repeat("\t", $level);
$lastType = $thisType;
if($spaceAfter || $newLineAfter)
$nextSpaceBefore = false;
else
$nextSpaceBefore = true;
}
}
$code = preg_replace('/^
/is', '', $code);
$code = preg_replace('/
( )*
/is', '
', $code);
$code = preg_replace('/
( )*$/is', '', $code);
$output .= '
'.$code.'
';
$output .= '
';
$output .= '| tdAtts.' class="id">';
$key = str_replace(' ', ' ', $key);
$output .= $key;
$output .= ' | ';
$type = $this->checkType($value);
if($type[0] == 'array') {
$output .= '';
$output .= $this->dumpArray($value, $dimension + 1);
$output .= ' | ';
}
else if($type[1]) {
$output .= '';
$output .= $this->getDump($value, $type[0]);
$output .= ' | ';
}
else {
$output .= '';
$output .= $this->getDump($value, $type[0]);
$output .= ' | ';
}
$output .= '
';
return $output;
}
/*----------------------------------------------------------------------
title(title) : Create string for 'title' span attribute
----------------------------------------------------------------------*/
function title($title) {
if($this->titleText) {
$title = str_replace('[Actual]', $title, $this->titleText);
$this->titleText = NULL;
}
return $title;
}
/*----------------------------------------------------------------------
css() : CSS
----------------------------------------------------------------------*/
function css() {
$output = '
';
$output = str_replace("\r", '', $output);
$output = str_replace("\n", '', $output);
$output = preg_replace('/\s+/is', ' ', $output);
$output = trim($output);
return $output;
}
}
/*----------------------------------------------------------------------
In order to minimise the code you have to type to quickly use this
class, these functions are predefined, and they create the PHP Dump
object for you. If you would rather create the PHP Dump object
yourself just remove or ignore these functions.
----------------------------------------------------------------------*/
function dump($input, $return = false) {
$dump = new phpDump;
return $dump->dump($input, $return);
}
function dumps($input, $return = false) {
$dump = new phpDump;
return $dump->dumps($input, $return);
}
function dumpq($input, $return = false, $expandFunctions = false) {
$dump = new phpDump;
return $dump->dumpq($input, $return, $expandFunctions);
}
?>