SQL for PHP PDO tutorial

Open the Start Menu and click the Settings gear icon to bring up “Windows Settings”.

In the search box, search for "Turn Windows features on or off" and select the application when it appears under the search box.

In the "Windows Features" window, check the Internet Information Services checkbox and expand Internet Information Services, World Wide Web Services, and Application Development Features. 

Check the box next to CGI.

Click OK and wait until the installation completes.

Restart your computer.

Verify that Windows IIS is functional by entering http://localhost into a browser address bar.

A “Microsoft Internet Information Services” web page should appear.

Download the PHP 7 SDK. Just press the green “Code” button and select “Download ZIP”.

A zip file with a name like “php-sdk-binary-tools-master.zip” will download.

After the download has finished, extract all its files into the root of your C: drive.

Rename the “C:\php-sdk-binary-tools-master” folder to “C:\php-sdk”.

The “C:\php-sdk” folder should contain some “phpsdk-____.bat” files and other folders and files.

Run the batch file of the version you want to use.

Open a Developer Command Prompt window for the version of Microsoft Visual Studio you are using. Typically, this is available from the Start menu, following a path similar to:

Visual Studio 2017 > X64 Native Tools Command prompt for VS 2017

where 2017 is your version of Visual Studio and X64 is for a 64-bit version of your FairCom product. Use X86 for 32-bit versions of your FairCom product.

In the Developer Command Prompt window, move to the C:\php-sdk folder.

Execute the “phpsdk-______.bat” file that corresponds to the version of Visual Studio you chose. Here is a typical listing of the available batch files:

vc14/vc15/vs16 is the version of Microsoft Visual Studio you chose to use.

x64/x86 is the bit depth of your FairCom product; “x64”=64 bits, “x86”=32 bits

After executing the batch file, the command prompt should have changed to a “$”:

Execute one of the following commands:

phpsdk_buildtree phpdev

phpsdk_buildtree master

The second command is used if you chose to use the “master” branch of PHP earlier.

Depending on which batch file you run in this step, a “phpdev” or “master” folder tree will be created in your C:\php-dev folder, and you will be moved into a “working folder” in that folder tree. Make a note of the working folder, such as “C:\php-sdk\phpdev\vc15\x64,” shown in the image that appears. You will later be unzipping a TAR file into this folder.

Download the version of PHP that you want to use. Do not follow the “Windows downloads” link, because this leads to ZIP files which do not contain the source code that we need to build from source. Only the tar files contain the source code we need. Depending on what version of PHP you are downloading, you might have to follow the “Old archives” link at the right-hand side of the page. The tar files are available in three different compression formats: bz2, gz, and xz. Choose any one of them. The freely-available, open source 7zip program can be used to unzip any of them. If you chose the bz2 compression format, your file will have a name like php-7.4.8.tar.bz2.

Once the download is complete, open the tar file with a file decompressor and open the first folder (the .tar archive). This should show a single folder, which has the same name as the PHP version shown in the previous step (“php-7.4.8” in this example). Drag that PHP folder into the “working folder” (“C:\php-sdk\phpdev\vc15\x64” in this example). At this point, your “working folder” should contain two folders - the original “deps” folder and your new PHP folder which came from the tar file. The new PHP folder contains the source code of PHP.

In the Developer Command Prompt window, change directories to the new PHP folder you just created and filled from the tar file. You will probably need to change the version in php7-.4.8 to match the PHP version above.

Download and extract the source code of all of the PHP dependencies by executing phpsdk_deps -u if you are not using the “master” branch. If you are using the “master” branch execute phpsdk_deps -u -b master

The process may take a few minutes. It should finish with a message such as “Updates performed successfully.” It might display INFO: Could not find files for the given pattern(s) which is not a problem.

At the Command Prompt, run the following based on the FairCom product you are using to specify your add-modules-dir. <basedir> is the full path of your FairCom product installation directory:

c-treeACE

buildconf --force --add-modules-dir=<basedir>\sdk\sql.php.pdo

c-treeRTG

buildconf --force --add-modules-dir=<basedir>\Driver\sql.php.pdo

c-treeEDGE

FairCom-DB

FairCom-EDGE

FairCom-RTG

buildconf --force --add-modules-dir=<basedir>\drivers\php.sql.pdo

You should get a message about adding the specified folder to the module search path.

Now run the following command with <basedir> changed as in the previous step:

configure --disable-all --disable-zts --enable-pdo --enable-cli --enable-cgi --enable-object-out-dir=.. --disable-ipv6 --with-pdo-ctsql=shared,<>basedir

This will do some checks and print configuration information. There should be no warnings or error messages, and it should end by telling you to “Type 'nmake' to build PHP”.

If you get Unknown option --with-pdo-ctsql, it means the “add-modules-dir” you specified was incorrect. Go back and verify that the folder exists.

If you get the following warning, it means the <basedir> folder you specified in the “configure” command (in this step) is incorrect.

WARNING: ctreesql not enabled; libraries and headers not found

You know this step worked correctly if you see something like the following in the output, which indicates the our PHP PDO extension was found and enabled:

|Enabling extension __________\drivers\php.sql.pdo\src

The last box of configuration information that is printed should have “Thread Safety” shown as “No”. That is the purpose of the “--disable-zts” flag (“Zend Thread Safety”). If “Thread Safety” is still shown as “Yes”, then add “--disable-maintainer-zts” flag to the 'configure' command you ran at the start of this step as well. We are turning off thread safety because we are using IIS + FastCGI, and this combination requires thread safety to be turned off.

Make the PHP and PHP PDO extension by running the following command in the Developer Command Prompt:

nmake

There will likely be many compiler warnings as PHP is built, but they can be ignored.Once PHP is built, a message should return confirming its completion.

At the command prompt make sure a new “Release” folder has appeared in the “working folder”:

dir ..

The folder should be called “Release”. If there is no “Release” folder, but there is a “Release_TS” folder, it means that Thread Safety was not turned off. The “Release” folder should contain the “php.exe” application you just built. Now copy one of the INI file templates from the current folder into that Release folder, using the following command:

copy php.ini-development ..\Release\php.ini

Make a note of this “Release” folder’s full path. You will need it in subsequent steps of these instructions and in the “Configure Microsoft IIS” instructions.

Use a text editor to open the php.ini file you just created and search for lines ";extension_dir"

Un-comment one of them by removing the leading semicolon, and change the line so the directory is the Release folder that contains the INI file and "php.exe". For example, the line should now read something like

"extension_dir = "C:\php-dev\phpdev\vc15\x64\Release""

Find the section of the INI file that contains the commented-out list of extensions and find the line for “pdo_mysql”

Make a copy of that line then remove the leading semicolon, and change it to “pdo_ctsql". Be sure to save the INI file after you have finished making your changes.

If you are using PHP7.1.33, the extension line reads something like "extension=php_pdo_ctsql.dll"

Copy the “ctsqlapi.dll” file from the appropriate FairCom product folder to the “Release” folder that contains the INI file you just edited and “php.exe”. You can find “ctsqlapi.dll” in the following folder, where <basedir> is the full path of your FairCom product installation directory:

c-treeACE

<basedir>\bin\sql.direct\

c-treeRTG

<basedir>\bin\sql.direct\

c-treeEDGE

FairCom-DB

FairCom-EDGE

FairCom-RTG

<basedir>\drivers\ctree.drivers\lib\

In the Developer Command Prompt, verify that PHP built correctly and the extension loads correctly by first changing into the Release folder and then running the PHP version command:

cd ..\Releasephp -v

Upon completion, version information should be printed with no error messages. If there are error messages about being unable to load dynamic library 'pdo_ctsql', then there was likely an issue in previous steps.

At this point, you can test the FairCom PHP PDO tutorials from the command line as follows:

c-treeACE

php -f <basedir>\sdk\sql.php.pdo\tutorials\PHP_Tutorial1.php

c-treeRTG

php -f <basedir&gt;\Driver\sql.php.pdo\tutorials\PHP_Tutorial1.php

c-treeEDGE

FairCom-DB

FairCom-EDGE

FairCom-RTG

php -f <basedir&gt;\drivers\php.sql.pdo\tutorials\PHP_Tutorial1.php

It should print the HTML source code of a web page. If “ctsqlConnect: -20212 Error in Network Daemon” is shown, it means the FairCom server is not running. Start the FairCom server and re-do this step. The following is the correct output:

<html>
<head>
<title>PHP Tutorial 1</title>
</head>
<body>
<h4>INIT</h4>
Logon to server...<br>
<h4>DEFINE</h4>
Create table...<br>
<h4>MANAGE</h4>
Delete records...<br>
Add records...<br>
Display records...<br>
<TABLE border=1>
<TR><TH>Number</TH><TH>Name</TH></TR>
<TR><TD>1000</TD><TD>Bryan Williams</TD></TR>
<TR><TD>1001</TD><TD>Michael Jordan</TD></TR>
<TR><TD>1002</TD><TD>Joshua Brown</TD></TR>
<TR><TD>1003</TD><TD>Keyon Dooling</TD></TR>
</TABLE>
<h4>DONE</h4>
Logout...<br>
</body>
</html>

If you wish, you can repeat this step for each of the PHP tutorials

See How to build PHP for more details. The instructions above do not follow that web page exactly.

Open the Start Menu, select Run, and execute InetMgr.exe.

In the InetMgr main window, double-click Handler Mappings.

In the Handler Mappings window, click Add Module Mapping... on the right-side Actions menu:

Complete the "Add Module Mapping" dialog window with the following:

Request Path: *.php

Module: FastCgiModule

Executable: This needs to be filled in with the full path to the “php-cgi.exe” executable that is in the “Release” folder created in Compile PHP and the PHP PDO extension (Windows). An example path would be “C:\php-sdk\phpdev\vc15\x64\Release\php-cgi.exe”.

Name: PHP

Click OK and then Yes on the "Add Script Map" message box that appears. Finally, close the InetMgr dialog.

Restart your computer to ensure everything is configured.

Copy the contents of the FairCom PHP PDO “tutorials” directory into the C:\inetpub\wwwroot directory. This requires Administrator privileges. The files are found in your FairCom installation folder:

c-treeAce

<faircom>\sdk\sql.php.pdo\tutorial

c-treeRTG

<faircom>\driver\sql.php.pdo\tutorials

c-treeEDGE

FairCom-DB

FairCom-EDGE

FairCom-RTG

<faircom>\driver\php.sql.pdo\tutorials

Open your favorite web browser and connect to http://localhost. You should see the index.htm page with hyperlinks to the three tutorials to be executed. Some systems you might have to use http://localhost/index.htm instead.

Click on the tutorial hyperlinks to execute the tutorials.

Create the Configuration Script

Move to the <faircom>/drivers/php.sql.pdo/src directory.

Run the phpize command to create the configuration script:

phpize

Configure and Build

Run the configure script to create the makefile containing the instructions to build the FairCom PHP extension:

./configure

You should see the following line in the text that is printed:

checking whether to enable PDO c-tree SQL support... yes, shared

Build FairCom PHP PDO extension using make. If you change versions of PHP, you should do a make clean first, before doing make:

make

It should say “Build complete” when done. The extension will be created in the modules folder:<faircom>/drivers/php.sql.pdo/src/modules/pdo_ctsql.so

Install the Extension

Run the following command to Install the FairCom PHP extension into your PHP installation extensions directory:

sudo make install

Be sure the pdo.ctsql.so file has the same permissions as the other .so files in that install folder.

Be sure php.ini is configured to load extensions from the PHP installation extensions directory. If you have a configure script with installed Autotools, follow these steps:

> libtoolize 
> aclocal 
> autoreconf -i
> phpize 
> ./configure --with-pdo-ctsql

Open php.ini with your favorite text editor. In most installations, you will find the server (SAPI) version of php.ini in /etc/php/apache2/php.ini

In Linux installations of PHP, there is often a separate php.ini file for SAPI (PHP served from a web server), and for CLI (PHP run from the Command Line). If you intend to test things from the command line, be sure to make the following changes to the CLI version of php.ini (usually /etc/php/cli/php.ini) as well as the SAPI version of php.ini.

Search for extension_dir.

If the extension_dir line is commented out (; on the beginning of the line) leave it that way, because the “make install” step during the build should have copied “pdo_ctsql.so” into the default extension folder

If this line is not commented, it's better to copy pdo_ctsql.so into your default PHP extensions directory (the directory listed in the php.ini file).

Search for extensions area and add extension=pdo_ctsql.so to configure the FairCom SQL PHP module into your PHP:

; If you wish to have an extension loaded automatically, use the following syntax
; 
;   extension=modulename.extension
;
; For example, on Windows:
;
;   extension=php_ldap.dll
;
; ... or under UNIX:
;
;   extension=php_ldap.so
;
; Note that it should be the name of the module only; no directory information
; needs to go here. Specify the location of the extension with the 
; extension_dir directive above.

; Example lines:

;extension=php_ldap.so
;extension=gd.so
extension=pdo_ctsql.so

Your copy of php.ini might have the extensions end with “.so” and it might not, depending on the version of PHP you are using. For this reason, we recommend that you follow the pattern of the other extensions already listed in the file. For example, find the existing “pdo_mysql” extension line, copy it, remove the leading semicolon, and then change two letters to make it say “pdo_ctsql”...

Save the changes to php.ini and close your text editor. If desired, change the other php.ini file as well.

The libctsqlapi.so file must be in either its original location when the PHP module was built or in a directory part of the library path.

The pdo_ctsql module you just built should already know the location of libctsqlapi.so, because the build added the libctsqlapi.so directory to the pdo_ctsql.so module library path. So, unless you have renamed or deleted the folder, you should be OK. Later in deployment situations, you might need to put libctsqlapi.so in a more generic place, for example, you may have built pdo_ctsql.so on a different machine.

Make sure the previous steps worked by launching PHP, as follows:

php -v

No error messages or warnings should be printed.

If you previously modified the CLI version of php.ini, you can run the tutorials from the command line, as follows:

php -f ../tutorials/PHP_Tutorial1.php

Here is what the correct output of this command should look like:

<html>
<head>
<title>PHP Tutorial 1</title>
</head>
<body>
<h4>INIT</h4>
Logon to server...<br>
<h4>DEFINE</h4>
Create table...<br>
<h4>MANAGE</h4>
Delete records...<br>
Add records...<br>
Display records...<br>
<TABLE border=1>
<TR><TH>Number</TH><TH>Name</TH></TR>
<TR><TD>1000</TD><TD>Bryan Williams</TD></TR>
<TR><TD>1001</TD><TD>Michael Jordan</TD></TR>
<TR><TD>1002</TD><TD>Joshua Brown</TD></TR>
<TR><TD>1003</TD><TD>Keyon Dooling</TD></TR>
</TABLE>
<h4>DONE</h4>
Logout...<br>
</body>
</html>

If you wish, you can repeat this step for each of the PHP tutorials.

It should print the HTML source code of a web page.

If “error in tcp bind 111 - SQLSTATE[20212] ctsqlConnect: -20212 Error in Network Daemon - SQL ERROR [-20212]” is shown, it means the FairCom server is not running. Start the FairCom server and re-do this step.

If “could not find driver - SQL ERROR [0]” is shown, it probably means that you did not edit the CLI version of php.ini above.

Testing from the command line allows you to see the error messages, even if PHP fails to launch (because it is misconfigured). The tutorial files do not need to be copied to the web server's documents directory in order to do this test.

From the root shell restart your web server with the following command:

/etc/init.d/apache2 restart

Open a root shell, move to /var/www/ and copy the contents of the<faircom>drivers/php.sql.pdo/tutorials/ directory:

debian:~# cd /var/www/debian:/var/www# cp -v <faircom>/php.sql.pdo/tutorials/* .

Adjust the path based on your installation directory.

Make sure FairCom SQL is running.

Open your favorite web browser and connect to http://localhost/index.htm (make sure you are using a proper URL if you did not use the web server root directory).

You should see the index.htm page with hyperlinks to the three tutorials to be executed:

Click the tutorials hyperlinks to execute the tutorials.

Initialize()

Connects to the FairCom Database Engine.

Define()

Creates a customer master table named custmast.

Manage()

Done()

Disconnects from FairCom Database Engine.

Initialize()

Connects to the FairCom Database Engine.

Define()

Creates "custmast", "custordr", "ordritem" and the "itemmast" tables with related indexes.

Manage()

Done()

Disconnects from FairCom Database Engine.

Initialize()

Connects to the FairCom Database Engine.

Define()

Defines and creates our four tables/files.

Manage()

Done()

Disconnects from FairCom Database Engine which releases resources.