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); $suffix = ''; $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"; print $sql;
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 = 33, Position 2 = 47
Branch analysis from position: 33
2 jumps found. (Code = 78) Position 1 = 34, Position 2 = 47
Branch analysis from position: 34
1 jumps found. (Code = 42) Position 1 = 33
Branch analysis from position: 33
Branch analysis from position: 47
2 jumps found. (Code = 43) Position 1 = 52, Position 2 = 57
Branch analysis from position: 52
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 57
Branch analysis from position: 47
Branch analysis from position: 11
filename:       /in/VWlZ8
function name:  (null)
number of ops:  60
compiled vars:  !0 = $fields, !1 = $extra, !2 = $field, !3 = $suffix, !4 = $sql, !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        ASSIGN                                                   !3, ''
   19    18        INIT_FCALL                                               'implode'
         19        SEND_VAL                                                 '%2C+'
         20        SEND_VAR                                                 !0
         21        DO_ICALL                                         $16     
         22        CONCAT                                           ~17     'INSERT+INTO+%7Breport_generic_report%7D+SELECT+', $16
         23        ROPE_INIT                                     7  ~19     '%2C+ws.submitted%2C+ps.doi+FROM+%7Bform_map_history'
         24        ROPE_ADD                                      1  ~19     ~19, !3
         25        ROPE_ADD                                      2  ~19     ~19, '%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'
         26        ROPE_ADD                                      3  ~19     ~19, !3
         27        ROPE_ADD                                      4  ~19     ~19, '%7D+ws+ON+fmh.sid+%3D+ws.sid+JOIN+%7Bpartner_submission'
         28        ROPE_ADD                                      5  ~19     ~19, !3
         29        ROPE_END                                      6  ~18     ~19, '%7D+ps+ON+ws.sid+%3D+ps.sid+AND+fm.vid+%3D+ps.vid+JOIN+%7Bnode%7D+n+ON+ws.nid+%3D+n.nid'
         30        CONCAT                                           ~23     ~17, ~18
         31        ASSIGN                                                   !4, ~23
   20    32      > FE_RESET_R                                       $25     !1, ->47
         33    > > FE_FETCH_R                                               $25, !2, ->47
   21    34    >   ROPE_INIT                                    11  ~27     '+LEFT+JOIN+%7Bwebform_submission_extra'
         35        ROPE_ADD                                      1  ~27     ~27, !3
         36        ROPE_ADD                                      2  ~27     ~27, '%7D+%60'
         37        ROPE_ADD                                      3  ~27     ~27, !2
         38        ROPE_ADD                                      4  ~27     ~27, '%60+ON+ws.sid+%3D+%60'
         39        ROPE_ADD                                      5  ~27     ~27, !2
         40        ROPE_ADD                                      6  ~27     ~27, '%60.sid+AND+%60'
         41        ROPE_ADD                                      7  ~27     ~27, !2
         42        ROPE_ADD                                      8  ~27     ~27, '%60.%60name%60+%3D+%27'
         43        ROPE_ADD                                      9  ~27     ~27, !2
         44        ROPE_END                                     10  ~26     ~27, '%27'
         45        ASSIGN_OP                                     8          !4, ~26
   20    46      > JMP                                                      ->33
         47    >   FE_FREE                                                  $25
   23    48        ASSIGN_OP                                     8          !4, '+WHERE+ws.submitted+BETWEEN+%25d+AND+%25d'
   24    49        FETCH_DIM_R                                      ~35     !5, 'values'
         50        FETCH_DIM_R                                      ~36     ~35, 'language'
         51      > JMPZ                                                     ~36, ->57
   25    52    >   FETCH_DIM_R                                      ~37     !5, 'values'
         53        FETCH_DIM_R                                      ~38     ~37, 'language'
         54        CONCAT                                           ~39     '+AND+n.%60language%60+%3D+%27', ~38
         55        CONCAT                                           ~40     ~39, '%27'
         56        ASSIGN_OP                                     8          !4, ~40
   27    57    >   ASSIGN_OP                                     8          !4, '+ORDER+BY+%60partner%60%2C+sid'
   28    58        ECHO                                                     !4
         59      > RETURN                                                   1

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
156.81 ms | 1392 KiB | 17 Q