->query() -- send a raw query
Description
Sends a raw query to database. Often you may consider that using a large number of
whereAdd's and orderBy method calls are not necessary, and it would be simpler to just
write the query, to make the code clearer and shorter.
Note
This function can not be called
statically.
Example
Example 39-1. raw queries on the database
<?php
$person = new DataObjects_Person;
$person->query("SELECT * FROM {$person->__table} WHERE id > 12 ORDER BY id");
while ($person->fetch()) {
echo $person->name;
}
?>
|
|