CODEWITHSUNDEEP
jquerymysql
Moon
Moon

Reputation: 20002

Can we Execute SQL Queries in JQuery

can we execute mySQL queries in jQuery Calllback functions & misc. functions

like simple query

UPDATE EMPLOYEE SET PAY = PAY + 500 WHERE E_ID = '32'

Upvotes: 5

Views: 59273

Answers (4)

vin val
vin val

Reputation: 21

Try this:

https://github.com/vinval/MyJSQL

How to:

$.jsql({
tbName:"EMPLOYEE",
set:["PAY=PAY+500"],
where:"E_ID=32"
}, function(){
//this is the callback 
})

Upvotes: 1

rahul
rahul

Reputation: 187030

The best thing you can do is to issue an AJAX request to a server and then execute this query using a server side code.

You can use jQuery.post() in this case.

Edit

To get an overview of AJAX Read this

Read this to get and overview of AJAX methods in jQuery.

Write a server side logic to execute the SQL command, in a page. Then using AJAX issue a request to that page.

Sample Code

$(function(){
    // Bind a click event to your anchor with id `updateSal`
    $("#updateSal").click(function(){
        // get your employeeID
        var empID = "32"; 
        // issue an AJAX request with HTTP post to your server side page. 
        //Here I used an aspx page in which the update login is written
        $.post("test.aspx", { EmpID: empID},
            function(data){
                // callack function gets executed
                alert("Return data" + data);
        });

        // to prevent the default action
        return false;
    });
});

Upvotes: 10

user111013
user111013

Reputation:

While you could do this using a callback to a server-side script to execute your queries against MySQL, it would be a quick way to security holes.

Generating SQL queries from anything run on an end user device is a terribly bad idea.
Never trust anything a user sends you.

Upvotes: 12

Adam Flanagan
Adam Flanagan

Reputation: 3052

You can't directly access a database from javascript/jQuery but you can post to a web service on the server which can access the database.

Upvotes: 0

Related Questions