PHP5.X/MYSQL5.X QUERY DATABASE INPUT FIELD FROM WEB FORM
$250-750 USD
Paid on delivery
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.
NOTES:
-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
DELIVERABLES:
- Provide updated ExampleCode1 code
- Provide updated ExampleCode2 code
DOCUMENTS:
- [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
PROJECT REQUIREMENTS:
-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:
-PHP 5.x
-MySQL 5.x (UTF-8)
-Lighttp
-Ubuntu 9.0.4
-URL Rewrite – there is a URL rewrite on all URLs
BID REQUIREMENTS:
-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.
Project ID: #497917
