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

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!

Taidot: Markkinointi Facebookissa, MySQL, PHP

Näytä lisää: post facebook via database, automatically post facebook page mysql, php post database facebook, post facebook page database, automated post php facebook, work values, job values, app script form, facebook create post database, sundays, php script create table, page facebook, need a three character, facebook post, cron script, create facebook page, CHARACTER SETUP, change facebook page, php cron schedule, php mysql schedule, facebook schedule post script, post php script facebook, script facebook post, facebook post script, cronjob daily

Tietoa työnantajasta:
( 4 arvostelua ) London, United Kingdom

Projektin tunnus: #1724925

Myönnetty käyttäjälle:


please check pm

30 $ USD 0 päivässä
(13 arvostelua)

7 freelanceria on tarjonnut keskimäärin 76 $ tähän työhön


quick pro help. ftp and escrow required.

100 $ USD 1 päivässä
(521 arvostelua)

Hi, plz see your private msg TY

100 $ USD 1 päivässä
(61 arvostelua)

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

30 $ USD 1 päivässä
(107 arvostelua)

Hello, Please check PM for more details. Regards

200 $ USD 5 päivässä
(33 arvostelua)

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

40 $ USD 1 päivässä
(6 arvostelua)

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

30 $ USD 2 päivässä
(6 arvostelua)