<?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=? WHERE id=?";
    $pre = $db->prepare($sql);
    $pre->execute(array('Szeged', 2));
    $pre->execute(array('Zalaegerszeg', 3));


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

?>