3v4l.org

run code in 300+ PHP versions simultaneously
<?php $con = mysqli_connect("home.fgx.com.br","fgxbidper","QajCBPx4W2Zw9U6c","fgx_bidper"); $sql = "SELECT peopleID, firstName, lastName, valueEx FROM exchange inner join people on people.id = exchange.peopleID WHERE curHave = (SELECT CurWant FROM exchange WHERE peopleID = 24) and finished = 0 and peopleID <> 24"; $res = mysqli_query($con,$sql); $result = array(); while($row = mysqli_fetch_array($res)){ array_push($result, array('id'=>$row[0], 'curHave'=>$row[1], 'curWant'=>$row[2], 'countryLive'=>$row[3])); } echo json_encode(array("result"=>$result)); mysqli_close($con); ?>
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 42) Position 1 = 27
Branch analysis from position: 27
2 jumps found. (Code = 44) Position 1 = 32, Position 2 = 15
Branch analysis from position: 32
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 15
2 jumps found. (Code = 44) Position 1 = 32, Position 2 = 15
Branch analysis from position: 32
Branch analysis from position: 15
filename:       /in/CaugV
function name:  (null)
number of ops:  41
compiled vars:  !0 = $con, !1 = $sql, !2 = $res, !3 = $result, !4 = $row
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    3     0  E >   INIT_FCALL_BY_NAME                                       'mysqli_connect'
          1        SEND_VAL_EX                                              'home.fgx.com.br'
          2        SEND_VAL_EX                                              'fgxbidper'
          3        SEND_VAL_EX                                              'QajCBPx4W2Zw9U6c'
          4        SEND_VAL_EX                                              'fgx_bidper'
          5        DO_FCALL                                      0  $5      
          6        ASSIGN                                                   !0, $5
    5     7        ASSIGN                                                   !1, 'SELECT+peopleID%2C+firstName%2C+lastName%2C+valueEx+FROM+exchange+inner+join+people+on+people.id+%3D+exchange.peopleID++WHERE+curHave+%3D+%28SELECT+CurWant+FROM+exchange+WHERE+peopleID+%3D+24%29+and+finished+%3D+0+and+peopleID+%3C%3E+24'
    6     8        INIT_FCALL_BY_NAME                                       'mysqli_query'
          9        SEND_VAR_EX                                              !0
         10        SEND_VAR_EX                                              !1
         11        DO_FCALL                                      0  $8      
         12        ASSIGN                                                   !2, $8
    7    13        ASSIGN                                                   !3, <array>
    8    14      > JMP                                                      ->27
    9    15    >   INIT_FCALL                                               'array_push'
         16        SEND_REF                                                 !3
   10    17        FETCH_DIM_R                                      ~11     !4, 0
         18        INIT_ARRAY                                       ~12     ~11, 'id'
   11    19        FETCH_DIM_R                                      ~13     !4, 1
         20        ADD_ARRAY_ELEMENT                                ~12     ~13, 'curHave'
   12    21        FETCH_DIM_R                                      ~14     !4, 2
         22        ADD_ARRAY_ELEMENT                                ~12     ~14, 'curWant'
   13    23        FETCH_DIM_R                                      ~15     !4, 3
         24        ADD_ARRAY_ELEMENT                                ~12     ~15, 'countryLive'
         25        SEND_VAL                                                 ~12
         26        DO_ICALL                                                 
    8    27    >   INIT_FCALL_BY_NAME                                       'mysqli_fetch_array'
         28        SEND_VAR_EX                                              !2
         29        DO_FCALL                                      0  $17     
         30        ASSIGN                                           ~18     !4, $17
         31      > JMPNZ                                                    ~18, ->15
   15    32    >   INIT_FCALL                                               'json_encode'
         33        INIT_ARRAY                                       ~19     !3, 'result'
         34        SEND_VAL                                                 ~19
         35        DO_ICALL                                         $20     
         36        ECHO                                                     $20
   16    37        INIT_FCALL_BY_NAME                                       'mysqli_close'
         38        SEND_VAR_EX                                              !0
         39        DO_FCALL                                      0          
   17    40      > RETURN                                                   1

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
162.19 ms | 1400 KiB | 17 Q