PDO.php

<?php

try {
    $pdo = new PDO('mysql:host=localhost;dbname=test', 'user', 'password');
} catch (PDOException $exc) {
    die($exc->getMessage());
}

$simpleQuery = $pdo->query('SELECT * FROM user WHERE rol_id = 2 LIMIT 3');

$resulsetSQ = $simpleQuery->fetchAll(PDO::FETCH_ASSOC);

var_dump($resulsetSQ);

$prepareQuery = $pdo->prepare('SELECT * FROM user WHERE email = :email LIMIT 1');

$prepareQuery->execute([
    ':email' => '[email protected]'
]);

$resulsetPQ = $prepareQuery->fetch(PDO::FETCH_OBJ);

var_dump($resulsetPQ);