3v4l.org

run code in 300+ PHP versions simultaneously
<?php class SlightlyLessBollocksMySQLi { public function prepareWithParams($query, $params) { $tokens = $this->getQueryTokens($query); $query = ''; $args = $paramRefs = []; $i = 1; foreach ($tokens as $token) { if ($token !== '?') { $query .= $token; continue; } $paramRefs[$i] = array_shift($params); switch (true) { case is_array($paramRefs[$i]): $query .= implode(', ', array_fill(0, count($paramRefs[$i]), '?')); $tmp = $paramRefs[$i]; array_splice($paramRefs, $i, 1, $tmp); foreach ($tmp as $val) { switch (true) { case is_int($val): $args[0] .= 'i'; break; case is_float($val): $args[0] .= 'd'; break; default: $args[0] .= 's'; break; } } for ($j = $i; isset($paramRefs[$j]); $j++) { $args[] = &$paramRefs[$j]; } $i = $j; break; case is_int($paramRefs[$i]): $args[0] .= 'i'; $query .= '?'; $args[] = &$paramRefs[$i++]; break; case is_float($paramRefs[$i]): $args[0] .= 'd'; $query .= '?'; $args[] = &$paramRefs[$i++]; break; default: $args[0] .= 's'; $query .= '?'; $paramRefs[$i] = (string)$paramRefs[$i]; $args[$i] = &$paramRefs[$i]; break; } } var_dump($query, $args); } /** * @param string $token * @return bool */ private function isQuotedString($token) { return in_array($token[0], array('"', "'")) && $token[0] == $token[strlen($token) - 1]; } /** * "Tokenize" the query * * Actually all this does is split the query up into things that are and are not quoted strings, to avoid treating * a literal question mark as a placeholder. * * @param string $query * @return string[] */ private function getQueryTokens($query) { static $expr = '/("(?:[^"\\\\]*(?:\\\\.[^"\\\\]*)*)"|\'(?:[^\'\\\\]*(?:\\\\.[^\'\\\\]*)*)\')/'; $tokens = []; foreach (preg_split($expr, $query, -1, PREG_SPLIT_DELIM_CAPTURE | PREG_SPLIT_NO_EMPTY) as $token) { if ($this->isQuotedString($token)) { $tokens[] = $token; } else { $tokens = array_merge($tokens, preg_split('/(\?)/', $token, -1, PREG_SPLIT_DELIM_CAPTURE)); } } return $tokens; } } (new SlightlyLessBollocksMySQLi)->prepareWithParams("SELECT * FROM foo WHERE 'a' = b AND foo = ? AND bar IN(?)", [2, [1, 2, 12.345, "hello"]]);
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/m68BC
function name:  (null)
number of ops:  7
compiled vars:  none
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   99     0  E >   NEW                                              $0      'SlightlyLessBollocksMySQLi'
          1        DO_FCALL                                      0          
          2        INIT_METHOD_CALL                                         $0, 'prepareWithParams'
          3        SEND_VAL_EX                                              'SELECT+%2A+FROM+foo+WHERE+%27a%27+%3D+b+AND+foo+%3D+%3F+AND+bar+IN%28%3F%29'
          4        SEND_VAL_EX                                              <array>
          5        DO_FCALL                                      0          
          6      > RETURN                                                   1

Class SlightlyLessBollocksMySQLi:
Function preparewithparams:
Finding entry points
Branch analysis from position: 0
2 jumps found. (Code = 77) Position 1 = 11, Position 2 = 111
Branch analysis from position: 11
2 jumps found. (Code = 78) Position 1 = 12, Position 2 = 111
Branch analysis from position: 12
2 jumps found. (Code = 43) Position 1 = 14, Position 2 = 16
Branch analysis from position: 14
1 jumps found. (Code = 42) Position 1 = 11
Branch analysis from position: 11
Branch analysis from position: 16
2 jumps found. (Code = 44) Position 1 = 24, Position 2 = 31
Branch analysis from position: 24
2 jumps found. (Code = 44) Position 1 = 27, Position 2 = 80
Branch analysis from position: 27
2 jumps found. (Code = 44) Position 1 = 30, Position 2 = 89
Branch analysis from position: 30
1 jumps found. (Code = 42) Position 1 = 98
Branch analysis from position: 98
1 jumps found. (Code = 42) Position 1 = 110
Branch analysis from position: 110
1 jumps found. (Code = 42) Position 1 = 11
Branch analysis from position: 11
Branch analysis from position: 89
1 jumps found. (Code = 42) Position 1 = 110
Branch analysis from position: 110
Branch analysis from position: 80
1 jumps found. (Code = 42) Position 1 = 110
Branch analysis from position: 110
Branch analysis from position: 31
2 jumps found. (Code = 77) Position 1 = 52, Position 2 = 68
Branch analysis from position: 52
2 jumps found. (Code = 78) Position 1 = 53, Position 2 = 68
Branch analysis from position: 53
2 jumps found. (Code = 44) Position 1 = 55, Position 2 = 58
Branch analysis from position: 55
2 jumps found. (Code = 44) Position 1 = 57, Position 2 = 61
Branch analysis from position: 57
1 jumps found. (Code = 42) Position 1 = 64
Branch analysis from position: 64
1 jumps found. (Code = 42) Position 1 = 67
Branch analysis from position: 67
1 jumps found. (Code = 42) Position 1 = 52
Branch analysis from position: 52
Branch analysis from position: 61
1 jumps found. (Code = 42) Position 1 = 67
Branch analysis from position: 67
Branch analysis from position: 58
1 jumps found. (Code = 42) Position 1 = 67
Branch analysis from position: 67
Branch analysis from position: 68
1 jumps found. (Code = 42) Position 1 = 76
Branch analysis from position: 76
2 jumps found. (Code = 44) Position 1 = 78, Position 2 = 71
Branch analysis from position: 78
1 jumps found. (Code = 42) Position 1 = 110
Branch analysis from position: 110
Branch analysis from position: 71
2 jumps found. (Code = 44) Position 1 = 78, Position 2 = 71
Branch analysis from position: 78
Branch analysis from position: 71
Branch analysis from position: 68
Branch analysis from position: 111
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 111
filename:       /in/m68BC
function name:  prepareWithParams
number of ops:  117
compiled vars:  !0 = $query, !1 = $params, !2 = $tokens, !3 = $args, !4 = $paramRefs, !5 = $i, !6 = $token, !7 = $tmp, !8 = $val, !9 = $j
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    5     0  E >   RECV                                             !0      
          1        RECV                                             !1      
    7     2        INIT_METHOD_CALL                                         'getQueryTokens'
          3        SEND_VAR_EX                                              !0
          4        DO_FCALL                                      0  $10     
          5        ASSIGN                                                   !2, $10
    8     6        ASSIGN                                                   !0, ''
    9     7        ASSIGN                                           ~13     !4, <array>
          8        ASSIGN                                                   !3, ~13
   10     9        ASSIGN                                                   !5, 1
   12    10      > FE_RESET_R                                       $16     !2, ->111
         11    > > FE_FETCH_R                                               $16, !6, ->111
   13    12    >   IS_NOT_IDENTICAL                                         !6, '%3F'
         13      > JMPZ                                                     ~17, ->16
   14    14    >   ASSIGN_OP                                     8          !0, !6
   15    15      > JMP                                                      ->11
   18    16    >   INIT_FCALL                                               'array_shift'
         17        SEND_REF                                                 !1
         18        DO_ICALL                                         $20     
         19        ASSIGN_DIM                                               !4, !5
         20        OP_DATA                                                  $20
   20    21        FETCH_DIM_R                                      ~22     !4, !5
         22        TYPE_CHECK                                  128          ~22
         23      > JMPNZ                                                    ~23, ->31
   41    24    >   FETCH_DIM_R                                      ~24     !4, !5
         25        TYPE_CHECK                                   16          ~24
         26      > JMPNZ                                                    ~25, ->80
   47    27    >   FETCH_DIM_R                                      ~26     !4, !5
         28        TYPE_CHECK                                   32          ~26
         29      > JMPNZ                                                    ~27, ->89
         30    > > JMP                                                      ->98
   21    31    >   INIT_FCALL                                               'implode'
         32        SEND_VAL                                                 '%2C+'
         33        INIT_FCALL                                               'array_fill'
         34        SEND_VAL                                                 0
         35        FETCH_DIM_R                                      ~28     !4, !5
         36        COUNT                                            ~29     ~28
         37        SEND_VAL                                                 ~29
         38        SEND_VAL                                                 '%3F'
         39        DO_ICALL                                         $30     
         40        SEND_VAR                                                 $30
         41        DO_ICALL                                         $31     
         42        ASSIGN_OP                                     8          !0, $31
   23    43        FETCH_DIM_R                                      ~33     !4, !5
         44        ASSIGN                                                   !7, ~33
   24    45        INIT_FCALL                                               'array_splice'
         46        SEND_REF                                                 !4
         47        SEND_VAR                                                 !5
         48        SEND_VAL                                                 1
         49        SEND_VAR                                                 !7
         50        DO_ICALL                                                 
   26    51      > FE_RESET_R                                       $36     !7, ->68
         52    > > FE_FETCH_R                                               $36, !8, ->68
   28    53    >   TYPE_CHECK                                   16          !8
         54      > JMPNZ                                                    ~38, ->58
   29    55    >   TYPE_CHECK                                   32          !8
         56      > JMPNZ                                                    ~39, ->61
         57    > > JMP                                                      ->64
   28    58    >   ASSIGN_DIM_OP                .=               8          !3, 0
         59        OP_DATA                                                  'i'
         60      > JMP                                                      ->67
   29    61    >   ASSIGN_DIM_OP                .=               8          !3, 0
         62        OP_DATA                                                  'd'
         63      > JMP                                                      ->67
   30    64    >   ASSIGN_DIM_OP                .=               8          !3, 0
         65        OP_DATA                                                  's'
         66      > JMP                                                      ->67
   26    67    > > JMP                                                      ->52
         68    >   FE_FREE                                                  $36
   34    69        ASSIGN                                                   !9, !5
         70      > JMP                                                      ->76
   35    71    >   FETCH_DIM_W                                      $45     !4, !9
         72        MAKE_REF                                         $46     $45
         73        FETCH_DIM_W                                      $44     !3
         74        ASSIGN_REF                                               $44, $46
   34    75        PRE_INC                                                  !9
         76    >   ISSET_ISEMPTY_DIM_OBJ                         0          !4, !9
         77      > JMPNZ                                                    ~49, ->71
   38    78    >   ASSIGN                                                   !5, !9
   39    79      > JMP                                                      ->110
   42    80    >   ASSIGN_DIM_OP                .=               8          !3, 0
         81        OP_DATA                                                  'i'
   43    82        ASSIGN_OP                                     8          !0, '%3F'
   44    83        POST_INC                                         ~54     !5
         84        FETCH_DIM_W                                      $55     !4, ~54
         85        MAKE_REF                                         $56     $55
         86        FETCH_DIM_W                                      $53     !3
         87        ASSIGN_REF                                               $53, $56
   45    88      > JMP                                                      ->110
   48    89    >   ASSIGN_DIM_OP                .=               8          !3, 0
         90        OP_DATA                                                  'd'
   49    91        ASSIGN_OP                                     8          !0, '%3F'
   50    92        POST_INC                                         ~61     !5
         93        FETCH_DIM_W                                      $62     !4, ~61
         94        MAKE_REF                                         $63     $62
         95        FETCH_DIM_W                                      $60     !3
         96        ASSIGN_REF                                               $60, $63
   51    97      > JMP                                                      ->110
   54    98    >   ASSIGN_DIM_OP                .=               8          !3, 0
         99        OP_DATA                                                  's'
   55   100        ASSIGN_OP                                     8          !0, '%3F'
   56   101        FETCH_DIM_R                                      ~68     !4, !5
        102        CAST                                          6  ~69     ~68
        103        ASSIGN_DIM                                               !4, !5
        104        OP_DATA                                                  ~69
   57   105        FETCH_DIM_W                                      $71     !4, !5
        106        MAKE_REF                                         $72     $71
        107        FETCH_DIM_W                                      $70     !3, !5
        108        ASSIGN_REF                                               $70, $72
   58   109      > JMP                                                      ->110
   12   110    > > JMP                                                      ->11
        111    >   FE_FREE                                                  $16
   62   112        INIT_FCALL                                               'var_dump'
        113        SEND_VAR                                                 !0
        114        SEND_VAR                                                 !3
        115        DO_ICALL                                                 
   63   116      > RETURN                                                   null

End of function preparewithparams

Function isquotedstring:
Finding entry points
Branch analysis from position: 0
2 jumps found. (Code = 46) Position 1 = 4, Position 2 = 10
Branch analysis from position: 4
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 10
filename:       /in/m68BC
function name:  isQuotedString
number of ops:  12
compiled vars:  !0 = $token
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   69     0  E >   RECV                                             !0      
   70     1        FETCH_DIM_R                                      ~1      !0, 0
          2        IN_ARRAY                                         ~2      ~1, <array>
          3      > JMPZ_EX                                          ~2      ~2, ->10
          4    >   FETCH_DIM_R                                      ~3      !0, 0
          5        STRLEN                                           ~4      !0
          6        SUB                                              ~5      ~4, 1
          7        FETCH_DIM_R                                      ~6      !0, ~5
          8        IS_EQUAL                                         ~7      ~3, ~6
          9        BOOL                                             ~2      ~7
         10    > > RETURN                                                   ~2
   71    11*     > RETURN                                                   null

End of function isquotedstring

Function getquerytokens:
Finding entry points
Branch analysis from position: 0
2 jumps found. (Code = 77) Position 1 = 10, Position 2 = 30
Branch analysis from position: 10
2 jumps found. (Code = 78) Position 1 = 11, Position 2 = 30
Branch analysis from position: 11
2 jumps found. (Code = 43) Position 1 = 15, Position 2 = 18
Branch analysis from position: 15
1 jumps found. (Code = 42) Position 1 = 29
Branch analysis from position: 29
1 jumps found. (Code = 42) Position 1 = 10
Branch analysis from position: 10
Branch analysis from position: 18
1 jumps found. (Code = 42) Position 1 = 10
Branch analysis from position: 10
Branch analysis from position: 30
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 30
filename:       /in/m68BC
function name:  getQueryTokens
number of ops:  33
compiled vars:  !0 = $query, !1 = $expr, !2 = $tokens, !3 = $token
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   82     0  E >   RECV                                             !0      
   83     1        BIND_STATIC                                              !1
   84     2        ASSIGN                                                   !2, <array>
   86     3        INIT_FCALL                                               'preg_split'
          4        SEND_VAR                                                 !1
          5        SEND_VAR                                                 !0
          6        SEND_VAL                                                 -1
          7        SEND_VAL                                                 3
          8        DO_ICALL                                         $5      
          9      > FE_RESET_R                                       $6      $5, ->30
         10    > > FE_FETCH_R                                               $6, !3, ->30
   87    11    >   INIT_METHOD_CALL                                         'isQuotedString'
         12        SEND_VAR                                                 !3
         13        DO_FCALL                                      0  $7      
         14      > JMPZ                                                     $7, ->18
   88    15    >   ASSIGN_DIM                                               !2
         16        OP_DATA                                                  !3
         17      > JMP                                                      ->29
   90    18    >   INIT_FCALL                                               'array_merge'
         19        SEND_VAR                                                 !2
         20        INIT_FCALL                                               'preg_split'
         21        SEND_VAL                                                 '%2F%28%5C%3F%29%2F'
         22        SEND_VAR                                                 !3
         23        SEND_VAL                                                 -1
         24        SEND_VAL                                                 2
         25        DO_ICALL                                         $9      
         26        SEND_VAR                                                 $9
         27        DO_ICALL                                         $10     
         28        ASSIGN                                                   !2, $10
   86    29    > > JMP                                                      ->10
         30    >   FE_FREE                                                  $6
   94    31      > RETURN                                                   !2
   95    32*     > RETURN                                                   null

End of function getquerytokens

End of class SlightlyLessBollocksMySQLi.

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
185.68 ms | 1412 KiB | 27 Q