Product Documentation

FairCom SQL for PHP PDO

Previous Topic

Next Topic

Transaction Processing


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.

  • Initialize() - Connects to the FairCom Database Engine.
  • Define() - Defines and creates our four tables/files.
  • Manage() - Adds rows/records to multiple tables/files under transaction control.
  • Done() - Disconnects from FairCom Database Engine.

Note our simple PHP script:


// 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("\t<title>PHP Tutorial 4</title>\n");




// Implementation of the concept of "init, define, manage and you're done..."


$session = Initialize();




We suggest opening the source code with your own editor.

Continue now to review these four steps.

In This Section





Additional Resources