3v4l.org

run code in 300+ PHP versions simultaneously
<?php $fields = array( 'np.title `partner`', 'fm.fmid', 'n.nid', 'ws.sid', 'n.language', ); $extra = array('adgroup', 'campaign', 'content', 'source', 'term', 'mobile', 'tablet'); foreach ($extra as $field) { $fields[] = "{$field}.`value` `{$field}`"; } $extra = array_combine($extra, $extra); $sql = 'INSERT INTO {report_generic_report} SELECT ' . implode(', ', $fields) . ", ws.submitted, ps.doi FROM {form_map_history{$suffix}} fmh JOIN {form_map} fm ON fmh.fmid = fm.fmid JOIN {node} np ON fm.vid = np.vid JOIN {webform_submissions{$suffix}} ws ON fmh.sid = ws.sid JOIN {partner_submission{$suffix}} ps ON ws.sid = ps.sid AND fm.vid = ps.vid JOIN {node} n ON ws.nid = n.nid"; foreach ($extra as $field) { $sql .= " LEFT JOIN {webform_submission_extra{$suffix}} `{$field}` ON ws.sid = `{$field}`.sid AND `{$field}`.`name` = '{$field}'"; } $sql .= " WHERE ws.submitted BETWEEN %d AND %d"; if ($form_state['values']['language']) { $sql .= " AND n.`language` = '".$form_state['values']['language']."'"; } $sql .= " ORDER BY `partner`, sid";
Finding entry points
Branch analysis from position: 0
2 jumps found. (Code = 77) Position 1 = 3, Position 2 = 11
Branch analysis from position: 3
2 jumps found. (Code = 78) Position 1 = 4, Position 2 = 11
Branch analysis from position: 4
1 jumps found. (Code = 42) Position 1 = 3
Branch analysis from position: 3
Branch analysis from position: 11
2 jumps found. (Code = 77) Position 1 = 32, Position 2 = 46
Branch analysis from position: 32
2 jumps found. (Code = 78) Position 1 = 33, Position 2 = 46
Branch analysis from position: 33
1 jumps found. (Code = 42) Position 1 = 32
Branch analysis from position: 32
Branch analysis from position: 46
2 jumps found. (Code = 43) Position 1 = 51, Position 2 = 56
Branch analysis from position: 51
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 56
Branch analysis from position: 46
Branch analysis from position: 11
filename:       /in/vKLM3
function name:  (null)
number of ops:  58
compiled vars:  !0 = $fields, !1 = $extra, !2 = $field, !3 = $sql, !4 = $suffix, !5 = $form_state
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    3     0  E >   ASSIGN                                                   !0, <array>
   11     1        ASSIGN                                                   !1, <array>
   12     2      > FE_RESET_R                                       $8      !1, ->11
          3    > > FE_FETCH_R                                               $8, !2, ->11
   13     4    >   ROPE_INIT                                     4  ~11     !2
          5        ROPE_ADD                                      1  ~11     ~11, '.%60value%60+%60'
          6        ROPE_ADD                                      2  ~11     ~11, !2
          7        ROPE_END                                      3  ~10     ~11, '%60'
          8        ASSIGN_DIM                                               !0
          9        OP_DATA                                                  ~10
   12    10      > JMP                                                      ->3
         11    >   FE_FREE                                                  $8
   15    12        INIT_FCALL                                               'array_combine'
         13        SEND_VAR                                                 !1
         14        SEND_VAR                                                 !1
         15        DO_ICALL                                         $13     
         16        ASSIGN                                                   !1, $13
   17    17        INIT_FCALL                                               'implode'
         18        SEND_VAL                                                 '%2C+'
         19        SEND_VAR                                                 !0
         20        DO_ICALL                                         $15     
         21        CONCAT                                           ~16     'INSERT+INTO+%7Breport_generic_report%7D+SELECT+', $15
         22        ROPE_INIT                                     7  ~18     '%2C+ws.submitted%2C+ps.doi+FROM+%7Bform_map_history'
         23        ROPE_ADD                                      1  ~18     ~18, !4
         24        ROPE_ADD                                      2  ~18     ~18, '%7D+fmh+JOIN+%7Bform_map%7D+fm+ON+fmh.fmid+%3D+fm.fmid+JOIN+%7Bnode%7D+np+ON+fm.vid+%3D+np.vid+JOIN+%7Bwebform_submissions'
         25        ROPE_ADD                                      3  ~18     ~18, !4
         26        ROPE_ADD                                      4  ~18     ~18, '%7D+ws+ON+fmh.sid+%3D+ws.sid+JOIN+%7Bpartner_submission'
         27        ROPE_ADD                                      5  ~18     ~18, !4
         28        ROPE_END                                      6  ~17     ~18, '%7D+ps+ON+ws.sid+%3D+ps.sid+AND+fm.vid+%3D+ps.vid+JOIN+%7Bnode%7D+n+ON+ws.nid+%3D+n.nid'
         29        CONCAT                                           ~22     ~16, ~17
         30        ASSIGN                                                   !3, ~22
   18    31      > FE_RESET_R                                       $24     !1, ->46
         32    > > FE_FETCH_R                                               $24, !2, ->46
   19    33    >   ROPE_INIT                                    11  ~26     '+LEFT+JOIN+%7Bwebform_submission_extra'
         34        ROPE_ADD                                      1  ~26     ~26, !4
         35        ROPE_ADD                                      2  ~26     ~26, '%7D+%60'
         36        ROPE_ADD                                      3  ~26     ~26, !2
         37        ROPE_ADD                                      4  ~26     ~26, '%60+ON+ws.sid+%3D+%60'
         38        ROPE_ADD                                      5  ~26     ~26, !2
         39        ROPE_ADD                                      6  ~26     ~26, '%60.sid+AND+%60'
         40        ROPE_ADD                                      7  ~26     ~26, !2
         41        ROPE_ADD                                      8  ~26     ~26, '%60.%60name%60+%3D+%27'
         42        ROPE_ADD                                      9  ~26     ~26, !2
         43        ROPE_END                                     10  ~25     ~26, '%27'
         44        ASSIGN_OP                                     8          !3, ~25
   18    45      > JMP                                                      ->32
         46    >   FE_FREE                                                  $24
   21    47        ASSIGN_OP                                     8          !3, '+WHERE+ws.submitted+BETWEEN+%25d+AND+%25d'
   22    48        FETCH_DIM_R                                      ~34     !5, 'values'
         49        FETCH_DIM_R                                      ~35     ~34, 'language'
         50      > JMPZ                                                     ~35, ->56
   23    51    >   FETCH_DIM_R                                      ~36     !5, 'values'
         52        FETCH_DIM_R                                      ~37     ~36, 'language'
         53        CONCAT                                           ~38     '+AND+n.%60language%60+%3D+%27', ~37
         54        CONCAT                                           ~39     ~38, '%27'
         55        ASSIGN_OP                                     8          !3, ~39
   25    56    >   ASSIGN_OP                                     8          !3, '+ORDER+BY+%60partner%60%2C+sid'
         57      > RETURN                                                   1

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
173.52 ms | 945 KiB | 18 Q