Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

How do i create an embedded catalogue within a web page?

Sep 17, 2012 12:37AM PDT

I'm creating a site which will have a product catalogue which one can search through.

I've decided i want users to be able to navigate through the catalogue within a frame on a static page which contains my nav bars and main links.

Since it's a searchable catalogue, results will be dynamically generated and displayed within the "frame".

Obviously i wont use actual frames, but how can i do it?

Any pointers in the right direction would be great Happy

Discussion is locked

- Collapse -
Clarification Request
(NT) What format is this catalog in?
Sep 17, 2012 11:44PM PDT
- Collapse -
Answer
PHP and MySQL. Oh and jQuery and AJAX.
Nov 15, 2012 2:21PM PST

Create a MySQL database.
Upload a csv of your inventory from excel.
Creat a web service using PHP that takes in the key word and uses different SQL queries from the key word(s) to give you the result, say in JSON.
http://www.techonthenet.com/sql/like.php SQL search example.
Use AJAX to request results from php each time the search box value is changed.
On success, inject the results using jQuery into the results frame.
You don't have to use AJAX, but if you don't, you'll have to reload the entire page each time the search is executed.