Peruttu

PHP5.X/MYSQL5.X QUERY DATABASE INPUT FIELD FROM WEB FORM

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.

Taidot: AJAX, Javascript, PHP

Näytä lisää: web notes technologies, sql code pdf, single match, safari search page, product brief template, php form search mysql database, php code search mysql database, php5.0, n query, new product brief template, new product brief, high match, database technologies, 8 x 8, php5 mysql query form, email database management, X++, x#, write query, website url rewrite, web form template, use existing pdf, text inputs, SQL Query, rewrite 51

Tietoa työnantajasta:
( 49 arvostelua ) Kowloon, United States

Projektin tunnus: #497917