Documentation

PHP SQL Developer's Guide

Next Topic

c-treeACE SQL PHP for c-treeACE SQL

Today’s progressive business environments demand online availability. The method of choice is via the web and PHP has become the language of choice for dynamic web scripting.

PHP (Hypertext PreProcessor) is a widely-used general-purpose scripting language that is especially suited for web development and can be embedded into HTML. c-treeACE SQL is a powerful database technology offering a wide range of interfaces now including PHP support. FairCom’s c-treeACE SQL PHP module extends your data access to the world through this popular web interface.

c-treeACE SQL PHP Interface technology gives the means to access data from c-treeACE SQL.

c-treePHP Diagram

c-treeACE SQL PHP modules can be installed with either Apache or Microsoft IIS (Windows) web servers.

Accessing c-treeACE from PHP

The c-treeACE package provides two versions of the c-treeACE SQL PHP drivers, each in its own directory:

sql.php.pdo

C:\FairCom\v11.x.x\winX64\sdk\sql.php.pdo - Notice the folder name is sql.php.pdo
If you are using c-treeRTG, adjust the path to match your version, e.g., V2.2.0.RTG, and replace sdk with Driver.

These drivers support PHP 7 and the PDO (PHP Data Object) extension.

This is the preferred way to access c-treeACE from PHP.

sql.php

C:\FairCom\v11.x.x\winX64\sdk\sql.php
(If you are using c-treeRTG, adjust the path to match your version, e.g., V2.2.0.RTG, and replace sdk with Driver.)

These drivers support PHP 5. See C:\FairCom\v11.x.x\winX64\sdk\sql.php.pdo for PHP 7 support.

Instructions are provided for using the c-treeACE SQL ODBC interface to connect c-treeACE to PHP. All later versions of PHP (PHP 4, PHP 5, and PHP 7) are compatible with the ODBC interface.

Note: If you are NOT using ODBC, only PHP 5 is supported. Use the other folder, sql.php.pdo, to connect to c-treeACE using PHP 7.

Each folder contains a ReadMe file for the drivers in that folder.

Documentation about c-treeACE SQL can be found on FairCom’s web site www.faircom.com.

TOCIndex