3v4l.org

run code in 300+ PHP versions simultaneously
<?php function checkParameters(string $sql) { $countNamed = 0; $countUnnamed = 0; $inQuote = false; for ($i = 0; $i < strlen($sql); ++ $i) { if ($inQuote) { if ($sql[$i] == $quote) { $inQuote = false; continue; } } else { if (in_array($sql[$i], ['"', "'"])) { $quote = $sql[$i]; continue; } } if ($sql[$i] == ':') { $countUnnamed ++; } elseif ($sql[$i] == '?') { $countNamed ++; } } if ($countNamed && $countUnnamed) { throw new Exception("mixed parms in: $sql" . PHP_EOL); } } $sql = "SELECT a, b FROM someTable WHERE a = '?' AND b = :id"; // checkParameters($sql); $sql = "SELECT a, b FROM someTable WHERE a = ? AND b = :id"; // checkParameters($sql); $sql = "SELECT a, b FROM someTable WHERE a = '?' AND b = :id"; checkParameters($sql);
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/Rc7B6
function name:  (null)
number of ops:  7
compiled vars:  !0 = $sql
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   37     0  E >   ASSIGN                                                   !0, 'SELECT+a%2C+b+FROM+someTable+WHERE+a+%3D+%27%3F%27+AND+b+%3D+%3Aid'
   40     1        ASSIGN                                                   !0, 'SELECT+a%2C+b+FROM+someTable+WHERE+a+%3D+%3F+AND+b+%3D+%3Aid'
   43     2        ASSIGN                                                   !0, 'SELECT+a%2C+b+FROM+someTable+WHERE+a+%3D+%27%3F%27+AND+b+%3D+%3Aid'
   44     3        INIT_FCALL                                               'checkparameters'
          4        SEND_VAR                                                 !0
          5        DO_FCALL                                      0          
          6      > RETURN                                                   1

Function checkparameters:
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 42) Position 1 = 29
Branch analysis from position: 29
2 jumps found. (Code = 44) Position 1 = 32, Position 2 = 6
Branch analysis from position: 32
2 jumps found. (Code = 46) Position 1 = 33, Position 2 = 34
Branch analysis from position: 33
2 jumps found. (Code = 43) Position 1 = 35, Position 2 = 42
Branch analysis from position: 35
1 jumps found. (Code = 108) Position 1 = -2
Branch analysis from position: 42
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 34
Branch analysis from position: 6
2 jumps found. (Code = 43) Position 1 = 7, Position 2 = 13
Branch analysis from position: 7
2 jumps found. (Code = 43) Position 1 = 10, Position 2 = 12
Branch analysis from position: 10
1 jumps found. (Code = 42) Position 1 = 28
Branch analysis from position: 28
2 jumps found. (Code = 44) Position 1 = 32, Position 2 = 6
Branch analysis from position: 32
Branch analysis from position: 6
Branch analysis from position: 12
1 jumps found. (Code = 42) Position 1 = 19
Branch analysis from position: 19
2 jumps found. (Code = 43) Position 1 = 22, Position 2 = 24
Branch analysis from position: 22
1 jumps found. (Code = 42) Position 1 = 28
Branch analysis from position: 28
Branch analysis from position: 24
2 jumps found. (Code = 43) Position 1 = 27, Position 2 = 28
Branch analysis from position: 27
2 jumps found. (Code = 44) Position 1 = 32, Position 2 = 6
Branch analysis from position: 32
Branch analysis from position: 6
Branch analysis from position: 28
Branch analysis from position: 13
2 jumps found. (Code = 43) Position 1 = 16, Position 2 = 19
Branch analysis from position: 16
1 jumps found. (Code = 42) Position 1 = 28
Branch analysis from position: 28
Branch analysis from position: 19
filename:       /in/Rc7B6
function name:  checkParameters
number of ops:  43
compiled vars:  !0 = $sql, !1 = $countNamed, !2 = $countUnnamed, !3 = $inQuote, !4 = $i, !5 = $quote
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    3     0  E >   RECV                                             !0      
    4     1        ASSIGN                                                   !1, 0
    5     2        ASSIGN                                                   !2, 0
    7     3        ASSIGN                                                   !3, <false>
    9     4        ASSIGN                                                   !4, 0
          5      > JMP                                                      ->29
   10     6    > > JMPZ                                                     !3, ->13
   11     7    >   FETCH_DIM_R                                      ~10     !0, !4
          8        IS_EQUAL                                                 !5, ~10
          9      > JMPZ                                                     ~11, ->12
   12    10    >   ASSIGN                                                   !3, <false>
   13    11      > JMP                                                      ->28
         12    > > JMP                                                      ->19
   17    13    >   FETCH_DIM_R                                      ~13     !0, !4
         14        IN_ARRAY                                                 ~13, <array>
         15      > JMPZ                                                     ~14, ->19
   18    16    >   FETCH_DIM_R                                      ~15     !0, !4
         17        ASSIGN                                                   !5, ~15
   19    18      > JMP                                                      ->28
   23    19    >   FETCH_DIM_R                                      ~17     !0, !4
         20        IS_EQUAL                                                 ~17, '%3A'
         21      > JMPZ                                                     ~18, ->24
   24    22    >   PRE_INC                                                  !2
         23      > JMP                                                      ->28
   26    24    >   FETCH_DIM_R                                      ~20     !0, !4
         25        IS_EQUAL                                                 ~20, '%3F'
         26      > JMPZ                                                     ~21, ->28
   27    27    >   PRE_INC                                                  !1
    9    28    >   PRE_INC                                                  !4
         29    >   STRLEN                                           ~24     !0
         30        IS_SMALLER                                               !4, ~24
         31      > JMPNZ                                                    ~25, ->6
   31    32    > > JMPZ_EX                                          ~26     !1, ->34
         33    >   BOOL                                             ~26     !2
         34    > > JMPZ                                                     ~26, ->42
   32    35    >   NEW                                              $27     'Exception'
         36        NOP                                                      
         37        FAST_CONCAT                                      ~28     'mixed+parms+in%3A+', !0
         38        CONCAT                                           ~29     ~28, '%0A'
         39        SEND_VAL_EX                                              ~29
         40        DO_FCALL                                      0          
         41      > THROW                                         0          $27
   34    42    > > RETURN                                                   null

End of function checkparameters

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
169.54 ms | 1402 KiB | 14 Q