->selectAdd() -- Add selected columns
Описание
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)
Заметка
Эта функция не должна вызываться статически.
Пример
Пример 35-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>"; |
|
Пример 35-2. Resulting SQL
SELECT id,name FROM person
SELECT *, DATE_FORMAT(birthday,'%d %m %Y') as birthday_formated FROM person WHERE id=12 |
|