Differences

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

--- activerecord:getactiverecords [2015/12/05 01:21] – [Usage] mnewnham
+++ v5:activerecord:getactiverecords [2018/07/02 14:19] (current) – prefer functions start lowercase (#430) peterdd
@@ Line 2: / Line 2: @@
 ~~NOTOC~~
 <WRAP right box>
-== syntax ==
+== Syntax ==
-  void getActiveRecords(
+  bool getActiveRecords(
     string $tableName,
     optional string  $where=false,
@@ Line 11: / Line 11: @@
 </WRAP>
+-------------------------------------
 ===== Description =====
+This method retrieves an array of ADOdb_Active_Records.
-GetActiveRecordsClass Performs an 'ALL' query
 ===== Parameters =====
@@ Line 23: / 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 37: / 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 43: / 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]}}