ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== getActiveRecordsClass ======
~~NOTOC~~
<WRAP right box>
== Syntax ==
  void getActiveRecordsClass(
   string $class,
   string $tableName,
   optional string  $where=false,
   optional mixed[] $bindarr=false,
   optional mixed[] $primaryKeyArray=false,
   optional mixed[] $queryExtras=array(),
   optional mixed[] $relationsData=array()
  )

</WRAP>

===== Description =====
This allows you to retrieve an array of objects derived from ADOdb_Active_Records. Returns false if an error occurs.

===== Parameters ===== 
====$class ====
This string represents the class of the current active record
==== $table ====
Table used by the active record object
==== $whereOrderBy====
 Where, order, by clause
==== $bindarr ====
For more information on the use of ''Bind'' variables, see [[v5:reference:connection:execute]]
==== $primaryKeyArray ====
 
==== $queryExtras ====
Query extras: limit, offset...
==== $relationsData ====

==== Usage ====
<code php>
class Product extends ADOdb_Active_Record{};
$table = 'products';
$whereOrderBy = "name LIKE 'A%' ORDER BY Name";
$activeRecArr = $db->getActiveRecordsClass('Product',
                                            $table,
                                            $whereOrderBy);

/*
* 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'));

</code>

{{tag>[Active_Record]}}