ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:activerecord:getactiverecordsclass

This is an old revision of the document!


getActiveRecordsClass

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()
)

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 execute

$primaryKeyArray

$queryExtras

Query extras: limit, offset…

$relationsData

Usage

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();
}

To use bind variables (assuming ? is the place-holder for your database):

$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'));
v5/activerecord/getactiverecordsclass.1452648704.txt.gz · Last modified: 2017/04/21 11:21 (external edit)