You'll need to know cURL, Paypal API and Mysql to complete this project.
I need you to have or build a IPN listening PHP page I can use with Paypals Standard merchant solution (Not pro)
Capture data and save to a MySql DB.
Once we have the data stored in the DB we'll need 2 php pages.
The first page will be summary/overview page that shows each paypal order in a line by line table.
You'll need to add some additional fields to the table (URL, Starting Views, Finished Views, Completed, Emailed)
The summary page will be Sorted by newest to oldest.
Each line will display (date,Order Amount, URL, Starting Views, Finished Views, Completed?, Email ID, Emailed)
At the end of each line will be 2 buttons, the first button will be labeled "Views" that can be clicked to "recheck view count" this will update the "finished views" field.
I'll also need another button labled "Done", clicking this button will change the "completed" fields stats from "Open" to "Closed" - the Open status text color should be green, Closed status should be in red.
In the IPN you'll get a YouTube video URL, you'll need to scrape the video View count from the URL provided by Paypal and save into the db as "Starting Views". You'll need to add some error handling here incase the URL is improperly formatted or the page is 404.
The date column should be clickable and open up a page that has all the IPN data available.
This page should also include the buttons "Done" and "Views" that we're already using on the Summary page.
Once we have this built there will be a second project available to add an Email Feature where we can email the customer using a custom template.
The budget is $50, with the possibility of a second project.
Please PM me if you already have the IPN PHP page that stores to a DB, this will speed things up. PM any examples of previous work that you've done using the Paypal IPN and an Admin interface.
6 freelancers are bidding on average $48 for this job
Hi, I have working code that I did for [url removed, login to view] , it sends email to you and updates the database and checks for fraudulant IPNs etc. I hope to hear from you James