PMA_splitSqlFile()

Complexity

Conditions	30
Paths	6

Size

Total Lines	104
Code Lines	57

Duplication

Lines	0
Ratio	0 %

Importance

Changes	4
Bugs	0	Features	0

<?php
function PMA_splitSqlFile(&$ret, $sql, $release)

The parameter $release is not used and could be removed.

{
    $sql          = rtrim($sql, "\n\r");
    $sql_len      = strlen($sql);
    $char         = '';

The assignment to $char is dead and can be removed.

    $string_start = '';
    $in_string    = false;
    $nothing      = true;
    $time0        = time();

    for ($i = 0; $i < $sql_len; ++$i) {
        $char = $sql[$i];

        // We are in a string, check for not escaped end of strings except for
        // backquotes that can't be escaped
        if ($in_string) {
            for (; ;) {
                $i = strpos($sql, $string_start, $i);
                // No end of string found -> add the current substring to the
                // returned array
                if (!$i) {
                    $ret[] = $sql;
                    return true;
                }
                // Backquotes or no backslashes before quotes: it's indeed the
                // end of the string -> exit the loop

                if ('`' == $string_start || '\\' != $sql[$i - 1]) {
                    $string_start = '';
                    $in_string    = false;
                    break;
                }
                // one or more Backslashes before the presumed end of string...

                // ... first checks for escaped backslashes
                $j                 = 2;
                $escaped_backslash = false;
                while ($i - $j > 0 && '\\' == $sql[$i - $j]) {
                    $escaped_backslash = !$escaped_backslash;

The condition $escaped_backslash is always false.

                    $j++;
                }
                // ... if escaped backslashes: it's really the end of the
                // string -> exit the loop
                if ($escaped_backslash) {
                    $string_start = '';
                    $in_string    = false;
                    break;
                }
                // ... else loop

                $i++; // end if...elseif...else
            } // end for
        } // end if (in string)

        // lets skip comments (/*, -- and #)
        elseif (('-' == $char && $sql_len > $i + 2 && '-' == $sql[$i + 1] && $sql[$i + 2] <= ' ') || '#' == $char || ('/' == $char && $sql_len > $i + 1 && '*' == $sql[$i + 1])) {
            $i = strpos($sql, '/' == $char ? '*/' : "\n", $i);
            // didn't we hit end of string?
            if (false === $i) {
                break;
            }
            if ('/' == $char) {
                $i++;
            }
        } // We are not in a string, first check for delimiter...
        elseif (';' == $char) {
            // if delimiter found, add the parsed part to the returned array
            $ret[]   = ['query' => substr($sql, 0, $i), 'empty' => $nothing];
            $nothing = true;
            $sql     = ltrim(substr($sql, min($i + 1, $sql_len)));
            $sql_len = strlen($sql);
            if ($sql_len !== 0) {
                $i = -1;
            } else {
                // The submited statement(s) end(s) here
                return true;
            }
        } // end else if (is delimiter)

        // ... then check for start of a string,...
        elseif (('"' == $char) || ('\'' == $char) || ('`' == $char)) {
            $in_string    = true;
            $nothing      = false;
            $string_start = $char;
        } // end else if (is start of string)

        elseif ($nothing) {
            $nothing = false;
        }

        // loic1: send a fake header each 30 sec. to bypass browser timeout
        $time1 = time();
        if ($time1 >= $time0 + 30) {
            $time0 = $time1;
            header('X-pmaPing: Pong');
        } // end if
    } // end for

    // add any rest to the returned array
    if (!empty($sql) && preg_match('@[^[:space:]]+@', $sql)) {
        $ret[] = ['query' => $sql, 'empty' => $nothing];
    }

    return true;
} // end of the 'PMA_splitSqlFile()' function