Search jQuery

jQuery Forum

jQuery, AJAX, PHP and MySQL

in Getting Started • 8 years ago

I have been doing a lot of Googling these past hours to try and find a method of using jQuery to interact with my MySQL database conditionally.

So lets say I have the table "stuff"

---+------+----------

ID | name | condition

---+------+----------

01 | boss | 0

So in this table it has the column "condition" that I would either set to a 1 or a 0.\

What I would like to achieve is that the jQuery/AJAX would first get the value of "condition" first. Then it will only execute the next step if condition is equal to 1.

Is there a way to use the data you take from your table and have jQuery interact with the data instead of just using it to fill an element?

Regards,

Replies(4)

dsvick

Re: jQuery, AJAX, PHP and MySQL

8 years ago

Sure, check out the ajax section, http://api.jquery.com/category/ajax/ . What you'll want to do is create your web page that contains the jQuery. That jQuery will execute one of the ajax methods, probably get() or ajax(), and then in its response handler it would process whatever it gets back.

The ajax method will call a server side php page that will access your database and return the value of the column.

This is sort of a high level view, if you want something more specific post a few more details about what your doing and how it is triggered and what the next steps are. But this should be enough to get you started.

Dave

xlordt

Re: jQuery, AJAX, PHP and MySQL

8 years ago

This is pretty simple to do, but if you still need help, than post back I think I have an example laying around.

Paulo

Re: jQuery, AJAX, PHP and MySQL

8 years ago

I've created a library that create a seamless connection between jQuery and PHP, through AJAX json responses. It's highly flexible, and can fit any type of app or website. http://phery-php-ajax.net/ you may follow the github account too http://github.com/pocesar/phery.