This repository contains a set of scripts to backup all your starred articles from Feedbin to a MySQL database. Code has been tested with Apache/2.4.18 , PHP v.5.5.38 and MySQL v5.7.19
First, head to the Feedbin settings page. In the 'Export' -section, click Export next to 'Starred Articles'. Feedbin will return a notification: "Starred export has begun. You will receive an email with the download link shortly”.
Next, check your inbox for an email with subject: "[Feedbin] Starred Items Export Complete” . The email contains a download link, which allows you to save the starred articles in a .JSON file.
- Download and copy the content of this repository to the DocumentRoot of your webserver.
- Store the
starred.json-file in the data/ directory.
-
Edit
db_create.phpin the include/ directory, change “username” and “password” if required. -
Launch
db_create.phpfrom your browser (via http://localhost/include/db_create.php ) to create the database and table structure -
Edit
db_connect.phpin the include/ directory, change “username” , “password” if required.
Direct your browser to http://localhost/data/import.php
This will parse the starred.json -file and insert the data into the database. Now direct your browser to http://localhost, this will display all entries found in the database.
Note: the layout is built with Bootstrap and uses the Font Awesome toolkit.
Complementary to the (initial) upload of starred articles in .JSON format, you can fetch additional starred articles through the XML feed.
First, head to the main Feedbin settings page and at the bottom of the page activate the "Enable starred article feed" -option and copy the URL (eg. https://feedbin.com/starred/THSYv5sdrKKOP92eQluQAQ.xml )
- Edit
feed.phpand include your own XML feed URL - Change database “username” and “password” if required
feed.php works similar to the upload of the .JSON file. It reads the content of the URL feed and writes the (new) entries to the database. You can run feed.php as a cron job to get frequent updates.