3v4l.org

run code in 300+ PHP versions simultaneously
<?php $sql = "select ex.opening_minutes as opening, asset.assetID, ex.google_code as exch_google_code, asset.google_code as asset_google_code from selected_asset as sa". " inner join asset on asset.assetID = sa.assetID". " inner join asset_exchange ae on ae.assetID = sa.assetID". " inner join exchange as ex on ex.exchangeID = ae.exchangeID". " where ae.exchangeID = ".$exchangeID." and sa.brokerID = ".$brokerID; $extension = ""; if ($result = mysqli_query($this->db, $sql) ) { while ($rec = $result->fetch_assoc()){ $asset_google_code = $rec["asset_google_code"]; $exchange_google_code = $rec["exch_google_code"]; $assetentry = array ( $rec["assetID"] => $asset_google_code ); $this->assets[] = $assetentry; $extension .= trim($exchange_google_code) .":".$asset_google_code.","; } } //$extension = rtrim($extension, ","); $extension .= "'"; $sql = "select ex.opening_minutes as opening from exchange as ex where ex.exchangeID = ".$exchangeID; if ($result = mysqli_query($this->db, $sql) ) { while ($rec = $result->fetch_assoc()){ $this->opening_minutes = "+" . $rec["opening"]." minutes"; } } $this->closetime = $this->opening->modify ($this->opening_minutes); $this->closetime = $this->closetime->format( "Y-m-d H:i:s");
Finding entry points
Branch analysis from position: 0
2 jumps found. (Code = 43) Position 1 = 14, Position 2 = 37
Branch analysis from position: 14
1 jumps found. (Code = 42) Position 1 = 33
Branch analysis from position: 33
2 jumps found. (Code = 44) Position 1 = 37, Position 2 = 15
Branch analysis from position: 37
2 jumps found. (Code = 43) Position 1 = 49, Position 2 = 60
Branch analysis from position: 49
1 jumps found. (Code = 42) Position 1 = 56
Branch analysis from position: 56
2 jumps found. (Code = 44) Position 1 = 60, Position 2 = 50
Branch analysis from position: 60
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 50
2 jumps found. (Code = 44) Position 1 = 60, Position 2 = 50
Branch analysis from position: 60
Branch analysis from position: 50
Branch analysis from position: 60
Branch analysis from position: 15
2 jumps found. (Code = 44) Position 1 = 37, Position 2 = 15
Branch analysis from position: 37
Branch analysis from position: 15
Branch analysis from position: 37
filename:       /in/hfgkv
function name:  (null)
number of ops:  80
compiled vars:  !0 = $sql, !1 = $exchangeID, !2 = $brokerID, !3 = $extension, !4 = $result, !5 = $asset_google_code, !6 = $rec, !7 = $exchange_google_code, !8 = $assetentry
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    7     0  E >   CONCAT                                           ~9      'select+ex.opening_minutes+as+opening%2C+asset.assetID%2C+ex.google_code+as+exch_google_code%2C+asset.google_code+as+asset_google_code+from+selected_asset+as+sa+inner+join+asset+on+asset.assetID+%3D+sa.assetID+inner+join+asset_exchange+ae+on+ae.assetID+%3D+sa.assetID+inner+join+exchange+as+ex+on+ex.exchangeID+%3D+ae.exchangeID+where+ae.exchangeID+%3D+', !1
          1        CONCAT                                           ~10     ~9, '+and+sa.brokerID+%3D+'
          2        CONCAT                                           ~11     ~10, !2
    3     3        ASSIGN                                                   !0, ~11
    8     4        ASSIGN                                                   !3, ''
    9     5        INIT_FCALL_BY_NAME                                       'mysqli_query'
          6        CHECK_FUNC_ARG                                           
          7        FETCH_THIS                                       $14     
          8        FETCH_OBJ_FUNC_ARG                               $15     $14, 'db'
          9        SEND_FUNC_ARG                                            $15
         10        SEND_VAR_EX                                              !0
         11        DO_FCALL                                      0  $16     
         12        ASSIGN                                           ~17     !4, $16
         13      > JMPZ                                                     ~17, ->37
   10    14    > > JMP                                                      ->33
   11    15    >   FETCH_DIM_R                                      ~18     !6, 'asset_google_code'
         16        ASSIGN                                                   !5, ~18
   12    17        FETCH_DIM_R                                      ~20     !6, 'exch_google_code'
         18        ASSIGN                                                   !7, ~20
   13    19        FETCH_DIM_R                                      ~22     !6, 'assetID'
         20        INIT_ARRAY                                       ~23     !5, ~22
         21        ASSIGN                                                   !8, ~23
   14    22        FETCH_THIS                                       $25     
         23        FETCH_OBJ_W                                      $26     $25, 'assets'
         24        ASSIGN_DIM                                               $26
         25        OP_DATA                                                  !8
   15    26        INIT_FCALL                                               'trim'
         27        SEND_VAR                                                 !7
         28        DO_ICALL                                         $28     
         29        CONCAT                                           ~29     $28, '%3A'
         30        CONCAT                                           ~30     ~29, !5
         31        CONCAT                                           ~31     ~30, '%2C'
         32        ASSIGN_OP                                     8          !3, ~31
   10    33    >   INIT_METHOD_CALL                                         !4, 'fetch_assoc'
         34        DO_FCALL                                      0  $33     
         35        ASSIGN                                           ~34     !6, $33
         36      > JMPNZ                                                    ~34, ->15
   19    37    >   ASSIGN_OP                                     8          !3, '%27'
   20    38        CONCAT                                           ~36     'select+ex.opening_minutes+as+opening+from+exchange+as+ex+where+ex.exchangeID+%3D+', !1
         39        ASSIGN                                                   !0, ~36
   22    40        INIT_FCALL_BY_NAME                                       'mysqli_query'
         41        CHECK_FUNC_ARG                                           
         42        FETCH_THIS                                       $38     
         43        FETCH_OBJ_FUNC_ARG                               $39     $38, 'db'
         44        SEND_FUNC_ARG                                            $39
         45        SEND_VAR_EX                                              !0
         46        DO_FCALL                                      0  $40     
         47        ASSIGN                                           ~41     !4, $40
         48      > JMPZ                                                     ~41, ->60
   23    49    > > JMP                                                      ->56
   24    50    >   FETCH_THIS                                       $42     
         51        FETCH_DIM_R                                      ~44     !6, 'opening'
         52        CONCAT                                           ~45     '%2B', ~44
         53        CONCAT                                           ~46     ~45, '+minutes'
         54        ASSIGN_OBJ                                               $42, 'opening_minutes'
         55        OP_DATA                                                  ~46
   23    56    >   INIT_METHOD_CALL                                         !4, 'fetch_assoc'
         57        DO_FCALL                                      0  $47     
         58        ASSIGN                                           ~48     !6, $47
         59      > JMPNZ                                                    ~48, ->50
   28    60    >   FETCH_THIS                                       $49     
         61        FETCH_THIS                                       $51     
         62        FETCH_OBJ_R                                      ~52     $51, 'opening'
         63        INIT_METHOD_CALL                                         ~52, 'modify'
         64        CHECK_FUNC_ARG                                           
         65        FETCH_THIS                                       $53     
         66        FETCH_OBJ_FUNC_ARG                               $54     $53, 'opening_minutes'
         67        SEND_FUNC_ARG                                            $54
         68        DO_FCALL                                      0  $55     
         69        ASSIGN_OBJ                                               $49, 'closetime'
         70        OP_DATA                                                  $55
   29    71        FETCH_THIS                                       $56     
         72        FETCH_THIS                                       $58     
         73        FETCH_OBJ_R                                      ~59     $58, 'closetime'
         74        INIT_METHOD_CALL                                         ~59, 'format'
         75        SEND_VAL_EX                                              'Y-m-d+H%3Ai%3As'
         76        DO_FCALL                                      0  $60     
         77        ASSIGN_OBJ                                               $56, 'closetime'
         78        OP_DATA                                                  $60
         79      > RETURN                                                   1

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
153.03 ms | 1404 KiB | 15 Q