Seeking someone with knowledge of PHP and MySQL to write a PHP page which would be an addition to an existing set of PHP pages.
The set of PHP pages is a customer control panel which is accessible to a userbase with accounts stored in an SQL database. It displays data (ie. account information and such) and also permits some changes (ie. changing email address, etc).
What I'm looking for is someone who can add a page to this set, to be used as a payment gateway for digital goods which ultimately results in an SQL query supplying the purchase (non-automated - no knowledge of merchant backend required). When the user first views this page, it would list some data from a specific database table (available items) and insert a line about their payment status into another database table (username - purchased item class/type = 0 - payment status = 0).
If a user who has paid visits this page (based on the payment status line which would be manually edited by me to have values not equal to zero), they see a different form which permits them to get what they purchased. This action would execute a MySQL query.
Since the system is meant for users, it must be free of any exploitability. Preferably, the bid winner could check the entire customer control panel for vulnerabilities. Let me know if this is an option.
In summary, it would be a PHP script that has to read from and write to two different SQL databases in a specific way. It has to read variables such as username from the pre-existing customer control panel PHP pages (which already have their own CSS and everything, this script just has to fit in). I have an example page which works similar to what I want, and I can provide additional information to the winning bidder. Also a possibility of more jobs available upon satisfactory completion of this one.
Let me know how long you think it would take as well, it's not very urgent but I'd like it done within a week or two if possible.
11 freelancers are bidding on average $635 for this job
I have got diverse expertise delivering DB-aware MySQL-backed PHP applications. My php development practice is about 5 years. I delivered both simple page sets and complex solutions utilizing Zend framework.