PHP PDO::Commit Examples

Programming Language: PHP

Class/Type: PDO

Method/Function: Commit

Examples at hotexamples.com: 1

PHP PDO commit is a method used to commit the current transaction in a database. It confirms all the changes made to the database during the transaction.

Example 1:

// create a PDO object and begin a transaction
$dbh = new PDO('mysql:host=localhost;dbname=myDB', $user, $pass);
$dbh->beginTransaction();

// perform database operations
$stmt = $dbh->prepare("INSERT INTO users (username, password) VALUES (?, ?)");
$stmt->execute(array("john", "password123"));

// commit the transaction
$dbh->commit();

In this example, we are creating a PDO object and beginning a transaction. We are then inserting a new user into the database and finally committing the transaction.

Example 2:

// create a PDO object and begin a transaction
$dbh = new PDO('mysql:host=localhost;dbname=myDB', $user, $pass);
$dbh->beginTransaction();

// perform database operations
$stmt1 = $dbh->prepare("INSERT INTO users (username, password) VALUES (?, ?)");
$stmt1->execute(array("john", "password123"));

$stmt2 = $dbh->prepare("INSERT INTO orders (user_id, item_name) VALUES (?, ?)");
$stmt2->execute(array($dbh->lastInsertId(), "Product A"));

// commit the transaction
$dbh->commit();

In this example, we are creating a PDO object and beginning a transaction. We are then inserting a new user into the database and retrieving the last inserted ID. We are then inserting a new order for that user and committing the transaction. The PDO commit method is part of the PDO package library.

PHP PDO::Commit - 1 examples found. These are the top rated real world PHP examples of PDO::Commit extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

getAvailableDrivers(30)

beginTransaction(30)

exec(30)

errorInfo(30)

errorCode(30)

rollback(30)

rollBack(30)

quote(30)

commit(30)

setAttribute(30)

getAttribute(30)

prepare(30)

query(30)

inTransaction(30)

lastInsertId(30)

__construct(30)

sqliteCreateFunction(26)

lastErrorMsg(17)

Query(15)

getConnection(13)

PREPARE(7)

execute(6)

errorinfo(5)

getDatabasePlatformName(5)

sqliteCreateAggregate(5)

expects(4)

Quote(4)

lastInsertID(4)

close(4)

fetchAll(4)

Prepare(3)

begintransaction(3)

real_escape_string(2)

getData(2)

push(2)

print_r(2)

pop(2)

getCount(2)

update(2)

get(2)

createExpression(2)

tableName(2)

SetAttribute(2)

sqliteCreateCollation(2)

bindParam(2)

setattribute(2)

setCharset(2)

delete(2)

deleteTable(2)

fieldName(2)

Example #1

Show file

File: install_lmb.php Project: BillTheBest/1.6.x

 // DROITS
 $query = "INSERT INTO users_permissions (ref_user,id_permission,value) SELECT DISTINCT '" . $ENTREPRISE_USER['ref_user'] . "',id_permission,'ALL' FROM permissions;";
 $bdd->exec($query);
 $query = "DELETE FROM users_permissions WHERE id_permission IN (42,43);";
 $bdd->exec($query);
 //FONCTIONS
 $query = "INSERT INTO annu_collab_fonctions (ref_contact, id_fonction)\r\n\t\t\t\t\t\tVALUES ('" . $ENTREPRISE_REF_CONTACT . "', '1')";
 $bdd->exec($query);
 // *************************************************************************************************************
 // CREATION DU STOCK ET MAGASIN
 $query = "INSERT INTO stocks (id_stock, lib_stock, ref_adr_stock, actif, abrev_stock)\r\n\t\t\t\t\t\tVALUES (1, 'Stock principal', '" . $ENTREPRISE_ADRESSES[0]['ref_adresse'] . "', 1, 'Stock')";
 $bdd->exec($query);
 $nom_entreprise = str_replace(CHR(13), " ", str_replace(CHR(10), " ", $ENTREPRISE_NOM));
 $query = "REPLACE INTO `magasins_enseignes` (\r\n\t\t\t\t\t\t`id_mag_enseigne` ,\r\n\t\t\t\t\t\t`lib_enseigne`\r\n\t\t\t\t\t\t)\r\n\t\t\t\t\t\tVALUES (\r\n\t\t\t\t\t\t'1' , '" . $nom_entreprise . "'\r\n\t\t\t\t\t\t);";
 $bdd->exec($query);
 $bdd->Commit();
 //mise à jour des textes de bas de page des pdf
 maj_configuration_file("config_generale.inc.php", "maj_line", "\$PIED_DE_PAGE_GAUCHE_0 =", "\$PIED_DE_PAGE_GAUCHE_0 = \"" . addslashes(stripslashes(str_replace("\n", " ", $ENTREPRISE_NOM) . " - " . str_replace("\n", " ", $ENTREPRISE_ADRESSES[0]['text_adresse']) . " " . $ENTREPRISE_ADRESSES[0]['code_postal'] . " " . $ENTREPRISE_ADRESSES[0]['ville'])) . "\";", "config/");
 maj_configuration_file("config_generale.inc.php", "maj_line", "\$PIED_DE_PAGE_GAUCHE_1 =", "\$PIED_DE_PAGE_GAUCHE_1 = \"Siret: " . addslashes(stripslashes($ENTREPRISE_NOTE)) . "\";", "config/");
 maj_configuration_file("config_generale.inc.php", "maj_line", "\$PIED_DE_PAGE_DROIT_0 =", "\$PIED_DE_PAGE_DROIT_0 = \"Site Internet: " . addslashes(stripslashes($url_site)) . "\";", "config/");
 maj_configuration_file("config_generale.inc.php", "maj_line", "\$PIED_DE_PAGE_DROIT_1 =", "\$PIED_DE_PAGE_DROIT_1 = \"Email: " . addslashes(stripslashes($ENTREPRISE_COORDONNEES[0]['email'])) . "\";", "config/");
 //générer image du entete_doc_pdf
 $source = imagecreatefromjpeg("fichiers/images/entete_doc_pdf.jpg");
 $nom_contact = explode("\n", $ENTREPRISE_NOM);
 $l = 60;
 $c = 10;
 $size = 30;
 $couleur = imagecolorallocate($source, 0, 0, 0);
 $font = 'fichiers/arial.ttf';
 foreach ($nom_contact as $line) {
     imagettftext($source, $size, 0, $c, $l, $couleur, $font, utf8_encode(str_replace("\\S", "", str_replace("\t", "", $line))));