Forum PHP.pl

[PHP] pobierz, plaintext 
<?php
/* Begin a transaction, turning off autocommit */
$dbh->beginTransaction();
 
/* Change the database schema and data */
$sth = $dbh->exec("DROP TABLE fruit");
$sth = $dbh->exec("UPDATE dessert
    SET name = 'hamburger'");
 
/* Recognize mistake and roll back changes */
$dbh->rollBack();
 
/* Database connection is now back in autocommit mode */
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
try
{
  $db->beginTransaction();
  $zapytanie = $db->prepare('INSERT INTO tabela (pole) VALUES (:pole)');
  $zapytanie->execute(array('pole' => 'wartość'));
  $id = $db->lastInsertId();  //lub: $db->lastInsertId('nazwa_sekwencji');
  $db->query('INNE ZAPYTANIE');
  $db->commit();
}
catch(PDOException $e)
{
  $db->rollBack();
}
[PHP] pobierz, plaintext