Differences

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

--- activerecord:getactiverecords [2015/12/05 17:09] – mnewnham
+++ v5:activerecord:getactiverecords [2016/01/19 05:02] – ↷ Links adapted because of a move operation 66.249.75.209
@@ Line 11: / Line 11: @@
 </WRAP>
+-------------------------------------
 ===== Description =====
 This method retrieves an array of ADOdb_Active_Records.
@@ Line 21: / Line 21: @@
  Where clause
 ==== $bindarr ====
-For more information on the use of ''Bind'' variables, see [[reference:execute()]].
+For more information on the use of ''Bind'' variables, see [[v5:reference:connection:execute]].
 ==== $primaryKeyArray ====
@@ Line 35: / Line 35: @@
 $whereOrderBy = "name LIKE 'A%' ORDER BY Name";
 $primaryKeys  = array('id');
-$activeRecArr = $db->GetActiveRecords($table, $whereOrderBy,$primaryKeys);
+$activeRecArr = $db->getActiveRecords($table, $whereOrderBy,$primaryKeys);
 foreach($activeRecArr as $rec)
 {
@@ Line 41: / Line 41: @@
     $rec->save();
 }
+</code>
+And to retrieve all records ordered by specific fields:
+<code php>
+$whereOrderBy = "1=1 ORDER BY Name";
+$activeRecArr = $db->GetActiveRecords($table);
+/*
+* To use bind variables (assuming ? is the place-holder for your database):
+*/
+$activeRecArr = $db->getActiveRecords($tableName, 'name LIKE ?',
+						array('A%'));
+/*
+Define the primary key field[s] of the table by passing an array of field names:
+*/
+$activeRecArr = $db->GetActiveRecords($tableName, 'name LIKE ?',
+						array('A%'), array('id'));
 </code>
 {{tag>[Active_Record]}}