Freelance It Jobs | Freelancing Work

PHP5.X/MYSQL5.X QUERY DATABASE SEARCH FROM WEB FORM

Description

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 ExampleCode1.pdf 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 ExampleCode2.pdf, if there are hits. If there isn’t any hits then an error message and the search box should be returned within the same ExampleCode2.pdf 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:
- ExampleCode1.pdf - Current search input box.
- ExampleCode2.pdf - Code you can use as a template for the search keyword output page

TARGET BUDGET: $30

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.

work freelancer