Automated PHP script to post database values to facebook page via cronjob

Completed Posted Jun 28, 2012 Paid on delivery
Completed Paid on delivery

I need php script(s) to collect data from a mysql table and create a facebook page post, which will then be automatically posted once a day.

The facebook page post will have a defined format (see below), but will get new values daily from the mysql table and will need to calculate some as well.

Gold: ?1,714 (-56 / [url removed, login to view]%)

Silver: ?34.56 ([url removed, login to view] / [url removed, login to view]%)

Platinum: ?1,686 (-40/ -2.32.%)

Only the metal price values for every day are recorded in the mysql table (1,714; 34.56; 1,686) and so the script will need to calculate the value change (-56; [url removed, login to view]; -40) and percentage change ([url removed, login to view]%; [url removed, login to view]%; [url removed, login to view]%) from the previous day. The arrow character will then adjust accordingly to show if the metal increased or decreased over the past day.

A cron job will then need to be setup to trigger the php script at a specific time each day (except Saturday's and Sundays).

In essence, this is three very simple pieces of work:

1. Facebook script to post to a facebook page (facebook app is already setup for this, but may need to be tweaked)

2. PHP script to collect data from mysql table and form a facebook post

3. Cron job to schedule the script(s)

These are quite simple tasks, so I don't expect this to take much time, and therefore, shouldn't cost more than $50.

Thats it!

Facebook Marketing MySQL PHP

Project ID: #1724925

About the project

7 proposals Remote project Active Jun 29, 2012

Awarded to:

iamadityaa

please check pm

$30 USD in 0 days
(13 Reviews)
3.6

7 freelancers are bidding on average $76 for this job

toinnisfree

quick pro help. ftp and escrow required.

$100 USD in 1 day
(521 Reviews)
7.8
Chtioui86

Hi, plz see your private msg TY

$100 USD in 1 day
(61 Reviews)
5.9
gangabass

I can do this for you. See PM for details.

$30 USD in 1 day
(107 Reviews)
5.7
persistent

Hello, Please check PM for more details. Regards

$200 USD in 5 days
(33 Reviews)
5.0
tomkai

Hi, I can do this job. I can start immediately. Please, check PM.

$40 USD in 1 day
(6 Reviews)
3.4
shubhamjain1

We have experience in developing apps for facebook. I can do this job.

$30 USD in 2 days
(6 Reviews)
3.2