Fetching a Sub Reddits latest posts is actually easy, mostly because the Reddit API is free and you don’t need a key.

You can do self archiving with PHP and MySQL very quickly.

Using the free Reddit api we can get the latest (newest) 50 posts/submits to  a sub using the following JSON endpoint http://www.reddit.com/r/SUBNAMEHERE/new.json?sort=new&limit=50 Note that you can return upto 100 results, but if you call the script every 1 or 2 minutes you will just be wasting resources.

Here is PHP code that also fetches data from the returned API JSON:

<?php
$data = json_decode(file_get_contents("http://www.reddit.com/r/SUBNAMEHERE/new.json?sort=new&limit=50"), true);
foreach ($data['data']['children'] as $val) {
    $title = $val['data']['title'];
    $domain = $val['data']['domain'];
    $url = $val['data']['url'];
    $reddit_link = $val['data']['permalink'];
    $post_id = $val['data']['id'];
    $date = $val['data']['created_utc'];
    $user = $val['data']['author'];
    $flair = $val['data']['author_flair_text'];
    $up = $val['data']['ups'];
    $comments = $val['data']['num_comments'];
    $thumbnail = $val['data']['secure_media']['oembed']['thumbnail_url'];
}

I have included examples to access some of the data in each of the returned “children” but not all..

{
          "approved_at_utc": null,
          "subreddit": "pics",
          "selftext": "",
          "author_fullname": "t2_gatxq",
          "saved": false,
          "mod_reason_title": null,
          "gilded": 0,
          "clicked": false,
          "title": "Anybody checked out the beautiful new year's full moon yesterday? Heres a pic i took",
          "link_flair_richtext": [],
          "subreddit_name_prefixed": "r/pics",
          "hidden": false,
          "pwls": 6,
          "link_flair_css_class": null,
          "downs": 0,
          "thumbnail_height": 140,
          "hide_score": true,
          "name": "t3_abhzu9",
          "quarantine": false,
          "link_flair_text_color": "dark",
          "author_flair_background_color": null,
          "subreddit_type": "public",
          "ups": 5,
          "domain": "i.redd.it",
          "media_embed": {},
          "thumbnail_width": 140,
          "author_flair_template_id": null,
          "is_original_content": false,
          "user_reports": [],
          "secure_media": null,
          "is_reddit_media_domain": true,
          "is_meta": false,
          "category": null,
          "secure_media_embed": {},
          "link_flair_text": null,
          "can_mod_post": false,
          "score": 5,
          "approved_by": null,
          "thumbnail": "https://b.thumbs.redditmedia.com/8BbyON-wnCUFy-fAIbuC_pP2uk9moz55YmuTTnVnuGY.jpg",
          "edited": false,
          "author_flair_css_class": null,
          "author_flair_richtext": [],
          "gildings": {
            "gid_1": 0,
            "gid_2": 0,
            "gid_3": 0
          },
          "post_hint": "image",
          "content_categories": [
            "photography"
          ],
          "is_self": false,
          "mod_note": null,
          "created": 1546376127,
          "link_flair_type": "text",
          "wls": 6,
          "banned_by": null,
          "author_flair_type": "text",
          "contest_mode": false,
          "selftext_html": null,
          "likes": null,
          "suggested_sort": null,
          "banned_at_utc": null,
          "view_count": null,
          "archived": false,
          "no_follow": false,
          "is_crosspostable": true,
          "pinned": false,
          "over_18": false,
          "preview": {
            "images": [
              {
                "source": {
                  "url": "https://preview.redd.it/2gaj8r907t721.jpg?auto=webp&s=1f2b2b0759605ee0bf613388caf6ec9794d22388",
                  "width": 3120,
                  "height": 4160
                },
                "resolutions": [
                  {
                    "url": "https://preview.redd.it/2gaj8r907t721.jpg?width=108&crop=smart&auto=webp&s=2acad265bf6fc57cb36f12de49910bb9148fdae1",
                    "width": 108,
                    "height": 144
                  },
                  {
                    "url": "https://preview.redd.it/2gaj8r907t721.jpg?width=216&crop=smart&auto=webp&s=fccaefe166c013601c48f32bfedca45347ec3922",
                    "width": 216,
                    "height": 288
                  },
                  {
                    "url": "https://preview.redd.it/2gaj8r907t721.jpg?width=320&crop=smart&auto=webp&s=deffeb956d186002daebce223220874a72967431",
                    "width": 320,
                    "height": 426
                  },
                  {
                    "url": "https://preview.redd.it/2gaj8r907t721.jpg?width=640&crop=smart&auto=webp&s=8c562de131301c0e759e4c6248f0967024f11360",
                    "width": 640,
                    "height": 853
                  },
                  {
                    "url": "https://preview.redd.it/2gaj8r907t721.jpg?width=960&crop=smart&auto=webp&s=c5b519c9392c25915ccce5d3d19844de01901915",
                    "width": 960,
                    "height": 1280
                  },
                  {
                    "url": "https://preview.redd.it/2gaj8r907t721.jpg?width=1080&crop=smart&auto=webp&s=f67def5fd07e9a97e9da839680f66d393b99225e",
                    "width": 1080,
                    "height": 1440
                  }
                ],
                "variants": {},
                "id": "AFOMmV7YjpTdqfBPasT-qqrseYBgrbJvqDySHVNN2cg"
              }
            ],
            "enabled": true
          },
          "media_only": false,
          "link_flair_template_id": null,
          "can_gild": true,
          "spoiler": false,
          "locked": false,
          "author_flair_text": null,
          "visited": false,
          "num_reports": null,
          "distinguished": null,
          "subreddit_id": "t5_2qh0u",
          "mod_reason_by": null,
          "removal_reason": null,
          "link_flair_background_color": "",
          "id": "abhzu9",
          "is_robot_indexable": true,
          "report_reasons": null,
          "author": "rrasic",
          "num_crossposts": 0,
          "num_comments": 0,
          "send_replies": true,
          "whitelist_status": "all_ads",
          "mod_reports": [],
          "author_patreon_flair": false,
          "author_flair_text_color": null,
          "permalink": "/r/pics/comments/abhzu9/anybody_checked_out_the_beautiful_new_years_full/",
          "parent_whitelist_status": "all_ads",
          "stickied": false,
          "url": "https://i.redd.it/2gaj8r907t721.jpg",
          "subreddit_subscribers": 20266416,
          "created_utc": 1546347327,
          "media": null,
          "is_video": false
}

There is a full post data.