v5:activerecord:getactiverecords
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
activerecord:getactiverecords [2015/12/05 01:55] – mnewnham | v5:activerecord:getactiverecords [2018/07/02 14:19] (current) – prefer functions start lowercase (#430) peterdd | ||
---|---|---|---|
Line 3: | Line 3: | ||
<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 23: | Line 21: | ||
Where clause | Where clause | ||
==== $bindarr ==== | ==== $bindarr ==== | ||
- | For more information on the use of '' | + | For more information on the use of '' |
==== $primaryKeyArray ==== | ==== $primaryKeyArray ==== | ||
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