PHP Code Refactor
Budget: $30 – $250 USD
My project is looking for a seasoned professional who can help me clean up my current PHP code. The goal is to replace ugly inline SQL with a stored procedure (SP already exists) and refactor PHP (CodeIgniter) code that is currently in a loop creating a table with new recordsets.
Specific Requirements:
- The current PHP code performs multiple SQL calls for each item in the loop. This is inefficient and needs to be optimized. All calculations currently done in PHP are moved to the stored procedure.
- The stored procedure includes all extra information so no additional calls are needed in the loop.
- The data transformation required in the PHP code involves conditional content generation.
The database management system in use is MySQL. The data processing currently being done in the loop involves listing data with different content in each cell depending on the item's data.
Ideal Skills:
- Extensive experience with PHP (CodeIgniter) and code optimization.
- Understanding of conditional content generation.
Please include the word CourseProgress in your quote so I know you're not an bot. ;)
Current code are attached at files along with all columns from the SP. Code are only used in this functon, not reused in more places
Specific Requirements:
- The current PHP code performs multiple SQL calls for each item in the loop. This is inefficient and needs to be optimized. All calculations currently done in PHP are moved to the stored procedure.
- The stored procedure includes all extra information so no additional calls are needed in the loop.
- The data transformation required in the PHP code involves conditional content generation.
The database management system in use is MySQL. The data processing currently being done in the loop involves listing data with different content in each cell depending on the item's data.
Ideal Skills:
- Extensive experience with PHP (CodeIgniter) and code optimization.
- Understanding of conditional content generation.
Please include the word CourseProgress in your quote so I know you're not an bot. ;)
Current code are attached at files along with all columns from the SP. Code are only used in this functon, not reused in more places