Online PHP editor | perf for MDgs3

@ 2016-01-25T18:32:56Z

<?php
function query($query) {
		if(strpos($query, 'WHERE') !== false) {
			$new = $this->prepare_where($query);
			$query = $new['query'];
			$values = $new['values'];
		} else {
		    $new = NULL;
			$values = array();
		}
		
        var_dump($query, $new);
}

function prepare_where($query) {
		$strpos_where = strpos($query, 'WHERE') + 6;
		$strpos_limit = (int) strpos($query, 'LIMIT');
		$strpos_group = (int) strpos($query, 'GROUP BY');
		$strpos_order = (int) strpos($query, 'ORDER BY');
		
		$new_query = substr($query, 0, $strpos_where);
		if($strpos_limit > 0 AND $strpos_limit < $strpos_group AND $strpos_limit < $strpos_order) {
			$where = substr($query, $strpos_where, $strpos_limit);
			$new_subquery = substr($query, $strpos_limit);
		} elseif($strpos_group > 0 AND $strpos_group < $strpos_limit AND $strpos_group < $strpos_order) {
			$where = substr($query, $strpos_where, $strpos_group);
			$new_subquery = substr($query, $strpos_group);
		} elseif($strpos_order > 0 AND $strpos_order < $strpos_limit AND $strpos_order < $strpos_group) {
			$where = substr($query, $strpos_where, $strpos_order);
			$new_subquery = substr($query, $strpos_order);
		} else {
			$where = substr($query, $strpos_where);
			$new_subquery = "";
		}
		
		$where_values = array();
		$where_break = explode(' AND ', $where);
		$where_break_c = count($where_break);
		
		for($i = 0; $i < $where_break_c; $i++) {
			if(!isset($where_break[$i])) {
				continue;
			}
			
			if(isset($where_break[$i + 1]) AND preg_match('/([\`a-z0-9\_\-]+)[\s]{0,1}(\=|LIKE|\<|\>|\<\=|\>\=|!\=)[\s]{0,1}(.*)/i', $where_break[$i + 1]) != 1) {
				$where_break[$i] = $where_break[$i]." AND ".$where_break[$i + 1];
				unset($where_break[$i + 1]);
			}
			
			$where_break_or = explode(' OR ', $where_break[$i]);
			$where_break_or_c = count($where_break_or);
			for($j = 0; $j < $where_break_or_c; $j++) {
				if(!isset($where_break_or[$i])) {
					continue;
				}
				
				if(isset($where_break_or[$j + 1]) AND preg_match('/([\`a-z0-9\_\-]+)[\s]{0,1}(\=|LIKE|\<|\>|\<\=|\>\=|!\=)[\s]{0,1}(.*)/i', $where_break_or[$j + 1]) != 1) {
					$where_break_or[$j] = $where_break_or[$j]." OR ".$where_break_or[$j + 1];
					unset($where_break_or[$j + 1]);
				}
				
				preg_match('/([\`a-z0-9\_\-]+)[\s]{0,1}(\=|LIKE|\<|\>|\<\=|\>\=|!\=)[\s]{0,1}(.*)/i', $where_break_or[$j], $matches);
				if(substr($matches[3], 0, 1) == "'" OR substr($matches[3], 0, 1) == '"') {
					$where_values[] = substr($matches[3], 1, -1);
				} else {
					$where_values[] = $matches[3];
				}
				
				$where_break_or[$j] = str_replace($matches[3], '?', $where_break_or[$j]);
			}
			
			$where_break[$i] = implode(' OR ', $where_break_or);
			
			preg_match('/([\`a-z0-9\_\-]+)[\s]{0,1}(\=|LIKE|\<|\>|\<\=|\>\=|!\=)[\s]{0,1}(.*)/i', $clausel2, $matches);
			if(substr($matches[3], 0, 1) == "'" OR substr($matches[3], 0, 1) == '"') {
				$matches[3] = substr($matches[3], 1, -1);
			}
			$where_values[] = $matches[3];
			
			$where_break[$i] = str_replace($matches[3], '?', $where_break[$i]);
		}
		
		$where_break = implode(' AND ', $where_break);
		$new_query .= $where_break.$new_subquery;
		return array('query' => $new_query, 'values' => $where_values);
}

query("SELECT TABLE FROM FZC WHERE TABLE='chandz' AND TABLE=1 OR DIE='52'");
query("SELECT TABLE FROM FZC WHERE TABLE='chandz AND ' AND TABLE=1 OR DIE='52 OR '");

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).

Version	System time (s)	User time (s)	Memory (MiB)
8.3.6	0.010	0.010	18.56
8.3.5	0.016	0.007	22.05
8.3.4	0.004	0.011	18.88
8.3.3	0.004	0.011	18.82
8.3.2	0.002	0.005	20.33
8.3.1	0.003	0.006	20.39
8.3.0	0.003	0.006	21.73
8.2.18	0.012	0.004	16.63
8.2.17	0.016	0.007	22.96
8.2.16	0.007	0.007	21.91
8.2.15	0.004	0.004	24.18
8.2.14	0.004	0.004	24.66
8.2.13	0.004	0.004	21.03
8.2.12	0.004	0.004	26.35
8.2.11	0.005	0.005	20.25
8.2.10	0.009	0.003	17.78
8.2.9	0.000	0.008	18.98
8.2.8	0.000	0.009	17.97
8.2.7	0.003	0.006	17.63
8.2.6	0.000	0.008	17.80
8.2.5	0.004	0.004	18.09
8.2.4	0.008	0.000	20.47
8.2.3	0.004	0.004	19.37
8.2.2	0.000	0.007	17.76
8.2.1	0.005	0.002	18.18
8.2.0	0.000	0.008	17.98
8.1.28	0.006	0.009	25.92
8.1.27	0.005	0.003	22.14
8.1.26	0.004	0.004	28.09
8.1.25	0.008	0.000	28.09
8.1.24	0.006	0.003	22.13
8.1.23	0.009	0.003	20.97
8.1.22	0.004	0.004	17.74
8.1.21	0.005	0.003	18.77
8.1.20	0.010	0.000	17.25
8.1.19	0.004	0.004	17.35
8.1.18	0.000	0.008	18.10
8.1.17	0.005	0.005	18.71
8.1.16	0.005	0.002	20.66
8.1.15	0.000	0.007	18.83
8.1.14	0.000	0.008	19.56
8.1.13	0.008	0.000	17.64
8.1.12	0.004	0.004	17.39
8.1.11	0.003	0.006	17.30
8.1.10	0.007	0.000	17.29
8.1.9	0.008	0.000	17.42
8.1.8	0.007	0.000	17.30
8.1.7	0.000	0.007	17.40
8.1.6	0.007	0.004	17.49
8.1.5	0.003	0.006	17.52
8.1.4	0.005	0.003	17.49
8.1.3	0.000	0.008	17.64
8.1.2	0.005	0.003	17.52
8.1.1	0.004	0.004	17.61
8.1.0	0.008	0.000	17.44
8.0.30	0.004	0.004	18.77
8.0.29	0.004	0.004	17.00
8.0.28	0.003	0.003	18.41
8.0.27	0.003	0.003	17.17
8.0.26	0.000	0.007	17.13
8.0.25	0.003	0.003	16.90
8.0.24	0.000	0.008	17.02
8.0.23	0.004	0.004	16.93
8.0.22	0.004	0.004	16.95
8.0.21	0.003	0.004	17.00
8.0.20	0.005	0.003	17.02
8.0.19	0.000	0.008	17.06
8.0.18	0.000	0.007	16.98
8.0.17	0.008	0.000	16.99
8.0.16	0.004	0.004	16.85
8.0.15	0.000	0.007	16.77
8.0.14	0.004	0.004	16.95
8.0.13	0.003	0.003	13.34
8.0.12	0.000	0.008	16.95
8.0.11	0.005	0.002	16.89
8.0.10	0.000	0.008	16.77
8.0.9	0.005	0.003	16.91
8.0.8	0.010	0.010	16.88
8.0.7	0.004	0.004	16.99
8.0.6	0.000	0.007	16.85
8.0.5	0.004	0.004	16.85
8.0.3	0.011	0.007	17.19
8.0.2	0.013	0.006	17.40
8.0.1	0.005	0.002	16.87
8.0.0	0.012	0.006	16.74
7.4.33	0.000	0.005	16.67
7.4.32	0.003	0.003	16.62
7.4.30	0.006	0.000	16.61
7.4.29	0.000	0.007	16.61
7.4.28	0.008	0.000	16.64
7.4.27	0.004	0.004	16.53
7.4.26	0.002	0.007	16.58
7.4.25	0.005	0.002	16.37
7.4.24	0.005	0.002	16.50
7.4.23	0.007	0.000	16.61
7.4.22	0.006	0.016	16.67
7.4.21	0.010	0.006	16.65
7.4.20	0.000	0.007	16.40
7.4.16	0.000	0.016	16.38
7.4.15	0.013	0.005	17.40
7.4.14	0.010	0.011	17.86
7.4.13	0.010	0.010	16.71
7.4.12	0.006	0.011	16.57
7.4.11	0.011	0.005	16.50
7.4.10	0.011	0.014	16.52
7.4.9	0.011	0.007	16.71
7.4.8	0.007	0.014	19.39
7.4.7	0.010	0.007	16.88
7.4.6	0.007	0.010	16.41
7.4.5	0.011	0.006	16.59
7.4.4	0.010	0.013	16.59
7.4.3	0.012	0.004	16.56
7.4.0	0.000	0.011	15.25
7.3.33	0.005	0.000	13.31
7.3.32	0.000	0.005	13.20
7.3.31	0.007	0.000	16.34
7.3.30	0.004	0.004	16.38
7.3.29	0.000	0.007	16.32
7.3.28	0.007	0.013	16.37
7.3.27	0.010	0.014	17.40
7.3.26	0.014	0.004	16.52
7.3.25	0.013	0.005	16.45
7.3.24	0.011	0.006	16.48
7.3.23	0.011	0.007	16.42
7.3.21	0.013	0.003	16.48
7.3.20	0.007	0.011	16.44
7.3.19	0.006	0.010	16.40
7.3.18	0.010	0.006	16.44
7.3.17	0.013	0.005	16.53
7.3.16	0.010	0.010	16.56
7.2.33	0.014	0.004	16.87
7.2.32	0.009	0.015	16.44
7.2.31	0.010	0.007	16.82
7.2.30	0.015	0.003	16.66
7.2.29	0.004	0.012	16.73
7.2.6	0.000	0.015	16.59
7.2.0	0.008	0.008	19.19
7.1.20	0.008	0.004	15.81
7.1.10	0.003	0.010	17.70
7.1.7	0.006	0.009	17.19
7.1.6	0.017	0.007	19.27
7.1.5	0.007	0.013	16.98
7.1.0	0.003	0.077	22.40
7.0.20	0.021	0.000	14.81
7.0.6	0.027	0.073	19.91
7.0.5	0.020	0.067	17.93
7.0.4	0.017	0.080	20.11
7.0.3	0.017	0.040	20.19
7.0.2	0.023	0.080	20.15
7.0.1	0.010	0.043	20.19
7.0.0	0.010	0.073	20.22
5.6.28	0.007	0.050	20.96
5.6.21	0.003	0.077	20.60
5.6.20	0.013	0.073	18.21
5.6.19	0.017	0.077	20.63
5.6.18	0.010	0.047	20.41
5.6.17	0.017	0.043	20.59
5.6.16	0.010	0.083	20.46
5.6.15	0.010	0.033	18.20
5.6.14	0.007	0.040	18.18
5.6.13	0.003	0.040	18.23
5.6.12	0.020	0.070	21.19
5.6.11	0.007	0.080	21.08
5.6.10	0.007	0.073	21.00
5.6.9	0.003	0.090	20.90
5.6.8	0.003	0.077	20.46
5.5.35	0.023	0.073	20.44
5.5.34	0.003	0.040	18.07
5.5.33	0.010	0.033	20.32
5.5.32	0.030	0.047	20.31
5.5.31	0.023	0.043	20.41
5.5.30	0.000	0.047	18.10
5.5.29	0.003	0.047	17.99
5.5.28	0.003	0.063	20.92
5.5.27	0.013	0.033	20.84
5.5.26	0.010	0.067	20.84
5.5.25	0.007	0.077	20.82
5.5.24	0.007	0.027	20.08

preferences:dark modelive preview