sql.php

是一款免费的轻量级论坛软件

<?
  class sql_syn extends plan_code_syn
  {
    var $keywords = array(
            'active',
            'after',
            'all',
            'alter',
            'and',
            'any',
            'as',
            'asc',
            'ascending',
            'at',
            'auto',
            'base_name',
            'before',
            'begin',
            'between',
            'by',
            'cache',
            'cast',
            'check',
            'column',
            'commit',
            'committed',
            'computed',
            'conditional',
            'constraint',
            'containing',
            'count',
            'create',
            'current',
            'cursor',
            'database',
            'debug',
            'declare',
            'default',
            'delete',
            'desc',
            'descending',
            'distinct',
            'do',
            'domain',
            'drop',
            'else',
            'end',
            'entry_point',
            'escape',
            'exception',
            'execute',
            'exists',
            'exit',
            'external',
            'extract',
            'filter',
            'for',
            'foreign',
            'from',
            'full',
            'function',
            'generator',
            'grant',
            'group',
            'having',
            'if',
            'in',
            'inactive',
            'index',
            'inner',
            'insert',
            'into',
            'is',
            'isolation',
            'join',
            'key',
            'left',
            'level',
            'like',
            'merge',
            'names',
            'no',
            'not',
            'null',
            'of',
            'on',
            'only',
            'or',
            'order',
            'outer',
            'parameter',
            'password',
            'plan',
            'position',
            'primary',
            'privileges',
            'procedure',
            'protected',
            'read',
            'retain',
            'returns',
            'revoke',
            'right',
            'rollback',
            'schema',
            'select',
            'set',
            'shadow',
            'shared',
            'snapshot',
            'some',
            'suspend',
            'table',
            'then',
            'to',
            'transaction',
            'trigger',
            'uncommitted',
            'union',
            'unique',
            'update',
            'user',
            'using',
            'view',
            'wait',
            'when',
            'where',
            'while',
            'with',
            'work'
    );

          function highlight($code)
          {
            $ch = "";
            $next_ch = "";
            $l=strlen($code);
            $out='';
            $i=0;
                        while ($i < $l)
            {
              if ($this->state==S_NONE)
              {
                $ch = $code{$i};
                if ($i+1 < $l)
                  $next_ch = $code{$i+1};
                else
                  $next_ch = '';

                if ($ch=='-' and $next_ch=='-')
                {
                  $this->state=S_COMMENT1;
            $out=$ch.$next_ch;
            $i++;
            $i++;
                }
                else if ($ch=='/' and $next_ch=='*')
                {
                  $this->state=S_COMMENT2;
            $out=$ch.$next_ch;
            $i++;
            $i++;
                }
                else if ($this->is_identifier_open($ch))
                {
                  $this->state=S_KEYWORD;
            $out=$ch;
            $i++;
                }
                else if ($ch=='\'')
                {
                  $this->state=S_STRING;
            $out=$ch;
            $i++;
                }
                else
                {
                  $out=$ch;
                }
          $this->open_state=$this->state;
          $this->close_state=S_NONE;
              }

                                if ($this->state!=S_NONE)
        {
                switch ($this->state)
                {
                  case S_COMMENT1:
                    $j=strpos($code,"\n",$i);
                    if ($j===false)
                      $j=$l-1;
              else
                            $this->close_state=$this->state;
                    $out.=substr($code, $i, $j - $i + 1);
                    $i=$j;
                    break;
                  case S_COMMENT2:
                    $j=strpos($code,'*/',$i);
                    if ($j===false)
                      $j = $l - 1;
              else
                      $this->close_state=$this->state;
                    $out.=substr($code, $i, $j + 1 - $i + 1);
                    $i=$j + 1;
                    break;
                  case S_KEYWORD:
                  {
                    $j= $i;
                    while ($j < $l)
                    {
                      if (!$this->is_identifier($code{$j}))
                        break;
                      $j++;
                    }
              $this->close_state=$this->state;//close if string breaked
                    $out.=substr($code, $i, $j - $i);
                    $i=$j - 1;
                    if (!in_array($out, $this->keywords))
	                  {
	                    $this->state=S_NONE;
	                    $this->open_state=S_NONE;
	                    $this->close_state=S_NONE;
	                  }
                    break;
                  }
                  case S_STRING:
                  {
                    $j=$i;
                    while ($j < $l)
                    {
                      if ($code{$j}=='\'')
                {
                 $out.=substr($code, $i, $j - $i + 1);//string in firebird support multiline
                        break;
                }
                      $j++;
                    }
                    $out.=substr($code, $i, $j - $i + 1);
                    $i=$j;
                    break;
                  }
          }
              }

              $this->text_out($out);
              $i++;
            }
          }
  }
?>