Using Stored User Preferences

Stored data is of no use if it cannot be retrieved and acted upon. This section shows and explains how to retrieve and use both the server-side and client-side sessions, whose storage was described in the earlier section.

If a logged-in user has defined a subpage to be their initial display and stored this in the database as explained in the previous section, then this information must be retrieved and returned each time the user logs in again. The PHP LoginBCO/VCO is used to accomplish this on the server side and is shown in the following code. The lines shown in bold are those that are used to retrieve the client session CLOB.

As opposed to the additional SQL code required to handle CLOBs when storing data, nothing ...

Get Oracle Database Ajax & PHP Web Application Development now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.