Using trusted connections in PHP

In the previous recipe, we saw how we can use trusted connections in Java. In this recipe, we will use trusted connections in PHP. Starting from DB2 9.5 FP3, the ibm_db2 extension for PHP supports trusted connections. We will use this extension to see how we can create trusted connections and how we can switch user IDs on an established trusted connection.

Getting ready

1. 1. To establish trusted connections, we need the IBM_DB2 extension configured in PHP.

2. 2. We need a trusted context to be created at the database. We can use the following command to create the trusted context:

CREATE TRUSTED CONTEXT ctx_common
BASED UPON CONNECTION USING SYSTEM AUTHID db2admin
ATTRIBUTES (ADDRESS 'localhost',
ENCRYPTION 'NONE')
ENABLE
WITH USE FOR tcuserwoa WITHOUT AUTHENTICATION,
tcusera WITH AUTHENTICATION;

This trusted context will allow tcuserwoa to use a trusted context without authentication and tcuserwa to use a trusted context with authentication.

How to do it...

By...