How can I get a value from MySQL using jQuery on Frontend

Question

I am using jQuery UI on the front end. I want to get the values off MySQL database on my page on a mouseclick using AJAX.

How do I retrieve data from MySQL using jQuery and update my div with the new HTML without a page refresh?

Thanks

bashmohandes · Accepted Answer · 2009-07-25 06:07:58Z

2

You have to provide a service tier, which can be something like a PHP or ASP.net page that gets the $.ajax request from jQuery and executes a query against MySQL backend, then it will recieve the result from the DB,translate it back to something understandable from javascript side, (such as JSON)

answered Jul 25, 2009 at 6:07

bashmohandes

2,3761 gold badge16 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:26:44Z

1

I believe you will need a server side controller or script to do the actual MySQL query. See this thread.

edited May 23, 2017 at 12:26

CommunityBot

11 silver badge

answered Jul 25, 2009 at 5:58

Sean A.O. Harney

24.6k4 gold badges32 silver badges30 bronze badges

Comments

Cyril Gupta · Accepted Answer · 2009-07-25 05:53:13Z

0

In Jquery there's a very helpful $ajax function using which you can send Get/Post requests to any webpage and use the retrieved information (which can be HTML) in your page.

Just give $ajax a look and your problem is solved. Though I don't hail from the PHP worls so I can't give you the exact code. Google it.

answered Jul 25, 2009 at 5:53

Cyril Gupta

13.8k11 gold badges70 silver badges92 bronze badges

Collectives™ on Stack Overflow

How can I get a value from MySQL using jQuery on Frontend

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related