Quoting system

willdesr

Hi All,
I'm trying to figure out what is the best way to go about creating a online quoting system. Where someone can visit the site and choose their variables in the form and it spits out the price.

Now I know how to do this in html/javascript with the products and prices written inline with the code. But I would like to have the ability for the site owner to logon to a 2nd page to edit the prices in a table (sql d😎.

leatherback

You would some system where you store products / services and their prices separately from your code (As you do not want the owner to edit in the code (!)). You could use a text-file with say an array of product=>price values. Or look into using a database.

willdesr

leatherback wrote:
You would some system where you store products / services and their prices separately from your code (As you do not want the owner to edit in the code (!)). You could use a text-file with say an array of product=>price values. Or look into using a database.

J

Leatherback, that's exactly what I want to do. I want to have the pricing secured so people could 'find' a text file with the prices, so I guess a database is the way to go.

I just need someone to point me in the right direction to materials / examples I can learn from.

If it helps by saying what I'm experienced in. I'm very good in HTML/XHTML, CSS, Javascript. I can do ok with PHP, and I've created a few simple programs in Visual Studio 2005. I've never messed with MySql, but am proficient in Filemaker.

Horizon88

I don't know about filemaker, but you can look at PHP's mysql functions.

http://php.net/mysql