In stock or out of stock change

NZ_Kiwis

I've got a database of stock, however on my website i've got options of what people can order for example.
I might have 3 items in stock, two green one white, so when a user visits my site they can order 3 so they will select 3 from my drop down menu but when the select green as the color I want it to run a script which will check if the 3 in stock are green, if not return a false message...

I guess it will be a javascript script which will run on a onchange for the drop down????

If so how would the javascript run an SQL query to see if it's in stock???

leatherback

You will need to look into AJAX (Asynchronize Javascript And ml): You use javascript to open a request to the server, activate a PhP script that returns some information, and then use javascript again to interpret the returned values.

Easier, but less userfriendly, is to do a OnChange Submit of the form.

thighmister

leatherback;10880069 wrote:
You will need to look into AJAX (Asynchronize Javascript And ml): You use javascript to open a request to the server, activate a PhP script that returns some information, and then use javascript again to interpret the returned values.

That's just what I want to do: display product inventory level on my site.

Recommend a good place to start learning AJAX?

Much thanks.

TheoGB

I've used http://script.aculo.us for my stuff, though it can still be a bit fiddly to get it working.

One issue is debugging is very tricky because echo statements don't seem to work in the Javascript stuff (or didn't for me) so I make a database table called 'debug' with just an ID key and text fields and put all debug data out to that so I could go back over and see what was happening.

halojoy

Here is a list of commonly used AJAX Frameworks:
http://en.wikipedia.org/wiki/List_of_Ajax_frameworks

Such a framework is a bunch of javascripts that together
can do lots of 'magic' for webpages.

I would say today JQuery.js is most popular but also Prototype.js is much used.
http://en.wikipedia.org/wiki/JQuery
http://en.wikipedia.org/wiki/Prototype_JavaScript_Framework

For JQuery you have JQueryUI http://jqueryui.com/demos/
which are ready made plugins & widgets for direct use in webpages
creating nice effects etc.

thighmister

Thanks to you both!