3v4l.org

run code in 300+ PHP versions simultaneously
<?php $query = 'SELECT COUNT( `orders`.order_id ) AS `cnt`, ' . '`orders`.`payment_type`, `orders`.`package_id`, `orders`.`country_id`, ' . '`payment_cost`.`cost`, `vat`, SUM(`orders`.`amount`) AS `omzet` ' . 'FROM `orders`, ' . 'WHERE `orders`.`status` IN(:success, :verified) ' . "AND DATE_FORMAT( `orders`.`payment_date` , '%m-%y' ) = :date " . 'AND `orders`.`payment_type`=`payment_cost`.`payment_type` ' . 'AND `orders`.`package_id`=`payment_cost`.`package_id` ' . 'AND `orders`.`country_id`=`payment_cost`.`country_id` ' . 'GROUP BY `orders`.`payment_type`, `orders`.`country_id`, `orders`.`package_id` ' . 'ORDER BY payment_type, country_id ASC'; echo $query;
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/6XW7l
function name:  (null)
number of ops:  3
compiled vars:  !0 = $query
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    2     0  E >   ASSIGN                                                   !0, 'SELECT+COUNT%28+%60orders%60.order_id+%29+AS+%60cnt%60%2C+%60orders%60.%60payment_type%60%2C+%60orders%60.%60package_id%60%2C+%60orders%60.%60country_id%60%2C+%60payment_cost%60.%60cost%60%2C+%60vat%60%2C+SUM%28%60orders%60.%60amount%60%29+AS+%60omzet%60+FROM+%60orders%60%2C+WHERE+%60orders%60.%60status%60+IN%28%3Asuccess%2C+%3Averified%29+AND+DATE_FORMAT%28+%60orders%60.%60payment_date%60+%2C+%27%25m-%25y%27+%29+%3D+%3Adate+AND+%60orders%60.%60payment_type%60%3D%60payment_cost%60.%60payment_type%60+AND+%60orders%60.%60package_id%60%3D%60payment_cost%60.%60package_id%60+AND+%60orders%60.%60country_id%60%3D%60payment_cost%60.%60country_id%60+GROUP+BY+%60orders%60.%60payment_type%60%2C+%60orders%60.%60country_id%60%2C+%60orders%60.%60package_id%60+ORDER+BY+payment_type%2C+country_id+ASC'
   14     1        ECHO                                                     !0
          2      > RETURN                                                   1

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
165.09 ms | 1397 KiB | 13 Q