19651 PHP CMS module modification

We have a relatively simple lexicon module in our php-based CMS that is written with horribly inefficient SQL usage. The result is that with the large lexicon we wish to implement, the performance is so bad as to make the module unusable. We are looking for a php coder to make these SQL improvements, make one layout fix, add a few on/off switches for features to the admin interface, and add a "match whole words" option to the search. It is simple enough that I, as a non-php-coder can understand the process, I just can't invest the ramp-up time to learn to code php. We have already done the work of identifying the locations of the inefficiencies and determining what fixes need to be made - we just need a good php-coder to make the right sytax. Required changes: Improve efficiency of code by (alternate recommendations from coder also welcome): -Moving a half-dozen excessive sql queries' results into variables accessible by all users. Make these queries run only when the DB is changed (and have a manual query run button in the admin interface). -Change an UPDATE of a counter field to an INSERT in a separate Counting Table Add on/off switches/function to the admin interface for the display of the various interface elements. Add a "match whole words" option/function to the search. Reformat query output (make terms and definitions list side-by-side in columns arranged by language rather than definition written under the term). Integrate GoogleAds Attached is a detailed documentation of the modifications.

Odd Jobs PHP

项目ID： #1770467

关于项目