- 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:rsfilter

# rsFilter

The file `rsfilter.inc.php` must be manually included in the script

##### Syntax

    obj rsFilter (
         obj $recordSet,
         string $functionName
         )

## Description

The method `rsFilter()` applies a callback function given by the string `$functionName` to all records in an ADOdb recordset given by `$recordSet`.

## Parameters

### $recordSet

The recordset must be a valid recordset retrieved using a SELECT statement executed with either execute() or selectLimit().

### $functionName

The value of `$functionName` must point to a valid function that will be used to process the records in the set.

## Usage

    include_once 'adodb/rsfilter.inc.php';
    include_once 'adodb/adodb.inc.php';

    /*
    * ucwords() every element in the recordset
    */
    function doUcwords(&$arr,$rs)
    {
         foreach($arr as $k => $v) {
              $arr[$k] = ucwords($v);
         }
    }

    $db = newADOConnection('mysql');
    $db->pConnect('server','user','pwd','db');

    $rs = $db->Execute('select ... from table');
    $rs = rsFilter($rs,'doUcwords');

v5/reference/connection/rsfilter.txt · Last modified: 2016/01/16 17:17 by mnewnham

### Page Tools

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