Simple Database Search On Website

[Samrc]

On another thread, surefire gave this instruction to get content into a mySQL database:

1- Convert excel to csv

2- Fire up phpmyadmin from cpanel link

3- upload csv data using link "Insert data from a text file into the table"

4- Crack open a beer

 

Sounds good. Nice instruction for the upload of the data to online database.

I have a followup question.... Once you have the data in the database, what program/script would you folks recommend to do a simple search/retrieve on that database online? Looking for two diffenernt projects (one on TCH server, one on a windows server elsewhere ....can't get them to move here....)

 

Example: Build a simple database file with product names, product category, manufactures, simple descriptions of the products, links to manufactures sites (no pricing, no shopping cart).

- SEARCH for staplers: Web page results shows listing in a simple table that shows the product names, manufactures, simple descriptions of the products, links to manufactures sites

- SEARCH for JoSchmo manufacturer: Web page results shows listing in a simple table that shows all choices for that manufacturer: the product names, product category, simple descriptions of the products

[GroovyFish]

Hi Samantha,

 

You might consider something like Zen-Cart even if you don't want a shopping cart. They do have some options to make the site just a showcase with no prices, or a showcase with prices but no way to add to a cart.

 

Now, I haven't played with customizing the search results, but I think what you want would be do-able.

 

Every product and manufacturer has a field built in for a link. Also, you can set up a side-bar box that shows a list of the manufacturers in a drop-down field and when the customer selects a manufacturer, all of the products for that manufacturer comes up.

 

HTH!

Edited March 17, 2006 by GroovyFish

[Samrc]

I'm working with ZEN CART on one of my accounts now. Got it installed last night and think it will work for that account as long as I can get a form to send with pricing, but does not charge cards (notification only). (There are 8000 settings to be tweaked! )

 

But on the other two, I don't want anything that elaborate. Bascially simple database searching with the results in a table like Excel. No pictures, prices, forms, something far lighter weight. Been looking but haven't come across anything yet....