Online PHP editor | perf for sRhIJ

@ 2018-07-14T00:33:41Z

<?php

use PDO;

class Role
{
    private $db;
    private $userId;

    public function __construct(PDO $db, $userId)
    {
        $this->db     = $db;
        $this->userId = $userId;
    }

    public function hasPermission($permissionName)
    {
        $sql = $this->db->prepare('
            SELECT p.name FROM users
            INNER JOIN user_product u on users.id = u.user_id
            INNER JOIN products p on u.product_id = p.id
            WHERE users.id = ?
        ');
        $sql->execute([$this->userId]);
        $results = $sql->fetchAll(PDO::FETCH_COLUMN);

        if (in_array($permissionName, $results)) {
            return true;
        }

        return false;
    }
}


Then used by:

$role = new Role($auth->userId);

$role->hasPermission('foo');

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)
7.2.7	0.025	0.003	14.63
7.2.6	0.014	0.009	14.85
7.2.5	0.022	0.003	14.79
7.2.4	0.022	0.006	14.75
7.2.3	0.013	0.010	14.51
7.2.2	0.015	0.009	14.83
7.2.1	0.015	0.009	14.76
7.2.0	0.014	0.007	14.64
7.1.17	0.019	0.006	13.54
7.1.16	0.020	0.007	13.52
7.1.15	0.018	0.009	13.75
7.1.14	0.017	0.010	13.70
7.1.13	0.011	0.009	13.59
7.1.12	0.011	0.011	13.72
7.1.11	0.021	0.003	13.84
7.1.10	0.092	0.010	13.50
7.1.9	0.013	0.007	13.50
7.1.8	0.007	0.013	13.48
7.1.7	0.028	0.003	13.29
7.1.6	0.032	0.006	31.55
7.1.5	0.049	0.006	31.43
7.1.4	0.044	0.006	31.63
7.1.3	0.040	0.007	31.52
7.1.2	0.045	0.007	31.55
7.1.1	0.013	0.015	13.29
7.1.0	0.010	0.010	13.57

preferences:dark modelive preview