Facebook OpenGraph: Add JSON-Feed into MySQL database
Closed - This job posting has been filled and work has been completed.
A daily Cronjob must read the JSON Feed of Facebook's open graph for one ore more facebook pages. The contained data has to be written in a MySQL database via PHP.
In the database must be a separate table for every Facebook page's open graph data. This table must have the name of the according ID (automatic ID detection out of the open graph data).
Every day a new column must be created for each table. In this column the following values and labels must be inserted:
“cover -> cover_id”, “cover -> source”, “likes”, “link”, “name”, “talking_about_count”, “username”, “website”, “were_here_count”, "category"
Here are two example Pages for the database: