v5:reference:recordset:fetchobj
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
reference:fetchobj [2015/07/27 04:46] – created mnewnham | v5:reference:recordset:fetchobj [2023/06/11 12:25] (current) – dregad | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== fetchObj ======= | ====== fetchObj ======= | ||
+ | |||
+ | ~~NOTOC~~ | ||
+ | |||
<WRAP right box> | <WRAP right box> | ||
- | obj fetchObj( | + | obj fetchObj() |
- | optional bool $upperCaseKeys=false | + | |
+ | obj fetchObject( | ||
+ | optional bool $upperCaseKeys=true | ||
) | ) | ||
</ | </ | ||
+ | |||
+ | ====== fetchObject ======= | ||
+ | |||
===== Description ===== | ===== Description ===== | ||
+ | The '' | ||
+ | |||
+ | They can be considered as aliases, except for the fact that '' | ||
+ | |||
+ | Unlike the [[v5: | ||
+ | |||
+ | If the SQL statement results in an empty recordset or if the recordset has moved past end of file, then calling fetchObj() will return an empty record. Use [[v5: | ||
+ | |||
+ | Results are influenced both by the [[v5: | ||
+ | |||
+ | The ADOFetchObj object has no special functionality, | ||
+ | |||
+ | ------------------- | ||
+ | ===== Usage ===== | ||
+ | <code php> | ||
+ | /* | ||
+ | * Database connection assumed | ||
+ | */ | ||
+ | $SQL = " | ||
+ | $result = $db-> | ||
+ | $r = $result-> | ||
+ | | ||
+ | /* | ||
+ | * returns | ||
+ | ADOFetchObj Object | ||
+ | ( | ||
+ | [emp_no] => 10001 | ||
+ | [birth_date] => 1953-09-02 | ||
+ | [first_name] => Georgi | ||
+ | [last_name] => Facello | ||
+ | [gender] => M | ||
+ | [hire_date] => 1986-06-26 | ||
+ | ) | ||
+ | |||
+ | */ | ||
+ | |||
+ | print $r-> | ||
+ | /* | ||
+ | * prints ' | ||
+ | */ | ||
+ | </ | ||
+ | {{tag> |
v5/reference/recordset/fetchobj.1437965196.txt.gz · Last modified: 2017/04/21 11:37 (external edit)