コード例 #1
0
ファイル: StringTest.php プロジェクト: spyp/parse-php-sql
 public function tesGetBetween()
 {
     $query = 'SELECT * FROM test';
     $expected = "*";
     $actual = String::getBetween($query, 'SELECT', 'FROM');
     $this->assertEquals($expected, $actual);
 }
コード例 #2
0
ファイル: Select.php プロジェクト: spyp/parse-php-sql
 /**
  * get column to select
  */
 public function getColumns()
 {
     // before this we have to disable functions
     $sql = $this->functions(false);
     $columns = trim(String::getBetween($sql, 'SELECT', 'FROM'));
     if ($columns && $columns != '' && strlen($columns) > 0) {
         $fields = explode(',', $columns);
         $data = array();
         // explore multiple columns
         foreach ($fields as $column) {
             $column = trim($column);
             if (strpos($column, 'AS')) {
                 $result = explode('AS', $column);
                 $data[] = array('column' => trim(trim($result[0]), '`'), 'alias' => trim(trim($result[1]), '`'));
             } elseif (count($column_saperate = explode(' ', $column)) > 1) {
                 $reverse_column = array_reverse($column_saperate);
                 $data[] = array('column' => trim(trim($column_saperate[0]), '`'), 'alias' => $reverse_column[0]);
             } else {
                 $data[] = array('column' => trim($column, '`'), 'alias' => '');
             }
         }
         return $data;
     } else {
         return array();
     }
 }
コード例 #3
0
ファイル: Object.php プロジェクト: spyp/parse-php-sql
 /**
  * get joins tables and condition of them
  */
 public function joins()
 {
     $string = 'JOIN';
     $positions = String::findPositions($this->sql, $string);
     if (count($positions)) {
         // check on join or more
         if (count($positions) == 1) {
             // we have usually USING or ON in joins mysql so we get tables and alias of theme
             $table = String::getBetween($this->sql, 'JOIN', 'ON');
             if (!$table) {
                 $table = String::getBetween($this->sql, 'JOIN', 'USING');
             }
             if (!$table) {
                 return array();
             }
             $aliases = $this->getAliases($table);
             return array(array('table' => trim(trim($aliases[0]), '`'), 'alias' => isset($aliases[1]) ? trim(trim($aliases[1]), '`') : ''));
         } else {
             $tables = array();
             $index = 0;
             foreach ($positions as $key => $position) {
                 $index++;
                 $next_position = String::findPositions($this->sql, 'ON', $position, false);
                 if (!count($next_position)) {
                     $next_position = String::findPositions($this->sql, 'USING', $position, false);
                 }
                 if (!count($next_position)) {
                     continue;
                 } else {
                     $next_position = $next_position[0];
                     if (isset($positions[$index]) && $next_position > $positions[$index]) {
                         continue;
                     }
                     $length = $next_position - $position;
                     $table = substr($this->sql, $position + strlen('JOIN'), $length - strlen('JOIN'));
                     $aliases = $this->getAliases($table);
                     $tables[] = array('table' => trim(trim($aliases[0]), '`'), 'alias' => isset($aliases[1]) ? trim(trim($aliases[1]), '`') : '');
                 }
             }
             return $tables;
         }
     } else {
         return array();
     }
 }
コード例 #4
0
ファイル: index.php プロジェクト: spyp/parse-php-sql
<?php

require_once dirname(__FILE__) . '/vendor/autoload.php';
$parser = new PHPParser\Parser('SELECT * FROM ps_user');
use PHPParser\Tools\String;
echo String::getBetween('SELECT', 's', 'l');