CODEWITHSUNDEEP
phpjquerymysqldatabase
Cail Desrochers
Cail Desrochers

Reputation: 63

Pull a result set from MySQL and then filter/search through it on the client side?

I have an online order form where the user should be able to type in a SKU and quantity and then (hopefully) when they are typing in the next one, jQuery has dynamically filled in the remaining fields (name, price, etc) for the previously entered item.

The product info is all within a MySQL database and I am perfectly okay with running the query to return all products ahead of time as it isn't a huge database of products. I'm running PHP as the server-side language.

One thing I do not want to do is refresh the page. The user should be able to enter the customer info, all products and options and have a final total price calculated on the fly before they need to click 'submit' and see any page loads.

I'm not even 100% sure this can be done, but I've seen more complex stuff online!

If anybody can help out at all, I'd greatly appreciate it!

Upvotes: 0

Views: 1107

Answers (1)

Sandeep Bansal
Sandeep Bansal

Reputation: 6394

I've had excellent experiences with jQuery DataTables, take a look at the website, there's a lot of examples and also PHP code to get you on your way on how you want everything to work. Takes around 15 - 30 minutes to do what you want with this plugin.

Here's an example on the website that uses PHP processing.

Upvotes: 1

Related Questions