Differences

This shows you the differences between two versions of the page.

--- v5:userguide:learn_abstraction:using_execute [2016/03/15 17:44] – [Reading Data] review dregad
+++ v5:userguide:learn_abstraction:using_execute [2020/01/02 12:03] (current) – ↷ Links adapted because of a move operation dregad
@@ Line 43: / Line 43: @@
 ^Command^Description|
 | [[v5:reference:recordset:move|move()]]                       | Move to the n<sup>th</sup> record of a recordset                                |
-| [[v5:reference:connection:movenext|moveNext()]]               | Moves the cursor to the next record of the recordset from the current position  |
+| [[v5:reference:recordset:movenext|moveNext()]]               | Moves the cursor to the next record of the recordset from the current position  |
 | [[v5:reference:recordset:movefirst|moveFirst()]]             | Moves the cursor to the first record of the recordset                           |
-| [[v5:reference:connection:movelast|moveLast()]]               | Moves to the last record of a recordset                                         |
+| [[v5:reference:recordset:movelast|moveLast()]]               | Moves to the last record of a recordset                                         |
 ===== Writing Data =====
@@ Line 80: / Line 80: @@
 $result = $db->selectLimit($sql,10,200);
 </code>
+===== Creating A Recordset Filter =====
+A recordset filter pre-processes all the rows in a recordset after retrieval but before we use it. For example, we want to apply the PHP function //**ucwords**// to all the values in the recordset.
+In order to apply the filter, we must include the extra file **rsfilter.inc.php**
+<code php>
+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');
+</code>
+The [[v5:reference:connection:rsfilter|rsFilter()]] method takes 2 parameters, the recordset **(passed by reference)**, and the name of the filter function. It returns the processed recordset scrolled to the first record.