|
|
|
php.sql.pdo\tutorials\PHP_Tutorial4.php
Now we will discuss transaction processing as it relates to the FairCom DB PHP Interface using the PDO (PHP Data Object) extension.
Transaction processing provides a safe method by which multiple database operations spread across separate tables/files are guaranteed to be atomic. By atomic, we mean that, within a transaction, either all of the operations succeed or none of the operations succeed. This "either all or none" atomicity ensures that the integrity of the data in related tables/files is secure.
Like all other examples in the c-tree tutorial series, this tutorial simplifies the creation and use of a database into four simple steps: Initialize(), Define(), Manage(), and You’re Done()!
Tutorial #4: Transaction Processing
Here we demonstrate transaction control.
Note our simple PHP script:
<?php
// PHP_Tutorial4.php
//
// Public domain PHP example using PDO
//
// FairCom Corporation, 6300 West Sugar Creek Drive, Columbia, MO 65203 USA
//
// The goal of this tutorial is to introduce the most basic PHP API
// to accomplish creating and manipulating a table through the ctreeServer
//
// Functionally, this application will perform the following:
// 1. Logon onto a session
// 2. Create 4 tables each with an index
// 3. Add records in multiple tables under transaction processing control
// 4. Display the contents of the tables
print("<html>\n");
print("<head>\n");
print("\t<title>PHP Tutorial 4</title>\n");
print("</head>\n");
print("<body>\n");
//
// Implementation of the concept of "init, define, manage and you're done..."
//
$session = Initialize();
Defines($session);
Manage($session);
Done($session);
We suggest opening the source code with your own editor.
Continue now to review these four steps.
