3v4l.org

run code in 300+ PHP versions simultaneously
<?php function pdo_named_in_clause_from_array($array, $name = 'in') { $in = $data = array(); $i = 0; $name = preg_replace('/[^a-z0-9_]+/', '', (string)$name); if (!preg_match('/^[a-z]/i', $name)) { throw new \InvalidArgumentException('Placeholder name ' . $name . ': must begin with a letter'); } foreach ($array as $value) { $key = $name . $i++; $in[] = ':' . $key; $data[$key] = $value; } return array(implode(', ', $in), $data); } $inList = [1, 2, 3]; list($inClause, $inData) = pdo_named_in_clause_from_array($inList, 'id'); $query = " UPDATE table SET value1 = :val1, value2 = :val2 WHERE id IN (" . $inClause . ") "; $data = array('val1' => 'Hello', 'val2' => 'World') + $inData; var_dump($query, $data); /* $stmt = $db->prepare($query); $stmt->execute($data); */
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/KtWlv
function name:  (null)
number of ops:  20
compiled vars:  !0 = $inList, !1 = $inClause, !2 = $inData, !3 = $query, !4 = $data
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   21     0  E >   ASSIGN                                                   !0, <array>
   23     1        INIT_FCALL                                               'pdo_named_in_clause_from_array'
          2        SEND_VAR                                                 !0
          3        SEND_VAL                                                 'id'
          4        DO_FCALL                                      0  $6      
          5        FETCH_LIST_R                                     $7      $6, 0
          6        ASSIGN                                                   !1, $7
          7        FETCH_LIST_R                                     $9      $6, 1
          8        ASSIGN                                                   !2, $9
          9        FREE                                                     $6
   28    10        CONCAT                                           ~11     '%0A++UPDATE+table%0A++SET+value1+%3D+%3Aval1%2C+value2+%3D+%3Aval2%0A++WHERE+id+IN+%28', !1
         11        CONCAT                                           ~12     ~11, '%29%0A'
   25    12        ASSIGN                                                   !3, ~12
   30    13        ADD                                              ~14     <array>, !2
         14        ASSIGN                                                   !4, ~14
   32    15        INIT_FCALL                                               'var_dump'
         16        SEND_VAR                                                 !3
         17        SEND_VAR                                                 !4
         18        DO_ICALL                                                 
   37    19      > RETURN                                                   1

Function pdo_named_in_clause_from_array:
Finding entry points
Branch analysis from position: 0
2 jumps found. (Code = 43) Position 1 = 18, Position 2 = 24
Branch analysis from position: 18
1 jumps found. (Code = 108) Position 1 = -2
Branch analysis from position: 24
2 jumps found. (Code = 77) Position 1 = 25, Position 2 = 35
Branch analysis from position: 25
2 jumps found. (Code = 78) Position 1 = 26, Position 2 = 35
Branch analysis from position: 26
1 jumps found. (Code = 42) Position 1 = 25
Branch analysis from position: 25
Branch analysis from position: 35
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 35
filename:       /in/KtWlv
function name:  pdo_named_in_clause_from_array
number of ops:  44
compiled vars:  !0 = $array, !1 = $name, !2 = $in, !3 = $data, !4 = $i, !5 = $value, !6 = $key
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    3     0  E >   RECV                                             !0      
          1        RECV_INIT                                        !1      'in'
    4     2        ASSIGN                                           ~7      !3, <array>
          3        ASSIGN                                                   !2, ~7
    5     4        ASSIGN                                                   !4, 0
    7     5        INIT_FCALL                                               'preg_replace'
          6        SEND_VAL                                                 '%2F%5B%5Ea-z0-9_%5D%2B%2F'
          7        SEND_VAL                                                 ''
          8        CAST                                          6  ~10     !1
          9        SEND_VAL                                                 ~10
         10        DO_ICALL                                         $11     
         11        ASSIGN                                                   !1, $11
    8    12        INIT_FCALL                                               'preg_match'
         13        SEND_VAL                                                 '%2F%5E%5Ba-z%5D%2Fi'
         14        SEND_VAR                                                 !1
         15        DO_ICALL                                         $13     
         16        BOOL_NOT                                         ~14     $13
         17      > JMPZ                                                     ~14, ->24
    9    18    >   NEW                                              $15     'InvalidArgumentException'
         19        CONCAT                                           ~16     'Placeholder+name+', !1
         20        CONCAT                                           ~17     ~16, '%3A+must+begin+with+a+letter'
         21        SEND_VAL_EX                                              ~17
         22        DO_FCALL                                      0          
         23      > THROW                                         0          $15
   12    24    > > FE_RESET_R                                       $19     !0, ->35
         25    > > FE_FETCH_R                                               $19, !5, ->35
   13    26    >   POST_INC                                         ~20     !4
         27        CONCAT                                           ~21     !1, ~20
         28        ASSIGN                                                   !6, ~21
   14    29        CONCAT                                           ~24     '%3A', !6
         30        ASSIGN_DIM                                               !2
         31        OP_DATA                                                  ~24
   15    32        ASSIGN_DIM                                               !3, !6
         33        OP_DATA                                                  !5
   12    34      > JMP                                                      ->25
         35    >   FE_FREE                                                  $19
   18    36        INIT_FCALL                                               'implode'
         37        SEND_VAL                                                 '%2C+'
         38        SEND_VAR                                                 !2
         39        DO_ICALL                                         $26     
         40        INIT_ARRAY                                       ~27     $26
         41        ADD_ARRAY_ELEMENT                                ~27     !3
         42      > RETURN                                                   ~27
   19    43*     > RETURN                                                   null

End of function pdo_named_in_clause_from_array

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
148.23 ms | 1403 KiB | 22 Q