Differences

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

--- activerecord:getactiverecordsclass [2015/12/05 01:55] – mnewnham
+++ v5:activerecord:getactiverecordsclass [2016/01/13 02:15] – ↷ Page moved from activerecord:getactiverecordsclass to v5:activerecord:getactiverecordsclass mnewnham
@@ Line 16: / Line 16: @@
 ===== Description =====
+This allows you to retrieve an array of objects derived from ADOdb_Active_Records. Returns false if an error occurs.
-GetActiveRecordsClass Performs an 'ALL' query
 ===== Parameters =====
@@ Line 36: / Line 35: @@
 ==== Usage ====
 <code php>
-include 'adodb/adodb.inc.php';
+class Product extends ADOdb_Active_Record{};
-include 'adodb/adodb-activerecord.inc.php';
+$table = 'products';
+$whereOrderBy = "name LIKE 'A%' ORDER BY Name";
+$activeRecArr = $db->GetActiveRecordsClass('Product',
+                                            $table,
+                                            $whereOrderBy);
-$db = NewADOConnection('mysqli');
+/*
-$db->connect('','user','password','employees');
+* the objects in $activeRecArr are of class 'Product'
+*/
+foreach($activeRecArr as $rec) {
+	$rec->id = rand();
+	$rec->save();
+}
+</code>
+To use bind variables (assuming ? is the place-holder for your database):
+<code php>
+$activeRecArr = $db->GetActiveRecordsClass($className,$tableName, 'name LIKE ?',
+						array('A%'));
+/*
+* You can also define the primary keys of the table by passing an array of field names:
+*/
+$activeRecArr = $db->GetActiveRecordsClass($className,$tableName, 'name LIKE ?',
+						array('A%'), array('id'));
-$activeRecs = $db->GetActiveRecords('departments');
 </code>
 {{tag>[Active_Record]}}