| Report new bug | New search | Development Roadmap | Status: Open | Feedback | All |
| Bug #5411 | Example 32-1. raw queries on the database | ||
|---|---|---|---|
| Submitted: | 2005-09-15 09:55 UTC | ||
| From: | alexandre dot barault at gmail dot com | Assigned: | |
| Status: | Duplicate | Package: | Documentation |
| PHP Version: | 5.0.0 | OS: | |
| Roadmaps: | (Not assigned) | ||
[2005-09-15 09:55 UTC] alexandre dot barault at gmail dot com
Description:
------------
example query.
the example is there to demonstrate, you can pass a raw query.
but in fast $person->find(); take the primary attention to the script and redefine the query.
If you want to use a raw query, you must drop the line with the method find().
Test script:
---------------
<?php
$person = new DataObjects_Person;
$person->query("SELECT * FROM {$person->__table} WHERE id > 12 ORDER BY id");
$person->find();
while ($person->fetch()) {
echo $person->name;
}
?>
Expected result:
----------------
i wait select * from person where id>12 ORDER BY id.
Actual result:
--------------
the query display select * from person.
Comments
[2005-09-22 08:33 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!