Car Database To Facebook Api

Hi there, thanks for looking at my project.

I need a PHP script which will post vehicle records from a database to a Facebook account, using the Facebook API.

The source database is a very simple tab-delineated text flat file. Here is the field order:

The result should look something like this page:!/Sewell?v=app_379874034061

It does not need to be this complicated, though. For each record, the script just needs to post the contents of five fields (year, make, model, description, stock number and price.) and display the photo. The photo URL for each record is in the source database.

I have attached a copy of the source database to this project so you can see what it looks like.

The source database contains vehicles of many dealers, so the script needs to be set up to post to many accounts, one at a time.

The script will have a simple array at the top. For each dealer, the array will have the dealer code (field 12 of the source database) and the dealer’s Facebook account login info.

When the script runs, what it needs to do is pretty straightforward:

For each dealer in the array, map their listings (any records whose field 12 matches the dealer code) into the FBML XML format and post them to that dealer’s Facebook account.

I’m not sure if a special app is needed on the Facebook side. If it is, let me know.

Let me know if you have any questions … thanks and I look forward to working with you.

Leave a Reply

Your email address will not be published. Required fields are marked *