->selectAdd() -- Add selected columns
Description
Adds a selected columns. By default a select query will request all
items (eg. SELECT * FROM table), to change this behavior
you can first call selectAdd() without any arguments to clear the
current request and then add the specific items you require.
You can also set up a default selection query by adding SelectAdd() method calls
in the object constructor method (the one with the same name as the class)
Note
This function can not be called
statically.
Example
Example 26-1. Using selectAdd() $person = new DataObjects_Person;
$person->selectAdd();
$person->selectAdd('id,name');
while ($person->fetch()) {
echo "$person->id} {$person->name}<BR>";
}
$person = new DataObjects_Person;
$person->selectAdd("DATE_FORMAT(birthday,'%d %m %Y') as birthday_formated ");
$person->id = 12;
$person->find(TRUE);
echo "$person->name} {$person->birthday_formated}<BR>"; |
|
Example 26-2. Resulting SQL SELECT id,name FROM person
SELECT *, DATE_FORMAT(birthday,'%d %m %Y') as birthday_formated FROM person WHERE id=12 |
|