$dsn = 'mysql:host=localhost;dbname=cinemas_ex;charset=utf8';

$pdo = new PDO($dsn, 'root', 'coderslab');

try {
    $pdo = new PDO($dsn, 'root', 'coderslab');
    $stmt = $pdo->query('UPDATE movies SET rating = (SELECT rating WHERE rating < 5) * 2 WHERE rating < 5');
    $stmt->execute();


} catch (PDOException $e) {
    echo $e->getMessage();
}

try {
    $pdo = new PDO($dsn, 'root', 'coderslab');
    $stmt = $pdo->query('UPDATE Payments SET type = "archived" WHERE DATEDIFF(NOW(), date) > 3');
    $stmt->execute();
} catch (PDOException $e) {
    echo $e->getMessage();
}