PHP expert needed to quickly review two (2) PHP scripts and understand where and how to make script changes we need within 24 hours of accepting the project.
We have two original PHP scripts that query a MySQL database on a Linux server and display the results in a custom format with pagination.
One script is 44KB with 936 lines of code, the second script is 7KB with 114 lines of code.
The original programmer is not available to make changes.
We cannot send you copies of the PHP scripts until you are selected for this project, but we can answer specific questions and you can see the working search application here:
[url removed, login to view]
Here are the changes we need:
* In the Advanced Search form, we need all main product categories to appear in the drop-down box. There is a CRON job that executes a PHP script daily, updating the products and categories in our database. When categories are added or deleted, these need to appear in the drop-down box.
* Categories have sub-categories. Those sub-categories should not appear in the drop-down box, but products in sub-categories should be searched when searching their parent categories.
* The Product Code -- a database field -- should be searchable as a parameter in keyword searches.