3v4l.org

run code in 500+ PHP versions simultaneously
<?php $prod_get_attr = "SELECT oca.product_id, pr.price, pr.image, pd.name FROM oc_product_attribute AS oca LEFT JOIN oc_product AS pr ON pr.product_id = oca.product_id LEFT JOIN oc_product_description AS pd ON pd.product_id = oca.product_id WHERE text IN ('" . $get_material_item . "') AND oca.product_id IN ( SELECT oca2.product_id FROM oc_product_attribute AS oca2 WHERE text IN ('" . $get_ves_item . "') ) GROUP BY oca.product_id"; // получаем id товаров, выбранных атрибутов Вес и материал $query_prod_get_attr = mysqli_query($dbh, $prod_get_attr); var_dump($query_prod_get_attr);
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/vF8YV
function name:  (null)
number of ops:  14
compiled vars:  !0 = $prod_get_attr, !1 = $get_material_item, !2 = $get_ves_item, !3 = $query_prod_get_attr, !4 = $dbh
line      #* E I O op                               fetch          ext  return  operands
-----------------------------------------------------------------------------------------
    3     0  E >   CONCAT                                               ~5      'SELECT+oca.product_id%2C+pr.price%2C+pr.image%2C+pd.name+FROM+oc_product_attribute+AS+oca+LEFT+JOIN+oc_product+AS+pr+ON+pr.product_id+%3D+oca.product_id+LEFT+JOIN+oc_product_description+AS+pd+ON+pd.product_id+%3D+oca.product_id+WHERE+text+IN+%28%27', !1
          1        CONCAT                                               ~6      ~5, '%27%29+AND+oca.product_id+IN+%28+SELECT+oca2.product_id+FROM+oc_product_attribute+AS+oca2+WHERE+text+IN+%28%27'
          2        CONCAT                                               ~7      ~6, !2
          3        CONCAT                                               ~8      ~7, '%27%29+%29+GROUP+BY+oca.product_id'
          4        ASSIGN                                                       !0, ~8
    4     5        INIT_FCALL_BY_NAME                                           'mysqli_query'
          6        SEND_VAR_EX                                                  !4
          7        SEND_VAR_EX                                                  !0
          8        DO_FCALL                                          0  $10     
          9        ASSIGN                                                       !3, $10
    5    10        INIT_FCALL                                                   'var_dump'
         11        SEND_VAR                                                     !3
         12        DO_ICALL                                                     
         13      > RETURN                                                       1

Generated using Vulcan Logic Dumper, using php 8.5.0


preferences:
166.84 ms | 2165 KiB | 14 Q