3v4l.org

run code in 300+ PHP versions simultaneously
<?php /** * @return mixed[] An array containing two elements: the modified SQL query (string), and the modified params (array). */ function unnameSqlParameters(string $sql, array $params): array { $newParams = []; $newSql = preg_replace_callback( '/:(\w+)/', static function (array $matches) use ($params, &$newParams): string { $name = $matches[1]; if (!array_key_exists($name, $params)) { throw new \RuntimeException("Cannot find parameter value for :{$name}."); } $newParams[] = $params[$name]; return '?'; }, $sql ); return [$newSql, $newParams]; } [$sql, $params] = unnameSqlParameters( 'INSERT INTO table1 (a, b, c) VALUES (:a, :b, :c)', ['a' => 'ValueA', 'c' => 'ValueC', 'b' => 'ValueB'] ); echo $sql, PHP_EOL; print_r($params);
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/TTJVg
function name:  (null)
number of ops:  15
compiled vars:  !0 = $sql, !1 = $params
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   29     0  E >   INIT_FCALL                                               'unnamesqlparameters'
   30     1        SEND_VAL                                                 'INSERT+INTO+table1+%28a%2C+b%2C+c%29+VALUES+%28%3Aa%2C+%3Ab%2C+%3Ac%29'
   31     2        SEND_VAL                                                 <array>
   29     3        DO_FCALL                                      0  $2      
   31     4        FETCH_LIST_R                                     $3      $2, 0
   29     5        ASSIGN                                                   !0, $3
          6        FETCH_LIST_R                                     $5      $2, 1
          7        ASSIGN                                                   !1, $5
          8        FREE                                                     $2
   34     9        ECHO                                                     !0
         10        ECHO                                                     '%0A'
   35    11        INIT_FCALL                                               'print_r'
         12        SEND_VAR                                                 !1
         13        DO_ICALL                                                 
         14      > RETURN                                                   1

Function unnamesqlparameters:
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/TTJVg
function name:  unnameSqlParameters
number of ops:  18
compiled vars:  !0 = $sql, !1 = $params, !2 = $newParams, !3 = $newSql
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    6     0  E >   RECV                                             !0      
          1        RECV                                             !1      
    8     2        ASSIGN                                                   !2, <array>
   10     3        INIT_FCALL                                               'preg_replace_callback'
   11     4        SEND_VAL                                                 '%2F%3A%28%5Cw%2B%29%2F'
   12     5        DECLARE_LAMBDA_FUNCTION                          ~5      [0]
          6        BIND_LEXICAL                                             ~5, !1
          7        BIND_LEXICAL                                             ~5, !2
   22     8        SEND_VAL                                                 ~5
   23     9        SEND_VAR                                                 !0
   10    10        DO_ICALL                                         $6      
         11        ASSIGN                                                   !3, $6
   26    12        INIT_ARRAY                                       ~8      !3
         13        ADD_ARRAY_ELEMENT                                ~8      !2
         14        VERIFY_RETURN_TYPE                                       ~8
         15      > RETURN                                                   ~8
   27    16*       VERIFY_RETURN_TYPE                                       
         17*     > RETURN                                                   null


Dynamic Functions:
Dynamic Function 0
Finding entry points
Branch analysis from position: 0
2 jumps found. (Code = 43) Position 1 = 8, Position 2 = 15
Branch analysis from position: 8
1 jumps found. (Code = 108) Position 1 = -2
Branch analysis from position: 15
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/TTJVg
function name:  {closure}
number of ops:  21
compiled vars:  !0 = $matches, !1 = $params, !2 = $newParams, !3 = $name
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   12     0  E >   RECV                                             !0      
          1        BIND_STATIC                                              !1
          2        BIND_STATIC                                              !2
   13     3        FETCH_DIM_R                                      ~4      !0, 1
          4        ASSIGN                                                   !3, ~4
   15     5        ARRAY_KEY_EXISTS                                 ~6      !3, !1
          6        BOOL_NOT                                         ~7      ~6
          7      > JMPZ                                                     ~7, ->15
   16     8    >   NEW                                              $8      'RuntimeException'
          9        ROPE_INIT                                     3  ~10     'Cannot+find+parameter+value+for+%3A'
         10        ROPE_ADD                                      1  ~10     ~10, !3
         11        ROPE_END                                      2  ~9      ~10, '.'
         12        SEND_VAL_EX                                              ~9
         13        DO_FCALL                                      0          
         14      > THROW                                         0          $8
   19    15    >   FETCH_DIM_R                                      ~14     !1, !3
         16        ASSIGN_DIM                                               !2
         17        OP_DATA                                                  ~14
   21    18      > RETURN                                                   '%3F'
   22    19*       VERIFY_RETURN_TYPE                                       
         20*     > RETURN                                                   null

End of Dynamic Function 0

End of function unnamesqlparameters

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
134.82 ms | 1019 KiB | 16 Q