Online PHP editor | perf for 5NrFe

@ 2021-01-06T14:50:23Z

<?php

//var dump of $params shows: array(2) { [0] => string(2) [1]=> string(7) "renault" [1]=> string(20) "Alaskan" }


 public function getSomething(string $sql, array $params): array {
        $result = array();

        $statement = $this->connection->prepare($sql);

        $sql = "SELECT * FROM housemark WHERE merk LIKE ? AND (model LIKE ?) GROUP BY form ORDER BY form";


    if ($statement) {
        //var dump return true
        call_user_func_array(array(&$statement, 'bind_param'), makeValuesReferenced($params));
     
        if ($statement->execute()) {
            $statement->store_result();
            var_dump($statement);
            if ($statement->num_rows >= 1) {
                $statement->bind_result($id, $mark, $model, $form);
                while ($rij = $statement->fetch()) {
                    $result[] = new Housemark($id, $mark, $model, $form);
                }
            }
        }
    }

    var_dump($this->connection->error);
    
    return $result;
}
    
    
function makeValuesReferenced(array $arr): array {
    $refs = array();
    foreach ($arr as $key => $value)
        $refs[$key] = &$arr[$key];
    return $refs;
}

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.0.0	0.008	0.011	17.86
7.4.14	0.022	0.000	17.86
7.4.13	0.000	0.022	17.86
7.4.12	0.009	0.009	17.86
7.4.11	0.011	0.011	17.86
7.4.10	0.016	0.009	17.86
7.4.9	0.013	0.009	17.86
7.4.8	0.010	0.010	17.86
7.4.7	0.007	0.014	17.86
7.4.6	0.014	0.010	17.86
7.4.5	0.005	0.020	17.86
7.4.4	0.012	0.009	17.86
7.4.3	0.008	0.012	17.86
7.4.2	0.018	0.003	17.86
7.4.1	0.009	0.009	17.86
7.4.0	0.013	0.006	17.86
7.3.26	0.013	0.005	17.86
7.3.25	0.013	0.006	17.86
7.3.24	0.011	0.007	17.86
7.3.23	0.010	0.010	17.86
7.3.22	0.016	0.010	17.86
7.3.21	0.016	0.004	17.86
7.3.20	0.011	0.008	17.86
7.3.19	0.004	0.020	17.86
7.3.18	0.008	0.012	17.86
7.3.17	0.012	0.006	17.86
7.3.16	0.018	0.004	17.86
7.3.15	0.005	0.014	17.86
7.3.14	0.012	0.006	17.86
7.3.13	0.018	0.007	17.86
7.3.12	0.016	0.003	17.86
7.3.11	0.000	0.018	17.86
7.3.10	0.004	0.016	17.86
7.3.9	0.018	0.008	17.86
7.3.8	0.010	0.010	17.86
7.3.7	0.012	0.004	17.86
7.3.6	0.020	0.000	17.86
7.3.5	0.014	0.008	17.86
7.3.4	0.012	0.008	17.86
7.3.3	0.004	0.013	17.86
7.3.2	0.020	0.000	17.86
7.3.1	0.112	0.013	17.86
7.3.0	0.010	0.006	17.86

preferences:dark modelive previewkey bindings