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 = 34
Branch analysis from position: 34
2 jumps found. (Code = 44) Position 1 = 39, Position 2 = 22
Branch analysis from position: 39
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 22
2 jumps found. (Code = 44) Position 1 = 39, Position 2 = 22
Branch analysis from position: 39
Branch analysis from position: 22
filename:       /in/abd0g
function name:  (null)
number of ops:  48
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        FETCH_CONSTANT                                   ~5      'home'
          2        FETCH_CONSTANT                                   ~6      'fgx'
          3        CONCAT                                           ~7      ~5, ~6
          4        FETCH_CONSTANT                                   ~8      'com'
          5        CONCAT                                           ~9      ~7, ~8
          6        FETCH_CONSTANT                                   ~10     'br'
          7        CONCAT                                           ~11     ~9, ~10
          8        SEND_VAL_EX                                              ~11
          9        SEND_VAL_EX                                              'fgxbidper'
         10        SEND_VAL_EX                                              'QajCBPx4W2Zw9U6c'
         11        SEND_VAL_EX                                              'fgx_bidper'
         12        DO_FCALL                                      0  $12     
         13        ASSIGN                                                   !0, $12
    5    14        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    15        INIT_FCALL_BY_NAME                                       'mysqli_query'
         16        SEND_VAR_EX                                              !0
         17        SEND_VAR_EX                                              !1
         18        DO_FCALL                                      0  $15     
         19        ASSIGN                                                   !2, $15
    7    20        ASSIGN                                                   !3, <array>
    8    21      > JMP                                                      ->34
    9    22    >   INIT_FCALL                                               'array_push'
         23        SEND_REF                                                 !3
   10    24        FETCH_DIM_R                                      ~18     !4, 0
         25        INIT_ARRAY                                       ~19     ~18, 'id'
   11    26        FETCH_DIM_R                                      ~20     !4, 1
         27        ADD_ARRAY_ELEMENT                                ~19     ~20, 'curHave'
   12    28        FETCH_DIM_R                                      ~21     !4, 2
         29        ADD_ARRAY_ELEMENT                                ~19     ~21, 'curWant'
   13    30        FETCH_DIM_R                                      ~22     !4, 3
         31        ADD_ARRAY_ELEMENT                                ~19     ~22, 'countryLive'
         32        SEND_VAL                                                 ~19
         33        DO_ICALL                                                 
    8    34    >   INIT_FCALL_BY_NAME                                       'mysqli_fetch_array'
         35        SEND_VAR_EX                                              !2
         36        DO_FCALL                                      0  $24     
         37        ASSIGN                                           ~25     !4, $24
         38      > JMPNZ                                                    ~25, ->22
   15    39    >   INIT_FCALL                                               'json_encode'
         40        INIT_ARRAY                                       ~26     !3, 'result'
         41        SEND_VAL                                                 ~26
         42        DO_ICALL                                         $27     
         43        ECHO                                                     $27
   16    44        INIT_FCALL_BY_NAME                                       'mysqli_close'
         45        SEND_VAR_EX                                              !0
         46        DO_FCALL                                      0          
   17    47      > RETURN                                                   1

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
163.63 ms | 1405 KiB | 17 Q