Highly-rated, high-competent provider wanted for the following project:
Write a search query to query two columns of data (item id and product title) from a single table in a MySQL 5.x database. The input will be an input field from a website, which will collect user entered keywords. Please see [url removed, login to view] for the current input field used. The SQL query should look for an exact match of the keyword against the item id column and a partial match (*keyword*) in the product title column. The output page should be based on the code provided in [url removed, login to view], if there are hits. If there isn’t any hits then an error message and the search box should be returned within the same [url removed, login to view] template.
-All inputs should be sanitized/parametrized to protect the database.
-Database connection details already included the header file – no need to change
-A URL rewrite is currently being employed on almost all URLs
- Provide updated ExampleCode1 code
- Provide updated ExampleCode2 code
- [url removed, login to view] - Current search input box.
- [url removed, login to view] - Code you can use as a template for the search keyword output page
-Provider can recommend best solution including languages use for this project.
-Code should be clean and minimal for quicker load times and commented.
-All inputs should be sanitized/parametrized.
-Should use existing CSS for any text or formatting management.
-Must be a cross browser solution including IE/Safari/Firefox.
-I will provide template, which includes header, left navigation and footer. All new pages should fit within this layout.
TECHNOLOGIES IN USE:
-MySQL 5.x (UTF-8)
-URL Rewrite – there is a URL rewrite on all URLs
-Generic bids will be rejected. Serious bidders only.
-Please bid the time frame appropriately.
-Please put the text "I have thoroughly read your project brief and project requirements" so I know you read the entire project description.
-Please email me for additional information.