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 = ""; $asset_google_code = $rec["asset_google_code"]; $exchange_google_code = $rec["exch_google_code"]; $assetentry = array ( $rec["assetID"] => $asset_google_code ); $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;
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/qVkN9
function name:  (null)
number of ops:  25
compiled vars:  !0 = $sql, !1 = $exchangeID, !2 = $brokerID, !3 = $extension, !4 = $asset_google_code, !5 = $rec, !6 = $exchange_google_code, !7 = $assetentry, !8 = $assets
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, ''
   10     5        FETCH_DIM_R                                      ~14     !5, 'asset_google_code'
          6        ASSIGN                                                   !4, ~14
   11     7        FETCH_DIM_R                                      ~16     !5, 'exch_google_code'
          8        ASSIGN                                                   !6, ~16
   12     9        FETCH_DIM_R                                      ~18     !5, 'assetID'
         10        INIT_ARRAY                                       ~19     !4, ~18
         11        ASSIGN                                                   !7, ~19
   13    12        ASSIGN_DIM                                               !8
         13        OP_DATA                                                  !7
   14    14        INIT_FCALL                                               'trim'
         15        SEND_VAR                                                 !6
         16        DO_ICALL                                         $22     
         17        CONCAT                                           ~23     $22, '%3A'
         18        CONCAT                                           ~24     ~23, !4
         19        CONCAT                                           ~25     ~24, '%2C'
         20        ASSIGN_OP                                     8          !3, ~25
   18    21        ASSIGN_OP                                     8          !3, '%27'
   19    22        CONCAT                                           ~28     'select+ex.opening_minutes+as+opening+from+exchange+as+ex+where+ex.exchangeID+%3D+', !1
         23        ASSIGN                                                   !0, ~28
         24      > RETURN                                                   1

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
155.67 ms | 1396 KiB | 15 Q