v5:activerecord:getactiverecords
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
activerecord:getactiverecords [2015/12/05 01:21] – [Usage] mnewnham | activerecord:getactiverecords [2015/12/05 21:19] – [Usage] mnewnham | ||
---|---|---|---|
Line 2: | Line 2: | ||
~~NOTOC~~ | ~~NOTOC~~ | ||
<WRAP right box> | <WRAP right box> | ||
- | == syntax | + | == Syntax |
- | | + | |
string $tableName, | string $tableName, | ||
optional string | optional string | ||
Line 11: | Line 11: | ||
</ | </ | ||
+ | ------------------------------------- | ||
===== Description ===== | ===== Description ===== | ||
- | + | This method retrieves | |
- | GetActiveRecordsClass Performs | + | |
===== Parameters ===== | ===== Parameters ===== | ||
Line 37: | Line 35: | ||
$whereOrderBy = "name LIKE ' | $whereOrderBy = "name LIKE ' | ||
$primaryKeys | $primaryKeys | ||
- | $activeRecArr = $db->GetActiveRecords($table, $whereOrderBy, | + | $activeRecArr = $db->getActiveRecords($table, $whereOrderBy, |
foreach($activeRecArr as $rec) | foreach($activeRecArr as $rec) | ||
{ | { | ||
Line 43: | Line 41: | ||
$rec-> | $rec-> | ||
} | } | ||
+ | </ | ||
+ | |||
+ | And to retrieve all records ordered by specific fields: | ||
+ | <code php> | ||
+ | |||
+ | $whereOrderBy = "1=1 ORDER BY Name"; | ||
+ | $activeRecArr = $db-> | ||
+ | /* | ||
+ | * To use bind variables (assuming ? is the place-holder for your database): | ||
+ | */ | ||
+ | |||
+ | $activeRecArr = $db-> | ||
+ | array(' | ||
+ | |||
+ | /* | ||
+ | Define the primary key field[s] of the table by passing an array of field names: | ||
+ | */ | ||
+ | $activeRecArr = $db-> | ||
+ | array(' | ||
</ | </ | ||
{{tag> | {{tag> |
v5/activerecord/getactiverecords.txt · Last modified: 2018/07/02 14:19 by peterdd