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

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
181.79 ms | 1401 KiB | 15 Q