ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


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 passed by reference 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/03/17 01:29 by mnewnham