3v4l.org

run code in 300+ PHP versions simultaneously
<?php $user = JFactory::getUser(); $query = $db->getQuery(true) ->select("s.FieldName, SUM(s.FieldValue) AS Sum") ->from("#__rsform_submission_values AS sv") ->innerJoin("#__rsform_submissions AS s ON sv.FormId = s.FormId") ->where([ "s.User_Id = " . (int)$user->id, "sv.FieldName IN (" . implode(',', $db->q($months)) . ")" ]) ->group("sv.FieldName");
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/OHRfV
function name:  (null)
number of ops:  37
compiled vars:  !0 = $user, !1 = $query, !2 = $db, !3 = $months
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    3     0  E >   INIT_STATIC_METHOD_CALL                                  'JFactory', 'getUser'
          1        DO_FCALL                                      0  $4      
          2        ASSIGN                                                   !0, $4
    5     3        INIT_METHOD_CALL                                         !2, 'getQuery'
          4        SEND_VAL_EX                                              <true>
          5        DO_FCALL                                      0  $6      
    6     6        INIT_METHOD_CALL                                         $6, 'select'
          7        SEND_VAL_EX                                              's.FieldName%2C+SUM%28s.FieldValue%29+AS+Sum'
          8        DO_FCALL                                      0  $7      
    7     9        INIT_METHOD_CALL                                         $7, 'from'
         10        SEND_VAL_EX                                              '%23__rsform_submission_values+AS+sv'
         11        DO_FCALL                                      0  $8      
    8    12        INIT_METHOD_CALL                                         $8, 'innerJoin'
         13        SEND_VAL_EX                                              '%23__rsform_submissions+AS+s+ON+sv.FormId+%3D+s.FormId'
         14        DO_FCALL                                      0  $9      
    9    15        INIT_METHOD_CALL                                         $9, 'where'
   10    16        FETCH_OBJ_R                                      ~10     !0, 'id'
         17        CAST                                          4  ~11     ~10
         18        CONCAT                                           ~12     's.User_Id+%3D+', ~11
         19        INIT_ARRAY                                       ~13     ~12
   11    20        INIT_FCALL                                               'implode'
         21        SEND_VAL                                                 '%2C'
         22        INIT_METHOD_CALL                                         !2, 'q'
         23        SEND_VAR_EX                                              !3
         24        DO_FCALL                                      0  $14     
         25        SEND_VAR                                                 $14
         26        DO_ICALL                                         $15     
         27        CONCAT                                           ~16     'sv.FieldName+IN+%28', $15
         28        CONCAT                                           ~17     ~16, '%29'
         29        ADD_ARRAY_ELEMENT                                ~13     ~17
         30        SEND_VAL_EX                                              ~13
         31        DO_FCALL                                      0  $18     
   13    32        INIT_METHOD_CALL                                         $18, 'group'
         33        SEND_VAL_EX                                              'sv.FieldName'
         34        DO_FCALL                                      0  $19     
    5    35        ASSIGN                                                   !1, $19
   13    36      > RETURN                                                   1

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
174.89 ms | 1396 KiB | 15 Q