Project Detail

Description

Simple PHP code needed to search a MySQL database (see below for details) which will be housed in a HTML page with a form included in the HTML.

A separate page with a new form, for users to post details to a database (see below).

A clean, fast, 2 page website needs a search feature to search a MySQL database.

The database has 2 tables.

The first table "includeddata" has 17 fields and is the table that needs to be searchable;
- name
- address
- url
- phone
- fax
- format
- contact1n
- contact1e
- contact2n
- contact2e
- contact3n
- contact3e
- contact4n
- contact4e
- contact5n
- contact5e
- notes

I'd like users to be able to search by company name and for all fields to be returned for each company name that matches with likeness. A user may search BB and get BBC and BBGuns returned, each with their associated fields.
Some fields will not have data present, I'd like these NOT to show on the results page.

The above search page will be the index page. I'd like the results viewable on a results.extension page.

Second table, I'd like the data to be posted to another table in the database, that I can then verify and transfer over (which will be done with my own database programme, not needed for this project).
The second table will be called "toconfirm" and will have 8 fields.
- name
- address
- url
- phone
- fax
- format
- contacts
- notes

I'd like a HTML form on a separate page "input.html" with the above fields. 'contacts' and 'notes' will be text areas. The form should return to a thankyou.html page once submitted.

The submitted data should not be searchable by the search feature, only data added to the includeddata table should be searchable. If I need to use a separate database, then so be it.

The script must be secure. I am unsure if it's secure to have the database connection details in one of the search scripts, so maybe it can be in a separate script file of it's own? Unless it's safe. It must be a secure script in all aspects. It must be fast, clean and function well.

I'd like the results to be displayed on a page I can format later with my own CSS. Each of the results in their own box within a div area.

Scripts I have seen on the web have not been explained well and there are too many programmes on there related to search engines which do not search for data only in MySQL etc... and a Joomla site using some extensions would be too excessive for the needs of this speedy site. Hence why I now want to pay to have a professional do this instead.

Proven examples or similar would be an advantage to my decision.

This sounds a big project, but it's just because I've explained it very well.