<?php

$user = "felhasznalonev";
$pass = "titok";
$host = "localhost";
$db = "proba";

$conn = new PDO("mysql:$host=$host;dbname=$db;charset=UTF-8", "$user", "$pass");

try
{
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $conn->beginTransaction();
    $sql = "UPDATE Szemely SET telepules='Debrecen' WHERE id=1";
    $conn->exec($sql);

    $sql = "UPDATE Szemely SET telepules='Debrecen' WHERE id=2";
    $conn->exec($sql);

    $conn->commit();
} catch (PDOException $e)
{
    $conn->rollBack();
}


?>