- skip to content

# Database Abstraction Layer

### User Tools

- Login

### Site Tools

- Recent changes
- Media Manager
- Sitemap

### Sidebar

##### Resources

- Reference Manual
- User Guide
- The Data Dictionary
- ADOdb-xmlschema
- ADOdb Active Record
- Performance Monitoring
- Date/Time Library
- Session Management Library
- Unsupported Addons
- Coding Standards

##### Supported Databases

- Access
- ADO
- CSV
- Firebird
- Frontbase
- IBM DB2
- Informix
- Interbase
- LDAP
- Microsoft SQL Server
- MySQL
- Netezza
- ODBC
- ODBTP
- Oracle
- PDO
- Postgresql
- SAP ADS
- SAP ASE
- SAP Maxdb
- SAP Sqlanywhere
- Sqlite
- Sybase
- Plain Text
- Visual Foxpro

##### Other

- Feature Comparison Matrix
- Connection Matrix
- Include File Guide

v5:reference:connection:cachegetcol

# cacheGetCol

##### syntax

     mixed cacheGetCol {
           mixed $cacheSeconds
           optional mixed $sql=ffalse
           optional string[] $bindvars=false
           optional bool $trimString=false
           }

## Description

Cache functions search for the results of an executed query in the query cache. The results of a query have an expiration time specified by the first parameter. If an unexpired cache result is not found, the query is cached for the specified period.

For an explanation of the syntax of the other parameter of `cacheGetCol()`, see getCol().

### Usage

    /*
     * DB2 Connection assumed
    */
    $ar = $db->cacheGetCol(2400,"SELECT * FROM ACT");

    /*
     * $ar returns:
    Array
    (
        [0] => 10
        [1] => 20
        [2] => 30

    .......
    */

[cache]
v5/reference/connection/cachegetcol.txt · Last modified: 2016/01/16 18:21 by mnewnham

### Page Tools

- Show pagesource
- Old revisions
- Backlinks
- Rename Page
- Back to top