Web Portal Using MySQL Database and PHP
Budget $100-500 USD
Job Description:
Job is to create a web portal for agents of our company to login and view information on commissions they have earned. You will import data from our billing database into an SQL Database and then display information from that database within the web interface. The importing is done by using an API (https) call to our billing database ??" some PHP code is needed to process the retrieved data and store it in the local SQL database. Portal needs to be based on a popular CMS so we can easily add future content.
Programmers need to be familiar with SQL databases, PHP coding and CMS systems.
Main tasks:
1) Recommend CMS to be used as the basis for the web portal and install the CMS.
2) Develop a Login page for Agents and compare login details against usercodes in the SQL database.
3) Make an Admin page where we can add new Agents and assoicated “Customers?? for those agents to teh SQL database
4) Write PHP code to make API call to our billing database and then insert the returned information into the SQL Database.
5) Write PHP code do report information from the SQL Database into the CMS template ??" 5 different reports are to be displayed.
Full Spec attached
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Web Page using a programmer slected CMS, MySQL and PHP coding
Awarded to:
14 freelancers are bidding on average $355 for this job
