->query()
->query() – send a raw query
Synopsis
void $DB_DataObject->query (
string $string
)
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.
Parameter
-
string $string- SQL Query
Note
This function can not be called statically.
Example
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;
}
?>