3v4l.org

run code in 300+ PHP versions simultaneously
<?php $filters = []; $start = 0; $csv = true; $count = false; $full = true; $whereClause = " WHERE c.cID IS NOT NULL AND p.status NOT IN ('hidden')"; $orderBy = " ORDER BY "; $params = array(); if(is_null($filters)&& isset($_SESSION['claimfilters']) && !is_null($_SESSION['claimfilters']) && !$csv) $filters = unserialize($_SESSION['claimfilters']); if(!is_null($filters)) { if(isset($filters['pID']) && $filters['pID'] != "" && !is_null($filters['pID'])) { $whereClause .= " AND c.pID = :pID"; $params['pID'] = $filters['pID']; } if(isset($filters['cnID']) && $filters['cnID'] && !is_null($filters['cnID'])) { //$whereClause .= " AND p.cnID = :cnID"; $country = new Country($filters['cnID']); if($country->code=='gb'){$country->code='en';} $whereClause .= " AND con.lang IN ('" . $country->code ."')"; } if(isset($filters['ptID']) && $filters['ptID'] && !is_null($filters['ptID'])) { $whereClause .= " AND p.ptID = :ptID"; $params['ptID'] = $filters['ptID']; } if(isset($filters['customerType']) && $filters['customerType'] != "") { $whereClause .= " AND con.customerType = :customerType"; $params['customerType'] = $filters['customerType']; } if(isset($filters['status']) && $filters['status'] != "") { $whereClause .= " AND c.status = :status"; $params['status'] = $filters['status']; } if(isset($filters['slug']) && $filters['slug'] != "") { $whereClause .= " AND p.slug = :slug"; $params['slug'] = $filters['slug']; } if(isset($filters['redemptionstatus']) && $filters['redemptionstatus'] != "") { $whereClause .= " AND c.cID IN (SELECT DISTINCT(r.cID) FROM claims_redemptions r WHERE r.status = :redemptionstatus)"; $params['redemptionstatus'] = $filters['redemptionstatus']; } if(isset($filters['startDate']) && $filters['startDate'] != "" && isset($filters['endDate']) && $filters['endDate'] != "") { $whereClause .= " AND DATE(c.date_created) BETWEEN :startDate AND :endDate"; $params['startDate'] = $filters['startDate']; $params['endDate'] = $filters['endDate']; } if(isset($filters['sort']) && $filters['sort'] != "") { $orderBy = " e." . $filters['sort']." ".$filters['direction'] . ","; } if(isset($filters['search']) && $filters['search'] != "") { $whereClause .= " AND ( c.cID = '".$filters['search']."' OR con.email LIKE '%".$filters['search']."%' OR con.surname LIKE '%".$filters['search']."%' OR con.postcode LIKE '%".$filters['search']."%' )"; } if(isset($filters['actioneddate']) && $filters['actioneddate'] != "") { if(isset($filters['status']) && $filters['status'] != "") { switch($filters['status']) { case 'processed' : $date = 'date_processed'; break; case 'validated' : $date = 'date_validated'; break; case 'rejected' : $date = 'date_rejected'; break; } $whereClause .= " AND DATE(" . $date . ") = :actioned"; } else { $whereClause .= " AND (DATE(date_processed) = :actioned OR DATE(date_validated) = :actioned OR DATE(date_rejected) = :actioned)"; } $params['actioned'] = $filters['actioneddate']; } } $orderBy .= "c.cID ASC"; if(!$csv) $_SESSION['claimfilters'] = serialize($filters); $sql = "SELECT "; if($count) { $sql .= "COUNT(*)"; } elseif($full) { $sql .= "SQL_CALC_FOUND_ROWS r.*, r.cashback AS r_cashback, c.*, pr.*, con.*, pur.*, DATEDIFF(date_received,invoiceDate) as daysTaken, p.promoName, p.cnID, p.ptID, c.cID AS cID"; } else { $sql .= "SQL_CALC_FOUND_ROWS c.*, con.*, pur.*, DATEDIFF(date_received,invoiceDate) as daysTaken, p.promoName, p.cnID, p.ptID, p.paymentPeriod, c.cID AS cID, (SELECT SUM(cashback) FROM claims_redemptions WHERE cID = c.cID AND `status` NOT IN ('invalid','incomplete')) AS `cashback_amount`"; } if($full) { $sql .= " FROM claims_redemptions r LEFT JOIN claims c ON c.cID = r.cID LEFT JOIN consumers con ON c.conID = con.conID LEFT JOIN claims_purchases pur ON c.cID = pur.cID LEFT JOIN promotions p ON c.pID = p.pID LEFT JOIN promotions_products pr ON r.prID = pr.prID "; } else { $sql .= " FROM claims c LEFT JOIN consumers con ON c.conID = con.conID LEFT JOIN claims_purchases pur ON c.cID = pur.cID LEFT JOIN promotions p ON c.pID = p.pID "; } $sql .= $whereClause . $orderBy; $sql .= (!$csv) ? " LIMIT " . $start . ", " . $GLOBALS['config']->general->num_per_page : ""; die($sql); if(!$count) return DatabaseHandler::GetAll($sql,$params); else return DatabaseHandler::GetOne($sql,$params);

Here you find the average performance (time & memory) of each version. A grayed out version indicates it didn't complete successfully (based on exit-code).

VersionSystem time (s)User time (s)Memory (MiB)
8.3.60.0130.00718.20
8.3.50.0180.00722.01
8.3.40.0090.00918.92
8.3.30.0040.01119.21
8.3.20.0040.00420.34
8.3.10.0040.00423.65
8.3.00.0080.00019.80
8.2.180.0140.00418.54
8.2.170.0040.01122.96
8.2.160.0140.00720.17
8.2.150.0050.00324.18
8.2.140.0000.00824.66
8.2.130.0050.00326.16
8.2.120.0030.00519.36
8.2.110.0090.00022.43
8.2.100.0110.00017.88
8.2.90.0040.00419.42
8.2.80.0060.00317.97
8.2.70.0000.00917.75
8.2.60.0070.00318.04
8.2.50.0040.00418.07
8.2.40.0050.00318.34
8.2.30.0000.00718.11
8.2.20.0040.00417.91
8.2.10.0040.00418.23
8.2.00.0000.00718.10
8.1.280.0060.01225.92
8.1.270.0040.00420.36
8.1.260.0080.00026.35
8.1.250.0040.00428.09
8.1.240.0060.00317.61
8.1.230.0070.00717.48
8.1.220.0030.00517.79
8.1.210.0000.00818.77
8.1.200.0040.00417.47
8.1.190.0030.00517.47
8.1.180.0080.00018.10
8.1.170.0080.00318.65
8.1.160.0000.00722.12
8.1.150.0000.00719.00
8.1.140.0040.00417.60
8.1.130.0030.00317.85
8.1.120.0030.00517.45
8.1.110.0060.00317.60
8.1.100.0000.00717.60
8.1.90.0040.00417.63
8.1.80.0000.00717.57
8.1.70.0000.00817.51
8.1.60.0040.00417.67
8.1.50.0090.00017.55
8.1.40.0040.00417.64
8.1.30.0060.00317.67
8.1.20.0090.00017.79
8.1.10.0000.00817.58
8.1.00.0090.00017.54
8.0.300.0000.00718.77
8.0.290.0040.00416.88
8.0.280.0000.00718.52
8.0.270.0000.00717.37
8.0.260.0080.00416.88
8.0.250.0000.00717.13
8.0.240.0000.00717.09
8.0.230.0080.00017.19
8.0.220.0000.00717.10
8.0.210.0030.00716.94
8.0.200.0030.00317.19
8.0.190.0070.00317.14
8.0.180.0000.00817.00
8.0.170.0000.00817.04
8.0.160.0000.00817.11
8.0.150.0040.00417.01
8.0.140.0060.00317.09
8.0.130.0000.00513.49
8.0.120.0030.00516.94
8.0.110.0000.00716.94
8.0.100.0030.00616.91
8.0.90.0000.00816.89
8.0.80.0070.01317.02
8.0.70.0030.00516.97
8.0.60.0080.00017.09
8.0.50.0000.00817.13
8.0.30.0070.01617.23
8.0.20.0080.01417.40
8.0.10.0040.00417.22
8.0.00.0090.01016.90
7.4.330.0050.00015.07
7.4.320.0000.00616.61
7.4.300.0000.00616.53
7.4.290.0040.00416.76
7.4.280.0060.00316.70
7.4.270.0030.00316.67
7.4.260.0070.00016.71
7.4.250.0040.00416.66
7.4.240.0040.00416.65
7.4.230.0000.00716.51
7.4.220.0070.01116.58
7.4.210.0000.01616.71
7.4.200.0070.00016.52
7.4.160.0060.01016.43
7.4.150.0080.01017.40
7.4.140.0130.00817.86
7.4.130.0120.00816.47
7.4.120.0080.01516.52
7.4.110.0110.00716.66
7.4.100.0130.01016.58
7.4.90.0040.02016.62
7.4.80.0090.00819.39
7.4.70.0080.00916.84
7.4.60.0080.00816.59
7.4.50.0060.00316.46
7.4.40.0110.00716.50
7.4.30.0090.00916.66
7.4.00.0120.00315.25
7.3.330.0080.00013.27
7.3.320.0030.00313.36
7.3.310.0040.00216.43
7.3.300.0000.00716.40
7.3.290.0090.00516.43
7.3.280.0070.01016.47
7.3.270.0180.00817.40
7.3.260.0110.00716.54
7.3.250.0100.00716.49
7.3.240.0110.00516.38
7.3.230.0030.01416.46
7.3.210.0110.00616.69
7.3.200.0070.01016.55
7.3.190.0000.01616.35
7.3.180.0130.00316.52
7.3.170.0090.00916.52
7.3.160.0140.00316.45
7.2.330.0110.00716.69
7.2.320.0060.01016.78
7.2.310.0090.00916.53
7.2.300.0070.01016.64
7.2.290.0070.01316.60
7.2.60.0070.00716.95
7.2.00.0300.00819.12
7.1.200.0090.00315.83
7.1.100.0060.00617.84
7.1.70.0000.01116.95
7.1.60.0060.01819.86
7.1.50.0070.01817.02
7.1.00.0000.08022.35
7.0.200.0000.00816.77
7.0.60.0130.08020.04
7.0.50.0070.06717.99
7.0.40.0130.07720.23
7.0.30.0570.07020.30
7.0.20.0200.04720.16
7.0.10.0070.04020.09
7.0.00.0000.07720.08
5.6.280.0100.07020.95
5.6.210.0130.06720.76
5.6.200.0070.04318.15
5.6.190.0030.04720.32
5.6.180.0300.07320.77
5.6.170.0270.07720.53
5.6.160.0000.04720.71
5.6.150.0030.05718.23
5.6.140.0070.08018.25
5.6.130.0030.04018.20
5.6.120.0030.07020.91
5.6.110.0270.06721.17
5.6.100.0030.04021.04
5.6.90.0070.04021.00
5.6.80.0100.07720.39
5.5.350.0000.04320.43
5.5.340.0100.07717.96
5.5.330.0070.04020.57
5.5.320.3930.04720.22
5.5.310.0230.07020.29
5.5.300.0070.08018.03
5.5.290.0100.04318.05
5.5.280.0000.09320.84
5.5.270.0030.06020.82
5.5.260.0130.08720.81
5.5.250.0070.08320.73
5.5.240.0270.07320.41
5.4.450.0300.07719.37
5.4.440.1500.03719.54
5.4.430.0970.03019.38
5.4.420.0070.06019.49
5.4.410.0170.04719.20
5.4.400.0070.05319.13
5.4.390.0070.07019.06
5.4.380.0230.05319.09
5.4.370.0230.04019.15
5.4.360.0070.05719.07
5.4.350.0200.05319.06
5.4.340.0100.06719.00
5.4.320.0130.05019.06
5.4.310.0100.05319.02
5.4.300.0100.05319.05
5.4.290.0070.06019.09
5.4.280.0100.05318.97
5.4.270.0100.05718.99
5.4.260.0100.05319.04
5.4.250.0100.05719.17
5.4.240.0230.05019.14
5.4.230.0030.07019.04
5.4.220.0130.05318.97
5.4.210.0270.06019.04
5.4.200.0070.05716.59
5.4.190.0170.05019.13
5.4.180.0100.05019.05
5.4.170.0100.05719.07
5.4.160.0230.04018.97
5.4.150.0100.05319.13
5.4.140.0230.04716.41
5.4.130.0070.05016.57
5.4.120.0070.05016.43
5.4.110.0100.04716.26
5.4.100.0070.05316.56
5.4.90.0130.04716.27
5.4.80.0130.04716.21
5.4.70.0030.05716.39
5.4.60.0170.04316.36
5.4.50.0130.04716.54
5.4.40.0200.04316.14
5.4.30.0130.04716.45
5.4.20.0130.05016.20
5.4.10.0030.05716.58
5.4.00.0200.05315.70
5.3.290.0100.06014.61
5.3.280.0130.05314.50
5.3.270.0170.04714.52
5.3.260.0000.06714.45
5.3.250.0070.05314.52
5.3.240.0270.05014.52
5.3.230.0030.06014.48
5.3.220.0070.05714.40
5.3.210.0070.05314.46
5.3.200.0130.05714.53
5.3.190.0100.05014.49
5.3.180.0030.05714.35
5.3.170.0070.05014.46
5.3.160.0130.04714.48
5.3.150.0100.05014.41
5.3.140.0070.05014.40
5.3.130.0130.04714.42
5.3.120.0270.05014.43
5.3.110.0070.08314.41
5.3.100.0100.05014.04
5.3.90.0030.05313.87
5.3.80.0200.04013.93
5.3.70.0100.05013.87
5.3.60.0170.04313.79
5.3.50.0100.04713.80
5.3.40.0070.05713.79
5.3.30.0270.03013.94
5.3.20.0030.05013.69
5.3.10.0030.05013.67
5.3.00.0100.05013.57
5.2.170.0100.03710.99
5.2.160.0100.03711.20
5.2.150.0030.04311.09
5.2.140.0100.04311.01
5.2.130.0030.04311.03
5.2.120.0070.03711.16
5.2.110.0130.03311.00
5.2.100.0100.03711.04
5.2.90.0070.04011.05
5.2.80.0030.04711.04
5.2.70.0100.04011.18
5.2.60.0130.03710.89
5.2.50.0100.03711.03
5.2.40.0070.04010.89
5.2.30.0170.03010.91
5.2.20.0000.04310.88
5.2.10.0070.05010.82
5.2.00.0070.05010.64
5.1.60.0030.03710.07
5.1.50.0070.0339.84
5.1.40.0070.0339.89
5.1.30.0030.04310.25
5.1.20.0130.02710.20
5.1.10.0070.03310.00
5.1.00.0170.0379.99
5.0.50.0070.0278.44
5.0.40.0000.0338.33
5.0.30.0070.0408.13
5.0.20.0030.0278.25
5.0.10.0000.0308.07
5.0.00.0070.0407.98
4.4.90.0030.0235.83
4.4.80.0070.0175.86
4.4.70.0000.0235.81
4.4.60.0000.0235.85
4.4.50.0030.0205.87
4.4.40.0030.0335.75
4.4.30.0000.0235.77
4.4.20.0000.0235.83
4.4.10.0030.0275.88
4.4.00.0000.0435.92
4.3.110.0030.0275.68
4.3.100.0000.0235.67
4.3.90.0100.0135.69
4.3.80.0030.0405.81
4.3.70.0030.0205.64
4.3.60.0000.0235.80
4.3.50.0000.0235.75
4.3.40.0000.0375.62
4.3.30.0000.0234.89
4.3.20.0000.0234.89
4.3.10.0000.0304.89
4.3.00.0070.00714.77

preferences:
56.05 ms | 401 KiB | 5 Q