protected function getMySQLqueryType($sQuery)
    {
        $queryPieces    = explode(' ', $sQuery);
        $statementTypes = $this->listOfMySQLqueryStatementType($queryPieces[0]);
        if (in_array($queryPieces[0], $statementTypes['keys'])) {
            $type    = $statementTypes['value']['Type'];
            $ar1     = ['1st Keyword Within Query' => $queryPieces[0]];
            $lnT     = $this->listOfMySQLqueryLanguageType($type);
            $aReturn = array_merge($ar1, $lnT, $statementTypes['value']);
            ksort($aReturn);
            return $aReturn;
        }
        return [
            'detected1stKeywordWithinQuery' => $queryPieces[0],
            'unknown'                       => ['standsFor' => 'unknown', 'description' => 'unknown'],
            'Type'                          => 'unknown',
            'Description'                   => 'unknown',
        ];
    }
protected function getMySQLqueryType($sQuery)
    {
        $queryPieces    = explode(' ', $sQuery);
        $statementTypes = $this->listOfMySQLqueryStatementType($queryPieces[0]);
        if (in_array($queryPieces[0], $statementTypes['keys'])) {
            $type    = $statementTypes['value']['Type'];
            $ar1     = ['1st Keyword Within Query' => $queryPieces[0]];
            $lnT     = $this->listOfMySQLqueryLanguageType($type);
            $aReturn = array_merge($ar1, $lnT, $statementTypes['value']);
            ksort($aReturn);
            return $aReturn;
        }
        return [
            'detected1stKeywordWithinQuery' => $queryPieces[0],
            'unknown'                       => ['standsFor' => 'unknown', 'description' => 'unknown'],
            'Type'                          => 'unknown',
            'Description'                   => 'unknown',
        ];
    }
protected function getMySQLqueryType ( $ sQuery ) { $ queryPieces = explode ( ' ' , $ sQuery ) ; $ statementTypes = $ this -> listOfMySQLqueryStatementType ( $ queryPieces [ 0 ] ) ; if ( in_array ( $ queryPieces [ 0 ] , $ statementTypes [ 'keys' ] ) ) { $ type = $ statementTypes [ 'value' ] [ 'Type' ] ; $ ar1 = [ '1st Keyword Within Query' => $ queryPieces [ 0 ] ] ; $ lnT = $ this -> listOfMySQLqueryLanguageType ( $ type ) ; $ aReturn = array_merge ( $ ar1 , $ lnT , $ statementTypes [ 'value' ] ) ; ksort ( $ aReturn ) ; return $ aReturn ; } return [ 'detected1stKeywordWithinQuery' => $ queryPieces [ 0 ] , 'unknown' => [ 'standsFor' => 'unknown' , 'description' => 'unknown' ] , 'Type' => 'unknown' , 'Description' => 'unknown' , ] ; }
Returns the Query language type by scanning the 1st keyword from a given query

@param string $sQuery
Returns the Query language type by scanning the 1st keyword from a given query