Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $entries = SCAR::get('authors')
- ->byEmail($emails)
- ->entries()
- ->byPostTime('>=', $one_week_ago)
- ->byId(
- SCAR::get('tags')->byName($tag)
- );
- foreach ($entries as $entry) {
- echo "ENTRY $entry->id titled $entry->title\n";
- echo "Posted $entry->post_time by ".$entry->authors()->email."\n";
- echo "Tagged With:\n";
- foreach ($entry->tags() as $tag) {
- echo "$tag->name\n";
- }
- echo "Body: $entry->body\n\n\n\n";
- }
- ?>
- QUERIES:
- string(93) "QUERY: SELECT * FROM `authors` WHERE `email` IN ('jakob@felocity.org', 'jakob@notlocity.org')"
- string(52) "QUERY: SELECT * FROM `tags` WHERE `name` = 'awesome'"
- string(56) "QUERY: SELECT * FROM `entries_tags` WHERE `tag_id` = '1'"
- string(122) "QUERY: SELECT * FROM `entries` WHERE `author_id` IN ('1', '2') AND `post_time` >= '1203908504' AND `id` IN ('2', '6', '8')"
- string(58) "QUERY: SELECT * FROM `entries_tags` WHERE `entry_id` = '2'"
- string(44) "QUERY: SELECT * FROM `tags` WHERE `id` = '2'"
- string(58) "QUERY: SELECT * FROM `entries_tags` WHERE `entry_id` = '6'"
- string(58) "QUERY: SELECT * FROM `entries_tags` WHERE `entry_id` = '8'"
- OUTPUT:
- ENTRY 2 titled foo entry
- Posted 1204419391 by jakob@felocity.org
- Tagged With: awesome, cool
- Body: fo fo fo fo fooooooo
- ---
- ENTRY 6 titled random entry 131204357303
- Posted 1204419391 by jakob@felocity.org
- Tagged With:
- awesome
- Body: this is a random entry for 821204357303
- ---
- ENTRY 8 titled random entry 811204357823
- Posted 1204419391 by jakob@felocity.org
- Tagged With:
- awesome
- cool
- Body: this is a random entry for 901204357823
Add Comment
Please, Sign In to add comment